Hi,



Anyone tell me what files I need to remove (I removed via remove programs
and it is still working, I want to switch back to 7.4 drivers).



I originally tried removing both from the 8.0 install (has a odbc tree
option) and as a separate install).

This worked and I had no odbc driver.

Then just to ensure it was the 8.0 driver giving me issues I installed it
again.

From the msi not with 8.0 postgres install.

I then removed using remove programs and the driver wont go away.

I figured I would just delete the files manually if some one know what files
and maybe a dir I should look at?

I appreciate the help.

The issues are because of encoding (I plan on trying to load my data into a
Unicode database, but not sure of a easy way to get it from SQL_ASCII).

The other issue is I have some text fields over 8k (what I had been using as
max longvarchar length in my connect).

I found changing it to a larger number corrected my problem in 7.4 driver
land, but 8.0 driver gave me some odd multiple operation error.



Joel Fradkin



Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305



jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

On Jun 9, 2005, at 10:15 AM, Joel Fradkin wrote:

> Anyone tell me what files I need to remove (I removed via remove
> programs and it is still working, I want to switch back to 7.4
> drivers).
>

First, use the ODBC administrator to get rid of all the system and user
DSNs associated with the driver you want to remove.

Then, check the registry in HKLM\Software\ODBC\ODBCINST.INI. There
will be a key for each ODBC driver in your system. Look in the
PostgreSQL one. There will be string values named "Driver" and "Setup"
that point to the driver DLL. (For postgres, both values should name
the same DLL, and it's probably in your Windows system directory).
Delete that DLL.

Then delete the PostgreSQL driver key from the registry, and delete its
entry in the "ODBC Drivers" key as well.

There might be a generic script or utility that does this automatically
for any ODBC driver, but I'm not a windows user so I can't say for
sure.

Hope that helps,

Jonathan

Thanks that did it was in my windows/system32

I thought I checked there but must have been hallucinating.



Joel Fradkin



Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305



jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.






-----Original Message-----
From: Jonathan Fuerth [mailto:fuerth@sqlpower.ca]
Sent: Thursday, June 09, 2005 10:02 AM
To: Joel Fradkin
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] trouble removing 8.0 driver in xp



On Jun 9, 2005, at 10:15 AM, Joel Fradkin wrote:

Anyone tell me what files I need to remove (I removed via remove programs
and it is still working, I want to switch back to 7.4 drivers).


First, use the ODBC administrator to get rid of all the system and user DSNs
associated with the driver you want to remove.

Then, check the registry in HKLM\Software\ODBC\ODBCINST.INI. There will be a
key for each ODBC driver in your system. Look in the PostgreSQL one. There
will be string values named "Driver" and "Setup" that point to the driver
DLL. (For postgres, both values should name the same DLL, and it's probably
in your Windows system directory). Delete that DLL.

Then delete the PostgreSQL driver key from the registry, and delete its
entry in the "ODBC Drivers" key as well.

There might be a generic script or utility that does this automatically for
any ODBC driver, but I'm not a windows user so I can't say for sure.

Hope that helps,

Jonathan