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