Unknown Database

[kkawano]

Hi,

We are encountering a problem that has me puzzled. All users are able to log into Goldmine fine. They can even navigate to different contacts. However, when they open the "Document Management Center" we get the following error:


-----------------------------------------------------------------------------------
Unknown database.

Context: openDatabase
SQL Server: GoldMine_Sales: dbo.FORMS

1: Alias: GoldMine_Sales

BDE Error Cat:Code: [39:30]
BDE: 500 [4/11/1999] GoldMine: 6.00.30203

User: KKAWANO
Window:
Template:
Details:
ALIAS: GoldMine_Sales

-----------------------------------------------------------------------------------



If we try to merge a template we get the following errors:




-----------------------------------------------------------------------------------
Unknown database.

Context: openDatabase
SQL Server: GoldMine_Sales: dbo.MAILBOX

1: Alias: GoldMine_Sales

BDE Error Cat:Code: [39:30]
BDE: 500 [4/11/1999] GoldMine: 6.00.30203

User: KKAWANO
Window:
Template:
Details:
ALIAS: GoldMine_Sales






Unknown database.

Context: openDatabase
MSSQL: GoldMine_Sales: dbo.CONTACT1

1: Alias: GoldMine_Sales

BDE Error Cat:Code: [39:30]
BDE: 500 [4/11/1999] GoldMine: 6.00.30203

User: KKAWANO
Window:
Template:
Details:
ALIAS: GoldMine_Sales




Unknown database.

Context: openDatabase
MSSQL: GoldMine_Sales: dbo.CONTACT2

1: Alias: GoldMine_Sales

BDE Error Cat:Code: [39:30]
BDE: 500 [4/11/1999] GoldMine: 6.00.30203

User: KKAWANO
Window:
Template:
Details:
ALIAS: GoldMine_Sales






Unknown database.

Context: openDatabase
MSSQL: GoldMine_Sales: dbo.CONTSUPP

1: Alias: GoldMine_Sales

BDE Error Cat:Code: [39:30]
BDE: 500 [4/11/1999] GoldMine: 6.00.30203

User: KKAWANO
Window:
Template:
Details:
ALIAS: GoldMine_Sales






Unknown database.

Context: openDatabase
MSSQL: GoldMine_Sales: dbo.CONTHIST

1: Alias: GoldMine_Sales

BDE Error Cat:Code: [39:30]
BDE: 500 [4/11/1999] GoldMine: 6.00.30203

User: KKAWANO
Window:
Template:
Details:
ALIAS: GoldMine_Sales







Unknown database.

Context: openDatabase
SQL Server: GoldMine_Sales: dbo.CAL

1: Alias: GoldMine_Sales

BDE Error Cat:Code: [39:30]
BDE: 500 [4/11/1999] GoldMine: 6.00.30203

User: KKAWANO
Window:
Template:
Details:
ALIAS: GoldMine_Sales




-----------------------------------------------------------------------------------


Ok, so here is the weird thing. If I do an SQL query from "Filters", I can access all the tables. Also, I tried changing the SQL Server login to my password which is an admin account so I know it has nothing to do with database privaliges. All, items appear to be pulled correctly through the ODBC source I set up "Goldmine_Sales". Additionally, to remove it from a possibility, I went into BDE admin and was able to connect to the databases that way.


Now, this problem and another problem appeared last week (I assume at the same time). Last week, for some reason, all of the users usernames were wiped out so they were getting sql server login dialog boxes when going into Goldmine.

I went to File>Configure>User's Settings>Properties>Access and entered in the users login name and password which fixed that problem. So I think maybe this problems are related somehow. What I am bogged by is the fact that they can log in initially, and I can access the tables manually but get the error only in certain areas, namely the "Document Management Center".


Has anybody run into this issue before or have any ideas?

Best Regards,

Karl Kawano

 

[Adecaro]

when converting the original database from instal to SQL, did you include the option "copy GoldMine Files"? I have seen this cause a similar error

 

[groundedagain]

It is almost certainly that your GMBase files are still on dBase.

Check by Help>>About and select System.

The Contact Files are probably pointing to SQL but is the GoldMine Files entry?

HTH

Jason Wienert
Central City Communications
Brisbane, Austalia.

 

[goner]

if GoldMine_Sales is an ODBC data source, remove it. GoldMine only supports NATIVE drivers, not ODBC drivers. In BDE Admin, there shoudl be a GoldMine_Sales item with an icon next to it with 4 geometric shapes, not a cylinder with an infinity symbol over it. The latter represents an ODBC connection. While you may be able to CONNECT to the database with an ODBC, you're going to have trouble with most functions beyond the simplest...



Doug Castell
Computer Control Corp
(310)396-6811

http://www.ccc24k.com