Stuart,
Thanks for the info. I haven't had any time to work on this today but I do have one more question for you. Which DLL do you use when you set up your DSN. For me the only way I've managed to get it to work is using the 32 bit 2.0 version and the gds32.dll.
Doyce
--- In MS_Access_Professionals@yahoogroups.com, "Stuart Luckman" <stuartluckman@...> wrote:
>
> Doyce,
>
>
>
> I'm actually using Firebird 2.5 with the driver:
> Firebird_ODBC_2.0.1.152_x64.exe from www.firebirdsql.org/en/odbc-driver/
>
> which seems to be the same one at sourceforge.
>
> Must be Firebird 1.5 that has the issue.
>
> I'm using this combo with an fdb created with Firebird 1.5 and a gdb created
> with Firebird 1.5.
>
>
>
> Cheers,
>
> Stuart
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of dnwinberry
> Sent: Tuesday, 31 July 2012 7:50 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Access, Firebird 1.5 and Windows 7 64 bit
>
>
>
>
>
> Stuart,
>
> I've tried all kinds of combinations installing different versions of
> drivers. Could you please tell me which versions (client and databasae) you
> and using and point me to a site where I can download the 64 bit driver
> you're using? I found one on SourceForge but you may have a different one.
>
> Thanks,
> Doyce
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Stuart Luckman"
> <stuartluckman@> wrote:
> >
> > There is a 64 bit Firebird odbc driver which is working well for me on
> > Windows 7.
> >
> > If you are still using the 32 bit XP driver maybe you will have to
> uninstall
> > it and install the 64 bit driver.
> >
> >
> >
> > Cheers,
> >
> > Stuart
> >
> >
> >
> >
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of dnwinberry
> > Sent: Tuesday, 31 July 2012 12:07 AM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Re: Access, Firebird 1.5 and Windows 7 64 bit
> >
> >
> >
> >
> >
> > Thanks Bill! I always appreciate your good advice. I had planned to
> upgrade
> > the software package to the latest version and downloaded the trial and
> was
> > very disappointed to learn that it was still running on Firebird 1.5.
> There
> > are later versions of Firebird. So I was suprised. At this point the later
> > version won't help me. I'll keep trying though!
> >
> > Doyce
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca"
> > <wrmosca@> wrote:
> > >
> > > Doyce
> > >
> > > I've seen that error before and it always meant the DLL was
> > self-registering. But don't hold me to that.
> > >
> > > Your next step would be to go to a Firebird support forum to see if they
> > have an answer for you. It could be you need to get a later version that
> > will run on a 64-bit OS. I really don't know.
> > >
> > > Bill
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "dnwinberry"
> > <winberry.doyce@> wrote:
> > > >
> > > > Good morning Bill,
> > > >
> > > > I get this error message when trying to re-register the DLL. "The
> module
> > C:\program files(x86)\Firebird\firebird_1_5\bin\fbclient.dll was loaded
> but
> > the entry-point DLLRegisterServer was not found. Make sure that
> "C:\program
> > files(x86)\Firebird\firebird_1_5\bin\fbclient.dll is a valid dll or OCX
> file
> > and then try again."
> > > > I've searched Google on this error but haven't found anything yet that
> > made sense or would fix the problem. I'll keep working on it but would
> > appreciate any other ideas to fix this problem.
> > > >
> > > > Thanks,
> > > > Doyce
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca"
> <wrmosca@>
> > wrote:
> > > > >
> > > > > Doyce
> > > > >
> > > > > The first thing I would try is to re-register the DLL. Then I would
> > create a new DSN to see if that fixes it.
> > > > >
> > > > > Regards,
> > > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > > http://www.thatlldoit.com
> > > > > Microsoft Office Access MVP
> > > > >
> >
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
> > 1E
> > > > > My nothing-to-do-with-Access blog
> > > > > http://wrmosca.wordpress.com
> > > > >
> > > > >
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "dnwinberry"
> > <winberry.doyce@> wrote:
> > > > > >
> > > > > > Hello friends,
> > > > > >
> > > > > > I have Access 2007 linked to an application that uses a Firebird
> 1.5
> > database with an ODBC driver. This has worked well with Windows XP. Since
> > I've upgraded my PC to Windows 7 64-bit, I can't get the Firebird ODBC
> > driver to show up as a data source when I try to add an ODBC DSN. It does
> > show up under the driver tab. Google searches have led me to believe this
> is
> > a common problem, however I've not been able to find a workable solution.
> > Can anyone help me link to these tables with Windows 7?
> > > > > >
> > > > > > Doyce
> > > > > >
> > > > >
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar