Solved

Deploying SQL Links

Posted on 2000-05-12
4
193 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

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 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

18 Experts available now in Live!

Get 1:1 Help Now