Solved

Deploying SQL Links

Posted on 2000-05-12
4
196 Views
Last Modified: 2010-04-04
Hi everyone...

I want to deploy the MSSQL SQL Link to an existing client. The BDE is already installed on the clients machine. I tried to simply copy the two link files to the bde folder, but the MSSQL driver doesn't show up in the BDE administrator. I also tried to build a small setup program with the install shield. It installs ok, but still no sign of MSSQL in the list. It's a Windows 98 system and the MSSQL 7 client is installed on that machine. What am I doing wrong?

Regards, Jonny...
0
Comment
Question by:jonnyfive
  • 2
4 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2804903
hi jonny five

i'm guessing you must just add (additional to the copy) a key in the registry (and it subkeys)
HKEY_lOCAL_MACHINE/SOFTWARE/Borland/Database Engine/Drivers

meikl
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 75 total points
ID: 2804908
oops, key is wrong (missed a folder)
correction:
HKEY_lOCAL_MACHINE/SOFTWARE/Borland/Database Engine/Settings/Drivers
0
 
LVL 15

Expert Comment

by:simonet
ID: 2806439
If the InstallShield setup went fine (and you added SQLLinks to the InstallShield project), then the problem might be because InstallShield didn't merge the new (SQLLinks) configuration to the existing BDE setup.

Here's what to do to fix that (this is all done on the client machine):

- Open BDE Administrator
- Select the menu Object | Merge Configuration
- Look for any CFG files or files without an extension in the BDE directory, or in the directory where InstallShield installed BDE. You may also look for those files in the installed application folder.
- Select the files and click on "Ok"
- If InstallShield did the job right of creating the BDE config file, then the new BDE options will be displayed in the BDE Administrator.


Another possible problem is that INstallShield may have added another copy of BDE, so now the client machine has 2 copies of BDE. Check for this possibility as well.

Yours,

Alex
0
 

Author Comment

by:jonnyfive
ID: 2820396
This did the trick :-)

Thanks a lot... Jonny...
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

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 teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 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