| GM 6.7 SQL + Win 2008 + SQL 2008 + Win 7 64BIT - Issue | |
Posted: Tue Apr 29, 2014 7:19 pm |
Points: 0 |
|
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! |
|
|
|
|
| | |
Posted: Wed Apr 30, 2014 6:34 am |
Points: 0 |
|
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. |
|
|
|
|
Posted: Wed Apr 30, 2014 8:24 am |
Points: 0 |
|
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? |
|
|
|
|
Posted: Wed Apr 30, 2014 9:24 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
|
|
|
|
Posted: Wed Apr 30, 2014 9:42 am |
Points: 0 |
|
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? |
|
|
|
|
Posted: Thu May 01, 2014 7:30 am |
Points: 0 |
|
Paul Laufer |
GoldBox Guru |
|
|
Joined: 27 Oct 2008 |
Posts: 125 |
|
|
|
|
|
|
|
|
When adding the ODBC drivers add them via C:\Windows\SysWOW64\odbcad32.exe so that they're 32 bit. |
|
|
|
|
Posted: Fri May 02, 2014 9:13 am |
Points: 0 |
|
king123 |
Cuckoo for GoldMine Puffs |
|
|
Joined: 02 Sep 2009 |
Posts: 374 |
|
|
|
|
|
|
|
|
That was IT! Thanks Paul!! |
|
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|