[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 674
  • Last Modified:

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
0
unreal400
Asked:
unreal400
  • 2
  • 2
1 Solution
 
TaintedGodCommented:
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.
0
 
unreal400Author Commented:
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.

0
 
TaintedGodCommented:
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.
0
 
unreal400Author Commented:
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.
0
 
aolXFTCommented:
You probably don't have the mssql extension installed.

Check a phpinfo() page to see if there is any reference to mssql there(in the extensions section)

If it is commented(has a ; in front of it) uncomment it(remove semicolon);
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now