What PostgreSQL ODBC driver should I use on Windows NT with the latest version of PostgreSQL from CVS? I had been using psqlodbc.dll version 6.50.0000 by Insight Distribution System, as made available on ftp.postgresql.org in the 'latest' folder. That worked OK with version 7.0.3 of PostgreSQL, and does pretty well with the head CVS version too. But... I'm using ODBC connections with Zope, and Zope was able to display table schemas when connected to PG 7.0.3. However, it doesn't display any schema information when using the same ODBC driver but connected to the latest/head version of PG. This makes me think that the 6.50 ODBC driver is not a good match to the latest version of PG. So I ran 'configure --with-odbc' when building PG from source, creating a new psqlodbc.dll file. But when I replace my %systemroot%/system32/psqlodbc.dll file (the version 6.50 one) with this new version, nothing about ODBC to PG works right anymore. Attempting to use the driver to create a new DSN gives the message "The setup routines for the PostgreSQL ODBC driver could not be accessed. Please reinstall the driver." Maybe I need to do something more to install it correctly, but I couldn't find any information about how to do that. Can someone tell me how to install this latest version of the ODBC driver? -- Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
