unreal400
asked on
Mssql_pconnect function undefined?
I am running a copy of apache and php on a windows machine for testing purposes. I am trying to connect to a sqlserver 2000 database. I tried the mssql_pconnect function but I get the error that it is an undefined function.
Is there something I have to change to make this work? I am used to using mysql but this is the first time I am using php with a sql server database. Does anyone know why I am getting this error?
Kelly
Is there something I have to change to make this work? I am used to using mysql but this is the first time I am using php with a sql server database. Does anyone know why I am getting this error?
Kelly
The database you are trying to connect to may have pconnect or persistant connections disabled, so just use mssql_connect instead and it should work.
ASKER
I've tried that but the only way I can seem to get it to work is if I use odbc_connect instead of the mssql_connect. I'm not sure why the mssql functions won't let me connect. I still haven't been able to figure that out.
Why dont you install MYSQL instead of using MSSQL, it is much better and i am sure it will work great, just go here for a good stable version http://www.mysql.com/downloads/mysql-4.0.html and get the windows version with the installer, it makes things alot eaier.
ASKER
Oh trust me I would love to switch to mysql, I do tons of mysql PHP stuff at home and it works great. The problem is I have to do this for my office and they have a massive mssql database and I'm talking 300 GB of data and they do not want to convert to mysql for several reasons so I have to do this with a mssql backend.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.