| Third-party ODBC driver error (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying the ODBC .NET data provider with an ODBC driver from an accounting software vendor. For a test, I copied code from a very simple sample in the ODBC .NET documentation. The sample code reads a couple of fields from rows in a table and writes them to the console. I got it to work with the NWind database first (in SQL Server 2000, but via ODBC. NET, not ADO). When I try this same code wit... |
|
| Server-Explorer for ODBC (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I have installed the download ODBC .NET Data Provider Beta 1 But if i try with the SERVER EXPLORER to install a new database connection, i cant select any ODBC Driver !!! What I have to do, so that i can access ODBC Driver within the Server Explorer od Visual Studio ?? Thanks for any help Peter |
|
| VisualStudio Beta 2 and ODBC (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Does anybody have a hint how to connect to a Database via ODBC in C# with VisualStudio.ENT Beta2? No connectiion to SQLServer, Access or Oracle, just to any other ODBC DSN? |
|
| Is this newsgroup active? (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| The following newsgroup only seems to appear via NNTP; it doesn't show up on the web based newsgroup access: microsoft.public.dotnet.framework.odbcnet Is microsoft.public.dotnet.framework.odbcnet alive and well, or should we post to framework.adonet instead? Thanks, Ric |
|
| Is there any point asking questions in this group? (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Is there any point asking questions in this group? It is very rare that one gets any kind of response from Microsoft. A simple acknowledgement of the problem one is experiencing would be a start, I can understand a fix may not be available for some time. Regards ()z |
|
| Are there any updates for ODBC.NET? (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Are there currently, or are there going to be any service releases for ODBC.NET Beta 1? The version I have is unusable for the databases I wish to access, and the OLEDB option has been taken away from me in Beta 2, so I really really could do with an update that fixes some of the many issues already reported here. Kind Regards ()z |
|
| Insert using parameters (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to insert into my database using parameters. So far I have been unsuccessful. If anyone has any suggestions as to why my code isn't working please advise? I have a dataservice that is building my dsn fine/ The problem is the screen returns the following: Record Added INSERT into discrepancy stand texts ([CLINICAL STUDY ID], [PROCEDURE ID], [PROCEDURE VER SN]) values (?, ?, ?) bu no rec... |
|
| Q: Stored Procedure Parameters (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| i am trying to call a stored procedure on my sql server, but i always get the following error message: System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'spCustomerCreate' expects parameter '@CustomerName', which was not supplied. my code looks as follows: cmd new OdbcCommand("spCustomerCreate", con); cmd.CommandType CommandType.StoredProcedure;... |
|
| Error: "OLE DB driver for ODBC drivers cannot be used" (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have tried to connect to a free FoxPro table using OleDbDataAdapter/Connection/Command objects but I keep getting this error message. I can create a connection within Server Explorer, and view the table data that way, but that's it. If I use the Data Adapter Configuration wizard I can create a connection and "test connection" succeeds, but then the wizard reports that ... "The connection you hav... |
|
| Doesn't work? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Help... Installation works but nothing is available to use?? Morgan Vermef 329749 mvermef@yahoo.com Hardware: ASUS KV7, AMD 800, 256Ram, Creative GTS2 32, SBLive MP3 , NetGear FA310tx, Seagate 30.6 Barracuda2 7200RPM, IBM Deskstar 30.7 7200RPM Dual Boot: RC2 Windows XP Personal (Clean) RC2 Windows XP Pro (Clean) ICQ# 5827864 |
|
| System.Data.SqlClient.SqlDataReader cannot be serialized because it does not have a default public constructor. (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| i get the above error in a service with the following code: [WebMethod()] /// summary /// Retrieve a DataReader object of values from a SQL Server Database /// /summary public SqlDataReader getDataReader SQL(string server, string sql, string database, string dataSetName) { SqlConnection conn new SqlConnection("Initial Catalog " database ";Data Source " server ";Trusted Connection Yes"); SqlDataRea... |
|
| How to get row count without re-query? (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| How can I get a row count of the number of rows selected without reading the entire data set? I am doing the following in c# and can't get a row count, even if I System.Data.Odbc.OdbcConnection db; db new System.Data.Odbc.OdbcConnection(); db.ConnectionString "DSN myDsn;USER user;PWD pass;"; OdbcCommand sql new OdbcCommand("SELECT stuff FROM mytable", db); OdbcDataReader reader sql.ExecuteReader()... |
|
| BUG? mySQL, OdbcDataReader.GetFieldType - Unknown SQL type - 91 (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I get an unhandled exception of type System.ArgumentException in system.data.odbc.dll when trying to get the type information for a mysql field of type varchar(64)NOT NULL The SQL in question is: select I.catid, C.description, I.typeid, T.description, I.product, I.subgroup from docindex I, categories C, types T where C.catid I.catid and T.typeid I.typeid group by catid, typeid, product, subgroup W... |
|
| SQL Server does not exist or access denied (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Can anyone tell me whats the problem with my Installation of .net SDK beta 2 ?? I am getting this error while going thru Quickstart samples. I have 2000 professional with SQL 7.0 running machine name: fundoo ..net has installed MSDE with an Instance of (local)\NetSDK as I can see a directory by the name of MSSQL$NetSDK in program files but how do we start this SQL Server. Can I keep both SQL 7.0 a... |
|
| Is OdbcConnection going to get a connection string building wizard like SqlConnection and OleDbConnection? (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, Is OdbcConnection going to get a cool connection string building wizard like SqlConnection and OleDbConnection has? SqlConnection and OleDbConnection has a Drop down list in the properties box that contains the item New Connection ... which is a wizard to build a connection string. Does anyone know if this is going to happen for OdbcConnection. Thanks.. John. |
|
| Schemas (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, We are developing an application that needs database connectivity. During the setup of the app the user needs to select tables from a database connection. We have been getting schema information using the following call in the oledb library. GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] {null, null, null, "TABLE"}); The problem we now have is that some of our clients only have od... |
|
| "Concurrency Violation" - we are stumped. (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, We're using .NET Beta 2 to access Ingres 2.0. We're having problems updating the DB via the command builder. If we specify the update string manually everything works fine. Now if we use the CommandBuilder to create the update command, we get a "Concurrently violation, 0 records updated" error. But the weird bit is that we only get it on some tables. So far testing 14 tables I've found tha... |
|
| HELP: OLDDB, ODBC + MySQL (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am running VS.NET beta 2 ODBC.NET beta 1. I am trying to access a MySQL database from c# (the code was working on VS.NET beta 1) as follows System.Data.OleDb.OleDbConnection extranet; extranet.ConnectionString "Provider MSDASQL;SERVER extranet;Driver MySQL;OPTION 131072;DB csws" However, when I run my App, I get the following exception on the above line An unhandled exception of type 'System.Not... |
|
| Connection to an ODBMS with ODBC driver (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I want to establish a database connection from Visual Studio.NET Beta 2 to an ODBMS (Matisse) system. I created in Visual Studio a data link with 'Microsoft OLE DB Provider for ODBC Drivers' and the connection also works fine, but in the tables view, I cannot see the tables of the ODBMS, although there are objects in the ODBMS. With the Access DBMS, it works fine and I can see all the tables and v... |
|
| Simply cannot get ODBC data, I am desperate (9 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, whatever I do, I cannot seem to get any kind of data into a dataset from an ODBC source. My code: Dim strConn As String "DSN PDWHbase" Dim strSQL As String "SELECT ..." Dim myDA As System.Data.Odbc.OdbcDataAdapter New System.Data.Odbc.OdbcDataAdapter(strSQL, strConn) Dim myDS As DataSet New DataSet("NameofDataset") myDA.Fill(myDS, "call rated cdr") DataGrid1.DataSource myDS I am always either ... |
|
| where to find odbc.NET API (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| where can I find odbc.NET API and documentation? Thanks, |
|
| ODBC.Net & COM+ (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have few questions: 1/How can i put ODBC.Net database operation into COM transaction ? 2/Is ODBC.Net support manually enlistment ? which means one ODBC.Net connection can be reused in many transaction of an object pooling COM component. Thanks, M.H |
|
| ODBC .Net Data Provider - Is Cancel() Supported? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am using the ODBC .Net Data Provider to connect to an NCR Teradata RDMS. The ODBCCommand.Cancel() method throws 'NotSupportedException'. Is this problem Teradata specific or is the method not supported by the ODBCCommand class at all? |
|
| VS Release Candidate (Hussain - could you help ?) (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have a problem with ODBC.NET install when using the VS RC. I have formatted the dev machine installed windows XP installed VS RC and installed ODBC.NET in that order. When I looked to add the ODBC.NET reference to my project I found it was not in the .NET tab of the Add References dialog. I then proceded to add it manually using the browse button. After I did this my code would compile. Howe... |
|
