DB access

[jsaintonge]

Hey there,

Is there ANY other way to access the GMSM database
through the net than Everywhere server? Can I get
to the sql server and allow people to login some how?

Thanks

James

 

[RobColborne]

Hi,

If you do not want to use Everywhere Server, I am assuming this also includes GoldMine Thin Client.

It depends on what you wish the your users to do, if you require just read only access then there is a variety of ways to provide acceess. Here are just some of the ways:

1. Use SQL server to automatically generate static HTML pages. This is a very basic method.
2. Use ASP pages to dynamically query the database and return the results.
3. Use Crystal Report web server to provide superb dynamic reporting capability.

If you require users to make changes to the database then you are looking at developing your own access capability. However be aware that any direct manipulation of data is not synchronisation aware, i.e. it will not record changes in the transaction logs affecting synchronisation. You should use the GoldMine API or GM SQL Stored Procedures when developing any software integration with GoldMine.

There are some third party products available for web / wireless access to GoldMine data:

Xybo - WAP access through a mobile or Wap enabled PDA. Beacuse it is WAP it can therefore be accessed by the Web
KeyGold - Data Synchronisation to Palm Pilot

Hope this Helps



Robert Colborne

http://www.prior-analytics.com

Experts in GoldMine