Asit,
Did you ever solve your problem? - I have the same...
Bruce
-----Original Message-----
From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]]
Sent: Thu, 07 June 2001 21:42
To: asit; [EMAIL PROTECTED]
Subject: Re: Help required for OLEDB on win32 for MySQL(linux)
At 20:56 07/06/2001 +0530, asit wrote:
Hi,
Please take a look on the help file, where you should find that
your connection string is wrong. You find the instructions of
the connection string just below of Overview item.
server=192.168.100.101 ?
Regards,
Miguel
>Hi,
>
>I am facing problem while connecting to MYSQL server (linux) from Win32 VB
>client through OLEDB provider from MYSQL.
>I am successfully connecting to server through MyODBC using DSN but
>unable to connect to through OLEDB provider ( downloaded from
www.MYSQL.com)
>
>Following is the script in VB
>MySQL server is on 192.168.100.101 and database is Test . This is allowed
>to be connected from any IP and any user
>
>Private Sub Form_Load()
>Dim dcncentral As ADODB.Connection
>Set dcncentral = New ADODB.Connection
>Dim str1$
>str1 = "Provider=MySQLProv;Data Source=192.168.100.101;DB=Test
>dcncentral.Open str1 --------- Giving Catastrophic Error
>End Sub
>
>This function is not opening the database and giving "Catastrophic Error".
>What should be the connection string for database ?
>
>Please help. Kindly note that I want to connect to MYSQL database without
>a DSN
>
>Thanks in Advance
>
>Asit Saha
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Miguel A. Solórzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil
<___/ www.mysql.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
---------------------------------------------------------------------
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
