| OdbcDataReader and number of returend rows (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I connect to my database: Dim SQLCommand As OdbcCommand New OdbcCommand() Dim drDB As OdbcDataReader Dim SQLConnection1 As OdbcConnection New OdbcConnection([...]) drDB SQLCommand.ExecuteReader() Befor I want to go to the while loop, I want to get the number of rows, returend by the database. Without the number, I cannot make a percentbar. I don't want to use the DataSet. While (drDB.Read) End Whi... |
|
| Primary Key (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| My database apparently does not say what is primary key. How do I make a column in a dataset the primary key? It is always the same is there a way to permantly tell vs what the column is for the PK? Thank you, Dave |
|
| ODBC timeout (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I want change the timeout for a SELECT Command. Normally the command needs only 2 Seconds So I want change the timeout to 10 Seconds. Is this possible in a C Application ?? Thanks for any help Peter Stojkovic |
|
| Query fails when ran against an access DB. HELP PLEASE! (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have code that connects to an access database but when I try to run this query it fails Dim SQL As String "SELECT a.idKey, c.sSoftwareName, a.sDateSubmit, a.sDateRequired, a.sProductName, d.StatusName, " "b.sName, b.sEmail FROM REQUIREMENT SPECS a, CONTACTS b, SOFTWARE PRODUCTS c, STATUS d " "WHERE a.ptrContact b.idKey AND a.ptrSPM c.idKey And a.sStatus d.idKey AND " "(d.StatusType ""0"" OR d.St... |
|
| DataAdapter.Update error (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| HI: I'm using the ODBC.NET data provider to read a comma delimited file into a DataSet via an OdbcDataAdapter. The Fill call on the OdbcDataAdapter loads the Dataset and I'm able to display the data from the comma delimited file. If I make a change to a column and then create an OdbcCommandBuilder passing it the OdbcDataAdapter, when I call the Update method on the OdbcDataAdapter and I get the fo... |
|
| SQLColumns (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello happy developpers, How can i make a SQLColumns to get name and info about columns with ODBC. NET ? |
|
| ODBC return codes from .Net ODBC provider (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| If I am using ExecuteNonQuery and an error occurs I get a system error exception thrown.How can I tell what that error is I need to know for example that the unique key already exists or a referential integrity check has failed. |
|
| Oledb .net data provider: getting it on the list! (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I want to use dsn conenctions to MS Access I have: downloaded and installed the oledb .net data provider added the reference to the solution in VS.net imported the namespace into the global.asax Still not in the list of providers in the data link properties dialogue when I go to add a connection Aghh... what am I not doing? |
|
| Opening a connection using ODBCConnection (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, am trying to connect to a database for which i have an odbc driver. Is it possible using ADO.NET? When i attempt to open an ODBCconnection using the following string Provider MSDASQL.1;Password "";Persist Security Info True;User ID TIM;Data Source SageLine132 i get the following error Microsoft.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found a... |
|
| SQLTables (7 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| How can i make an SQLTables to get name and info about all tables of a DSN with ODBC.NET ? When i play with FillSchema, i must have defined first à OdbcDataAdapter with à SQLCommand like "select * from mytable" But "mytable" is the item i want to fetch, so how can i do ? Thank's by advance. |
|
| HELP NEED HERE : ASP.NET (OLEDB/Foxpro) Problem (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, This is not the fist time I ask for this problem (I'm desperate lol) Each time I try to access to a Foxpro table with OLEDB in a Web Services (ASP.NET), He give me the following error. Cannot update the cursor Read with SELECT work fine..... Just Update and Insert dosen't work.... Outside ASP.NET (I mean in a Windows Application) everything is working fine. Is it because I need to change t... |
|
| Data Type of ODBC column. (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I want to find the type of data contained in an ODBC returned column. Right now I am using an ODBCDataReader.getType(i) method.... But it returns a lot more then I want to know and I can't find out if it is varChar. (I don't think) There is a nice ODBCTYPE enumeration but that does not match with the type returned from getType. Any Known ways to get the type of data in the column and compare it to... |
|
| Crap solution - ODBC Datagrid column names hyperlinks (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Why on earth has Microsoft released such poor ODBC.net reference. It should at very least work in the same way as the ole db connections for db connections and data adaptor. I can't even create a dataset using the gererate dataset method. Any way .... I can't change the column names from datagrid and I can't add hyperlinks on the columns via code can someone help me. I'm using a sysbase sql anywhe... |
|
| Return Code problem (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am having trouble returning codes to my Web Services which uses ODBC.NET. Sybase Adaptive Server 11 Stored procedure: ..... ..... IF EXISTS ( SELECT myField FROM myTable WHERE some key @some key) BEGIN return 2222 END .... .... WebService Command: int sqlRet2 cmd1.ExecuteNonQuery(); sqlRet2 equals 1 even when the stored procedure condition evaluates to TRUE. I need to see " 2222". Can someone he... |
|
| Local Application Database Caching? (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hey, I have this app that is client server, mainly by a SQL database. Any thoughts on how to make it not depend on the main database? To make it fast, local database hits vs internet database hits, and also for when the database isn't availible, etc? Doing everything selects, updates, inserts. Not a real issue of multiple users overwriting each others changes. Thanks, Keith |
|
| ODBC REAL SLOW! (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a VB .NET application using ODBC (Microsoft.data.odbc) It takes 72 seconds to get the result... (only 14 rows) so something is very very wrong here... Dim myConnString2 As String "Provider MSDASQL;Persist Security Info False;DSN myDSN;UID ####;PWD ####" Try informix New OdbcConnection(myConnString2) and it opens fine...and here's the select... and THIS is what takes 72 seconds... connection... |
|
