Solved

mySQL with out odbc??

Posted on 2004-04-30
5
446 Views
Last Modified: 2010-08-05
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!
0
Comment
Question by:kwickway
5 Comments
 
LVL 1

Accepted Solution

by:
Eric_draven earned 75 total points
Comment Utility
Hi,

       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.
0
 
LVL 20

Expert Comment

by:hes
Comment Utility
0
 

Author Comment

by:kwickway
Comment Utility
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!
0
 
LVL 4

Expert Comment

by:lpzCoville
Comment Utility
Hi Eric_draven,

why not use an ole db provider?

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


0
 

Author Comment

by:kwickway
Comment Utility
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...
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now