connecting two databases - SQL Server Forums

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

SQL Server Development (2000)

connecting two databases

Author

Topic

JNotenboom
Starting Member

27 Posts

Posted - 2002-03-28 : 04:26:28

Hello,
Basically, I have the following problem: I need to query a database which is not in my network. The query gives me a result which I want to insert into my own database. I'm developing a webapplic.
Does anyone know any documentation or answers?

Regards,
Johan

======
'Our solution will be part of your problem'

jackstow
Posting Yak Master

160 Posts

Posted - 2002-03-28 : 04:36:14

You'll need to link the two servers and use fully qualified names in your procedures - have a look at this example - http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=14212

lgraz
Starting Member

7 Posts

Posted - 2002-03-28 : 04:50:45

Hi JNotenboom, I don't know if you're scripting
to create your app, but if that's the case try
a DSN-less connection, and use instead the IP
of the machine running the Svr you need.

Just 0.02€,
LGraz

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources