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]
RE: What fornt programing language should be used with MySql?
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]
Re: What fornt programing language should be used with MySql?
Daphne, There are two or three parts to this application. It all depends on how you are designing it. You put so many things in one sentence that I cannot figure out what you have already done and what you have been asked to do. You mentioned web database. Does that mean that you will have this application structure - user web browser web server database - or is it - user vb application database - where the communication between your VB application is and the server is accomplished over a network? If you need to develop the first scenario: What web server will you be using? Will it be scripted or CGI? If scripted, in what language? Please, take your time and explain your project requirements and your available resources. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Li, Dahuan [EMAIL PROTECTED]To: [EMAIL PROTECTED] a.Uscc: Fax to: 06/30/2004 02:28 Subject: What fornt programing language should be used with MySql? PM 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]
