REAL TIME LINK FROM ODBC TO SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

REAL TIME LINK FROM ODBC TO SQL

Author

Topic

helios
Starting Member

2 Posts

Posted - 2003-05-23 : 10:52:34

I'd like to know how to create real time link to SQL table or view (not store procedure) from ODBC, e.g like real time link MS Access table from ODBC.

Thanks.

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-05-23 : 11:06:57

Have you looked into Access Data Projects in Access 2000 or 2002.
Can you give more detail?

What environment/programming language do you want to use?

Edited by - ValterBorges on 05/23/2003 11:07:54

helios
Starting Member

2 Posts

Posted - 2003-05-26 : 01:35:59

Environment that I use is SQL 2000. I'd just wonder can SQL do linking table just like Access can do. I have tried using DTS but it is not real time. Can it be done without using store procedure.

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-05-28 : 10:49:54

Yes, look in BOL on how to create a linked server.

X002548
Not Just a Number

15586 Posts

Posted - 2003-05-28 : 12:25:15

Assuming you want to link to another server or instance:

sp_addlinkedserver

and don't forget:

sp_addlinkedsrvlogin

But if your talking about referencing tables on the same server you just have to add the database name (and maybe owner to the reference.

For Example, try this and cut and paste the code in to QA:

USE Pubs
GO

SELECT * FROM Employee
GO

SELECT * FROM Northwind.dbo.Employees
GO
--Or
SELECT * FROM Northwind..Employees
GO

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources