Using ODBC databases
-
Hi folks, I´m building a database application, which has to connect to a database through an ODBC provider, but when I insert an OleDbDataAdapter in my form, and try to "connect" it with any ODBC data source, I get a nasty message telling me that the data source and the adapter are not compatible. If I choose another OleDB provider, such as Microsoft Jet driver it works fine. The question is: ¿do I need any kind of special code/libraries to get data from ODBC sources?. Thanks in advance.
-
Hi folks, I´m building a database application, which has to connect to a database through an ODBC provider, but when I insert an OleDbDataAdapter in my form, and try to "connect" it with any ODBC data source, I get a nasty message telling me that the data source and the adapter are not compatible. If I choose another OleDB provider, such as Microsoft Jet driver it works fine. The question is: ¿do I need any kind of special code/libraries to get data from ODBC sources?. Thanks in advance.
What does your ConnectionString look like? Can you also post what excatly the error message says? ------------------------------- Joan MomComputerGeek.com
-
What does your ConnectionString look like? Can you also post what excatly the error message says? ------------------------------- Joan MomComputerGeek.com
The ConnectionString of my connection is: "Provider=MSDASQL.1;Persist Security Info=False;Data Source=Base de datos de ejemplo Xtreme;Extended Properties="DSN=Base de datos de ejemplo Xtreme;DBQ=C:\Archivos de programa\Microsoft Visual Studio .NET\Crystal Reports\Samples\Database\es\xtreme;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;";Initial Catalog=C:\Archivos de programa\Microsoft Visual Studio .NET\Crystal Reports\Samples\Database\es\xtreme" And I get this error message: "La conexión que acaba de crear no funciona con el adaptador actual" In english: "The connection you´ve just created doesn´t work with the current adapter" Maybe I need some patch or update for my VS copy. :confused: "When I look into your eyes, there´s nothing there to see, nothing but my own mistakes staring back at me"
-
Hi folks, I´m building a database application, which has to connect to a database through an ODBC provider, but when I insert an OleDbDataAdapter in my form, and try to "connect" it with any ODBC data source, I get a nasty message telling me that the data source and the adapter are not compatible. If I choose another OleDB provider, such as Microsoft Jet driver it works fine. The question is: ¿do I need any kind of special code/libraries to get data from ODBC sources?. Thanks in advance.
If you're using Framework 1.0 and VS.NET 2002, you'll need to download the ODBC.NET Data Provider[^]. If you're using Framework 1.1 and VS.NET 2003, then you just need to use the System.Data.Odbc namespace.
I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past. -Chris Maunder