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

ContactReview Forum Index » GoldMine 6 » GM 6.7 SQL + Win 2008 + SQL 2008 + Win 7 64BIT - Issue
Post new topic  Reply to topic View previous topic :: View next topic 
GM 6.7 SQL + Win 2008 + SQL 2008 + Win 7 64BIT - Issue
PostPosted: Tue Apr 29, 2014 7:19 pm Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




Hi,

We are running GM 6.7 SQL on a Windows Server 2008 with a SQL 2008 on it. We have no problems connecting Goldmine using Windows XP 32 bit machines, we add ODBC source, install SQL Client tools and it works out of the box. However, we just got new Win 7 64Bit Machines and we can't access GM.

Here's what we did so far:

1. Installed SQL Tools - sdn.microsoft.com/en-us/sqlserver/ff658533.aspx
2. I copied ntwdblib.dll into system32/ and SYSWOW64/, because i was getting an error requesting this file

and now we are stuck at the error below



We are able to establish connection to MSSQL server via ODBC connection:


If i run bdeadmin - I enter the password for the sql server, but it does not allow me to access it:



I have not tried updating the BDE, currently it's 5.11 should we upgrade to 5.2?

Thanks!
View user's profile Send private message

PostPosted: Wed Apr 30, 2014 6:34 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




While this may not solve your problem, I would make sure that you have killed the UAC. Here are some instructions that I have for that:
Quote:


1. Launch MSCONFIG by from the Run menu.
2. Click on the Tools tab. Scroll down till you find "Disable UAC" . Click on that line.
3. Press the Launch button.
4. A CMD window will open. When the command is done, you can close the window.
5. Close MSCONFIG. You need to reboot the computer for changes to apply.


Send me an email and I could send you a document on this subject that would provide more details.

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

PostPosted: Wed Apr 30, 2014 8:24 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




Thanks - I disabled UAC and also installed BDE 5.2, but still the same error - any ideas?
View user's profile Send private message

PostPosted: Wed Apr 30, 2014 9:24 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




download http://www.castellcomputers.com/files/ntwdblib.dll and put it in the system32 folder on the workstation.

_________________
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: Wed Apr 30, 2014 9:42 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




Doug - thanks I've tried that, if I remove it - i get ntwdblib.dll error, if it's there i get 10004 error(as in screenshot). any other suggestions?
View user's profile Send private message

PostPosted: Thu May 01, 2014 7:30 am Points: 0 Reply with quote
Paul Laufer
GoldBox Guru
Joined: 27 Oct 2008
Posts: 124




When adding the ODBC drivers add them via C:\Windows\SysWOW64\odbcad32.exe so that they're 32 bit.

_________________
Paul Laufer
Telesage Solutions
www.tsage.com
View user's profile Send private message Visit poster's website

PostPosted: Fri May 02, 2014 9:13 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




That was IT! Thanks Paul!!
View user's profile Send private message

GM 6.7 SQL + Win 2008 + SQL 2008 + Win 7 64BIT - Issue
  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 1 of 1  

  
  
 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