By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,751 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Can't connect to SQL Server via ODBC

P: n/a
I just installed PHP 5.1.4 with SQL Server 2005 on my laptop. PHP is
running fine and so is SQL Server 2005. When I try to connect to SQL
Server from my my PHP code I get this error.

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect in
C:\Inetpub\wwwroot\index.php on line 5

Here's my connection string that is causing the error

$connect_id = odbc_connect("Driver={SQL
Server};Server=mydbname;Database=myDB","myUser", "myPass");
Any idea what's wrong? This is driving me nutts.. I installed PHP on my
computer at home and had no problem connecting to SQL Server. It's like
this laptop is cursed.

Jul 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
~john wrote:
I just installed PHP 5.1.4 with SQL Server 2005 on my laptop. PHP is
running fine and so is SQL Server 2005. When I try to connect to SQL
Server from my my PHP code I get this error.

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect in
C:\Inetpub\wwwroot\index.php on line 5

Here's my connection string that is causing the error

$connect_id = odbc_connect("Driver={SQL
Server};Server=mydbname;Database=myDB","myUser", "myPass");
Any idea what's wrong? This is driving me nutts.. I installed PHP on my
computer at home and had no problem connecting to SQL Server. It's like
this laptop is cursed.
Do you have the ODBC database registered with the correct driver?

I don't use odbc much - but most of the time I've found when it works on
one machine but not another there's a problem with how the database
and/or driver is registered (if it is at all).

It could also be a difference driver in levels; never worked with the
SQL Server driver.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.