Re: psqlODBC / install / WinXP

skendric(at)fhcrc(dot)org (Stuart Kendrick) wrote in message news:<Pine(dot)LNX(dot)4(dot)61(dot)0407230842090(dot)6916(at)vishnu(dot)fhcrc(dot)org>...
> right, ok, that's where i started, with only one 's' in the name. thanx
> anyway,

I found a hacky fix. If you create a key in
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI named what you want the
datasource to be named which has some of string keys for the values (I
referenced the suggestions in the following url, but only did through
the ReadOnly entry) found here:

http://groups.google.com/groups?q=psqlodbc+odbc.ini&hl=en&lr=&ie=UTF-8&c2coff=1&selm=03AF4E498C591348A42FC93DEA9661B884D2%40mail.vale-housing.co.uk&rnum=3

You can edit the settings using the GUI inside the ODBC Administrator.
The driver still doesn't appear in the Drivers list, but you can edit
the DSN as you see fit, through the GUI.

Good luck.

> On Fri, 23 Jul 2004, Dave Page wrote:
>
> >
> >
> >> -----Original Message-----
> >> From: Stuart Kendrick [mailto:skendric(at)fhcrc(dot)org]
> >> Sent: 23 July 2004 16:32
> >> To: Dave Page
> >> Cc: Janet Borschowa; pgsql-odbc(at)postgresql(dot)org
> >> Subject: RE: [ODBC] psqlODBC / install / WinXP
> >>
> >> hi janet, hi dave,
> >>
> >> ok, so ...
> >>
> >> i change the key:
> >> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL
> >> to
> >> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgresSQL
> >>
> >> and i change
> >> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
> >> Name = PostgreSQL to
> >> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
> >> Name = PostgresSQL
> >>
> >> and i close regedit ...
> >>
> >> and i open the GUI tool ...
> >>
> >> but i still don't see any 'PostGreSQL' or even 'PostGresSQL'
> >> entry in the 'Drivers' tab
> >>
> >>
> >> ... am i understanding your suggestion here accurately?
> >
> > No, it should be:
> >
> > PostgreSQL
> >
> > No double S. I don't think it's going to help though - something is
> > clearly not right with your driver manager.
> >
> > Regard,s Dave.
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match