Solved

mySQL with out odbc??

Posted on 2004-04-30
5
454 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 1

Accepted Solution

by:
Eric_draven earned 75 total points
ID: 10960854
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
ID: 10961081
0
 

Author Comment

by:kwickway
ID: 10961326
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
ID: 10961699
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
ID: 10968689
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

688 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