Goldmine 6 - MSSQL 2000 API

[vdlima]

Hi,

We are currently using MSSQL 2000 with GM 6 and are trying to install the SQL Stored Procedures. I downloaded the files from Prior-Analystics, moved the GM6S32.dll into the right location, but haven't been able to find the GM6SQL.dll file anywhere.

Currently, I'm using the gm5SQL.dll but GMW_WriteContact procedure results in error 140 (i.e. wrong version of SQL). Any ideas on how to get around this?

Thanks.

 

[richardy]

Hi,

Unfortunately their written for GM5S32.DLL so you'll need to adjust the SPs to look for GM6S32.DLL

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

 

[vdlima]

Hi Richard,

How do I modify the SP? Opening them in Query Analyzer gives me:
/****** Encrypted object is not transferable, and script can not be generated. ******/

Does anyone have the Queries themselves?

thanks so much for your help, we've been stuck at this point for about a month and a half, our frontrange reseller hasn't been very helpful at all.

- Vivek

 

[vdlima]

Hi,

The only reference to a dll that I've found is in the extended procedure xp_GMNewRecid, and that points to gm5sql.dll I have placed that in the right directory. I have not been able to find gm6sql.dll and don't even know if it exists.

thanks,
Vivek

 

[TheIntWizard]

If you are looking for programming tools and guides, they are available from my website for GM 6



The Wizard

http://www.integrationwizard.com

Home of Link Magic and Web Magik

 

[antonyd]

I downloaded the plaintext source for these stored procedures from the FrontRange site, in the support section, but the problem still remains that the xp_GMW_NewRecid points to gm5sql.dll - which in turn points to the 5 version API DLL - I have no idea where to find the gm6sql.dll which should solve the problem. Integration wizard doesn't have it on his web site either.
Can Anyone help?