Hi,

I'm trying to open an existing database.
When making the connection with following connectionstring:
DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local;CatalogName=ADM2013;Initial Catalog=C:\<<path>>\ADM2013
The connection seems to be opening fine but I keep getting the 11010 error 'table or backup file xxx does not exist' (xxx is the name of a dat file in the folder).

When trying the connection using a preconfigured DSN I get following error when opening the connection:
The specified DSN contains an architecture mismatch between the Driver and Application

Any idea on what might be wrong or causing these issues?

Thanks!

Small update/note: using the evaluation ODBC driver for the moment (until I'm sure I can do the stuff needed...)

Roeligan wrote:

Hi,

I'm trying to open an existing database.
When making the connection with following connectionstring:
DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local;CatalogName=ADM2013;Initial Catalog=C:\<<path>>\ADM2013
The connection seems to be opening fine but I keep getting the 11010 error 'table or backup file xxx does not exist' (xxx is the name of a dat file in the folder).

When trying the connection using a preconfigured DSN I get following error when opening the connection:
The specified DSN contains an architecture mismatch between the Driver and Application

Any idea on what might be wrong or causing these issues?

Thanks!

Try changing the CatalogName to be the full path and it might be worth
adding a "PrivateDirectory" entry for a place where temporary tables can
be stored as well.

Chris Holland
[Team Elevate]

On 12/02/2013 21:15, Roeligan wrote:
> Hi,
>
> I'm trying to open an existing database.
> When making the connection with following connectionstring:
> DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local;CatalogName=ADM2013;Initial Catalog=C:\<<path>>\ADM2013
> The connection seems to be opening fine but I keep getting the 11010 error 'table or backup file xxx does not exist' (xxx is the name of a dat file in the folder).
>
> When trying the connection using a preconfigured DSN I get following error when opening the connection:
> The specified DSN contains an architecture mismatch between the Driver and Application
>
> Any idea on what might be wrong or causing these issues?
>
> Thanks!
>

Seems to work indeed...
Thanks!!!

R

Chris Holland wrote:

Try changing the CatalogName to be the full path and it might be worth
adding a "PrivateDirectory" entry for a place where temporary tables can
be stored as well.

Chris Holland
[Team Elevate]

On 12/02/2013 21:15, Roeligan wrote:
> Hi,
>
> I'm trying to open an existing database.
> When making the connection with following connectionstring:
> DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local;CatalogName=ADM2013;Initial Catalog=C:\<<path>>\ADM2013
> The connection seems to be opening fine but I keep getting the 11010 error 'table or backup file xxx does not exist' (xxx is the name of a dat file in the folder).
>
> When trying the connection using a preconfigured DSN I get following error when opening the connection:
> The specified DSN contains an architecture mismatch between the Driver and Application
>
> Any idea on what might be wrong or causing these issues?
>
> Thanks!
>

Chris answered your other question, but I'll answer this one:

<< When trying the connection using a preconfigured DSN I get following
error when opening the connection: The specified DSN contains an
architecture mismatch between the Driver and Application >>

This means that you're configuring the DSN for the 32-bit ODBC driver when
using a 64-bit application, or vice-versa:

http://www.elevatesoft.com/supportfaq?action=view&category=dbisam&question=odbc_driver_64_bit

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com