Обсуждение: Re: Version info
> -----Original Message----- > From: Brenda [mailto:brenda@wallace.net.nz] > Sent: 18 July 2002 05:22 > To: pgsql-odbc@postgresql.org > Subject: [ODBC] Version info > > > is there an easy way to determine what version of the pg ODBC > someone is using? I need to guide someone over the phone or > email to help then work this out. On what OS? And do you want to check manually or programmatically? Regards, Dave.
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. > -----Original Message----- > From: Dave Page [mailto:dpage@vale-housing.co.uk] > Sent: Friday, 19 July 2002 00:13 > To: Brenda; pgsql-odbc@postgresql.org > Subject: RE: [ODBC] Version info > > > > > > -----Original Message----- > > From: Brenda [mailto:brenda@wallace.net.nz] > > Sent: 18 July 2002 05:22 > > To: pgsql-odbc@postgresql.org > > Subject: [ODBC] Version info > > > > > > is there an easy way to determine what version of the pg ODBC > > someone is using? I need to guide someone over the phone or > > email to help then work this out. > > On what OS? And do you want to check manually or programmatically? > > Regards, Dave. > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.377 / Virus Database: 211 - Release Date: 15/07/2002 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.377 / Virus Database: 211 - Release Date: 15/07/2002
> -----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.