[RESOLVED] MSSQL Connection

obrienkev

Hi all,

What does the below error mean?
Here's my odbc connection.

$db_link = odbc_connect($dsn, $username, $password)
or die('Error connecting to server. Server says: '.htmlspecialchars(odbc_errormsg()));

Error connecting to server. Server says: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Roger_Ramjet

Why are you using odbc to connect to mssql anyway? Try using the mssql functions instead. Much better functionality and performance. Odbc is a connection-of-last-resort when you have nothing else that will work.

Oh yes, that error message means that you have not set up your odbc datasource properly. That is something you do in mssql with the data source manager.

obrienkev

Hi Roger,

Forgot to uncomment in php.ini file but now I am having problems getting MS SQL Server 2005 with PHP 4.4.1

I uncommented extension=php_mssql.dll in PHP.INI file but no website on the server will load now.

I also copied ntwdblib.dll from system 32 folder to the PHP dll folder.

Any ideas?

Thanks.

Roger_Ramjet

No. I don't mix MS stuff with php - and would not use IIS for a web server in a pink fit. I've seen some threads on this sort of problem though so search the forums, or post in the Install forum for help on this.

obrienkev

Tried the php functions but doesn't give any error and doesn't connect...

// Connect to database
@$db = mssql_pconnect('localhost', 'training', 'training2');

if (!$db)
{
 	 echo '<p>Could not connect to database</p>';
	 exit;
}

// Select Database
mssql_select_db('training_dub'));

Doug_G

If you haven't, try connecting with Enterprise Manager or some other sql server tool to verify that your connection parameters are valid, use the same server name, username and password.

I use similar syntax on my xp pro development machine with sql server 2000, IIS 5.1 and php 5.0.4 without problems, connecting to the server on the same computer.

You could try disabling any firewall software or antivirus script blocking software for testing (assuming this doesn't expose your computer to the outside world).

obrienkev

If you haven't, try connecting with Enterprise Manager or some other sql server tool to verify that your connection parameters are valid, use the same server name, username and password.

How do I do this? Thanks.

Doug_G

obrienkev wrote:
How do I do this? Thanks.

Easiest is to create a new server registration with the credentials you're using in your code.

Full details are found in the SQL Server Books Online (a resource you should get familiar with if you're planning to use SQL Server).