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 +0000, 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
