Problem connecting from Windows 9x/Me

Hi,

Thank you for the ODBC driver, it has enabled us to access the PostgreSQL 
server from our Windows 2000 & XP machine.
However, people on Windows 9x/Me machines are having problems.

Basically, everytime they open the MS Access application, the application 
failed with the following error message:
"ODBC -- connection to 'pgsql_sir' failed."

There's a workaround for this - if we create a new table link to the 
PostgreSQL database, then afterwards everything works fine. I have no idea 
why it solves the problem (temporarily), but there you go.

But of course this can not be / not feasible to be done by the users 
everytime they start up the application, so I hope somebody can help us to 
solve this problem.

I've made the SQL.LOG files (ODBC tracing output) available :

http://www.abangadek.com/tamu/ODBCLOG-unable-to-connect.txt
Recorded the failure of our internal MS Access application to connect to 
the PostgreSQL server

http://www.abangadek.com/tamu/ODBCLOG-connected-after-creating-new-link-in-Access.txt
Recorded the table link creation process to the PostgreSQL server. 
Afterwards, the MS Access application can access the PostgreSQL database 
with no problem whatsoever.

We'd be grateful for any assistance anyone can give us regarding this.


Many thanks,
Harry


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq