Re: Connect from sql query via IP adress - is i possible?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: oj (nospam_ojngo_at_home.com)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 13:03:49 -0700

You can do ad-hoc/pass through query via openrowset or opendatasource.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_78z8.asp

http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_2be1.asp?frame=true

"Just D." <no@spam.please> wrote in message
news:FkSOc.18891$1o.215@fed1read06...
> Does anybody really know is it possible? We don't want to create a linked
> database, but we need to make some steps on the remote database, gather some
> data and then send this data to our main server via IP connection, setting
> the connection every time when the remote server wants to transfer the data.
> Is it possible at all if we don't create a linked database or whatever, just
> from sql script? If yes, then how?
>
> Dmitri.
>
>

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Updating remote MySQL databases
    ... than over Internet directly to the database. ... > I want to maintain with the WinForms program. ... > remote server, that would probably be done with PHP or whatever. ... > the appropriate dialect down the TCP/IP connection from my local PC to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)