Agent can't access network drive via ODBC from MS Server 2003

HCL Domino Domino Forum
1

Problem is, I cannot access Network drive via ODBC after OS Migration NT4 to MS Server 2003 = Import from MS Access 2000 DB to Notes DB.

  • ND runs as Service with Domain Account(Admin)

  • Network Drive is mapped with the same Domain Account

  • System DSN is created(MS Access 2000 DB)

  • Access via ODBC works from the same Srv with Notes Client

  • Access via ODBC to local drive works,too

ND 6.5.6 FP2 and Windows Server 2003 SP2

The agent (Security Level 2 and Server-signed) starts and does never end - restart from Domino is needed…

What is my problem?

2

Subject: Agent can’t access network drive via ODBC from MS Server 2003

Have you tried using UNC paths for the data?

I’ve never had much luck using MS Access via ODBC with an agent. Better to move to an MS-SQL server. You can keep the Access front-end by linking the tables to MSSQL via ODBC.

3

Subject: RE: Agent can’t access network drive via ODBC from MS Server 2003

In the odbc _Administrator on the 2003 Server I can only use mapped drives, in my case I use H:, H:\ is mapped by the same Domain Account, and for a test I could start a repair in the odbc-Administration Tool. Test connection is not availiable for Access DB’s.