Computing.Net > Forums > Programming > MySQL ODBC and VB6

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MySQL ODBC and VB6

Reply to Message Icon

Name: siteforge (by Greg Apel)
Date: September 5, 2006 at 12:22:47 Pacific
OS: WinXPP
CPU/Ram: 800mhz AMD Duron
Product: generic
Comment:

My particular project is a peer-to-peer messenger which obtains the IP addresses of users and establishes winsock host/client sockets and transmits messages. But in order for someone to contact another, the username must be exposed or populate a listbox (with the IP embedded as item data).

A possible solution would be to use a MySQL database on a webserver for login information - Name, IP address, form state, etc. This information would be sent to all client applications and exposing all members logged in, allowing a user to select a name on the list, and connect to them with the hidden IP address information.

The Problem: this requires a client to query a remote MySQL database through a Visual Basic 6 application, and to do this they must have local ODBC connectivity.

I have thought about all the alternatives - bundling MyODBC driver/connector in the installer, but then the client would have to figure out DNS settings, etc. - which would defeat the user-friendly scheme of the program, and also install two programs instead of one.

Is there an easy solution to query a remote MySQL database (on a linux webserver) with VB6, and not require the client to install a complicated driver?



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


C++ and Arrays Java Method Question



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: MySQL ODBC and VB6

VB6 Mysql remote connection string www.computing.net/answers/programming/vb6-mysql-remote-connection-string/13709.html

Coldfusion and MySQL www.computing.net/answers/programming/coldfusion-and-mysql/1682.html

Creating sql tables vb6 www.computing.net/answers/programming/creating-sql-tables-vb6/13895.html