mySQL with out odbc??

hello, if i create a program that uses an odbc connection to connect to a mysql db server, is there a way to make the program dependent?  I mean can i somehow create a program that allows me to connect to my server with out an mysql db odbc?

can you show some code?  thanks!
Who is Participating?
Eric_dravenConnect With a Mentor Commented:

       I've have been trying to do the same thing for some time now with no success. I found out that in recent versions of MySQL there is a file called libmysql.dll which enable you to talk to mysql without odbc drivers, but i think it only works for the C language. I may be wrong about this.
kwickwayAuthor Commented:
Thanks, i will look at this as soon as i can access my remote desktop again, might be tonight.  But i was going to say, if you read the how to instructions on that web site, its funny because it tells you how do down load it.  I think if a programer needs that kind of instruction, then he probbly doesnt know how to program ;)  Just thought that was funny..

Thanks again!
Hi Eric_draven,

why not use an ole db provider?

oConn.Open "Provider=MySQLProv;" & _
           "Data Source=mySQLDB;" & _
           "User Id=myUsername;" & _

kwickwayAuthor Commented:
hes:  I tried the code, i can see how it could work, but i can't figure this out, can you help me?  Can you make it:

1) Connect to the server with the suername and password
2) Create a database called "DB1"
3) Create a table under "DB1" called "TB1"
4) Create 4 fields "F1, F2, F3, F4"
5) Enter 6 lines of info in each field
6) Pause it so you can go to the contorl and look at your database and make sure its there.
7) find a record one of the ones you just added.
8) Remove a line
9) kill the db1 database
??  I can't figure this out.  If you need access to my serverand a userid, let me konw...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.