| A. Bellermann 2005-03-30, 9:40 am |
| Hi,
I have 2 Navision companies which are connected to SQL2000 via C/ODBC as
linked servers.
I need to get some tables copied to the SQL Database.
Therefore I have created for each company a stored procedure which selects
the data with the openquery-command and does an insert to the SQL-DB.
When running the stored procedure the first time for company 1 the data
import works fine.
When running the sp the first time for company 2 the data import also works.
NOW: If I run the stored procedure the 2nd time i'll get the following error
message:
DBCC-Ausführung abgeschlossen. Falls DBCC Fehlermeldungen ausgegeben hat,
wenden Sie sich an den Systemadministrator.
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Prozedur
sp__import_contact_c
h, Zeile 20
Der OLE DB-Provider 'MSDASQL' meldete einen Fehler. Fehler bei der
Authentifizierung.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Fehler
bei SQLSetConnectAttr-Aufruf für Treiber]
[OLE/DB provider returned message: [Microsoft Business Solutions
ApS][Microsoft Business Solutions-Navision ODBC Driver]Data source rejected
establishment of connection]
OLE DB-Fehlertrace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initi
alize
returned 0x80040e4d: Fehler bei der Authentifizierung.].
has anyone an idea ?
any help appreciated !
Thanks / Axel
|