Обсуждение: Help! What has changed in the internal structure of PostgreSQL?
Hi, I'm having some troubles using the driver ODBC! The problem is that a did some reports with Crystal Reports XI andused 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_0101but 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!
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
Re: Help! What has changed in the internal structure of PostgreSQL?
От
"Rodrigo Katsumoto Sakai"
Дата:
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 PostgreSQL8.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. Imean, my tables have the same strucuture, my data is also the same, my reports is the same, the only thing that has changedis 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@archonet.com] Sent: seg 20/06/2005 10:57 To: Rodrigo Katsumoto Sakai Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 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
Rodrigo Katsumoto Sakai wrote: > > 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) > ); [snip] > 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. There's nothing I know of should cause these problems. What do you mean by "mapped correctly". -- Richard Huxton Archonet Ltd