Connection String?

2003-03-14 Thread Tamayo, Nelson
I am trying to connect to MySQL without using a DSN entry, this is my connection string DRIVER={MySQL ODBC 3.51 Driver};SRVR=159.113.44.49;DB=csapps;UID=user;PWD=password The error I get is "Invalid connection string attribute" Any ideas? Nelson Tamayo Claims Automation (800) 237-7767 x3520

MySQL Goofup

2003-03-13 Thread Tamayo, Nelson
This is going to sound silly, but I accidently removed the privelages of my user that could add users..etc.. I use the Control Center, since I am not all that great with advanced SQL syntax... now I can't even use the CC to add users, or anything.. what can I do? What is the username/password that

Converting DBs

2003-03-12 Thread Tamayo, Nelson
Is there a way to convert an Access database into MySQL easily? I am running into problems trying to convert it through VB code using a recordset. I'm rather new at this stuff. I'm also tried generating an insert statement through VB code and then executing it, I get the error "Unknown column 'Fal