Hey folks,
I'm having trouble with inserting into a table I've just created.
As a summary of what I'm doing:
- if the table exists, delete it
- create the table
- read from the table to prove it's there
- insert into the table
*splat* : "Invalid object name..."
I can post the full code and error if you want.
All the other forum posts around the web say things like:
- check the user permissions
- the user in the datasource has db_owner, and for good measure
db_datawriter, db_datareader.
- reference the table in the INSERT with the owner (ie: dbo.tablename)
- I've gone so far as to look up the owner in sysobjects
- if using JDBC driver then set selectMode=cursor
- done
Thought it might be related to http://support.microsoft.com/kb/837970/ so I'm
now running this on a different new fresh SQL server, with SP4 installed.
The same error occurs on CF5 and CFMX7.
Even when I try the Insert without the Create Table it fails. (ie: run once so
table is created, then rem out the Create Table bit and run it again.)
All suggestions welcome...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255156
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
