Error Solution Request

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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php