convert .gdb to access/word/excel
convert .gdb to access/word/excel
(OP)
I just tried to use the data pump to convert a .gdb file to a Microsoft
Access file. I created an alias to the directory where the file was stored
using the Database Desktop and selected MS Access Database as the target
when using the datapump. I got the error:
Key violation
[Microsoft][ODBC Microsoft Access Driver]General error Not enough
information to connect to this DSN
with SQLConnect. Use
General SQL error.
SQLDriverConnect.
Alias: MS Access Database
after I was prompted for a username and password. I'm not sure why I need a
username and password but tried
username: SYSDBA
pasword: masterkey
which then gave me this error
Access file. I created an alias to the directory where the file was stored
using the Database Desktop and selected MS Access Database as the target
when using the datapump. I got the error:
Key violation
[Microsoft][ODBC Microsoft Access Driver]General error Not enough
information to connect to this DSN
with SQLConnect. Use
General SQL error.
SQLDriverConnect.
Alias: MS Access Database
after I was prompted for a username and password. I'm not sure why I need a
username and password but tried
username: SYSDBA
pasword: masterkey
which then gave me this error
RE: convert .gdb to access/word/excel
You might try and use the datapump in the application that I wrote - download yourself a trial copy of InterBase Workbench - www.upscene.com - select the DataPump and see if that helps.
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com