Connect to a remote MSSQL database using BDE

Posted on 2003-03-14
Medium Priority
Last Modified: 2013-11-23
How to connect to a remote MSSQL database using BDE ?
Question by:root_mailbox
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
  • 2
LVL 17

Accepted Solution

geobul earned 130 total points
ID: 8135741

Create a DSN entry using 'SQL Server' ODBC driver (ODBC Data Source Administrator program that can be found in Control Panel (Administrative Tools in 2000/XP)). Set the remote server name, database name and the authentication method (Windows integrated or SQLServer security).

Open Delphi, Add a TDatabase component. Set its Alias property to the DSN you've just created. Fill DatabaseName property with 'sqlConn' for example. Set Connected property to true. You'll see login prompt (SQL security) or connect directly (Windows integrated).

Add a TTable component. Set its DatabaseName property to 'sqlConn'. Select a table from TableName property.


Regards, Geo

Assisted Solution

mocarts earned 70 total points
ID: 8139159
if you have SQL links installed with your BDE you can use Native BDE MS SQL driver.
in BDE administrator add new alias with database driver name MSSQL, set the SERVER NAME to your SQL server name, DATABASE NAME to your database name in server. test connectoin by trying to open alias.

all othre actions depends on what type of application you want to develop. you can use TQuery (preffered component with SQL server) or TTable by setting its DatabaseName to newly created Alias. You can use TDatabase component if you want control login process (by providing custom login dialog) or to control sessions.

wbr, mo.

Expert Comment

ID: 9316780
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.
LVL 17

Expert Comment

ID: 9386573
Split the points

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month11 days, 8 hours left to enroll

752 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