[PHP] MS SQL Server and ODBC

2002-07-11 Thread Tim Nields
I am attempting to connect to a MSSQL 2000 database from a linux box. I have installed freetds successfully and configured php with sybase as directed by freetds. I configured the freetds .conf file. However this is where I have questions. The freetds.conf file only asks for the ip address of

Re: [PHP] MS SQL Server and ODBC

2002-07-11 Thread Adam Voigt
Check out the mssql_select_db function. Call it right after the connection open. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-11 at 12:31, Tim Nields wrote: I am attempting to connect to a MSSQL 2000 database from a linux box. I have installed freetds successfully and configured php with

Re: [PHP] MS SQL Server and ODBC

2002-07-11 Thread Michael Davey
Errr - doesn't that function apply to mySQL databases only? Mikey Adam Voigt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Check out the mssql_select_db function. Call it right after the connection open. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-11 at

Re: [PHP] MS SQL Server and ODBC

2002-07-11 Thread Adam Voigt
I wouldn't have said it if it did. Notice that it's MSSQL_select_db not MYSQL_select_db. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-11 at 10:03, Michael Davey wrote: Errr - doesn't that function apply to mySQL databases only? Mikey Adam Voigt [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP] MS SQL Server and ODBC

2002-07-11 Thread Michael Davey
doh! Adam Voigt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I wouldn't have said it if it did. Notice that it's MSSQL_select_db not MYSQL_select_db. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-11 at 10:03, Michael Davey wrote: Errr - doesn't that

Re: [PHP] MS SQL Server and ODBC

2002-07-11 Thread Michael Davey
However, this still wouldn't work for ODBC... Adam Voigt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I wouldn't have said it if it did. Notice that it's MSSQL_select_db not MYSQL_select_db. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-11 at 10:03,

Re: [PHP] MS SQL Server and ODBC

2002-07-11 Thread Adam Voigt
Ofcourse not. I didn't say it would. ODBC and FreeTDS (which is what he said he was using) are two totally different drivers. Thats like saying mysql_select_db wouldn't work for Oracle databases, ofcourse they wouldn't, there different drivers. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-11 at