Re: Error adding table in Crystal Reports(mult. schemas

On Mon, 30 Jun 2003, Godshall Michael wrote:

> Hi,
>  
> I have a postgresql database with two non temporary schemas.  I am able to
> add the tables from the schema named "Public" to my reports but I cannot add
> tables from my 2nd schema to my reports.
>  
> I am not trying to add tables from both schemas to same report.
>  
> I tried using ODBC 7.2X and have upgraded to 7.3.100 and still receive the
> following error.
> "Not Supported. Details:  Cannot obtain error message from server".
>  
> The account I am using to access both schemas is the same with same
> permissions set.
>  
> I am using Crystal 9.0 with SP1 installed on Win2000 SP4.
>  
> How can I determine if the problem is with postgresql driver or crystal?

More than likely Crystal 9.0 was written with pgsql 7.2.x in mind, and 
doesn't know that 7.3.x has schema support.

In general, when there's a problem with Crystal Reports and some other 
piece of software, the problem is usually with Crystal Reports.  I'm not 
being sarcastic, it's honestly been my experience that Crystal Reports is 
a pretty rigid / inflexible program that doesn't integrate well with 
things it wasn't programmed to directly integrate with.

Weird Performance Issue with .NET

Hi All,

I've imported a VB6 project into VB.NET, and I'm quite appalled at the
database performance through ADO.NET which seems to be a factor of 3 slower.
In general this isn't too much of a problem, but there is one view which is
exhibiting bizarre behaviour:

CREATE VIEW vw_checklist AS

SELECT ch.order_id, ch.checklist_id, ch.called, ch.notes, ch.emailed,
cl.short_name, t.*
FROM tblchecklist ch
INNER JOIN tbltrader t ON ch.trader_id = t.trader_id
INNER JOIN tblclient cl ON t.client_id = cl.client_id
ORDER BY  cl.short_name, t.first_name, t.last_name

Now if you do a select on this view:
e.g. SELECT * FROM vw_checklist WHERE order_id = 1260

this query takes about 0.01 seconds under VB6, but under VB.NET it takes 1.2
seconds. The bizarre thing is if you run the SQL that creates the view, so
that it becomes:

SELECT ch.order_id, ch.checklist_id, ch.called, ch.notes, ch.emailed,
cl.short_name, t.*
FROM tblchecklist ch
INNER JOIN tbltrader t ON ch.trader_id = t.trader_id
INNER JOIN tblclient cl ON t.client_id = cl.client_id
WHERE order_id = 1260
ORDER BY  cl.short_name, t.first_name, t.last_name

Re: A few problems with the ODBC driver

Hiroshi Inoue wrote:

>>-----Original Message-----
>>From: Shachar Shemesh
>>
>>Hi list,
>>
>>I'm still trying to find my way around the ODBC arena, so 
>>please forgive me if I
>>ask something irrelevant. I am trying to migrate an 
>>application that currently
>>works on Windows with MS-SQL and Oracle to also work with PG-SQL. I've
>>downloaded the 7.3.100 ODBC driver. The problems are 
>>independant, but if anyone
>>manages to solve my first problem, I'm not going to care 
>>about the other ones.
>>
>>1. The application is successful in seeing the database, and 
>>in getting the rows
>>from it. When it tries to modify a row, however, we get an 
>>error that says "Only
>>SQL_POSITION/REFRESH is supported for PGAPI_SetPos". 
>>Searching the sources
>>reveals that the line is issued as a result of line 2762 of 
>>"result.c". The
>>preceding lines show that either the odbc driver was compiled without
>>DRIVER_CURSOR_IMPLEMENT, or the cursor is a read only cursor. 
>>Tracing the MFC
>>stack reveals that the program does try to create a ROW_VER 
>>cursor. Could it be

Re: (ODBC) Error connecting to postgres 7.2.2

Why not just try the PostgreSQL driver?
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

--- Rick <rick <at> reac.nl> wrote:
>     ODBC driver version 		insight distr. stms
> 6.40.0006
>     PostgreSQL database version 	7.2.2
> 
> Hi All,
> 
> Probably a common question, but i couldn't find any
> answers on the net.
> 
> This ODBC driver connects fine to one of our servers
> running Postgres 7.0.2
> It fails however to connect to another server
> running PG 7.2.2.  After a very,
> very long timeout it says something like : "Database
> does not exist or user 
> unknown".
> 
> I've logged the connection, and it fails on sending
> an empty query!. It doesnt
> get a result and tears down the connection.
> 
> 
> -- 
> Regards,
> 
> Rick

db

Re: A few problems with the ODBC driver

Shachar Shemesh wrote:
> 
> Hiroshi Inoue wrote:
> 
> >>-----Original Message-----
> >>From: Shachar Shemesh
> >>
> >>1. The application is successful in seeing the database, and
> >>in getting the rows
> >>from it. When it tries to modify a row, however, we get an
> >>error that says "Only
> >>SQL_POSITION/REFRESH is supported for PGAPI_SetPos".
> >>Searching the sources
> >>reveals that the line is issued as a result of line 2762 of
> >>"result.c". The
> >>preceding lines show that either the odbc driver was compiled without
> >>DRIVER_CURSOR_IMPLEMENT, or the cursor is a read only cursor.
> >>Tracing the MFC
> >>stack reveals that the program does try to create a ROW_VER
> >>cursor. Could it be
> >>that the binary ODBC available from the mirrors does not
> >>support cursors? Why?
> >
> >Are you checking the "Updatable cursors" DSN option ?
> >
> As a matter of fact - I am. We were wondering what it does. In any case,
> that did not help.

What kind of cursor are you opening ?
Anyway, could you send me the Mylog debug output ?

> > 2. I tried to compile a replica of the driver I downloaded. I
> >followed the
> >instructions in README.TXT. Created the project in Visual
> >Studio 6. Added the
> >def file (I opted for psqlodbc_win32.def, as that's the only
> >one that matched
> >the name of the DLL I was supposed to create). The result was
> >that the project
> >wouldn't compile. I tried to run ./configure from cygwin
> >before, and now it
> >would compile, but throw an exception when I try to run it.
> >What do I need to do
> >in order to recompile a copy of the binary version given at the site?
> >
> >Don't use the driver compiled under cygwin.
> >I recommend to compile it from the command line i.e type
> >  nmake /f win32.mak
> >
> Ok. I fail with "don't know how to make psqlodbc.rc". It is, indeed, not
> in the sources. Where do I get it?

Please go to
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php.
You can view Web CVS there or access CVS from the command line
according to an info on the page.

regards,
Hiroshi Inoue
	http://www.geocities.jp/inocchichichi/psqlodbc/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

How to can i make ,y system as psql database server????????

How to fetch the RefCursor in via ODBC??

Hi All,
  I wrote a function to return a RefCursor of a temp table as below:

    CREATE FUNCTION reffunc(refcursor, varchar(10), varchar(10))
        RETURNS refcursor AS '
        BEGIN
          EXECUTE ''create local temp table tablexxx
                    (repno character(15), date date)'';
          insert into tablexxx (repno, date) VALUES ( $2, now() );
          insert into tablexxx (repno, date) VALUES ( $3, now() );
          OPEN $1 for EXECUTE '' SELECT * FROM tablexxx '';
          RETURN $1;
          EXECUTE '''';
        END;
    ' LANGUAGE 'plpgsql';

It work fine on psql, at least it work as I expected. I call this
function by following command on psql:

        BEGIN;
          SELECT reffunc('funccursor', 'AAA', 'BBB' );
          FETCH ALL FROM funccursor;
        COMMIT;

However, when I try to call this function via ODBC ( namely in the
Borland DBExplorer ). It got none information for me! I am wondoring
is ODBC supporting RefCursor, since the FAQ of GBorg said the ODBC
only support simple data type. Therefore, does ODBC support
refcursor??

PS: My psqlODBC version is 07.03.0100
    My psql version is  7.3.1
Harry Yau
MIS HK

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Re: A few problems with the ODBC driver

Shachar Shemesh wrote:
> 
> Quoting Hiroshi Inoue <Inoue <at> tpf.co.jp>:
> 
> > Shachar Shemesh wrote:
> >
> > What kind of cursor are you opening ?
> It's deep inside the MFC code, so I'm not sure. I /THINK/ It's a rowver cursor.
> > Anyway, could you send me the Mylog debug output ?
> Attached.

Maybe I found a cause.
Please try the snapshot dll at 
	http://www.geocities.jp/inocchichichi/psqlodbc/ .

regards,
Hiroshi Inoue
	http://www.geocities.jp/inocchichichi/psqlodbc/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: A few problems with the ODBC driver

Quoting Hiroshi Inoue <Inoue <at> tpf.co.jp>:

> Maybe I found a cause.
> Please try the snapshot dll at 
> 	http://www.geocities.jp/inocchichichi/psqlodbc/ .
I downloaded "psqlodbc.zip" from the site. The exact same symptoms.

IS this different than CVS tip? That's what I'm compiling locally (and that's
the versions the logs I sent were taken with).

           Shachar

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