Re: Delphi7, ADO, ODBC and PostgreSQL connection problems - Mailing list pgsql-odbc

From Mikhail Umorin
Subject Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Date
Msg-id B0014327550@vljcms08.ucmretail.internal.callsciences.com
Whole thread Raw
In response to Delphi7, ADO, ODBC and PostgreSQL connection problems  ("Mikhail Umorin" <mikeumo@onebox.com>)
List pgsql-odbc
Hiroshi --
thanks for looking into my problem.
my connection string:
'Provider=MSDASQL.1;Persist Security Info=False;User ID=lara;DataSource=PostgreSQL30;Mode=Read;lie=1'

I tried it with your suggestion and the result is exactly the same.
that log excerpt did contain some error; what was it? I am a newbie to ADO/ODBC so, I can't tell. As far as I know,
TADOConnectionobject I use in my Delphi program is a wrapper around MS ADO API. 

Now, what I also discovered on PostgreSQL site was that 7.2 docs contained a chapter on ODBC and mentioned that one
mustrun odbc.sql on template1 in order to have ODBC-oriented functions in the database.  However, ODBC documentation is
absentin 7.3 (which I have) as well as odbc.sql. 
What's up with that?
Do I still need to run odbc.sql against template1, or ODBC API functions are already implemented there?

--
Mikhail Umorin
mikeumo@onebox.com



-----Original Message-----
From:     Hiroshi Inoue <Inoue@tpf.co.jp>
Sent:     Wed, 17 Sep 2003 10:30:51 +0900
To:       Mikhail Umorin <mikeumo@onebox.com>
Cc:       pgsql-odbc@postgresql.org
Subject:  Re: [ODBC] Delphi7,  ADO, ODBC and PostgreSQL connection problems



Mikhail Umorin wrote:
>
> here it is up until the message appears. After that I stopped the trace.

Unfortunately I could find no clue in the log.

How do you open the connection ?
Could you try to add a "lie=1" option to your connection string ?

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



pgsql-odbc by date:

Previous
From: "Mikhail Umorin"
Date:
Subject: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Next
From: Richard Combs
Date:
Subject: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems