Hi Marcus, OLE DB and .NET are supported through the bridges, MS provided for ODBC (see http://sapdb.2scale.net/moin.cgi/UsingMicrosoftApis).
Apparently, you found out that the OLE DB bridge is not appropriated for .NET. > Is there any way I can use OLE DB with SAP DB? Without .NET the OLD DB data provider for ODBC seems to work. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org -----Original Message----- From: Marcus Dickerhof [mailto:[EMAIL PROTECTED]] Sent: Donnerstag, 6. Februar 2003 12:44 To: [EMAIL PROTECTED] Subject: OLE DB and SAPDB Hello, Could you please help me with a little problem? At the moment I have to evaluate SAP DB for my department. We mainly use Microsoft .net here. Over the past couple of month we have been writing little tools that help us to access databases more conveniantly (we have been using Access, but now we have a new project that really is very data intensive). The Problem now is, that all our tools are based on OLE DB. Now I saw SAP DB only supports ODBC. I saw there is something like a Microsoft OLEDB Provider for ODBC. But somehow this provider won't work with the oledb.net implementation. I used it in this way: string source = @"Provider=MSDASQL ;PWD=...;UID=...;SERVER=...;DATABASE=...;DRIVER=SAP DB 7.3"; connectionString = source; connectionPath = AccessDBPath; OleDbConnection con = new OleDbConnection(source); con.Open(); This will give me the exception An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: Der OLE DB-Anbieter f�r .Net-Daten (System.Data.OleDb) unterst�tzt nicht den MSDASQL-Anbieter, Microsoft OLE DB-Anbieter f�r ODBC-Treiber. I guess using the OLE DB Provider for ODBC was a good approach in the past. Do you know if there is another oleDBConnection besides the .net implemenation that would support MSDASQL? Is there any way I can use OLE DB with SAP DB? We don't want to change all our libraries :-) Thank you very much in advance Greetings Marcus Dickerhof _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
