Skip site navigation (1) Skip section navigation (2)

Re: problem ODBC

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "frank_lupo" <frank_lupo(at)email(dot)it>,"pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: problem ODBC
Date: 2002-07-25 09:12:38
Message-ID: D85C66DA59BA044EB96AB9683819CF61137FA5@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
When does the error occur in pgAdmin?

Regards, Dave.

> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo(at)email(dot)it] 
> Sent: 25 July 2002 10:00
> To: pgadmin-hackers
> Subject: [pgadmin-hackers] problem ODBC
> 
> 
> I connect to postgresql via ODBC.
> ---------------
> String connection:
> 
>         szDns = "SERVER=" & szHost & ";"
>         szDns = szDns & "PORT=" & lPort & ";"
>         szDns = szDns & "UID=" & szUser & ";"
>         szDns = szDns & "PASSWORD=" & szPassword & ";"
>         szDns = szDns & "DATABASE=" & szDataBase & ";"
>         szDns = szDns & "DRIVER={PostgreSQL};"
>         szDns = szDns & "READONLY=0;"
>         szDns = szDns & "PROTOCOL=6.4;"
>         szDns = szDns & "FAKEOIDINDEX=0;"
>         szDns = szDns & "SHOWOIDCOLUMN=0;"
>         szDns = szDns & "ROWVERSIONING=0;"
>         szDns = szDns & "SHOWSYSTEMTABLES=0;"
>         szDns = szDns & "CONNSETTINGS=;"
>         szDns = szDns & "FETCH=100;"
>         szDns = szDns & "SOCKET=4096;"
>         szDns = szDns & "UNKNOWNSIZES=0;"
>         szDns = szDns & "MAXVARCHARSIZE=256;"
>         szDns = szDns & "MAXLONGVARCHARSIZE=65536;"
>         szDns = szDns & "OPTIMIZER=1;"
>         szDns = szDns & "KSQO=1;"
>         szDns = szDns & "USEDECLAREFETCH=0;"
>         szDns = szDns & "TEXTASLONGVARCHAR=1;"
>         szDns = szDns & "UNKNOWNSASLONGVARCHAR=1;"
>         szDns = szDns & "BOOLSASCHAR=1;"
>         szDns = szDns & "PARSE=0;"
>         szDns = szDns & "CANCELASFREESTMT=0;"
>         szDns = szDns & "EXTRASYSTABLEPREFIXES=dd_;"
> 
>         DbCon.Open szDns
> ---------------
> 
> Show datestyle
> -> DateStyle is ISO with European conventions
> select now()
> 25/07/2002 9.01.57
> 
> Change date style
> SET datestyle TO 'SQL' or  SET datestyle TO 'SQL,European'
> -> DateStyle is SQL with European conventions
> select now()
> In Visual Basic error -2147217887
> 
> This problem is present also in PgAdmin2.
> 
> Help me
> 
> Bye !!
> Frank Lupo (Wolf) !!
> 
> 
> 
> --
> Prendi GRATIS l'email universale che... risparmia: 
http://www.email.it/f

Sponsor:
Partecipa al QX Concorso e vinci ricchi premi!
Iscriviti gratis a QX Service e richiedi un artigiano o un
professionista per vincere fantastici Premi: Lettori Dvd, Micro Hi-fi e
Radioregistratori con CD Philips! Clicca qui:
http://adv2.email.it/cgi-bin/foclick.cgi?mid=540&d=25-7

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-07-25 09:29:38
Subject: Re: problem ODBC
Previous:From: frank_lupoDate: 2002-07-25 09:11:32
Subject: Re: problem ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group