We help IT Professionals succeed at work.

delphi, sql deplhi, 7, connect to sql server 2000

Last Modified: 2013-11-23

i need an example of how to connect to sql server 2000 using delphi 7

has anyone go an example?

all help will do
Watch Question

Top Expert 2007
This one is on us!
(Get your first solution completely free - no credit card required)

Use the BDE Administrator.  Go to the Database tab, and right click to add a new database, select the SQL Server, and continue on entering the appropriate parameters.  The most important would be database name and user name.  The other defaults will probably work.
Top Expert 2007

and keep in mind, when using BDE you will have to deply the BDE redistributables with your application, otherwise it will not work on other computers (which don't have BDE installed)


how do i add tables to the connection to base my query on?
Top Expert 2007

which method? ado or bde?

After you define your database connection in BDE, you go into Delpi IDE and under the tool bar there is a tab for BDE.  There is also one for ADO.  Click on the BDE tab and you get object types to define the database, tables, procedures and queries.

Ciuly is right about installing the BDE when deploying the application.  That's they way I've done in the past, but after reading about the ADO, I agree that's the way to go.  The BDE is handy for development however.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.