Microsoft OLE DB Provider for ODBC Drivers - not working for me 1

[humour]

re: .net, dotnet connect via System.Data.OleDb MSDASQL.1 (MAXDB/SAPDB - published by MYSQL)

I have the vb.net Visual Studio STANDARD edition and cannot use "Server Explorer" with Microsoft OLE DB Provider for ODBC Drivers - it is restriced to MSDE and Access and MS SQL. I am hoping this only is disabled in VS Studio. I am assuming with the right connection string I can successfully connect in code. Can anyone confirm if this is true?

' My connection string below
"Provider=MSDASQL.1;Persist Security Info=False;User ID=CM;Extended Properties='DSN=Contact;UID=CM;pwd=mypass;SERVERDB=CONTACT;SERVERNODE=192.168.32.##;'"

The error message is as follows: The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

I know ODBC works and the ADODB Interop assembly in .net works ok (but I am having problems with datagrid update event. I was just hoping to be able to take advantage of the new .net syntax like datasets etc...

I would love to hear from anyone who successfully develops using .net with MAXDB/SAPDB via the Microsoft OLE DB Provider for ODBC Drivers.

Thanks in Advance

 

[RiverGuy]

As far as the first problem, I don't use Standard, but I have heard others in this forum describing what you have said, and saying that they can't use server explorer in standard.

To use ODBC.Net with System.Data.ODBC, you will have to reference that DLL, and instead of creating OleDBConnection objects, create ODBCConnection objects. The same goes for all the data objects.