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

Fw: Thank for your Clue - PostgreSQL ODBC

From: "Chandra Wibawa" <chandraw(at)prima(dot)net(dot)id>
To: <interfaces(at)postgresql(dot)org>
Subject: Fw: Thank for your Clue - PostgreSQL ODBC
Date: 2000-02-22 09:30:36
Message-ID: 001001bf7d17$798f0880$230039ca@prima.net.id (view raw or flat)
Thread:
Lists: pgsql-interfaces
Dear SIr,

I need your help about PostgreSQL ODBC. Please help me to solve the problem

Regards,
chandra

----- Original Message ----- 
From: Jose Soares 
To: Chandra Wibawa ; interfaces 
Sent: Friday, February 11, 2000 20:40
Subject: Re: Thank for your Clue - PostgreSQL ODBC


  
Chandra Wibawa wrote: 

   Dear Jose, Our server configuration is :1. Pentium III 500, 256 MB, SCSI U2W2. SuSE 6.2, PostgreSQL 6.5.3 Our client configuration is :1. Pentium 133, RAM 40 MB, IDE2. Windows 98, Access 973. ODBC From Insight  
  What version of PsqlODBC are you running? You need 6.40.0007. 
  I remember this behavior the first times we started using access->PostgreSQL but now I don't remember 
  why. 
  Send this mail to interfaces(at)postgresql(dot)org, there is Byron Nikolaidis the author of the ODBC driver, he 
  certanly knows this behavior. 
  Also take a look at the FAQ:  http://www.insightdist.com/psqlodbc/psqlodbc_faq.html 
    
   Our network is :1. Network Hub 10 Mb I have followed your hints, it does improve the performance. 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 scrolled down the MS Access windowit took a very long time to scroll down (5 minutes). When i tried to scroll to the last record, i had to waitfor ages, and finally when i pressed Ctrl-Alt-Del, i saw  a message "not responding" on MS Access. Could you tell me what could be done to overcome this problem ? Could this be the network, or the client ? Thanks for your help. Regards,Chandra 
    ----- Original Message -----
    From: jose
    To: Chandra Wibawa
    Sent: Wednesday, February 09, 2000 20:26
    Subject: Re: Thank for your Clue - PostgreSQL ODBC
      
    Chandra Wibawa ha scritto: 

      Thank's Jose, I have succesfully connected my database (postgreSQL) to Access 97 on client machine. But I think there is still big problem because the link table takes takes too much time (maybe around 45 - 60 minutes, even not responding).Would you mind give me suggestion to solve my problem ? For your information, our configuration :1. Processor 133 MHz at client side2. Harddisk 1 GB at client side3. RAM 40 MB at client side4. Our LAN speed is 10 Mbps
    Is this your server or client ? 
    M$ access is very slow but 45-60 minutes is too much 
    This seems like a net problem. 
    Anyway try to tune ODBC drive. 

    GO TO Options(Advanced) 
    Driver: 

    check on: 
    <KSQO> 
    <Recognize unique indexes> 
    <Use declare/fetch> 

    check off: 

    <CommLog> 
    <Parse statments> 

    DataSource: 

    check on. 
    <Row versioning> 
      

    I hope this help you. 

    Jose' 
     

-- 
Jose' Soares 
Bologna, Italy                     Jose(at)sferacarta(dot)com 
  

pgsql-interfaces by date

Next:From: Alexey V. MeledinDate: 2000-02-22 09:46:21
Subject: Sharing Database Connection Among Different CGI scripts writen in different languages
Previous:From: Tom RogieDate: 2000-02-22 08:04:38
Subject: pgadmin on win9x

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