Solved

Deploying SQL Links

Posted on 2000-05-12
4
207 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
[X]
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
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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…
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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
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…
Suggested Courses
Course of the Month6 days, 7 hours left to enroll

636 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