SQL Connection Problems

[emeade]

Ever since installing Windows XP service pack 2 I've been having problems
registering and using a SQL Server 2000 database with Coldfusion MX 7
Developers edition. I'm running everything local on my laptop with Win XP pro
(IIS, SQL Server 2000 and CF MX7 Developer). I am unable to register a SQL
database using the Microsoft SQL Server driver in the CF Admin. I read some
posts that said to use an ODBC Socket which I did and am able to register with
the CF Admin and verify. But now when I run a query I get the following error:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid object name 'Users'.

The error occurred in C:\Inetpub\wwwroot\sites\MyCMS\index.cfm: line 1

1 : <cfquery name="loginQuery" datasource="CMS">
2 : SELECT UserID, UserName, Password
3 : FROM Users</cfquery>




--------------------------------------------------------------------------------

SQL SELECT UserID, UserName, Password FROM Users
DATASOURCE CMS
VENDORERRORCODE 208
SQLSTATE 42S02

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)
Remote Address 127.0.0.1
Referrer
Date/Time 17-Sep-05 04:38 PM

Stack Trace (click to expand)

I've tried adding a username/password to the query but still got the same
error. I'm at a total loss and would really like to be able to get this working
locally so I can do some offline development.

[mxstu]

Did you make sure any firewall settings allow communication with your database?
What was the exact error message you received when using the "Microsoft SQL
Server" driver?
Did you set the default database in the ODBC DSN configuration? Otherwise I
think it defaults to the "master" database.

[emeade]

Thanks for the quick response. So of couse as soon as I post I get it to work.
I tried using the SQL Server Driver one more time and changed the Server from
(Localhost) to 127.0.0.1 and it worked. I thought I had already tried that. Go
figure. Thanks.

[mxstu]

That happens sometimes. Glad it is working now.

[The ScareCrow]

You have to install sp 3 for sql server after you have installed sp2 for xp

Ken