I'm trying to use cfupdate with a new MS SQL server database... I'm
getting the error below(I'm brand new to SQL server)

THIS IS THE CFUPDATE STATEMENT:
<cfupdate datasource="customers" dbtype="odbc" TABLENAME="
testdatabase.myusername.customers">

THIS IS THE ERROR:
The Primary key for table "agents" was not found in the datasource

This error may be caused by not specifying the table name in the format
that the database server expects. (For example. Oracle Server table name
must be upper case or the Server table name must be qualified in the
format of "schema.table_name". For the SQL Server, the format is
"databasename.username.tablename", such as in customers.dbo.orders)

What username are they referring to?... I assume the sql server username

Any help would be appreciated

Tim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to