Subject | AW: [firebird-support] Using Firebird with MS Access |
---|---|
Author | Olaf Kluge |
Post date | 2013-02-11T14:54:43Z |
Hello Gerhard,
Please read my answer at the bottom below the question. This was asked by Himanshu Bahirat. We have the same idea and result :o)
Hello Olaf,
you have to usein win7 or win8 the 32-bit odbc
manager(c:\windows\SysWOW64\odbcad32.exe)
1. install the Firebird obc driver, you find it on the Firebird webpage
2. use the Odbcad32.exe to make a System-DSN entry for your firebird
database
3. in Access you can then connect to this database
best regards
Gerhard
Am 11.02.2013 12:46, schrieb Olaf Kluge:
Please read my answer at the bottom below the question. This was asked by Himanshu Bahirat. We have the same idea and result :o)
Hello Olaf,
you have to usein win7 or win8 the 32-bit odbc
manager(c:\windows\SysWOW64\odbcad32.exe)
1. install the Firebird obc driver, you find it on the Firebird webpage
2. use the Odbcad32.exe to make a System-DSN entry for your firebird
database
3. in Access you can then connect to this database
best regards
Gerhard
Am 11.02.2013 12:46, schrieb Olaf Kluge:
>[Non-text portions of this message have been removed]
> Hi,
>
> ……………………..
>
> Hello all,
> I had previously posted about ODBC drivers, but I didn't understand how to
> solve the problem, so trying it again.
>
> I have Windows 7 64 bit, MS Office 32 bit version installed on 64 bit
> machine. I want to data from a database with extension .gdb into to MS
> Access.
>
> I am told I will need ODBC driver for this.
> I am unsure which driver should I download, how to install it and then how
> to import the data.
>
> I don't know anything about databases and other complexities, so I will
> greatly appreciate simple steps to get this done.
>
> regards,
> Himanshu Bahirat
>
> …………………..
>
> I try to help you.
>
> You can download and install the 32Bit ODBC Driver from firebirdsql.org.
> After this, you should create a system dsn, please run
> C:\Windows\SysWoW64\odbcad32.exe (for 32 Bit, the 64Bit located in the
> control panel does not work für 32 Bit Access. Set a name for your
> connection and fill in all fields on the configuration page. You
> should use
> the fdb extension for your firebird database.
>
> Than you can link the tables in msacces after select the system dsn. For
> running stored procedures directly in ms access you can use a adodb
> connection. You can also import the data, but in this case the data
> are not
> linked, but fix imported.
>
> Good look.
>
> Best regards.
>
> Olaf
>
> [Non-text portions of this message have been removed]
>
>