Re: Scratching my head why results are different between machines. - Mailing list pgsql-general

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@magwerks.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 

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. 

[1444-387.642]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=51, stmt='Select user_password from mediawiki.mwuser limit 10'
[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--
[1444-387.665]qresult: len=44, buffer=':B:e2e28556:8ff13b68ebc64eccad0921d1571bf08c'
[1444-387.666]qresult: len=0, buffer=''
[1444-387.667]qresult: len=44, buffer=':B:60a118ba:592cb633245cc330d48cc2e52c922f90'
[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.