I have searched the forums on this issue and have found nothing that resolves my issue.
My Environment:
Visual Studio 2008
VS.php 2.7 for VS 2008
I am connecting to MS SQL Server 2005
The MS SQL SQL 2008 Native Client is installed
I've verified the following:
I am running the Local Configuration, which is configured to use PHP 5.
I am using XDebug.
I can connect to the SQL Server using SQL Server Management Studio
The mssql plugin shows as enabled when I run phpinfo.
Secure connection is turned off
I have uninstalled and reinstalled the program (as one post suggested), but still have the issue.
I receive the following error(connection info has been edited out):
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: in
here is the connection string in the file(this works in our dev and production servers):
mssql_connect(SQL_HOST, SQL_USER, SQL_PASS)
The variables are correct as it displays the correct sql server(from SQL_HOST) in the error message.
Here is the mssql info from phpinfo:
mssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0
Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60
Any help with this is appreciated.
juanc says:
What's the exact 2.7 build that you are using?
Also most likely the issue has to do with ntwdblib.dll
Perhaps you need to update this dll which is located in the VS.Php program files directory.
Pharmakon says:
I'm using build 2,7,5,6034.
Ok, I downloaded ntwdblib.dll version 2000.80.194.0, and dropped it in
C:\Program Files\Jcx.Software\VS.Php\2008\Php 5. I am still having the same issue.
Pharmakon says:
Also,
When I load php_mssql.dll in dependency walker I get the following issues:
ntwdblib.dll - missing
IEShims.dll - missing
IEFrame.dll - Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.
I fixed the first two by copying the dlls directly into the 2008/Php 5/ext directory.
I have not been able to resolve the issue with IEFrame.dll
juanc says:
Actually, the ntwdblib.dll needs to be in the Apache2\bin directory.
The other two you can ignore...
Pharmakon says:
Awesome, it works now. Thank you!
juanc says:
Could you please email me that version? I'll like to include the correct version in the installer.
support at jcxsoftware
Thanks,
Juan
Pharmakon says:
Just emailed it to you.