| Steven_J_Maas 2006-02-15, 8:23 pm |
| 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 that strong! Tech support
has been less than helpful as well.
I believe this should be able to be accomplished as I have been able to link
all of the tables in Microsoft Access 2003 using the system DSN.
Here is the code I have been using to create the linked server
EXEC sp_addlinkedserver
@server = 'LinkedDB',
@srvproduct = '',
@provider = 'MSDASQL',
@datasrc = 'PriDB',
@provstr = 'Driver={Systems ATO Driver); _
DSN=PriDB;DBQ=/usr/task/ task;RemoteHost=loca
lhost;RemotePort=202
20'
This appears to work adequately however; I do not have an effective way to
test if the database link is correct. In previous version of SQL enterprise
manager I could double click on the linked server and see the tables. I do
test it by running a simple query using the four part name:
Select *
From [LinkedDB].[PriDB]..[TableName]
I get an error that the data source could not initialize.
Any help would be appreciated…
|