Linked Server File DSN?
Can anyone help? I am trying to connect a Domino Server with the NotesSQL
ODBC.
I was unable to set the ODBC up as a System DSN ('The setup routines for the
Lotus NotesSQL Driver (*.nsf) ODBC driver could not be loaded due to system
error
code 126') and had to set it up as a file DSN.
Can I still set up a Linked Server to it? I keep getting errors:
'7399 Invalid Connection String attribute]
(not sure what I was supposed to enter in the 'Product String' dialog box)
Datasource name not found and no default driver specified]....'
The file DSN was setup OK. I know this because I can use it as a connection
in
DTS and successfully import various tables (although it does not work with
the
import wizard?)
Does anyone know if I can use the file DSN to setup a linked server?
If so, what do I put in the 'provider string' and 'catelog' dialogs.
Any help much appreciated. wyatt.DeleteThis@andersonit.co.uk
wyatt.anderson.DeleteThis@nwmhp.nhs.uk
>> Stay informed about: Linked Server ... Can I use a File DSN?