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

problem ODBC

From: "frank_lupo" <frank_lupo(at)email(dot)it>
To: "pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org>
Subject: problem ODBC
Date: 2002-07-25 08:59:39
Message-ID: GZSRNF$IZNZirSFsolEChgGjE3o2y4C2NjlMrDxKAtt6U0isId9e@email.it (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

pgadmin-hackers by date

Next:From: frank_lupoDate: 2002-07-25 09:11:32
Subject: Re: problem ODBC
Previous:From: Discount Calls UKDate: 2002-07-23 13:45:07
Subject: WE CAN HALVE YOUR COMPANY'S UK TELEPHONE BILLS!!

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