Unix Technical Forum

Linked Server ... Can I use a File DSN?

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. ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-03-2008, 02:49 PM
Wyatt
 
Posts: n/a
Default Linked Server ... Can I use a File DSN?

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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:34 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com