Re: Scratching my head why results are different between machines.

Is there anyone out there using Windows 7 64 bit with Postgres 8.4.2 and
the psqlodbc driver?  I've tried to install using the one that is available
with the standard windows installer.  I've also tried to install with the
one from EDB.   It appears that the installer finishes the install but when
I look for the drivers there are none in the odbc administrator.  I've
installed and uninstalled a couple of times.

Does anyone have any idea on what is going on here and how to fix the
problem?  I've logged in as the domain adminstrator and the system
administrator for our domain and I've turned UAC off also, but as of yet no
luck.

I know that they are at least partially installed because I can access our
database via two tools that use ODBC as it's access method.  It's just that
they are not showing up in the administrator and this makes me think that
I've got a problem. 

I'm trying to get a data conversion tool to work (was working when I was
using Windows XP) to convert data from SQL Anywhere into PostgreSQL 8.4.2. 
The problem is with UUID columns that are looked up and used in other
tables.  The UUID's are created properly in their parent tables, but the
value isn't correct when it is used as a lookup column.

The author of this product has taken a complete backup of my database and
restored it on his machine. When he runs the conversion routine it produces
the correct data.  The only difference between his machine and mine seems
to be how the odbc driver is installed.  He's using the one he downloaded
from EDB.  He sent it to me, I uninstalled the previous one I had, rebooted
and installed the one he sent me.  Same results, no driver shows up in the
odbc admin.

Best Regards

Michael Gould

"Justin Graf" <justin(at)magwerks(dot)com> wrote:
 

>On 3/3/2010 5:16 PM, Michael Gould wrote:
>>
>>
>>One thing I've noticed is that on my machines, when I install the odbc
>>driver I get no error messages but when I look in the ODBC administrator I
>>do not see any entry for PostGres in the drivers list.
>>
>>I do know that it somehow is working because the DMC conversion tool only
>>uses ODBC and builds it's data structures based on what it gets back from
>>querying the database.
>>
>>Programs like WinSQL also work and I believe it uses ODBC.
>>
>>In the past I believe I remember seeing the Postgres driver listed in the
>>ODBC admin tool under the drivers tab.
>>
>>I'm running on a Windows 7 64 bit machine and I'm logged into our domain
as
>>the domain administrator. Is there something else I need to do to install
>>the odbc driver under windows? I've even turned UAC off and it didn't
seem
>>to help
>> </pre>
>>
>
>Can't help on the Windows 7  ODBC  not  appearing in the drivers list
>
>If you can manage to configure a Data Source Name  turn on the logging
>
>then connect using this DSN in your DMC app just do a simple select
>
>The log will get big quick so keep the selects small and use limit.  This
>will allow to see what ODBC driver is up to
>
>open the C:\mylog_XXX and look at and you will find all the commands sent
>the Postgresql and the results 
>
>then you will look for something like this.  This will tell us what the
>Select looks like and what being sent DMC app. 
>
><b>[1444-387.642]Exec_with_parameters_resolved: copying statement params:
>trans_status=1, len=51, stmt='Select user_password from mediawiki.mwuser
>limit 10'</b>
>[1444-387.645]   stmt_with_params = 'Select user_password from
>mediawiki.mwuser limit 10'
>[1444-387.646]about to begin SC_execute
>[1444-387.647]       Sending SELECT statement on stmt=02C5D8C0,
>cursor_name='SQL_CUR02C5D8C0' qflag=0,1
>[1444-387.648]CC_send_query: conn=04313E00, query='Select user_password
>from mediawiki.mwuser limit 10'
>------snip--
><b>[1444-387.665]qresult: len=44,
>buffer=':B:e2e28556:8ff13b68ebc64eccad0921d1571bf08c'</b>
>[1444-387.666]qresult: len=0, buffer=''
><b>[1444-387.667]qresult: len=44,
>buffer=':B:60a118ba:592cb633245cc330d48cc2e52c922f90'</b>
>[1444-387.667]qresult: len=0, buffer=''
>[1444-387.668]qresult: len=0, buffer=''
>[1444-387.668]qresult: len=0, buffer=''
>[1444-387.669]qresult: len=0, buffer=''
>[1444-387.669]qresult: len=0, buffer=''
>[1444-387.670]qresult: len=0, buffer=''
>
>
>
>
>
>All legitimate Magwerks Corporation quotations are sent in a .PDF file
>attachment with a unique ID number generated by our proprietary quotation
>system. Quotations received via any other form of communication will not be
>honored.
>
>CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain
>legally privileged, confidential or other information proprietary to
>Magwerks Corporation and is intended solely for the use of the individual
>to whom it addresses. If the reader of this e-mail is not the intended
>recipient or authorized agent, the reader is hereby notified that any
>unauthorized viewing, dissemination, distribution or copying of this e-mail
>is strictly prohibited. If you have received this e-mail in error, please
>notify the sender by replying to this message and destroy all occurrences
>of this e-mail immediately.
>Thank you.
>

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax