| View previous topic :: View next topic |
| Author |
Message |
formula
Newbie
Joined: 10 Jan 2005
Posts: 3
|
 Posted: Jan 11th, 2005 04:32 PM Post subject: Mysql with VB |
 |
|
Hello,
I am doing my first steps with vb.
I try to connect to mysql db.
But with the data controler I have only option to connect to access or dbase, but not ODBC. How can I connect to ODBC?
Thanks,
formula |
|
| Back to top |
|
P.T.A.M.
Administrator
Joined: 08 Oct 2003
Posts: 752
Location: Greece
|
| Posted: Jan 14th, 2005 06:16 PM Post subject: |
|
|
You will need to download the ODBC connector from the website of mysql.
_________________
No one is completely useless. They can at least be an example of what to avoid. |
|
| Back to top |
|
TriSight
Regular
Joined: 12 Oct 2004
Posts: 69
Location: Mobile, AL
|
| Posted: Jan 18th, 2005 02:47 PM Post subject: |
|
|
There is actually a better way to connect to mySQL databases and that's using the DLL that comes with mySQL. If you want a reference, I wrote a query analyzer for mySQL that uses the DLL (thanks to a wrapper written by another programmer). If you wanna take a look at it you can get the code here:
[link]
_________________
/=--_The Nomad_--=\
"Men of lofty genius when they are doing the least work are most active. " - Leonardo da Vinci |
|
| Back to top |
|
formula
Newbie
Joined: 10 Jan 2005
Posts: 3
|
| Posted: Jan 18th, 2005 05:39 PM Post subject: |
|
|
I downloaded that, and I get an error in this line:
mlMYSQL = mysql_init(mlMYSQL) |
|
| Back to top |
|
TriSight
Regular
Joined: 12 Oct 2004
Posts: 69
Location: Mobile, AL
|
| Posted: Jan 19th, 2005 08:35 AM Post subject: |
|
|
What error are you getting? Also, keep in mind that I made it so that you can pass the login information into the exe.. so you will need to go into the Project->Properties and click on the Compile tab and remove the login information from the Command Line Arguments.. that's probably the issue you are having.
_________________
/=--_The Nomad_--=\
"Men of lofty genius when they are doing the least work are most active. " - Leonardo da Vinci |
|
| Back to top |
|
|
