Solved

Connecting Database to GoldMine.

Posted on 2006-06-19
7
799 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

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

Title # Comments Views Activity
CMDB for MSSQL business apps 2 305
Notes - my question 12 256
Career Choice BW/BI + HANA or BODS + HANA 8 724
CRM & Email Software 6 125
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.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 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

15 Experts available now in Live!

Get 1:1 Help Now