Link to home
Start Free TrialLog in
Avatar of dawnyd01
dawnyd01

asked on

MySQL - API (mySqlLib.dll)

Hello, How can you make tables with this api?  
ASKER CERTIFIED SOLUTION
Avatar of eAi2k
eAi2k

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dawnyd01
dawnyd01

ASKER

The whole reasion for the dll is not to have anything to do with myODBC or ODBC and dsn's.
Found out how by just playing around with it....  check it out, it works great...

Dim mysql_options As Long
Set mysql = New cMysql
mysql.real_connect txtHost, txtUser, txtPass, txtDB, CLng(txtPort), , 0
mysql.query "CREATE TABLE people5(name varchar(50), email varchar(50))"
Set mysql = Nothing
If mrec Is Nothing Then Else mrec.Close
Set mrec = Nothing

sys admin, please do not delete this question, just refund points so people can learn from this.

Thanks.