OLE DB and SAPDB

[Marcus Dickerhof]

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