Hi all, I feel little bit ashamed because I've read so many posts about it and still, I can't make a connection to MySQL.
I explain what I did.
1.- I've downloaded a "pack" found in some thread called
DBP_TPC_MySQL.zip.
2.- Following instructions, I've copied
DBP_TPC_MySQL_EXP.DLL into
Dark Basic Software\Dark Basic Professional\Compiler\plugins-user. I noticed it recognize now the mysql commands, so I guess this step is right, even the key words in the editor aren't highlighting.
3.- I restarted the program thinking, the changes have to be read.
finally, I try use this simple script:
MySQL_Init
MySQL_SetDBNullReplaceString " "
dbhost$ = "SERVER=localhost;"
dbuser$ = "USER=root;"
dbpass$ = "PASSWORD=;"
dbname$ = "DATABASE=k2k;"
dbdriver$ = "DRIVER=MySQL ODBC 5.1 Driver;"
dboption$ = "OPTION=3;"
test=MySQL_SetConnection(dbdriver$+dbhost$+dbname$+dbuser$+dbpass$+dboption$)
wait 250
if (test>0)
print "Successfully done."
else
print "Conexion failed."
endif
print str$(test)
wait key
end
I'm using EasyPHP V5.3.0 in localhost, and the program returns
conexion failed.
I'm not much skilled, I'm skilled Php, and the connection is really easy, what is missing?
Thank you so much.