Database Error when trying to specify Recordsource

B

Beryl Small

Hi, if anyone can help me I would appreciate it. I'm trying to use a DSN to
connect to a SQLBase database. The DSN works fine in Access. I can view or
records and query on them. However, when I try to use the same DSN in
FrontPage Database Results Wizard, when I try to connect to RecordSource I
get the following error:

The Server encountered an error while trying to process a database request.

Server error: Unable to retrieve schema information from the record source
'PRODUCT' in a database using the connection string:

'DSN=Star;DRIVER={Centura SQLBase 3.6 32-bit Driver -NT &
Win95};UID=STARUSER;PWD=staruser'.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[MERANT][ODBC SQLBase driver][SQLBase]00601 DIC ITN Table has not been created

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

If the DSN didn't work in Access I don't think I would be so confused.
Anyone have any idea what this problem could be? I would appreciate any help
you could give me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Security in Access 2013 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Trying to remove error from conflicting code 0
msquery: 09815 PRS RCI Result column name must be identifyer 0
Connecting Query Form To SQL 0
Cannot find ODBC driver for MS Access 2007 database on Win 7 64-bi 9
64-bit ADODB in Excel 4
Programmatically set UID & PWD in existing ODBC DSN connection string. 1

Top