×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Can not load IDAPI service library

Can not load IDAPI service library

Can not load IDAPI service library

(OP)
Product = Corporate Edition [Remote]
Versions = GoldMine 6.70.50123,  BDE 500 [4/11/1999]

SQL Server = Microsoft SQL Server  2000 - 8.00.194
Intel X86)
GoldMine EXE = c:\program files\goldmine\goldmine\gmw6.exe
BDE DLL Files = C:\Program Files\Common Files\Borland Shared\BDE\

Started as SQL Server 2000 install on system running Windows 2000 SP4, all went well BDE was tweaked as suggested by one of the manuals from Prior Analytics Team,
even though some of the fields were not there to be changed

GM works fine on ACTING SERVER, now workstation is the issue

Linking workstation also on W2K SP4 after mapping caused error : UKNOWN DATABASE .... BDE ERROR CAT: CODE[39.30]

followed the forum from July ... got to a next level where I managed to connect for a while from within BDE Admin ...

Now I get error CAN NOT LOAD IDAPI SERVICE LIBRARY

BDE CAT:CODE[33:10]

Was desperate and I have followed the forum further and installed SQL SERVER 2000 on workstation as suggested in the forum - "installed mssql client utility and I have set named pipes" (could not find the MSSQL client utility as download assumed it is part of the SQL SERVER 2000 setup

Still the same IDAPI error

Your assistance is much appreciated, calling on especially
wahrani16 / goner / mkal / RobColborne

Thank you !!!

The next step will be to import the database from GM 6.5 user to this new GM 6.7 Corporate

RE: Can not load IDAPI service library

If GoldMine works on the server and not the workstations then you will need to copy the BDE folder from C:\Program Files\Common Files\Borland Shared\ and copy this to the GoldMine folder c:\program files\goldmine\goldmine\Setup\.

Rename the BDE folder BDEShare same as the old folder however keep a copy of the original by renaming BDEShare_old.

Workstations should then be able to see the Borland folder on the mapped network drive.

Hope this helps.

RE: Can not load IDAPI service library

(OP)
Thank You! Will try ... was it on the server ?

copy the BDE folder from C:\Program Files\Common Files\Borland Shared\ON THE SERVER ?

and copy this to the GoldMine folder c:\program files\goldmine\goldmine\Setup ON THE SERVER ?

Would installing goldmine on the workstaion help ?
Still not sure what was meant by "mssql client utility" in previous thread ...the only way to get that on the workstation was to tun the SQL 2000 install

Rich

RE: Can not load IDAPI service library

You need the SQL Client Network Utility to connect to GoldMine database which runs off SQL. Their is no need to install GoldMine on the workstation as you will be viewing a different database to the server.

RE: Can not load IDAPI service library

Sounds like you're in a real mess, Rich.  

On the WORKSTATION, you don't need an SQL server or anything in c:\program files\goldmine\.  I'd suggest uninstalling MSSQL and clearing the WORKSTATION's goldmine folder.

The MSSQL client utility can be boiled down to NTWDBLIB.DLL in your windows\system32\ folder.  File that on a working machine and copy it to this one and you've got the MSSQL client connectivity part done.  

Open the registry and go to HKEY_LOCAL_MACHINE\Software\ and delete the whole BORLAND key.

Browse to the server via the drive I'm sure you've mapped to a directory one level above the \goldmine\ folder.  Locate gmw6.exe and drag a shortcut to it to your desktop (right-click drag)

Everything should go fine from there on out (assuming you have local admin rights for the copying of DLL(s) and Registry modifications that will take place upon first-run.

Doug Castell
Castell Computers
www.castellcomputers.com

RE: Can not load IDAPI service library

(OP)
Doug Doug Doug !!! you are the man, btw thank you all for the support !!! Was this meant to be in the manual ? Worked  marvels ...

NOW this is not over for me I'm afraid ... now this GM CE on the server needs to import all the data from the GM 6.5 stand alone version, any tips on how to do it the right way?

Also, this server version is logged in as Product = Corporate Edition [Remote]
am I right to assume this is a one user license ? so even if I creatge 2 users still only one at a time can work ?

Next thing is to come up with a reliable Goldmine Backup Strategy, at moment backing up the entire goldmine folder.

Your expertise greatly appreicated !!!

RichXP

RE: Can not load IDAPI service library

Get attached to the dbase databases on the CE install and then use the NEW DATABASE wizard under the file menu to copy the contents to a bde-aliased MSSQL database.

Doug Castell
Castell Computers
www.castellcomputers.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close