Solved

Using SQLDatabases w Delphi 2.0 or 3.0

Posted on 1997-10-09
4
143 Views
Last Modified: 2010-04-04
1 - I would like to know if Delphi 3.0 's "native drivers" are stand alone or if we still need to use & configure BDE on every PC's where the software is being installed.?

2- If I have to configure BDE on every PCs, is there a way to do that automatically? (by programmation)

3- What are the files i have to copy (or distribute) with me .EXE?

4- (optionnal) where can i find docs on programming my own component for MS SQLServer direct TCP/IP querrying? (doh!)
0
Comment
Question by:pilotes
  • 2
4 Comments
 
LVL 3

Expert Comment

by:Pegasus100397
ID: 1347101
Pilotes,

I utilized ODBC drivers alot (they have sped up MUCH in recent versions) and general pre-configure the BDE BEFORE distribution with the Aliases I need that point to the correct ODBC drivers.

Since the BDE installs on the user's computer pre-configured then it's simply a matter to install the necessary ODBC drivers.

Hope this helps.

Pegasus
0
 

Author Comment

by:pilotes
ID: 1347102
I need some technical details if possible!
0
 
LVL 3

Accepted Solution

by:
Pegasus100397 earned 50 total points
ID: 1347103
Pilotes,

Ok, I'll take the questions one by one then:

on (1)  YES, Normally you will have to configure the BDE on each user's machine (Aliases) by running the BDECFG32.EXE program. There may be a way to do this automatically but I have not had occasion to do it. In the meantime, just write down the aliases, BDE stuff that your program uses and set up the other machines to the same values.

on (2) MAYBE? I'm not aware of a way to programmatically set up the BDE at runtime. There are makers of third-party database drivers that are included with the .EXE program that make this an unecessary step.

on (3) Very few! If you use the InstallShield program to package your program up (and installed using the SETUP.EXE program) then pretty much everything is included in the install package that Installshield makes. If you use ODBC drivers, they will have to be installed seperately.

on (4), check the DCHAT.DPR program in the Program Files\Borland\Delphi 2.0\Demos\Tcp directory. It should give you some tips on how to use the TCP component to talk with SQL Server. See also, "Named Pipes" in the Win32s documentation.

Hope this helps
Pegasus
0
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1347104
Bought This Question.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to convert wav to mp3 in delphi 9 174
Delphi cmd execution 6 56
Tviruailstringtree sort multi columns on header click 1 54
Dynamically Created Query 3 50
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

867 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now