Yes, Alexander is right. Anyway - I wonder what are you missing with the ODBC classes?? AFAIK you can load data to dataset from ODBCDataAdapter (or Reader, I'm not sure) as well, can't you?
Marcin Uzytkownik "Schroeder, Alexander" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] Sorry, as you may read here http://support.microsoft.com/default.aspx?scid=kb;EN-US;310374 your are probably out of luck here. Microsoft has prohibited the .NET OLE DB Data Provider from using the ODBC-OLEDB-Bridge, only chance is to use the .NET ODBC Data Provider (which as a different interface though). Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: H [mailto:[EMAIL PROTECTED] > Sent: Monday, August 02, 2004 5:28 PM > To: [EMAIL PROTECTED] > Subject: Re: ADODB works but OleDB does not! > > > re: .net, dotnet connect via System.Data.OleDb MSDASQL.1 > > Thanks for your assistance Marcin, unfortunately it is NOT > working for me yet ;-). My connection string is below, I > have tried several variations of it all yield the same error > (see below). Unfortunately 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. > > "Provider=MSDASQL.1;Persist Security Info=False;User > ID=CM;Extended > Properties='DSN=Contact;UID=CM;pwd=mypass;SERVERDB=CONTACT;SER > VERNODE=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 Interop assembly in .net works ok > as well I was just hoping to be able to take advantage of the > new .net syntax like datasets etc... > > I am assuming you actually tried a compiled-code connection, > perhaps the "server explorer" piece works but an actual > compile via the framework might yield the same error I listed above. > > 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 again.... > > > Marcin P <[EMAIL PROTECTED]> wrote: > Yes, it's true that Ado relies on OLEDB. > > There is a possibility to use Microsoft Oledb Bridge > for ODBC - I didn't use it as long as Odbc works fine on my site. > In your example, it seems to me that you're trying to connect > to SAP DB/MaxDB with Oledb Driver for MS SQL. > Try building ConnectionString with Server Explorer (from VS), and > choose Microsoft OLE DB Provider for ODBC Drivers. > I gave it a trial a moment ago and the result is: > Provider=MSDASQL.1;Persist Security Info=False;User ID=MY_USER;Data > Source=MY_DB;Extended > Properties="DSN=MY;UID=MY_USER;SERVERDB=TEST_DB;SERVERNODE=MACH_IP;" > > It works OK. > However, as there is no native Oledb driver for > SAP DB/MaxDB you can always go with simple > ODBC classes. > m_cnADOConnection = New OdbcConnection() > > Best regards, > > Marcin Pytel > MCSD ;-) > > Uzytkownik "H" napisal w wiadomosci > news:[EMAIL PROTECTED] > > > > > > > > > > Using asp and vb.net I very successfully am able to use ADO > technology > with MAXDB database. > > > > > > I am confused though, in diagrams I have seen published by > WROX ADO relies > on OLE DB technology. Why is it that I can't seem to get to > the data using > the native OLE DB .net provider defined in the .net namespace known as > System.Data.OleDB (please provide an explanation or clear my > confusion on > the technologies involved here). > > > > > > Where I am getting hung up is on the line of code below, I > dont know what > I should put in the provider parameter. What I have there now > I think is > exclusively for SQL-SERVER but I am not sure. > > > > stringConnectionString = "Provider=SQLOLEDB;dsn=contact;user > id=CM;password=*****;" > > objConnection = New > System.Data.OleDb.OleDbConnection(stringConnectionString) > > > > Is this possible? Has anyone done it? > > > > > > If it is not supported are there plans by MYSQL or > Microsoft or anyone > else to achieve this? > > > > > > > > Thanks in Advance. > > > > > > > > > > > > --------------------------------- > > Post your free ad now! Yahoo! Canada Personals > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > --------------------------------- > Post your free ad now! Yahoo! Canada Personals > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
