ODBC connection to a seperate machine

From: Steve Grosz (boise_bound_at_hotmail.com)
Date: 06/16/04

  • Next message: Charles Parker: "Select using only key sorts results"
    Date: Wed, 16 Jun 2004 10:48:34 -0600
    
    

    I'm curious, can you set up a ODBC connection on one server, that points
    to another computer on the network where the database is? I've tried
    the computer name as //server2, but it doesn't seem to find it, yet, I
    can get to it via the RDC within WinXP Pro.

    Thanks,
    Steve


  • Next message: Charles Parker: "Select using only key sorts results"

    Relevant Pages

    • Re: Remote data entry solution needed for Access 2007
      ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
      (microsoft.public.access.externaldata)
    • Re: Active/Active configuration
      ... Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the ... how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance. ... you really shouldn't share a single network. ... Is this a valid assumption?You may get better performance by virute of running each database on its own ...
      (microsoft.public.sqlserver.clustering)
    • Re: dataset safety?
      ... In my idea is the transport on the network (even more on ethernet because of ... posible collisions) that makes a network slow, not the times you use it. ... client has to send the update to the server. ... so the server can go to the database. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Winsock rate of sending data
      ... The database only has 1 table with 3 columns: ... my machine with less power then the server, ... compress when I am sending the data, ... >network and reducing the server's workload, ...
      (microsoft.public.vb.general.discussion)
    • Re: db corruption
      ... > posts just to help someone. ... See http://www.QBuilt.com for all your database needs. ... Very solid and fast network connectivity, ... > The server is hundreds of GB's with many many users. ...
      (microsoft.public.access.setupconfig)