April 2, 2008 at 6:37 am
Linked Server File DSN?
Can anyone help? I am trying to connect a Domino Server with the NotesSQL ODBC on SQL2K.
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.anderson@nwmhp.nhs.uk
April 3, 2008 at 8:36 am
Wyatt,
You have half way there, having your DSN configured, tested and working.
I agree that the labels for the Linked Server Syntax is confusing.
below I have syntax for connecting to my DB2 database, you should be able to use it as a template for getting all of the proper settings configured. I have a comment after each line, to remind myself what data goes into each option:
EXEC sp_addlinkedserver
@server='DB2_ODBC', -- Name of the Linked Server, when it is created.
@srvproduct='Microsoft OLE DB Provider for ODBC', -- OLE DB Provider.
@catalog='', -- Catalog Is Optional For ODBC Connections.
@provider='MSDASQL', -- Provider_name.
@datasrc ='ODBCLIB', -- DSN Name of the ODBC Data Source.
@provstr= -- ODBC Connection String.
'
DRIVER={DB2};SERVER=*SERVERNAME*;UID=*USERID*;PWD=*PASSWORD*;
'
When you get yours working, please post your results/syntax back.
Hope This Helps,
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply