MS SQL Server ODBC - Trouble Connecting to Notes Domino through ODBC as linked server

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Trouble Connecting to Notes Domino through ODBC as linked server

Peter Capazzi

2005-04-05, 8:01 pm

Hello,
I have an established ODBC connection to a Notes Domino Server where I can
connect to tables and pull down information using MS Access. So as far as I'm
aware the ODBC part is confirugred properly.

Any guidance would be greatly appreciated...

I used the following link as a guide:
http://www.databasejournal.com/feat...cle.php/3462011

My linked server properties are
Provider Name: Microsoft OLE DB Provider for ODBC Drivers
Product name: Tracking_System {copied from dsn name}
Data source: Tracking_System {copied from dsn name}
Provider String/Location/Catalog: {null}
Security Tab - use this security context: (Notes user ID - fully qualified)
and my password - the same info I used to create ODBC which worked.
Server Options: Data Access and Use Remote Collation are the only items
checked... timeouts are both zero

Sponsored Links