Postgres Pro
Downloads
Home   >   mailing lists

Thread: trouble removing 8.0 driver in xp

trouble removing 8.0 driver in xp

From
"Joel Fradkin"
Date:

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.
© 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.

 


 

 

Re: trouble removing 8.0 driver in xp

From
Jonathan Fuerth
Date:
On Jun 9, 2005, at 10:15 AM, Joel Fradkin wrote:


<excerpt><fontfamily><param>Arial</param><x-tad-bigger>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).</x-tad-bigger></fontfamily>


</excerpt>

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

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

Re: trouble removing 8.0 driver in xp

From
"Joel Fradkin"
Date:

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.
© 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