I am experimenting with MySQL and need some help. I have installed the latest stable release of MySQL and have also installed the latest ODBC as well. The ODBC is configured as follows:
System DSN
Windows DSN Name: X...X
Host name (blank)
MySQL database name: test
User: (blank)
Password: (blank)
Port: (blank)
SQL command on connect: (blank)
Don't optimize column width: checked
All others: unchecked
My problems:
1. When I connect to the data source (lDB = sqlconnect('test') ) results in the ODBC dialog appearing on the screen. All I do then is press OK and I have a connection.
2. I am not able to create a table with the following syntax:
llok = sqlexec(lDB,'create table junk ( fld1 c(10) )')
What am I doing wrong?
Thanks
Glenn
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement