Solved

Connecting Database to GoldMine.

Posted on 2006-06-19
7
798 Views
Last Modified: 2013-11-24
I'm trying to open a older SQL GoldMine database, and seem to be having a few problems... The database is called GMSM_Golf, so in the path I'm putting in: MSSQL: GMSM_Golf: dbo: but I keep getting connection errors... I should probably add that when I get back to the screen that allows me to select a database, it shows that it's trying to open a dBase, when it should remain MSSQL....  any ideas??

Thanks!
-mathieu
0
Comment
Question by:mmanaigre
  • 4
  • 3
7 Comments
 
LVL 13

Expert Comment

by:TommyTupa
ID: 16938995
Check your GM.ini file.  The sysdir path should point to the location of your license file.  The CommonDir and GoldDir should say MSSQL: GMSM_Golf: dbo


0
 

Author Comment

by:mmanaigre
ID: 16953095
I'm trying to connect to a second database, the GM.ini file has the original database in it but not the second...
0
 
LVL 13

Expert Comment

by:TommyTupa
ID: 16953277
Does your second database have a BDE alias created?  Do you need to know how to create a second BDE alias?

0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:mmanaigre
ID: 16968904
uh.. yes I think I do need to know...  
0
 
LVL 13

Accepted Solution

by:
TommyTupa earned 250 total points
ID: 16971472

1. On the box hosting goldmine go to Control Panel-->BDE Administrator.  If you cant find it then do a search for Bdeadmin.exe.
2. Create a new Alias: Object --> New -->MSSQL --> OK.
3. Name the Alias: e.g. GM_thisisatestalias
4. In the Database Name field on the left enter the name of the new Sql Server Database e. g. Goldmine_testdatabase.
5. In the Server Name field enter the server name or preferably the IP address on which Sql  Server is located.  
6. In the UserName field enter the SQL Server Service Account which has access to your  database, e.g. sa
7. Goto Object --> Apply.
8. Assure your alias connects to Sql Server by double-clicking on the alias name ( GM_thisistestalias).
9. You will be prompted for your Sql Server account password.  Enter it in and click OK.   If the left hand side refreshes as if nothing happened then you connected succesfully.  If  you get an error or some kind of timeout then your Sql Server username or password is not  correct and you have not connected to the database.
10. Exit BDE such as via Object --> Exit.
11. Attach Goldmine to this new alias
0
 

Author Comment

by:mmanaigre
ID: 16971847
This fixed my problem on the test server, but I still can't connect on the production... the BDE is definately already setup, but for some reason, I'm getting the same error as before...

The database is setup with the same bde alias, so the connection string should be: MSSQL: GMSM_Golf: dbo:

the user name fiels is correct, and I can connect no prob from the BDE Adminisitrator...

I confirmed every letter, so I'm not sure what I'm doing wrong... Anyway, I will continue to play with the production server, and hopefully I'll get it going...

thanks again!
0
 
LVL 13

Expert Comment

by:TommyTupa
ID: 16972550
Glad to help.

Two things come to my mind:
1. Servername rather than IP Address in BDE settings.
2. Problem with BDE settings or path.

If it were me I'd backup my idapi32.cfg, delete the BDE portion from the registry, delete the folder path  and resintall BDE.  

You can find out more about BDE paths and settings by going to support.frontrange.com-->online support.  Search for one of the installation guides such as:
GoldMine 5.7 Business Contact Manager Installation Guide

Also, there is a very active goldmine discussion forum here: forums.frontrange.com
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 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

9 Experts available now in Live!

Get 1:1 Help Now