Coldfusion SQL Server 2005 connectivity issue
Posted on 2006-11-12
I'm having troubles getting SQL Server 2005 Express to recognize my CF queries. I had SQL Server and CF working properly but had hard drive issues and had to reformat. I've reinstalled everything but now I'm getting this error message on all queries:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'color'.
The error occurred in C:\Inetpub\wwwroot\cfdocs\ruthSisters\store\test.cfm: line 11
10 : <!--- <cfquery name="getCategories" datasource="#request.db#" username="#request.username#" password="#request.password#"> --->
11 : <cfquery name="getCategories" datasource="ruthsisters" username="sa" password="xxxxxxx">
12 : SELECT *
13 : FROM color
14 : </cfquery>
"Color" is the name of a column in the database.
The install for both CF and SQL I believe is fine. I'm concerned because usually I've assigned port 1433 to the SQL db in the CF admininistrator. The only way CF will verify the db is if I use port 1259. I've went into Windows administrative tools and established an ODBC connect which is verified. I believe that I have everything as before but something is not working.
Thank you for any help you can give!!!!!