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
