Re: [Py2exe-users] ODBC issue on WIN 2008 64-bit

[Bela M. <bm...@ha...>]

Hi Richard,

thanks for the reply, it gives me a direction where to find the cause. 
I'm just waiting to get remote access to the 64-bit server so I can look 
around there. Still I do not know what and where to change to get it 
run, but will investigate. If you can provide more details it will be 
appreciated. For sure it will be great on Monday.

Have a nice weekend!

Rehards... Béla

2011.12.02. 14:06 keltezéssel, Richard Sharp írta:
> Hello,
> I recently had to battle with this. It probably has nothing to do with 
> py2exe, just with the fact that you are developing a 32-bit program 
> and running it on a 64-bit machine.
>
> I suspect you created your ODBC-Connection normally on the 64-Bit 
> machine. I haven't go a Windows 64-Bit at hand so I can't paste paths 
> from the registry, but you will find there are two sections in the 
> registry, one for 32-Bit programs and one for 64-Bit. Your 
> ODBC-Connection is in the 64-Bit (normal) part of the registry and 
> your 32-Bit program isn't allowed to see the 64-bit registry, which is 
> why it can't find the ODBC-entries.
>
> This just leaves you with a new problem. I had to write a small python 
> program which I am afraid is at my other working place, but when 
> accessing the registry you can put in a special parameter to say look 
> at the 64-Bit part and thus get hold of the registry.
>
> I had this problem when using Ghostscript from a 32-Bit Powerbuilder 
> program and had to access the 64-Bit entries to get to the path of the 
> Ghostscript executable.
>
> I'm only being halfway helpful, if you need more information about 
> getting at the 64-bit registry I will be in the company where the 
> programs are on Monday.
>
> Regards,
> Richard Sharp
>
> Am 02.12.2011 13:10, schrieb Bela Markus:
>> Hi,
>>
>> I'm building applications working with SQL databases via ODBC (pyodbc).
>> Applications are compiled on XP 32-bit and works fine on XP/VISTA
>> 32-bit, but on 2008 64-bit can't connect to ODBC datasource, ODBC says
>> no such source. However ODBC is working with other applications, only my
>> Python EXE can't see it.
>>
>> Any idea how to fix it?
>>
>> Regards... Béla
>>
>>
>> ------------------------------------------------------------------------------ 
>>
>> All the data continuously generated in your IT infrastructure
>> contains a definitive record of customers, application performance,
>> security threats, fraudulent activity, and more. Splunk takes this
>> data and makes sense of it. IT sense. And common sense.
>> http://p.sf.net/sfu/splunk-novd2d
>> _______________________________________________
>> Py2exe-users mailing list
>> Py2...@li...
>> https://lists.sourceforge.net/lists/listinfo/py2exe-users
>
>