help Problem with Adordd

[Databaselab2002]

Hi Coleagues

I need connect to Mysql but I Can T Can Anybody Help me
Im use Fwh 8.05 xharbour 1.1. , Mysql 5 , My odbc driver 5.1

thanks in advance
Fabian



The Error
Mysql .prg

Application
===========
Path and name: C:\ADO2241\samples\mysql.exe (32 bits)
Size: 1,517,056 bytes
Time from start: 0 hours 0 mins 0 secs
Error occurred at: 01/06/09, 23:13:24
Error description: Error ADODB.Connection/0 S_OK: OPEN
Args:
[ 1] = C DRIVER={MySQL ODBC 3.51 Driver};server=www.freesql.org;database=test00;uid=myuser;pwd=mypass

Stack Calls
===========
Called from: win32ole.prg => TOLEAUTO:OPEN(0)
Called from: adordd.PRG => ADO_OPEN(0)
Called from: => DBUSEAREA(0)
Called from: mysql1.PRG => MAIN(0

[anserkk]

Fabian,

Show me the part of your source code trying to connect to MySQL. I am able to connect without any problem.

I think I have replied to your query in the Spanish forum and you have not replied back. You have not specified the MySql port

Your connection string is wrong.

I need connect to Mysql but I Can T Can Anybody Help me
Im use Fwh 8.05 xharbour 1.1. , Mysql 5 , My odbc driver 5.1

You have said that your ODBC Driver is 5.1 and in your connection string you have specified the driver as 3.51

Please change the connection string to

"Driver={MySQL ODBC 5.1 Driver};Server=YourServerIP;Port=3306;Database=YourDataBaseName;User=YourUserName;Password=YourPassword;Option=3;"

The Error
Mysql .prg

Application
===========
Path and name: C:\ADO2241\samples\mysql.exe (32 bits)
Size: 1,517,056 bytes
Time from start: 0 hours 0 mins 0 secs
Error occurred at: 01/06/09, 23:13:24
Error description: Error ADODB.Connection/0 S_OK: OPEN
Args:
[ 1] = C DRIVER={MySQL ODBC 3.51 Driver};server=www.freesql.org;database=test00;uid=myuser;pwd=mypass

Stack Calls
===========
Called from: win32ole.prg => TOLEAUTO:OPEN(0)
Called from: adordd.PRG => ADO_OPEN(0)
Called from: => DBUSEAREA(0)
Called from: mysql1.PRG => MAIN(0

Regards

Anser

[Databaselab2002]

Anser I put the por number but the problem exist
Im use odbc driver 5.1 y msql 5

USE test VIA "ADORDD" TABLE "stock" MYSQL ;
FROM "127.0.0.1:3306" USER "root" PASSWORD "

[ 1] = C DRIVER={MySQL ODBC 3.51 Driver};server=127.0.0.1:3306;database=test;uid=root;pwd=

thanks
Fabian

[kokookao2007]

HI :

I Had Same Problem for test ADORDD + MySQL.

1) try MySQL ODBC 3.51 smae error message as Databaselab2002 pasted .
2) try MySQL ODBC 5.1
a) Edit ADORDD.prg

case Upper( cDbEngine ) == "MYSQL"
oConnection:Open( "DRIVER={MySQL ODBC 5.1 Driver};" + ;
"server=" + cServer + ;
";database=" + cDataBase + ;
";uid=" + cUserName + ;
";pwd=" + cPassword + ;
";option=3" )

b) Error message as

Application
===========
Path and name: D:\PROGRAM\xHarBour\BLES_NEW\blessing.exe (32 bits)
Size: 5,936,640 bytes
Time from start: 0 hours 0 mins 37 secs
Error occurred at: 2009/02/03, 11:52:39
Error description: Error ADODB.Connection/0 S_OK: OPEN
Args:
[ 1] = C DRIVER={MySQL ODBC 5.1 Driver};server=127.0.0.1;database=item;uid=users;pwd=s1234;option=3

Stack Calls
===========
Called from: source\rtl\win32ole.prg => TOLEAUTO:OPEN(0)
Called from: \program\xharbour\BLES_NEW\ADORDD.PRG => ADO_OPEN(224)
Called from: => DBUSEAREA(0)
Called from: \program\xharbour\BLES_NEW\TEST_ADO.PRG => ADO_TEST(20)
Called from: \program\xharbour\BLES_NEW\BLESSING.PRG => (b)MAIN(755)

MYSQL VERSION : mysql-connector-odbc-noinstall-5.1.5-win32

ANYONE HELP ME ?

--
Best Regards
--------------------------------------------------------------
kokoo KAO