Re: More on "What am I doing wrong!"

On Sun, 19 May 2002, mordicus wrote:

> Hello,
>
> Le Dimanche 19 Mai 2002 10:53, vous avez crit :
> > On Sat, 18 May 2002, mordicus wrote:
> > > faile with a message ?
> >
> > No there is nothing. Only my own error trap.
>
> > > Ok, so, if i understand, with psql when you do
> > >
> > > select apply_parent_details(...your params...) it work and
> > > in your code, when you do the same think it faile ?
> >
> > Yes, exactly.
>
> Very strange :)
>
>
> > > Can you active sql log to see what happend ?
> > How do I do that?
>
> you are working on windows or linux ?
> I'm not on windows actually, but from memory :
>
> on windows, in control panel / ODBC MANAGER when you configure your dsn, you
> can also set sql trace to on, it will create a file named c:\SQL.LOG.

I am not using an ODBC DSN, I'm going direct to the Server.

> of course, you have to modifie your code
>
> sprintf(m_Login.szConnect,
> "DRIVER={PostgreSQL};DATABASE=gpplus;SERVER=%s;PORT=%d;UID=%s;PWD=%s;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_",
> getIPAddr(), getPort(), getUser(), getPassword()) ;
>
> become
>
> sprintf(m_Login.szConnect, "dsn=yourdatabase;UID=%s;PWD=%s;", getUser(),
> getPassword()) ;

Which is why there is a getIPAddr() in the above.

> just for testing.
>
> And on postgresql, you can also activate debug log, but i have to know how you
> start postgresql ? have you compiled it yourself ?
>
> >
> > > I've tested with my own code, and it work well.
> >
> > Tested what?
>
> insert/update via functions with some odbc code ...

Fair enough but have done an atomic transaction in the same manner, where
the return from function A is sent to function B for example?

> > > Can you send me the shema of your database ?
> >
> > Sure. Will a dump() do?
>
> yes, pg_dump -s yourdatabase -f shema.sql and send me shema.sql :)
> so i can try with your shema and some dummy datas.
>
Ok, I'll do that.
>

--
Regards,

Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk