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 * ...).
> Thanks John!
> Say, are there any arguments not to use MS-SQL?
> Did you run into any problems?
> -----Original Message-----
> 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.
> John Negretti
> Web Applications Developer
> Cox Communications www.cox.com
> > -----Original Message-----
> > 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
> > platform the
> > MS-SQL database is obviously sitting on a Microsoft platform.
> > Can this work
> > and if so how can I do this?
> > Thanks,
> > Axel
> > ______________________________________________________________
> > ____ Axel
> > 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