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

From: Just D. (no_at_spam.please)
Date: 07/31/04

  • Next message: Just D.: "Re: Connect from sql query via IP adress - is i possible?" 
    Date: Sat, 31 Jul 2004 13:35:28 -0700

    Thanks for the answer.

    "oj" <nospam_ojngo@home.com> wrote in message
    news:ui9sqkzdEHA.4048@TK2MSFTNGP12.phx.gbl...
    > 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
    > > 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?

    Another one idea - if I create ODBC and it's tested and works fine is it
    possible to use that for the same purpose setting a remote database name via
    ODBC? In other words, is it possible to use a database alias that works via
    ODBC to set a connection from sql query without a linked database?

    Maybe it's easier...

    Dmitri.

  • Next message: Just D.: "Re: Connect from sql query via IP adress - is i possible?"

    Relevant Pages

    • Re: [VW 7.3.1] ODBCConnection
      ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
      (comp.lang.smalltalk)
    • Re: Ada DB bindings and APQ
      ... >>I didn't like the use of handles for database objects. ... > will ensure that the connection will not go away until at least one query ... > things which can be made with a connection. ... That is different to ODBC. ...
      (comp.lang.ada)
    • Re: Linking Access f/e to Access b/e via ODBC
      ... > Is it possible then to create an ODBC connection to use the ISAM driver ... If I understand your question correctly, the ISAM driver for Jet _is_ what ... you're getting when you create the DSN for an Access database file. ... the ODBC Data Source Administrator can create the DSN to the Access ...
      (microsoft.public.access.externaldata)
    • Re: Trusted Connection
      ... HOWEVER, for one of my users, I will create an ODBC DSN ... for my test database ON THEIR COMPUTER, ... So, when I set up the ODBC DSN connection for this user, ... >> Our SQL Server was set up NOT by me, ...
      (microsoft.public.sqlserver.security)
    • Re: Data Source Lost When Merge From Access to Word
      ... DDE was the default connection method and ODBC was the alternative as far as Access/Jet sources were concerned. ... In Word 2003, OLE DB is the default, but unfortunately when you have selected your database, Word does not display the Access tables that are linked to ODBC data sources. ... create one query in your Access database for each linked table you want to use, with SELECT * FROM, and use that as the data source. ...
      (microsoft.public.word.mailmerge.fields)