> -----Original Message-----
> From: Brenda [mailto:brenda@wallace.net.nz]
> Sent: 18 July 2002 23:03
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Version info
>
>
> OS is Windows... mix of win98 and win2k.
> They are using MS Access 2000 as a front end to a PgSQL database.
>
> they are getting "[Microsoft][ODBC] Function Sequence Error"
> when they try to view some reports. These reports use data
> from a View in Postgres. I don't let M$ Access do any joins
> or updates/insert. it's just an invoice created from a View in PgSQL.
>
> I'm working on the theory that these users have an older
> version of the ODBC driver.
>
> if this is the case, some-one (probably me) will need to go
> to their office and install a new ODBC driver... but I'd like
> to make sure that will fix it before I make the trip.
>
> if they do have the latest version, then I need to look
> elsewhere for the cause.
>
> so, any easy ways of working this out? I couldn't find a
> version info in the DSN config interface.
In the ODBC driver manager (either in Control Panel in 98 or the
Administrative Tools folder in 2K), there is a 'Drivers' tab. On there
you should see the driver names and versions for each of the drivers
installed on that machine. Alternatively, just right-click -> Properties
on psqlodbc.dll and check the version number on the Version tab. Ignore
the version at the top of the page, instead click on File Version in the
listview lower down and read the version on the right.
Regards, Dave.