SQL Technical Discussion - GoldMine

See Also

 

Note that in GoldMine v7 and v8 environments, only unified SQL installations are supported. 'Split SQL' systems will not work. OmniRush requires that GoldMine SQL installations run in a single SQL database.

 

Test GoldMine for proper SQL connection and operation.  Go to Help | About | System in GoldMine and check that GoldMine is using a single alias for the GoldMine and Contact tables.  OmniRush requires that GoldMine SQL installations run in a single SQL database.

 

Note:  As of September 2000, GoldMine requires that SQL installations use a single SQL Database for all GoldMine and Contact files.  Mixed dBase/SQL and multiple contact files are not recommended by GoldMine/FrontRange.  Ask your reseller for the GoldMine Technical Product Information document: “Supported Database Configurations”  

 

A Z-Firm discussion of this issue is also available.

 

 

MS SQL Users:  Check your sort order!  GoldMine Software Corp only supports one sort order on SQL Servers:  Dictionary Order, Case Insensitive.  This is Sort Order #52.  You can check the sort order on SQL by running Query Analyzer and switching to the MASTER database.  Then issue the command:  

 

sp_helpsort

 

This will return information on the sort order.  On MS SQL Server v6.5 & 7.0, you are looking for a result that looks like this:

 

Sort Order Description

---------------------------------------

Character Set = 1, iso_1

    ISO 8859-1 (Latin-1) - Western European 8-bit character set.

Sort Order = 52, nocase_iso

Case-insensitive dictionary sort order for use with several Western-European languages including English, French, and German

    .  Uses the ISO 8859-1 character set.

 

 

Check that the database owner is dbo.  Each SQL user can be aliased to a database user.  This can be viewed in SQL Enterprise Manager (databases|<database name>|users).  If the database owner name is not dbo, use the MS SQL system stored procedure:

 

sp_changedbowner

 

to set it that way.

 

Search the \goldmine\ structure for GM.INI files. There should only be one GM.INI in the environment!  Check the contents of GM.INI for correct configuration information.  The SYSDIR, GOLDDIR and COMMONDIR entries must be correct!