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