From: | "Mikhail Umorin" <mikeumo(at)onebox(dot)com> |
---|---|
To: | Inoue(at)tpf(dot)co(dot)jp |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Delphi7, ADO, ODBC and PostgreSQL connection problems |
Date: | 2003-09-17 23:18:21 |
Message-ID: | B0014327550@vljcms08.ucmretail.internal.callsciences.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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, TADOConnection object 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 must run odbc.sql on template1 in order to have ODBC-oriented functions in the database. However, ODBC documentation is absent in 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(at)onebox(dot)com
-----Original Message-----
From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Sent: Wed, 17 Sep 2003 10:30:51 +0900
To: Mikhail Umorin <mikeumo(at)onebox(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Combs | 2003-09-18 00:58:31 | Re: Delphi7, ADO, ODBC and PostgreSQL connection problems |
Previous Message | Relaxin | 2003-09-17 23:17:09 | Re: how to compile the odbc source? |