Re: Thank for your Clue - PostgreSQL ODBC - Mailing list pgsql-interfaces

  <p>Chandra Wibawa wrote: <blockquote type="CITE"> Dear Jose, Our server configuration is :1. Pentium III 500, 256
MB,SCSI U2W2. SuSE 6.2, PostgreSQL 6.5.3 <font face="Arial"><font size="-1">Our client configuration is
:</font></font><fontface="Arial"><font size="-1">1. Pentium 133, RAM 40 MB, IDE</font></font><font face="Arial"><font
size="-1">2.Windows 98, Access 97</font></font><font face="Arial"><font size="-1">3. ODBC From Insight</font></font> 
<br/>What version of PsqlODBC are you running? You need 6.40.0007. <br />I remember this behavior the first times we
startedusing access->PostgreSQL but now I don't remember <br />why. <br />Send this mail to
interfaces@postgresql.org,there is Byron Nikolaidis the author of the ODBC driver, he <br />certanly knows this
behavior.<br />Also take a look at the FAQ:  <a
href="http://www.insightdist.com/psqlodbc/psqlodbc_faq.html">http://www.insightdist.com/psqlodbc/psqlodbc_faq.html</a><br
/> <br /> <font face="Arial"><font size="-1">Our network is :</font></font>1. Network Hub 10 Mb <font
face="Arial"><fontsize="-1">I have followed your hints, it does improve the performance.</font></font> I have done some
testings,retrieving 3000 records from server to client.I can see the first hundred lines of the record, but when i
scrolleddown the MS Access windowit took a very long time to scroll down (5 minutes). When i tried to scroll to the
lastrecord, i had to waitfor ages, and finally when i pressed Ctrl-Alt-Del, i saw  a message "not responding" on MS
Access. <fontface="Arial"><font size="-1">Could you tell me what could be done to overcome this problem
?</font></font> <fontface="Arial"><font size="-1">Could this be the network, or the client ?</font></font> <font
face="Arial"><fontsize="-1">Thanks for your help.</font></font> <font face="Arial"><font
size="-1">Regards,</font></font><fontface="Arial"><font size="-1">Chandra</font></font><blockquote style="BORDER-LEFT:
#0000002px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"><div style="FONT: 10pt
arial">-----Original Message -----</div><div style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
black"><b>From:</b><a href="mailto:jose@sferacarta.com" title="jose@sferacarta.com">jose</a></div><div style="FONT:
10ptarial"><b>To:</b> <a href="mailto:chandraw@prima.net.id" title="chandraw@prima.net.id">Chandra Wibawa</a></div><div
style="FONT:10pt arial"><b>Sent:</b> Wednesday, February 09, 2000 20:26</div><div style="FONT: 10pt
arial"><b>Subject:</b>Re: Thank for your Clue - PostgreSQL ODBC</div>   <p>Chandra Wibawa ha scritto: <blockquote
type="CITE"><style></style><fontface="Arial"><font size="-1">Thank's Jose,</font></font> <font face="Arial"><font
size="-1">Ihave succesfully connected my database (postgreSQL) to Access 97 on client machine. But I think there is
stillbig problem because the link table takes takes too much time (maybe around 45 - 60 minutes, even not
responding).Wouldyou mind give me suggestion to solve my problem ?</font></font> <font face="Arial"><font size="-1">For
yourinformation, our configuration :1. Processor 133 MHz at client side2. Harddisk 1 GB at client side3. RAM 40 MB at
clientside4. Our LAN speed is 10 Mbps</font></font></blockquote> Is this your server or client ? <p>M$ access is very
slowbut 45-60 minutes is too much <br />This seems like a net problem. <br />Anyway try to tune ODBC drive. <p>GO TO
Options(Advanced)<br />Driver: <p>check on: <br /><KSQO> <br /><Recognize unique indexes> <br /><Use
declare/fetch><p>check off: <p><CommLog> <br /><Parse statments> <p>DataSource: <p>check on. <br
/><Rowversioning> <br />  <p>I hope this help you. <p>Jose' <br /> </blockquote></blockquote><p>-- <br />Jose'
Soares<br />Bologna, Italy                     Jose@sferacarta.com <br />