Page 1 of 1
help Problem with Adordd
Posted: Fri Jan 09, 2009 8:24 pm
by 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
Re: help Problem with Adordd
Posted: Sat Jan 10, 2009 5:15 am
by 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
Re: help Problem with Adordd
Posted: Sat Jan 10, 2009 12:43 pm
by 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
Re: help Problem with Adordd
Posted: Tue Feb 03, 2009 4:03 am
by 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