Thread: problems with the ODBC driver

problems with the ODBC driver

From
"J J"
Date:
I have installed your latest ODBC driver but it does not show up in the ODBC
admin driver list.  I checked the registry and all the entries look right.
The only thing I can think of is Windows XP does not think the driver is a
32 bit driver (I tried to find the 16 bit version of ODBC admin to verify
this but gave up for tonight).  Either that or it only shows drivers from
company Microsoft. :)  I did notice in the registry that the filemaker app
had put entries in that were not showing up either.  It appears anything not
from Microsoft wont show up.

Have you heard of this before?

Thanks,
Jason

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


Re: problems with the ODBC driver

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of J J
> Sent: 27 September 2004 05:48
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] problems with the ODBC driver
>
> I have installed your latest ODBC driver but it does not show
> up in the ODBC admin driver list.  I checked the registry and
> all the entries look right.
> The only thing I can think of is Windows XP does not think
> the driver is a
> 32 bit driver (I tried to find the 16 bit version of ODBC
> admin to verify this but gave up for tonight).  Either that
> or it only shows drivers from company Microsoft. :)  I did
> notice in the registry that the filemaker app had put entries
> in that were not showing up either.  It appears anything not
> from Microsoft wont show up.
>
> Have you heard of this before?

It's certainly a 32 bit driver (I know, I compiled it!). I have seen
this *once* before, and unfortunately the machine in question was only
fixed with a reinstall of Windows iirc. You might try an MDAC update
from www.microsoft.com/data - that might sort out and messed up ODBC
files or settings.

Regards, Dave

Re: problems with the ODBC driver

From
Daniel Lerch
Date:
I'm having a similar problem as below  (I installed an ODBC driver, but I'm not getting any
sort of ODBC link in my Control Panel like my book (Stones & Matthew,
"Beginning Databases with PostgreSQL", 2001) says I should).

I'm a total newbie to this, though, so I just assumed I did something wrong.

I'm running WinXP Professional, and I downloaded and installed
 'psqlodbc-07_02_0005.zip'
from
 'gborg.postgresql.org'

And, like I said, I'm getting nothing on 'Control Panel'.  According to my 'Add
& Remove Programs' tool, though, it _is_ installed.  What do I need to do?

Please help - I don't know how to move forward, and I'm getting a headache
from banging my head against the monitor.

-d


> -----Original Message-----
> From: pgsql-odbc-owner ( at ) postgresql ( dot ) org
> [mailto:pgsql-odbc-owner ( at ) postgresql ( dot ) org] On Behalf Of J J
> Sent: 27 September 2004 05:48
> To: pgsql-odbc ( at ) postgresql ( dot ) org
> Subject: [ODBC] problems with the ODBC driver
>
> I have installed your latest ODBC driver but it does not show
> up in the ODBC admin driver list.  I checked the registry and
> all the entries look right.
> The only thing I can think of is Windows XP does not think
> the driver is a
> 32 bit driver (I tried to find the 16 bit version of ODBC
> admin to verify this but gave up for tonight).  Either that
> or it only shows drivers from company Microsoft. :)  I did
> notice in the registry that the filemaker app had put entries
> in that were not showing up either.  It appears anything not
> from Microsoft wont show up.
>
> Have you heard of this before?

It's certainly a 32 bit driver (I know, I compiled it!). I have seen
this *once* before, and unfortunately the machine in question was only
fixed with a reinstall of Windows iirc. You might try an MDAC update
from www.microsoft.com/data - that might sort out and messed up ODBC
files or settings.

Regards, Dave


Re: problems with the ODBC driver

From
"Greg Campbell"
Date:
Help us to understand,...
not getting any sort of ODBC link in the control panel???

please confirm
 From Control Panel you chose Administrative Tools
 From Administrative Tools you selected Data Sources (ODBC)
In the window that appears you selected the System DSN, User DSN, or
File DSN tab
You select the button to Add... a new data source name.
In the list that appears, you  do not see PostgreSQL or any similar choice.




Daniel Lerch wrote:

> I'm having a similar problem as below  (I installed an ODBC driver,
> but I'm not getting any sort of ODBC link in my Control Panel like my
> book (Stones & Matthew, "Beginning Databases with PostgreSQL", 2001)
> says I should).
> I'm a total newbie to this, though, so I just assumed I did something
> wrong.
> I'm running WinXP Professional, and I downloaded and installed
> 'psqlodbc-07_02_0005.zip'
> from 'gborg.postgresql.org'
>
> And, like I said, I'm getting nothing on 'Control Panel'.  According
> to my 'Add & Remove Programs' tool, though, it _is_ installed.  What
> do I need to do?
>
> Please help - I don't know how to move forward, and I'm getting a
> headache from banging my head against the monitor.
>
> -d
>
>
>> -----Original Message-----
>> From: pgsql-odbc-owner ( at ) postgresql ( dot ) org
>> [mailto:pgsql-odbc-owner ( at ) postgresql ( dot ) org] On Behalf Of J J
>> Sent: 27 September 2004 05:48
>> To: pgsql-odbc ( at ) postgresql ( dot ) org
>> Subject: [ODBC] problems with the ODBC driver
>>
>> I have installed your latest ODBC driver but it does not show up in
>> the ODBC admin driver list.  I checked the registry and all the
>> entries look right.  The only thing I can think of is Windows XP does
>> not think the driver is a
>> 32 bit driver (I tried to find the 16 bit version of ODBC admin to
>> verify this but gave up for tonight).  Either that or it only shows
>> drivers from company Microsoft. :)  I did notice in the registry that
>> the filemaker app had put entries in that were not showing up
>> either.  It appears anything not from Microsoft wont show up.
>>
>> Have you heard of this before?
>
>
> It's certainly a 32 bit driver (I know, I compiled it!). I have seen
> this *once* before, and unfortunately the machine in question was only
> fixed with a reinstall of Windows iirc. You might try an MDAC update
> from www.microsoft.com/data - that might sort out and messed up ODBC
> files or settings.
>
> Regards, Dave
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


Attachment

Re: problems with the ODBC driver

From
Daniel Lerch
Date:
Ah, there's the problem - it's in 'Administrative Tools'.  My book
(which is now flying out the window) indicated I was supposed to get a
link to 'ODBC Data Sources' directly on the Control Panel.

Thanks.

Greg Campbell wrote:

> Help us to understand,...
> not getting any sort of ODBC link in the control panel???
>
> please confirm
> From Control Panel you chose Administrative Tools
> From Administrative Tools you selected Data Sources (ODBC)
> In the window that appears you selected the System DSN, User DSN, or
> File DSN tab
> You select the button to Add... a new data source name.
> In the list that appears, you  do not see PostgreSQL or any similar
> choice.