| Help me. ! Microsoft.Data.Odbc.OdbcException: ERROR Specified driver could not be loaded due to system error 126 (Sybase System 11). (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| The same program is normal in a .cs file. Server Error in '/' Application. ERROR [IM003] Specified driver could not be loaded due to system error 126 (Sybase System 11). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Dat... |
|
| How to switch Data providers (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Before using .Net, I used VB with native ODBC access. To change from one database to another was really easy. I just change the DSN. Now with .Net we have the: System.Data.SqlClient; System.Data.OleDb; Microsoft.Data.Odbc; How can I write and application and switch from System.Data.OleDb, lets say to Microsoft.Data.Odbc (To use and ODBC driver because and OLEDB provider is not available) without c... |
|
| ODBC.Net works only on release version (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| If you have encountered any trouble with the ODBC.Net Provider which released on 1/30/2002, just get the Visual Studio .Net RTM version, all trouble will go away. I just got the VS.Net Enterprise Architec edition from my company's MSDN package... after the installation of this new version... then recompiled my testing program... it works! |
|
| File Not Found Error with OdbcConnection (8 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm getting the following error: "An unhandled exception of type 'System.IO.FileNotFoundException' occurred in ADO01.exe" I'm importing: using System.Data; using Microsoft.Data.Odbc; The code: string strCon "dsn oracle;UID bsc;PWD bsc;"; OdbcConnection con new OdbcConnection(strCon); // Error. Any idea? Thanks. |
|
| ODBC.NET + MyODBC + ? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, I am sorry if it is repeating. Is there any other way I can access the databased using ODBC as the layer apart from ODBC.NET ? If yes, how ? For example, I would like to use MyODBC 3.51 to access MySQL server with ADO.NET, ASP.NET and ODBC.NET. I found a sample from MyODBC faq for ODBC.NET, but couldn't able to collect info on how to use it for the other cases. Can some one provide me a si... |
|
| Can't access certain files with odbc text driver (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I've written a small test harness to test file import using delimited text files. I'm using the odbc managed provider to read the data into a dataset. Here's what my connection string and command look like: connection string : "Provider MSDASQL;DSN CSV" where CSV is a user data source created with the odbc data source administrator pointing to a folder on my local system. I browse to the folder an... |
|
| ODBC.Net crash reading empty column values (13 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am using the Microsoft ODBC.Net driver dated 2002.01.30. I still get a crash when selecting data rows which have one or more empty values. If the value is null, there is no crash. I am filling my DataSet using an OdbcDataAdapter in the normal manner: Dim objDS As New Data.DataSet() Dim conn As New OdbcConnection( "DSN xxx;uid abc;pwd xyz;") Dim adapter As New OdbcDataAdapter() adapter.SelectComm... |
|
| Fixed length columns and parameter generation (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm wondering if anyone else has seen this problem, I believe its a bug. The ODBC spec says the if a column is fixed length, ColumnLength is ignored, ie, you can return ColumnLength 0 in its metadata. I've worked with a number of drivers (from different companies) that do this. However, when updating through a CommandBuilder, the command is correctly generated but no data appears in such a column.... |
|
| 07S01 Invalid use of default parameter (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I don't understand what this error is trying to tell me. I'm using the ODBC.Net provider because my production db only has ODBC drivers available. But for development, I'm using SQL Server 2000. I DTS'd the data in. This database has weird things, like char columns not null, no default specified, that must be blank filled. So, please interpret this error message if possible. What should I be looki... |
|
| Connections not being released with ODBC.Net and DB/2 (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Is anyone out there using IBM's DB/2 for Windows and Microsoft's ODBC.Net? We're having a problem where the connections are never being released, regarless of explicitly doing so in code. Anyone else experiencing this? Anyone heard of any work arounds? |
|
| ODBC.net Databinding in Windows Forms (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm writing a Windows Forms application that uses mySQL and ODBC.net. Is there anyway to use the GUI databinding techniques such as dragging data connections to the form and using databinding in a control's property window? Does it all have to be coded by hand? |
|
| Has anyone had any luck using MySQL? (9 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a project that is working great under Classic ASP that connects to a MySQL database. I've been trying to get it work in .NET and it is like pulling teeth! Has anyone found a solution that works? Ryan |
|
| Schemas in ODBC .NET (8 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Because it is not possible to get a db schema in ODBC .NET I wrote a small Managed C component that retrieves the dbschema. But after I opened AND closed a databaseconnection via ODBC .NET (via C#) I'm not able to open a db using CDatabase in C . The OpenEx method throws an Exception. Before I open a database via ODBC .NET I can call the C methods as often as I want (tested with Anywhere und Acces... |
|
| ODBC.NET and Stored Procedures (7 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi All, I hope someone can help out with this problem, because it's driving me crazy. To start of, i have the latest versions of Microsoft.data.odbc, MDAC2.7RTM, .NET Framework RTM, SQL Server 2000 SP2. Everything works fine until i use a stored procedure with input parameters. When i do, i get the following error: "Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Drive... |
|
| Odbc, OleDb and SqlClient performance (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have just finished some testing using these three methods with MS SQL Server 2000. I'm accessing the Northwind database and reading all the records on the orders table. My results are the following (In milliseconds): Run No. OleDb Odbc SqlClient 1 310.4464 150.216 460.6624 2 220.3168 140.2016 290.4176 3 220.3168 140.2016 290.4176 4 10.0144 10.0144 10.0144 The first three runs where made by closi... |
|
| Write a text file using new ODBC Managed Provider (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm wondering if anyone has "updated" a text file using the new .NET ODBC Managed Provider. I can read data from a text file fine but would also like to be able to update fields within the file. Here's some code I've been tinkering with... private DataSet Build ( DataSet ds ) { DataTable dt new DataTable ( "RazorNames" ); dt.Columns.Add ( new DataColumn ( "ID", typeof ( int ) ) ); dt.Columns.Add (... |
|
| Not using Visual Studio (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am having a problem using objects in the Microsoft.Data.ODBC namespace. The answer to this problem seems to be that I need to add a reference in the project explorer of VS.net. The problem I have is that I am not using VS.net. Does anyone have an example of how to reference the dll in code that I can impliment through my text editor. |
|
| Sybase SQL Anywhere + ODBC.NET (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'm using Sybase SQL Anywhere 6 and connecting thru ODBC.NET. When I'm trying to update a record, ExecuteNonQuery() returns 1, but no records updated. I do use BeginTransaction() and Commit(). What could be the problem? Thanks in advance, Alex |
|
