This is a discussion on Linked Server ... Can I use a File DSN? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Linked Server File DSN? Can anyone help? I am trying to connect a Domino Server with the NotesSQL ODBC. ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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@andersonit.co.uk wyatt.anderson@nwmhp.nhs.uk |