OpenLink provides single-tier ODBC Drivers for MS SQL Server from Mac OS X - these support the additional data types and will work against either Sybase ASE or MS SQL Server, on any platforms they run on. 30-day downloads are available from our site at http://www.openlinksw.com
Director of Technology Evangelism - OpenLink Software
Universal Data Access and the Virtuoso Universal Server
On Sunday, October 27, 2002, at 12:22 AM, Frank M. Kromann wrote:
It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info:
Sybase and MS SQL Server used to be the same product back when 4.x was released. Then Microsoft released 6.0 including a set of C libraries and everything was fine. Microsoft has not released new versions of the C libraries but they have added a lot of new features to the server with version 6.5, 7.0 and 2000. These features are not available from the C libraries so no matter if you are using the native MSSQL extension for Win32 or you use the Sybase extension with FreeTDS you are limited to the features available in version 6.0 of MS SQL Server.
These limitations include char and varchar columns with maximum 255 bytes. No support for nchar, nvarchar or ntext and other types as well. If you can design your tables without using the new features you should be able to make it work.
One of the big differences in the SQL is support for views and subselects in MS SQL Server but stuff like LIMIT is not supported (though you can do a select top * ...).
Say, are there any arguments not to use MS-SQL?
Did you run into any problems?
From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com]
Sent: Friday, October 25, 2002 3:14 PM
To: Axel; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] PHP and MS-SQL
Well, I'm not sure what everyone will tell you, but this is what I did. I used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL Server have quite a few differences with SQL Statements. As far as the rest of your code, it should not matter if it's on UNIX or Windows.
Web Applications Developer
Cox Communications www.cox.com
From: Axel [mailto:bergmann@;hi.net]
Sent: Friday, October 25, 2002 6:57 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP and MS-SQL
I want to apologize for my ignorance in advance...
I'm developing PHP code with MySQL on Unix platforms for
quite a while. Now
I'm asked to use my unix based PHP code with a MS-SQL database on a
Microsoft platform. So while having the php code on a unix
MS-SQL database is obviously sitting on a Microsoft platform.
Can this work
and if so how can I do this?
Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php