odbc driver for postgresql 8.1.8 available?

I have started having odd problems in communication between postgres and MS=
Access using odbc, so to start with I want to update the odbc driver. cur=
rently I am using odbc ver 7.03.02.00 (has been working well for a long tim=
e).

My postgresql version is 8.1.8

http://www.postgresql.org/download/ only links to mODBC_Installer(beta_00.9=
9.121).msi, which appears to be a beta odbc driver and gave me problems imm=
ediately after installing (a lot of "Another user changed the data, [copy t=
o clipboard], [discard]..." type of stuff).

Is there another, non-beta odbc driver available for my version of postgres?

Thanks in advance for any help.

Fred


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: odbc driver for postgresql 8.1.8 available?

LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hB
MQ0KDQpPbiBXZWQsIDIwIEZlYiAyMDA4IDE2OjE3OjM2IC0wODAwDQoiRnJl
ZCBQYXJraW5zb24iIDxGcmVkUEBhYmFnLmNhLmdvdj4gd3JvdGU6DQoNCj4g
SSBoYXZlIHN0YXJ0ZWQgaGF2aW5nIG9kZCBwcm9ibGVtcyBpbiBjb21tdW5p
Y2F0aW9uIGJldHdlZW4gcG9zdGdyZXMNCj4gYW5kIE1TIEFjY2VzcyB1c2lu
ZyBvZGJjLCBzbyB0byBzdGFydCB3aXRoIEkgd2FudCB0byB1cGRhdGUgdGhl
IG9kYmMNCj4gZHJpdmVyLiAgY3VycmVudGx5IEkgYW0gdXNpbmcgb2RiYyB2
ZXIgNy4wMy4wMi4wMCAoaGFzIGJlZW4gd29ya2luZw0KPiB3ZWxsIGZvciBh
IGxvbmcgdGltZSkuDQo+IA0KPiBNeSBwb3N0Z3Jlc3FsIHZlcnNpb24gaXMg
OC4xLjgNCj4gDQo+IGh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG93bmxv
YWQvIG9ubHkgbGlua3MgdG8NCj4gbU9EQkNfSW5zdGFsbGVyKGJldGFfMDAu
OTkuMTIxKS5tc2ksIHdoaWNoIGFwcGVhcnMgdG8gYmUgYSBiZXRhIG9kYmMN
Cj4gZHJpdmVyIGFuZCBnYXZlIG1lIHByb2JsZW1zIGltbWVkaWF0ZWx5IGFm
dGVyIGluc3RhbGxpbmcgKGEgbG90IG9mDQo+ICJBbm90aGVyIHVzZXIgY2hh
bmdlZCB0aGUgZGF0YSwgW2NvcHkgdG8gY2xpcGJvYXJkXSwgW2Rpc2NhcmRd
Li4uIg0KPiB0eXBlIG9mIHN0dWZmKS4NCg0KVW1wZiB0aGF0IGlzIGEgcmVh
bGx5IG9sZCB2ZXJzaW9uLiBUcnkgdGhpcyBvbmU6DQoNCmh0dHBzOi8vcHJv
amVjdHMuY29tbWFuZHByb21wdC5jb20vcHVibGljL29kYmNuZy9hdHRhY2ht
ZW50L3dpa2kvRG93bmxvYWRzL21PREJDX0luc3RhbGxlciUyOGJldGFfMDAu
OTkuMTQzX25vX3NzbCUyOS5tc2k/Zm9ybWF0PXJhdw0KDQoNCj4gDQo+IElz
IHRoZXJlIGFub3RoZXIsIG5vbi1iZXRhIG9kYmMgZHJpdmVyIGF2YWlsYWJs
ZSBmb3IgbXkgdmVyc2lvbiBvZg0KPiBwb3N0Z3Jlcz8NCg0KDQpBbGwgc29m
dHdhcmUgaXMgYmV0YSwgaXRzIGp1c3QgYSBtYXR0ZXIgb2YgZGVncmVlIDop
DQoNCkpvc2h1YSBELiBEcmFrZQ0KDQoNCi0gLS0gDQpUaGUgUG9zdGdyZVNR
TCBDb21wYW55IHNpbmNlIDE5OTc6IGh0dHA6Ly93d3cuY29tbWFuZHByb21w
dC5jb20vIA0KUG9zdGdyZVNRTCBDb21tdW5pdHkgQ29uZmVyZW5jZTogaHR0
cDovL3d3dy5wb3N0Z3Jlc3FsY29uZmVyZW5jZS5vcmcvDQpEb25hdGUgdG8g
dGhlIFBvc3RncmVTUUwgUHJvamVjdDogaHR0cDovL3d3dy5wb3N0Z3Jlc3Fs
Lm9yZy9hYm91dC9kb25hdGUNClBvc3RncmVTUUwgU1BJIExpYWlzb24gfCBT
UEkgRGlyZWN0b3IgfCAgUG9zdGdyZVNRTCBwb2xpdGljYWwgcHVuZGl0DQoN
Ci0tLS0tQkVHSU4gUEdQIFNJR05BVFVSRS0tLS0tDQpWZXJzaW9uOiBHbnVQ
RyB2MS40LjYgKEdOVS9MaW51eCkNCg0KaUQ4REJRRkh2TVRsQVRiL3pxZlpV
VVFSQWlIekFLQ2FqYXFOYlY4N1Zac2lybFltdjhnL3lqbC9wZ0NnZzhlaQ0K
bExHVHRGVDRZVGk4S0ErbHVYWUc1Q3M9DQo9dFd6cg0KLS0tLS1FTkQgUEdQ
IFNJR05BVFVSRS0tLS0tDQoKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
KGVuZCBvZiBicm9hZGNhc3QpLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
ClRJUCA1OiBkb24ndCBmb3JnZXQgdG8gaW5jcmVhc2UgeW91ciBmcmVlIHNw
YWNlIG1hcCBzZXR0aW5ncwo=

Re: odbc driver for postgresql 8.1.8 available?

On Thu, Feb 21, 2008 at 12:25 AM, Joshua D. Drake wrote:

> Umpf that is a really old version. Try this one:
> https://projects.commandprompt.com/public/odbcng/attachment/ wiki/Downloads/mODBC_Installer%28beta_00.99.143_no_ssl%29.ms i?format=raw
>
> >
> > Is there another, non-beta odbc driver available for my version of
> > postgres?
>
>
> All software is beta, its just a matter of degree :)

Yeah, if you want a mature driver, try psqlODBC:
http://www.postgresql.org/ftp/odbc/versions/

:-p

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org