It really boils down to what is your favorite programming language? You
say you are using vb? If so, there isn't a lot that would need to be
changed in your current vb app (if that is what you have and not vba in
access). The key will be to get the odbc driver, and use ado (at least
that's what I use). I wrote a few cross-db apps to accept using mysql,
mssql, and access. There are a few things different that would need
changing (cursors is one thing that comes to mind). HTH.
Oh,
Here's a connect string to the db (with ado)
DBConnectionString="driver={MySQL ODBC 3.51
Driver};server=[server-ip-or-name];port=3306;uid=[username];pwd=[passwor
d];database=[database];stmt=;OPTION=17346"
Watch for line wraps, and what's inside the []'s are what you need added
Thanks,
James
-----Original Message-----
From: Li, Dahuan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 2:29 PM
To: [EMAIL PROTECTED]
Subject: What fornt programing language should be used with MySql?
Hello, Everyone,
I'd like to get some comments form you.
I have developed some window database applications from MS Access with
VB.
My boss wanted me use mysql to develope new web database application and
rewrite my current database application using MySql.
Any one can point me the right direction to go?
I used ODBC to get Mysql database from Access. I looked at the database
from
SQLyog. The relationship gone and always get error to set it.
Thanks for any comments or suggestion.
Daphne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
