Jump to content

Problems connecting to MSSQL (ODBC?)


Recommended Posts

I made a site using PHP, on my development server. But on the live server, I have problems getting a database connection.



Connection could not be established.

Array ( [0] => Array ( [0] => IM002

[sqlSTATE] => IM002 [1] => 0
 => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )

I have set up ODBC, and testet the connection sucessfully!

My ODBC is configured like this:
Microsoft SQL Server ODBC Driver Version 03.86.3959

Data Source Name: Zeus
Data Source Description: 
Server: Zeus
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

I'm using this PHP code:
function DB_Conn_Zeus ($dbname, $tsql)
        $serverName        = "\Zeus,1001"; 
        $uid             = "xxx"; 
        $pwd             = "xxxxxx";
        $connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>$dbname);
        $conn = sqlsrv_connect( $serverName, $connectionInfo);
        if( $conn )
            //echo "Connection established.<br />";

Can anyone see where the problem is?

I can ping the MSSQL server, and classic ASP seems to work just fine.

Link to comment
Share on other sites

Have you checked the sql server logs to verify your server is listening on port 1001?  And I'm not sure you should put the sql server name after the IP


And since port 1001 is a non-standard sql server port you may have some firewall problems, or there may be something you need to configure in the odbc drivers.


Link to comment
Share on other sites

I don't know if the port number is the problem. The error you are showing in your first post tells me that the correct version of ODBC is not installed on the same machine that is running PHP. Have you installed the latest ODBC on that machine?


If the port number is the issue, try this:


$serverName        = "Zeus,1001";


The way you were doing it, it looked like Zeus was an instance name (not sure that's your set up).


More info here: http://msdn.microsoft.com/en-us/library/cc761422(SQL.90).aspx



Link to comment
Share on other sites

I can connect to the database in classic ASP, using this connection (same server, different name):

I tried this info in PHP, didn't work either - same error.



Set oConNews = Server.CreateObject("ADODB.Connection")

oConNews.ConnectionString = "Provider=SQLOLEDB;Server=WebSQL;UID=xxx;PWD=xxx;Database=dbname"



Link to comment
Share on other sites

I solved this problem, by using odbc_connect() instead of sqlsrv_connect()..

Have no idea why sqlsrv failed, but as long as I have a connection, I’m happy!

odbc_connect() has problems returning results from some of my stored procedures, but i can live with that for now.


- Tank you for your time!


Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.