Link to Data

I have a superbase database i like to link to sql server 2005. MS access is not working. How do i link a ODBC data connection into SQL Server.

You can either use the create a linked server for the datasource and then acces it via the four part name with the following syntax

SELECT * FROM LinkedServername.Database.Schema.ObjectName

(Those parts that don′t exists on the target server can be left out like LinkedServerName...ObjectName if applicable)

...or you can use the OPENROWSET function which can take a connection string for adhoc querying

...or you can use the OPENQUERY function to use a linked server to query for (if you want to do more than just querying some data from tables like executing a stored procedure on the remote system)

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||

Hi, i tried linked server.This is the message i get.

LE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "superdata" returned message "Could not find installable ISAM.".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "superdata".

|||Hi,

make sure that the right driver for the ISAM is installed:

http://support.microsoft.com/kb/209805/en-us

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de