Solved

Connecting Database to GoldMine.

Posted on 2006-06-19
7
821 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

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