Thread: 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? 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
> -----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
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
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
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.