Solved

How to update my mysql database(is in www.kgmsoft.com) thru vb

Posted on 2004-07-30
5
466 Views
Last Modified: 2010-05-02
i want to update my mysql database(is in www.kgmsoft.com) thru vb. any one pls
thanks
0
Comment
Question by:ackid32
5 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 250 total points
ID: 11675987
0
 
LVL 2

Assisted Solution

by:ingomar
ingomar earned 250 total points
ID: 11683184
You will need the MyODBC Driver installed on your pc.  It can be downloaded at http://dev.mysql.com/downloads/

Here is a sample connection string using the latest MyOdBC driver:

dbconn.Open "Driver={MySQL ODBC 3.51 Driver};Server=dburl;Database=dbname;UID=dbuser;PWD=dbpass;OPTION=16387;"
0
 

Author Comment

by:ackid32
ID: 11683207
i can open mysql database in my lan server, thru dll
but how can i open it stored in WEB (kgmsoft.com)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

708 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

15 Experts available now in Live!

Get 1:1 Help Now