PHP - MySQL - SQL7 Server - Visual Basic.
Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. Thanks, Bob Hiller - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP - MySQL - SQL7 Server - Visual Basic.
Bob, I've posted this back onto the list because there are others here who will be much more able to assist. Clarification: I currently have 22 NT workstation that send data to various tables in a SQL7 database running on a NT sever. The visual basic front end organizes this data in to a neat fashion and allows the user to graph and print data and comparisons from the various tables. The front end also responds to e-mail requests for information from the tables. Currently there are only 12 authorized e-mail accounts so it is easy to manage. We are now going to add about 100 workstations, More tables and 200 authorized e-mails accounts. With this addition I have decided to eliminate the e-mail accounts and post all of this information to a secure web server that I will administer. So what I need to do is have a VB program write this data to a MySql database that will only allow users to view the data. I have extensive VB experience and have created and updated many types of databases using it, however I have never used MySql and need some pointers. Can Vb create and write to MySql databases? =yes, using an ODBC or ADO interface. What syntax do I use in PHP to read the MySql database? =PHP has a wide range of interface functions 'built-in'. =Why use two RDBMS'? PHP can access MS-SQL to provide the web service. =dn Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP - MySQL - SQL7 Server - Visual Basic.
Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? =Please clarify, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP - MySQL - SQL7 Server - Visual Basic.
Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. Thanks, Bob Hiller - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP - MySQL - SQL7 Server - Visual Basic.
Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? =Please clarify, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP - MySQL - SQL7 Server - Visual Basic.
Bob, I've posted this back onto the list because there are others here who will be much more able to assist. Clarification: I currently have 22 NT workstation that send data to various tables in a SQL7 database running on a NT sever. The visual basic front end organizes this data in to a neat fashion and allows the user to graph and print data and comparisons from the various tables. The front end also responds to e-mail requests for information from the tables. Currently there are only 12 authorized e-mail accounts so it is easy to manage. We are now going to add about 100 workstations, More tables and 200 authorized e-mails accounts. With this addition I have decided to eliminate the e-mail accounts and post all of this information to a secure web server that I will administer. So what I need to do is have a VB program write this data to a MySql database that will only allow users to view the data. I have extensive VB experience and have created and updated many types of databases using it, however I have never used MySql and need some pointers. Can Vb create and write to MySql databases? =yes, using an ODBC or ADO interface. What syntax do I use in PHP to read the MySql database? =PHP has a wide range of interface functions 'built-in'. =Why use two RDBMS'? PHP can access MS-SQL to provide the web service. =dn Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP - MySQL - SQL7 Server - Visual Basic.
Hi bob, I have do everything you need but may be a little diff. I have MS SQL 6.5 on NT, MySQL 3.23.47 on Linux and using PHP / VB 6 for client. The first thing you must define some role of usage and other, how to manipulate your data. I have PHP update routing in some project (transfer via ftp function, read along text file and then update data to MySQL). If you need to access to MS SQL via PHP try to use FreeTDS on Linux (may be they have copy on NT). All you need about MySQL are on the Web. If you need to access MySQL via VB: try to use MyVBQL at www.icarz.com/mysql/. MyVBQL using libmysql.dll to access MySQL and let you used recordset style in your application. Sommai, At 20:53 5/2/2002 +, DL Neil wrote: Bob, I've posted this back onto the list because there are others here who will be much more able to assist. Clarification: I currently have 22 NT workstation that send data to various tables in a SQL7 database running on a NT sever. The visual basic front end organizes this data in to a neat fashion and allows the user to graph and print data and comparisons from the various tables. The front end also responds to e-mail requests for information from the tables. Currently there are only 12 authorized e-mail accounts so it is easy to manage. We are now going to add about 100 workstations, More tables and 200 authorized e-mails accounts. With this addition I have decided to eliminate the e-mail accounts and post all of this information to a secure web server that I will administer. So what I need to do is have a VB program write this data to a MySql database that will only allow users to view the data. I have extensive VB experience and have created and updated many types of databases using it, however I have never used MySql and need some pointers. Can Vb create and write to MySql databases? =yes, using an ODBC or ADO interface. What syntax do I use in PHP to read the MySql database? =PHP has a wide range of interface functions 'built-in'. =Why use two RDBMS'? PHP can access MS-SQL to provide the web service. =dn Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
