Sir, We used the following code for connecting Visual Basic 6.0 with MySql = 3.23.41 . Mysql was running in Linux Red Hat server 7.2
The VB application was in Window NT node The provider used was “MySQLProv” The code is ____________________________________________________ Option explicit Public gCn As New ADODB.Connection Dim SConnect As String Dim DataBaseName1 as String Dim ServerName1 as String Dim UserName1 as String Dim Password1 as String ____________________________________________________ Public Sub pConnOpen() ServerName1 = "MainServer" DataBaseName1 = "checkMySql" UserName1 = "abcd" Password1 = "abcd" gCn.Provider = "MySQLProv" strCon = "Data Source=" & ServerName1 & ";Initial Catalog=" & DataBaseName1 & ";User Id=" & UserName1 & ";Password=" & Password1 & ";" gCn.Open strCon End sub ___________________________________________________ We got the following error message "Multiple step operation generated errors. Please check OLEDB staus value if available.No work was done" We request your suggestion for solving this problem. Waiting in Anticipation for your reply R.jayakumar __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php