It is not clear what you want to do? Do you want to export data from MSSQL to MySQL or connetc to a MSSQL server, or both? To export data: Then use the shell command bcp.exe (Bulk CoPy) to copy data out from the tables of MSSQL to the file system, and then use the corresdponding buck program with MySQL. However this I would think that you would getter better answers from the MySQL mailing list in the precis details on bulk copy data with MySQl. To connect to MSSQL: There is a good ducumentation on how to do this at the www.php.net pages. Check out this link: http://nl.php.net/mssql_connect >From there on you should be able to find any thing you might need in order to connect to MS SQL server. -----Original Message----- From: BhongOng To: php-windows@lists.php.net Sent: 28-8-03 15:09 Subject: [PHP-WIN] MS SQL questions Hi, I'm using MSSQL for my database application and not yet ready to transfer my data to MySQL because of the file limit. We have a very huge database. MS SQL 7 Windows2000 Adv. Server IIS 5 PHP 4.3.0 MySQL with MyODBC Visual Basic & MS Access as client We are developing a web application to access our data from MS SQL.. what are the softwares or driver do we need? Can somebody give me some code samples? I tried to use mssql_connect() syntax but it returns some error.. Thanks. Calixto Ong II -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
