Kbase 20060: Invalid Attribute in Connection String. ODBC Error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/21/2003 |
|
Status: Unverified
SYMPTOM(s):
MERANT ODBC driver
Data extraction failure.
SQL code scheduled to run as a DTS job.
[MERANT][ODBC PROGRESS driver]Invalid attribute in connection string.
SQL 7.0 server
CAUSE:
The problem comes from the SQL server. When the extract is run via SQL
Executive/SQL Agent, the job runs with the same Windows NT credentials as the NT user account that the SQL Executive/SQL Agent service is running under. This user account needs to have access to the network resources concerned (shares, files, printers etc).
FIX:
Check which NT user account is being used by going to control panel > services > startup. If it is using the Local-System account, then there is no network access.
Any network resources that you do use, must be referenced by UNC name and not a specific drive letter (for example, \\server1\bcps and not H:\).