Well, the driver psqlodbc-07 works on PostgreSQL, but not very well! My problem is that I have some tables, for exemple: create table service ( cod_service int, nam_service varchar(255) not null default '', des_service varchar(255) ); So I did some reports (Crystal Reports) on that table using PostgreSQL 7.4.x (linux )and after I migrate to PostgreSQL 8.0.3 (windowsXP). And I tried to use the same report to access the PostgreSQL 8, and then occured some errors, like the nam_service field couldn't be mapped correctly in the report, so I get blank reports without any data. I mean, my tables have the same strucuture, my data is also the same, my reports is the same, the only thing that has changed is the version of PostgreSQL, so I belive it has some mismatch with the internel structure or some error on the drivers. So I need to know if the tables or views in the system catalogs have changed somehow!!?? Thanks!! -----Original Message----- From: Richard Huxton [mailto:dev@xxxxxxxxxxxx] Sent: seg 20/06/2005 10:57 To: Rodrigo Katsumoto Sakai Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Help! What has changed in the internal structure of PostgreSQL? Rodrigo Katsumoto Sakai wrote: > Hi, I'm having some troubles using the driver ODBC! The problem is > that a did some reports with Crystal Reports XI and used PostgreSQL > 7.4.x with psqlodbc-07_03_0200, now I have migrate to PostgreSQL > 8.0.3 and I'm using psqlodbc-08_00_0101 but the reports that I did is > not working anymore because it is not mapping the fields of the > tables correctly! I need to kwon what has changed in the structure > (if changed) of the talbes! Thanks a lot! What tables? What mapping? What is incorrect? Also, have you ruled out some change in the ODBC driver? I believe psqlodbc-07 should work with a version 8.0 PostgreSQL installation. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
