BDE connection

Posted on 2003-03-14
Medium Priority
Last Modified: 2013-11-23
Is it possible to connect using BDE to a database on a remote server (not on a LAN). The database being used is MSSQL. Can the IP adress be given instead of the SERVER NAME ? This is not being done through a program. I find that this works in a LAN though. Is there any restriction here ? Any additional parameters to be given ?
Question by:LizaPaul
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

ITugay earned 500 total points
ID: 8141772
Hi LizaPaul
I suppose that if you can achive server using IP inside LAN, then you shoud have no problems to connect to remote server using TCP/IP. You can meet some problems if you are bhind firewall.


Assisted Solution

da-vinci earned 500 total points
ID: 8142087
Normally, giving IP instead of server name will only work on a LAN, cuzz there the IP Address is known.

But you can configure the proxy or router so that this one knows the IP Address of that MS SQL Server. Then the router is rerouting 'your' traffic to the sql server.
In configuring the proxy it might be necessary to connect to the proxy using extra parameters.
For example: IP of proxy= then you have to connect with connect string:
or instead of servername the ip address.

Author Comment

ID: 8148705
Thank you for your suggestions. I found that I could achieve what I needed using DSN.

Expert Comment

ID: 9316774
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month8 days, 5 hours left to enroll

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question