Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 6 » Windows 2012 and Goldmine 6.7 SQL Goto page Previous  1, 2
Post new topic  Reply to topic View previous topic :: View next topic 
PostPosted: Thu Oct 17, 2013 6:23 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




We installed MSSQL 2008 express version to test the environment, now that we need to move to production it looks like the licenses are very expensive just to have mssql server running.

Which version should we be using for goldmine? standard? enterprise? pro? I know express has limitations(db size, ram, 1 cpu) Our database is 15GB.

What would you recommend or used in the past? We are trying to find most affordable solution.

Thanks
View user's profile Send private message

PostPosted: Thu Oct 17, 2013 8:43 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




Workgroup ought to be fine.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri Oct 25, 2013 11:14 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




Hey guys - need some help, we are now doing the migration on other server with SQL 2012 and we can't get the BDE admin setup properly. All the servers with have - have the "MSSQL" as Database Driver Name, however this one does not, If i look under configuration > drivers > native - i don't see MSSQL, however all the other servers has it.

Any ideas how to install MSSQL?

View user's profile Send private message

PostPosted: Fri Oct 25, 2013 3:05 pm Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




http://nancyhidywilson.wordpress.com/2012/06/26/discontinued-features-in-sql-server-2012-part-2/


Does that mean Goldmine 6.7 SQL will not work with SQL 2012?
View user's profile Send private message

PostPosted: Fri Oct 25, 2013 3:15 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




it's not supported, but if you make sure your databases are set to sql 2000 compatibility mode, it'll work.

as for your BDE having(or not) MSSQL drivers installed, yeah, you'll need to address that.

Try downloading my Borland setup ZIP which contains both the original BDE and SQL links setup for BDE 5.2 from here: http://www.castellcomputers.com/files/borland.zip

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri Oct 25, 2013 3:37 pm Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




Thanks! you are a life saver. The files you gave me did not work - did not allow to install regular BDE(due to incompatibility) nor to update(because i didnt have it installed.)

I downloaded it from http://www.medlog.com/bdesetup.htm and installed.

Was able to connect BDE to SQL

Thanks again!
View user's profile Send private message

PostPosted: Fri Oct 25, 2013 3:50 pm Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




The other issue im facing now is 80 - 2000 compatibility mode, seems that SQL 2012 does not have. Any ideas if this will even be possible?

View user's profile Send private message

PostPosted: Fri Oct 25, 2013 3:51 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




interesting. I wonder if the MEDLOG guy has made a new 64-bit friendly setup for it or something? Downloaded and filed away!

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri Oct 25, 2013 3:55 pm Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




So do you have any idea how we can bypass 90 compatibility mode? is it even possible? see the post above.

Thanks
View user's profile Send private message

PostPosted: Fri Oct 25, 2013 4:56 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




nope, sorry. I suspect you'll need to go for an older version of SQL (or newer version of GoldMine)

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri Oct 25, 2013 6:32 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I think that Doug's last comments are 100% correct.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

Windows 2012 and Goldmine 6.7 SQL
  ContactReview Forum Index » GoldMine 6
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 2 of 2  
Goto page Previous  1, 2
  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin