64 bit ODBC Datasource

Hello together
I'm running Reporting Services on a 64 bit Windows 2003 R2 machine. I've
installed the MyOdbc 3.51 Drivers for MySql which I would like to use as the
Datasource for my reports. I configured and tested the ODBC connection
successfully using the odbcad32.exe in the windows\syswow64 folder.
But when I deploy a report which I designed on my 32 bit development machine
where all is running correctly, and I run the report on the server, it
cannot find the datasource.
I think it has the same reason why I cannot see the MyODBC driver in the
normal ODBC Configuration Manager in the Administrative Tools.
Is there a possiblity to do that anyway'
Thank you and greetings from Switzerland
ThomasHi Thomas,
Did you get a response to this question? I'm not using MySQL, but
I've spent most of today chasing this exact problem. I can tell you
that hacking the registry doesn't work, but I'd really like to know if
you heard from someone that had solved it, or if you found the answer
yourself.
Thanks in advance.
Dan
Thomas Bolt wrote:
> Hello together
> I'm running Reporting Services on a 64 bit Windows 2003 R2 machine. I've
> installed the MyOdbc 3.51 Drivers for MySql which I would like to use as the
> Datasource for my reports. I configured and tested the ODBC connection
> successfully using the odbcad32.exe in the windows\syswow64 folder.
> But when I deploy a report which I designed on my 32 bit development machine
> where all is running correctly, and I run the report on the server, it
> cannot find the datasource.
> I think it has the same reason why I cannot see the MyODBC driver in the
> normal ODBC Configuration Manager in the Administrative Tools.
> Is there a possiblity to do that anyway'
> Thank you and greetings from Switzerland
> Thomas|||Hi Dan,
Did you get anywhere with this? I'm in exactly the same position that you
were in August!
Any help would be very much appreciated.
Rob
"barnetted@.michigan.gov" wrote:
> Hi Thomas,
> Did you get a response to this question? I'm not using MySQL, but
> I've spent most of today chasing this exact problem. I can tell you
> that hacking the registry doesn't work, but I'd really like to know if
> you heard from someone that had solved it, or if you found the answer
> yourself.
> Thanks in advance.
> Dan
> Thomas Bolt wrote:
> > Hello together
> >
> > I'm running Reporting Services on a 64 bit Windows 2003 R2 machine. I've
> > installed the MyOdbc 3.51 Drivers for MySql which I would like to use as the
> > Datasource for my reports. I configured and tested the ODBC connection
> > successfully using the odbcad32.exe in the windows\syswow64 folder.
> > But when I deploy a report which I designed on my 32 bit development machine
> > where all is running correctly, and I run the report on the server, it
> > cannot find the datasource.
> >
> > I think it has the same reason why I cannot see the MyODBC driver in the
> > normal ODBC Configuration Manager in the Administrative Tools.
> > Is there a possiblity to do that anyway'
> >
> > Thank you and greetings from Switzerland
> > Thomas
>