• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

Deploying SQL Links

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
jonnyfive
Asked:
jonnyfive
  • 2
1 Solution
 
kretzschmarCommented:
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
 
kretzschmarCommented:
oops, key is wrong (missed a folder)
correction:
HKEY_lOCAL_MACHINE/SOFTWARE/Borland/Database Engine/Settings/Drivers
0
 
simonetCommented:
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
 
jonnyfiveAuthor Commented:
This did the trick :-)

Thanks a lot... Jonny...
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now