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]