Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

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

 
   Database Forums (Home) -> ODBC RSS
Next:  Access my profile Details in  
Author Message
Wyatt

External


Since: Apr 01, 2008
Posts: 1



(Msg. 1) Posted: Tue Apr 01, 2008 12:23 pm
Post subject: Linked Server ... Can I use a File DSN?
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

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? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Linked Server for DB2 - Hi, I'm trying to create a linked server of DB2. I've tried using the providers "IBM OLE DB Provider for DB2" and "Microsoft OLE DB Provider for ODBC Drivers" but I just don't know what to put in the fileds to create a valid conne...

Linked Server - I am in the process of setting up a linked server in SQL Server 2005. I am having some difficulty at getting this accomplished. The database and the drivers associated with the database are both proprietary and unfortunately documentation is not tha...

Help PLEASE! Linked Server to IBM DB2 - Hi All, I have been unable to setup my connection to our IBM DB2 box as a "linked server" can someone give me some tips? I do have an ODBC connection set up from my machine that works but just can't get the right combination for the linked...

add linked server problem - Hi, there, I have two SQL Server 2000, which are SQLA -- with SAN connected; SQLB -- just a bald SQL Server. I want to set up linked server from SQLA , so I can run query like "select * from SQLB.dbname.dbo.tablename". The command I use is...

MySQL Linked Server - I am trying to linka MySQL database to SQL 2005, but I am not sure what I need to do. I have set up a DSN using the MySQL driver. I get lost when I try and create the linked server in SQL 2005. Can someone please outline the steps to create the linke...
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]