Kbase P25067: ODBC error 42000 when attempting to move records from Progress database db on UNIX to Microsoft SQL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/9/2008 |
|
Status: Verified
SYMPTOM(s):
ODBC error 42000 when attempting to move records from Progress database db on UNIX to Microsoft SQL Server via SQL DataServer
Attempting insert from Progress editor through the DataServer/schema holder gives 42000: [Microsoft] [ODBC SQL Server Driver] [SQL Server] insert permission denied on Object '<filename>', database '<DB_Name>', owner '<Owner_name>'
FACT(s) (Environment):
The pf file contains pervious password that has been changed recently. The user name and the password was not changed in the pf file to reflect the new one
MS SQL DataServer
Progress 9.1x
OpenEdge 10.x
MS SQL
Windows
CHANGE:
The user name and the password to connect to the SQL Server had recently been changed
CAUSE:
The user name and the password to connect to the SQL Server had recently been changed. The pf file was not modified to reflect the new user name and the password to connect to the SQL Server database.
FIX:
Change the -U and -P attributes in the pf file to reflect the new SQL Server database's user name and the password.