Re: need help with errors in ODBC log - Mailing list pgsql-interfaces

<div><div><h2>Re: need help with errors in ODBC log</h2><ul><li><strong>From</strong>: <strong>Carolyn Lu Wong <<a
href="mailto:carolyn@greatpacific.com.au">carolyn@greatpacific.com.au</a>></strong><li><strong>To</strong>:
<strong>DavePage <<a
href="mailto:dpage@vale-housing.co.uk">dpage@vale-housing.co.uk</a>></strong><li><strong>Subject</strong>:
<strong>Re:need help with errors in ODBC log</strong><li>Date: Wed, 08 Nov 2000 09:22:19 +1100 </ul><hr /><pre>>
DavePage wrote:<br />> > <br />> > > -----Original Message-----<br />> > > From: Carolyn Lu
Wong[mailto:carolyn@greatpacific.com.au]<br />> > > Sent: 07 November 2000 04:03<br />> > > To: <a
href="mailto:pgsql-interfaces@postgresql.org">pgsql-interfaces@postgresql.org</a><br/>> > > Subject:
[INTERFACES]need help with errors in ODBC log<br />> > ><br />> > ><br />> > > This problem
isregarding VB5 application connection to postgreSQL<br />> > > V6.5 via PsqlODBC V6.5. I'm not sure if the
problemis related to ODBC<br />> > > or the database. Please let me know if I should direct the question to<br
/>>> > another discussion group.<br />> > ><br />> > > When I try to open a record set from
VBwith a simple select<br />> > > statement, results are retrieved if I connect to database on a local<br
/>>> > server. However, if I try to retrieve data from remote server (via<br />> > > internet) with
thesame code, I get the following error: '3669:<br />> > > Execution Cancelled' (source - DAO.Connection).<br
/>>> ><br />> > > The statement I try to open the record set with is 'select * from<br />> >
>accounts where account_no = 3;' I have included extractions from the<br />> > > ODBC log files for both
cases.The only difference I can see is in the<br />> > > case where error arises, it has additional 'select *
fromselect *<br />> > > from....' in the log. I don't know where the 'select *' that comes<br />> > >
beforethe select statement comes from.<br />> > ><br />> > <br />> > The additional 'SELECT *
FROM'is probably caused by having the command type<br />> > set to table rather than text in the data control.
Thiscauses the control<br />> > to assume that the recordsource is a tablename so it sticks SELECT * FROM in<br
/>>> front of it to create a complete query.<br />> > <br />> > HTH,<br />> > Regards,
Dave.</pre></div><div>>The thing is, when I run the same application accessing database from<br />> the local
server(LAN), I don't have the VB 3669 error, and the<br />> additional 'Select * from' does not exist in the log
file.However, if<br />> i'm accessing database from remote server (WAN), it causes the VB<br />> error and
there'sadditional 'select * from' in the log file! Apart<br />> from the differences in the data, both database
tabledefinitions are<br />> identical.</div><p>> FYI, the source of the recordset in VB is SQL statement.<hr
/><fontcolor="#0000ff" size="3"><p>The following two lines represent a code fragment that can be used with the VB
development;we can place these lines within our 'Main' routine(s) and <i>'massage'</i> their values to iron-out many
accessproblems, not excluding the infamous <i>'Database Cancellation' </i>run-time error 3669:</font><font
color="#008080"face="Courier New" size="3"><p>glLoginTimeout = Val(GetINIString("LoginTimeout", "20"))<p>glQueryTimeout
=Val(GetINIString("QueryTimeout", "60"))</font><font color="#0000ff" size="3"><p>BTW, the values presented above, are
thedefault values for these properties. I attach a couple of extracts from the VB on-line help, to shed more light into
thisissue.</font><font color="#0000ff" size="3"><p>Enjoy,<p><u>-Toli       :-)</u></font><font color="#993366"
face="Arial"size="2"><p></font>____________________________________________________________ <br /><br />         I Only
KnowOne Thing -- That I Know Nothing! (SOCRATES) <br />____________________________________________________________ <br
/></div><brclear="all" /><hr />Get Your Private, Free E-mail from MSN Hotmail at <a
href="http://www.hotmail.com">http://www.hotmail.com</a>.<br/>