Hey all, I just set up a new machine at home, and am trying to setup a
db connection between a new CF application (BlogCFC) and SQL Server 2005
Express. I was able to successfully get the datasource set up in the
admin, but even the most simple of queries is failing (see message
below) saying that none of the objects I'm specifying are in the
database. I've tried accessing them without a predicate and with 'dbo'
and the actual username that owns the database and nothing works. I
take the same query and run it in the SQL Console and it works.
Anyone have a good amount of experience with SQL Express yet? I've not
had this problem on two other machines that I've set up with
Express/CFMX.
I'm about to turn on my debugging levels full blast but thought I'd
shoot the list a question in case someone had seen this before.
------------------------------------------------------------
Error Executing Database Query.
Invalid object name 'dbo.tblBlogComments'.
The error occurred in
C:\jboss\server\default\.\deploy\orbwave.war\test.cfm: line 1
1 : <cfquery datasource="Blog" name="days" username="{myUsername}"
password="{myPassword}">
2 : select *
3 : from dbo.tblBlogComments
------------------------------------------------------------
- Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239418
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
