ODBC Drivers

This is a multi-part message in MIME format.

------_=_NextPart_001_01C65E7A.3D68BA54
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

> Is there a complete list of Postgres ODBC drivers somewhere? I need
> a good, reliable, highly conforming driver or my boss is going to make =
us
> switch to SQL Server. Unfortunately, the current driver seems to fail =
the
> "highly conforming" criterion as far as Crystal Reports is concerned. =
I
> don't want to use the experimental driver in CVS because I have a
> production environment that needs to be stable. I wanted to try the
> Command Prompt driver, but they don't even list it under the Products
> section of their site, presumably because they are still working on =
it?
> Any references to other drivers, commercial or not, would be greatly
> appreciated (though my cursory search seems to indicate that the field
> is pretty narrow).
>=20
> __
> David B. Held
> Software Engineer/Array Services Group
> 200 14th Ave. East, Sartell, MN 56377
> 320.534.3637 320.253.7800 800.752.8129
>=20
>=20

------_=_NextPart_001_01C65E7A.3D68BA54
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




charset=3Diso-8859-1">
6.0.6617.29">

Is there a complete list of Postgres =
ODBC drivers somewhere?  I need


a good, reliable, highly conforming =
driver or my boss is going to make us


switch to SQL Server.  =
Unfortunately, the current driver seems to fail the


"highly conforming" =
criterion as far as Crystal Reports is concerned.  I


don't want to use the experimental =
driver in CVS because I have a


production environment that needs to =
be stable.  I wanted to try the


Command Prompt driver, but they don't =
even list it under the Products


section of their site, presumably =
because they are still working on it?


Any references to other drivers, =
commercial or not, would be greatly


appreciated (though my cursory search =
seems to indicate that the field


is pretty narrow).

__


David B. Held


Software Engineer/Array Services =
Group


200 14th Ave. East,  =
Sartell, MN 56377


320.534.3637 320.253.7800 =
800.752.8129

Re: ODBC Drivers

-----Original Message-----
From: "Dave Held"
Sent: 12/04/06 23:08:19
To: "pgsql-odbc@postgresql.org"
Subject: [ODBC] ODBC Drivers

> Unfortunately, the current driver seems to fail the
> "highly conforming" criterion as far as Crystal Reports is concerned.=20=
=20

In what way? We've been using psqlODBC with Crystal 7, 8 & now 11 since pg =
6.4ish with no problems.

Regards, Dave

-----Unmodified Original Message-----
> Is there a complete list of Postgres ODBC drivers somewhere? I need
> a good, reliable, highly conforming driver or my boss is going to make us
> switch to SQL Server. Unfortunately, the current driver seems to fail the
> "highly conforming" criterion as far as Crystal Reports is concerned. I
> don't want to use the experimental driver in CVS because I have a
> production environment that needs to be stable. I wanted to try the
> Command Prompt driver, but they don't even list it under the Products
> section of their site, presumably because they are still working on it?
> Any references to other drivers, commercial or not, would be greatly
> appreciated (though my cursory search seems to indicate that the field
> is pretty narrow).
>=20
> __
> David B. Held
> Software Engineer/Array Services Group
> 200 14th Ave. East, Sartell, MN 56377
> 320.534.3637 320.253.7800 800.752.8129
>=20
>=20

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

http://archives.postgresql.org

Re: ODBC Drivers

PiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBEYXZlIFBh
Z2UgW21haWx0bzpkcGFnZUB2YWxlLWhvdXNpbmcuY28udWtdDQo+IFNlbnQ6
IFdlZG5lc2RheSwgQXByaWwgMTIsIDIwMDYgNToxNCBQTQ0KPiBUbzogRGF2
ZSBIZWxkOyBwZ3NxbC1vZGJjQHBvc3RncmVzcWwub3JnDQo+IFN1YmplY3Q6
IFJFOiBbT0RCQ10gT0RCQyBEcml2ZXJzDQo+IA0KPiBbTWVdDQo+ID4gVW5m
b3J0dW5hdGVseSwgdGhlIGN1cnJlbnQgZHJpdmVyIHNlZW1zIHRvIGZhaWwg
dGhlDQo+ID4gImhpZ2hseSBjb25mb3JtaW5nIiBjcml0ZXJpb24gYXMgZmFy
IGFzIENyeXN0YWwgUmVwb3J0cw0KPiA+IGlzIGNvbmNlcm5lZC4gIA0KPiAN
Cj4gSW4gd2hhdCB3YXk/IFdlJ3ZlIGJlZW4gdXNpbmcgcHNxbE9EQkMgd2l0
aCBDcnlzdGFsIDcsIDggJiANCj4gbm93IDExIHNpbmNlIHBnIDYuNGlzaCB3
aXRoIG5vIHByb2JsZW1zLg0KDQpIZWguICBKdXN0IG15IGx1Y2suICBJbiBD
cnlzdGFsIDEwLCBhZ2FpbnN0IGFuIDguMCBkYiwgYW5kDQp0aHJvdWdoIGEg
QnVzaW5lc3MgT2JqZWN0cyBYSSBCdXNpbmVzcyBWaWV3LCBhbnkgdmFyY2hh
ciB3aXRoDQpsZW5ndGggPiAyNTUgc2hvd3MgdXAgYXMgYSBnb29meSBkYXRh
IHR5cGUgKFBlcnNpc3RlbnQubWVtbw0KaWYgSSByZWNhbGwgY29ycmVjdGx5
KS4gIFVuZm9ydHVuYXRlbHksIENyeXN0YWwgd29uJ3QgZXZlbg0KYWNrbm93
bGVkZ2UgdGhlIGV4aXN0ZW5jZSBvZiB0aGVzZSBmaWVsZHMsIHNvIHlvdSBj
YW4ndCBldmVuDQpwdXQgdGhlbSBvbiB5b3VyIHJlcG9ydC4gIFNRTCBTZXJ2
ZXIgZG9lcyBqdXN0IGZpbmUgd2l0aCBsYXJnZQ0KdmFyY2hhcnMuICBJdCB3
b3VsZCBiZSBldmVuIG5pY2VyIHRvIGp1c3QgdXNlIHRleHQgZmllbGRzLCBi
dXQNCnRob3NlIGNvbmZ1c2UgQ3J5c3RhbCBldmVuIG1vcmUgKHVzdWFsbHkg
aXQgZGlzcGxheXMgYSBsZW5ndGgNCm9mIC0xIGFuZCBkb2VzIHdlaXJkIHRo
aW5ncykuDQoNCkRhdmUNCgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0o
ZW5kIG9mIGJyb2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0K
VElQIDE6IGlmIHBvc3RpbmcvcmVhZGluZyB0aHJvdWdoIFVzZW5ldCwgcGxl
YXNlIHNlbmQgYW4gYXBwcm9wcmlhdGUKICAgICAgIHN1YnNjcmliZS1ub21h
aWwgY29tbWFuZCB0byBtYWpvcmRvbW9AcG9zdGdyZXNxbC5vcmcgc28gdGhh
dCB5b3VyCiAgICAgICBtZXNzYWdlIGNhbiBnZXQgdGhyb3VnaCB0byB0aGUg
bWFpbGluZyBsaXN0IGNsZWFubHkK

Re: ODBC Drivers

> > "highly conforming" criterion as far as Crystal Reports is concerned. I
> > don't want to use the experimental driver in CVS because I have a
> > production environment that needs to be stable. I wanted to try the

I think the Experimental Enhanced Branch (psqlODBC 07.03.026X - which
is now the CVS Head) is more stable than 08.01.0200 (which is marked as
stable). Feel free to test it.

I see no motivation to support 08.01 becouse it's dead end.

> > Any references to other drivers, commercial or not, would be greatly
> > appreciated (though my cursory search seems to indicate that the field
> > is pretty narrow).

What about google with: postgresql odbc driver?

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: ODBC Drivers

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dave Held
> Sent: 12 April 2006 23:19
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ODBC Drivers
>=20
> > -----Original Message-----
> > From: Dave Page [mailto:dpage@vale-housing.co.uk]
> > Sent: Wednesday, April 12, 2006 5:14 PM
> > To: Dave Held; pgsql-odbc@postgresql.org
> > Subject: RE: [ODBC] ODBC Drivers
> >=20
> > [Me]
> > > Unfortunately, the current driver seems to fail the "highly=20
> > > conforming" criterion as far as Crystal Reports is concerned.
> >=20
> > In what way? We've been using psqlODBC with Crystal 7, 8 & now 11=20
> > since pg 6.4ish with no problems.
>=20
> Heh. Just my luck. In Crystal 10, against an 8.0 db, and=20
> through a Business Objects XI Business View, any varchar with=20
> length > 255 shows up as a goofy data type (Persistent.memo=20
> if I recall correctly). Unfortunately, Crystal won't even=20
> acknowledge the existence of these fields, so you can't even=20
> put them on your report. SQL Server does just fine with=20
> large varchars. It would be even nicer to just use text=20
> fields, but those confuse Crystal even more (usually it=20
> displays a length of -1 and does weird things).

Hmm, we never use varchars that big but use text instead with no
problems. We don't use Business Objects XI Business Views though.

Have you tried tweaking the MaxVarchar setting in your DSN? That
defaults to 254...

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend