Connecting to remote DB

Results 1 to 3 of 3

Thread: Connecting to remote DB

  1. #1
    syl Guest

    Default Connecting to remote DB

    Need to connect to a db on another server. Please does someone know code for this??

  2. #2
    Ed Guest

    Default RE: Connecting to remote DB

    Is it a SQL Server? If so, do it just like you would if it was local. Setup a system DSN; on the Server listbox in the first pane when you add a new DSN, select the server the database resides on...

  3. #3
    Nana Guest

    Default RE: Connecting to remote DB

    I like to put my answer in two points.<BR><BR>1. If you are trying to connect the remote server from Enterprise Manager, give the remote server name and give the User and Password. Before which you should to be able to ping to that Remote server.<BR><BR>2. If you are trying to connect through DSN, make sure you are able to ping to the remote server and give the Server name, User name and Password.<BR><BR> If you are connecting the server through Net then you should give the IP address instead of Server name.<BR><BR>Check it and gimme the feedback. Let us know.<BR><BR>regards,<BR><BR>Nana

Posting Permissions

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