DB on another server

Results 1 to 5 of 5

Thread: DB on another server

  1. #1
    wex_69 Guest

    Default DB on another server

    If I want to query/write to a db that is on another server, what is the best way for me to do this.<BR>I know I have to specify I.P.Address etc but what else is required.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default This is easy

    create a DSN and use tha DSN to connect to the DB

  3. #3
    wex_69 Guest

    Default RE: This is easy

    Can you be a little bit more specific. I can do a DSN less connection to db on the same server but to a database on another server I am not two sure of the code and what I should know. Thanks

  4. #4
    Steve Cimino Guest

    Default RE: This is easy

    SELECT *<BR>FROM dbo.SERVERNAME.databasename.tablename<BR><BR>I think this is what you&#039;re asking, not how to connect, right? As for just opening communications, all you need to do is have permissions and the proper connect string.

  5. #5
    Join Date
    Dec 1969

    Default RE: This is easy

    If you can set up a DSN on your own server, it is the same on a remote DB. Of course you have to have access to that machines ODBC. Is this what you needed?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts