Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connecting Database to GoldMine.

Posted on 2006-06-19
7
Medium Priority
?
829 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
[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
  • 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
The top UI technologies you need to be aware of

An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!

 

Author Comment

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

Accepted Solution

by:
TommyTupa earned 1000 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

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

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

Read about achieving the basic levels of HRIS security in the workplace.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

704 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