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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy