Thread: ODBC Driver on Windows 64 bit
Hi
I have installed the ODBC driver on Windows XP Professional 64bit. The installation said that it was sucessful, but I cannot see the odbc driver in the ODBC data sources administrator.
Is there something that I have to do on Windows 64 bit to use the driver?
Any help will be appreciated
Thanks
Craig
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Craig
Sent: 08 September 2005 19:44
To: PostgreSQL-ODBC
Subject: [ODBC] ODBC Driver on Windows 64 bitHiI have installed the ODBC driver on Windows XP Professional 64bit. The installation said that it was sucessful, but I cannot see the odbc driver in the ODBC data sources administrator.Is there something that I have to do on Windows 64 bit to use the driver?
Hi Craig,
I don't believe 64 bit windows should require anything different, however we have had (literally) one or two reports of similar problems in the past where Windows just wouldn't play ball, despite everything being installed correctly :-(
What version of the driver do you have?
Regards, Dave
Hi Dave
I downloaded the latest driver before installing (psqlodbc-08_00_0102.zip).
Thanks
Craig
----- Original Message -----From: Dave PageTo: Craig ; PostgreSQL-ODBCSent: Friday, September 09, 2005 9:46 AMSubject: Re: [ODBC] ODBC Driver on Windows 64 bit
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Craig
Sent: 08 September 2005 19:44
To: PostgreSQL-ODBC
Subject: [ODBC] ODBC Driver on Windows 64 bitHiI have installed the ODBC driver on Windows XP Professional 64bit. The installation said that it was sucessful, but I cannot see the odbc driver in the ODBC data sources administrator.Is there something that I have to do on Windows 64 bit to use the driver?Hi Craig,I don't believe 64 bit windows should require anything different, however we have had (literally) one or two reports of similar problems in the past where Windows just wouldn't play ball, despite everything being installed correctly :-(What version of the driver do you have?Regards, Dave
Craig, > I have installed the ODBC driver on Windows XP Professional > 64bit. The installation said that it was sucessful, but I cannot > see the odbc driver in the ODBC data sources administrator. > Is there something that I have to do on Windows 64 bit to use > the driver? just found this in the microsoft odbc newsgroup. Perhaps it helps: > I solved the problem this way: First run C:\WINDOWS\SysWOW64\odbcad32.exe. > This will bring up the ODBC Data Source Administrator with the 32-bit drivers > (including Microsoft Access for those of you having trouble with that) If > you had a driver you installed, it will show up here also. At this point you > set up your DSN just like you would on any other system. Have Fun. > > "Giancarlo" wrote: > > >>> Hi, >>> I am running Windows XP x64 and .NET (x32 version). When upgrading my >>> Windows XP from x32 to x64 an odbc driver installation doesn't work properly. >>> When I go to ODBC Data Source Administrator and then click Drivers tab it >>> does not show the odbc driver I installed. I checked and its .dll is located >>> here: C:\Program Files (x86)\Qantel\Qicware\ODBC\bin\iwinnt but, not in Data >>> Source Administrator thus I can't set up a DSN to access external database. >>> Any help would be much appreciated, >>> Giancarlo -- -------------------------------------------- Lit Window Library - Speed up GUI coding 10x http://www.litwindow.com/library?src=ml wxVisualSetup - integrate wxWidgets into Visual Studio .NET http://www.litwindow.com/Products/products.html?src=ml BugLister - Defect Tracker http://www.litwindow.com/buglister?src=ml Tips & Tricks for wxWidgets & MS Visual Studio http://www.litwindow.com/Knowhow/knowhow.html?src=ml
Hi Craig,
I've been looking at this some more, and unfortunately it looks like psqlODBC will not work on 64 bit versions of Windows at present. The reason that you do not see the driver is because the installer (being 32 bit) installs the ODBC registry keys under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC instead of HKEY_LOCAL_MACHINE\SOFTWARE\ODBC. Unfortunately, even creating the registry keys in the right place doesn't work as the DM then fails to load the 32 bit psqlODBC libraries.
So it looks like we need to produce a special 64 bit build :-( What makes it worse, is that we'll need a 64 bit version of libpq and all it's supporting libraries as well.
Regards, Dave.
From: Craig [mailto:postgresql@bryden.co.za]
Sent: 11 September 2005 07:14
To: Dave Page; PostgreSQL-ODBC
Subject: Re: [ODBC] ODBC Driver on Windows 64 bitHi DaveI downloaded the latest driver before installing (psqlodbc-08_00_0102.zip).ThanksCraig----- Original Message -----From: Dave PageTo: Craig ; PostgreSQL-ODBCSent: Friday, September 09, 2005 9:46 AMSubject: Re: [ODBC] ODBC Driver on Windows 64 bit
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Craig
Sent: 08 September 2005 19:44
To: PostgreSQL-ODBC
Subject: [ODBC] ODBC Driver on Windows 64 bitHiI have installed the ODBC driver on Windows XP Professional 64bit. The installation said that it was sucessful, but I cannot see the odbc driver in the ODBC data sources administrator.Is there something that I have to do on Windows 64 bit to use the driver?Hi Craig,I don't believe 64 bit windows should require anything different, however we have had (literally) one or two reports of similar problems in the past where Windows just wouldn't play ball, despite everything being installed correctly :-(What version of the driver do you have?Regards, Dave
Hi,
I just begin to use PostGRE with ODBC on Win2000/VC++6
I arrive to this kind of things
void CODBCDlg::OnOpen()
{
CString sql;
CComptes cpt(&m_fBase);
m_fBase.Open("ODBC;DSN=KEOPS");
sql.Format("SELECT * FROM [Comptes] WHERE [Type]=1",
cpt.GetDefaultSQL());
cpt.Open(cpt.snapshot,sql,CRecordset::useBookmarks);
cpt.AddNew();
cpt.m_Type=4;
cpt.m_Etat=2;
cpt.m_Nom="DD";
cpt.m_Date_ouverture=COleDateTime::GetCurrentTime();
cpt.Update();
CDBVariant mark;
cpt.GetBookmark(mark);
cpt.Close();
m_fBase.Close();
}
The Update works, but i have an error on GetBookmark
Error 24000 : Invalid cursor state
What can I do ?
--
André THEVENIN
Hortus Technologies
<andre.thevenin@hortus.fr>
04 99 61 47 80
06 19 01 48 20
J'ai mis toute ma vie à savoir dessiner comme un enfant.
(Pablo Picasso)
Dave, what about the workaround I posted from the Microsoft ODBC newsgroup? Have you tried that? (calling C:\WINDOWS\SysWOW64\odbcad32.exe. This will bring up the ODBC Data Source Administrator with the 32-bit drivers (including Microsoft Access for those of you having trouble with that) Regards Hajo -- -------------------------------------------- Lit Window Library - Speed up GUI coding 10x http://www.litwindow.com/library?src=ml wxVisualSetup - integrate wxWidgets into Visual Studio .NET http://www.litwindow.com/Products/products.html?src=ml BugLister - Defect Tracker http://www.litwindow.com/buglister?src=ml Tips & Tricks for wxWidgets & MS Visual Studio http://www.litwindow.com/Knowhow/knowhow.html?src=ml
> -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Hajo Kirchhoff > Sent: 14 September 2005 16:35 > To: pgsql-odbc@postgresql.org > Subject: Re: [ODBC] ODBC Driver on Windows 64 bit > > Dave, > > what about the workaround I posted from the Microsoft ODBC newsgroup? > > Have you tried that? > > (calling C:\WINDOWS\SysWOW64\odbcad32.exe. This will bring > up the ODBC > Data Source Administrator with the 32-bit drivers (including > Microsoft > Access for those of you having trouble with that) Ack, yes - that does work. I saw your post but then somehow managed to run the 64 bit DM anyway!! Of course, it probably won't help for 64 bit apps though. Regards, Dave.
Andre THEVENIN a écrit:
>
> Hi,
>
> I just begin to use PostGRE with ODBC on Win2000/VC++6
>
> I arrive to this kind of things
>
> void CODBCDlg::OnOpen()
> {
> CString sql;
> CComptes cpt(&m_fBase);
> m_fBase.Open("ODBC;DSN=KEOPS");
>
> sql.Format("SELECT * FROM [Comptes] WHERE [Type]=1",
> cpt.GetDefaultSQL());
>
> cpt.Open(cpt.snapshot,sql,CRecordset::useBookmarks);
> cpt.AddNew();
> cpt.m_Type=4;
> cpt.m_Etat=2;
> cpt.m_Nom="DD";
> cpt.m_Date_ouverture=COleDateTime::GetCurrentTime();
> cpt.Update();
> CDBVariant mark;
> cpt.GetBookmark(mark);
>
> cpt.Close();
> m_fBase.Close();
> }
>
> The Update works, but i have an error on GetBookmark
> Error 24000 : Invalid cursor state
>
> What can I do ?
>
The problem appears when my table contains a field of type "serial".
Has anyone an answer ?
--
André THEVENIN
Hortus Technologies
<andre.thevenin@hortus.fr>
04 99 61 47 80
06 19 01 48 20
J'ai mis toute ma vie à savoir dessiner comme un enfant.
(Pablo Picasso)
From: Craig [mailto:postgresql@bryden.co.za]
Sent: 15 September 2005 14:16
To: Dave Page
Subject: Re: [ODBC] ODBC Driver on Windows 64 bitHi DaveThanks for all the effort. I am trying to decide if I should change my operating system to Windows XP 32bit based of this (and other driver issues). Do you have any idea if creating a 64 bit build is on the cards in the near future?
It's very unlikely (in the near future that is). The current toolset we use is still well and truly 32 bit on Windows, and even once we've worked around that (by perhaps moving to the Microsoft Compiler), we'd still need to port at least libpq from PostgreSQL, as well as find 64 bit versions of the SSL and GNU Gettext libraries - neither of which I've ever seen.
Regards, Dave.
I think the best short term chance for 64 bit postgresql on windows is the upcoming SUA, aka Interix with the beefed up posix kernel personality that is coming out with the new server. The old interix had a full gnu toolset capable of compiling postgres. The neatest part was that they made it easy to swap out intel, ms, and gcc compilers.
That being said, from what I’m hearing it may be moot because it’s probably best to run postgres as 32 bit on a 64 bit operating system performance wise.
Merlin
It's very unlikely (in the near future that is). The current toolset we use is still well and truly 32 bit on Windows, and even once we've worked around that (by perhaps moving to the Microsoft Compiler), we'd still need to port at least libpq from PostgreSQL, as well as find 64 bit versions of the SSL and GNU Gettext libraries - neither of which I've ever seen.
Regards, Dave.
From: Merlin Moncure [mailto:merlin.moncure@rcsonline.com]
Sent: 15 September 2005 14:31
To: Dave Page
Cc: pgsql-odbc@postgresql.org; Craig
Subject: RE: [ODBC] ODBC Driver on Windows 64 bitI think the best short term chance for 64 bit postgresql on windows is the upcoming SUA, aka Interix with the beefed up posix kernel personality that is coming out with the new server. The old interix had a full gnu toolset capable of compiling postgres. The neatest part was that they made it easy to swap out intel, ms, and gcc compilers.
Yeah, that might well be the best long-term solution.
That being said, from what I’m hearing it may be moot because it’s probably best to run postgres as 32 bit on a 64 bit operating system performance wise.
Oh? why's that then?
/D
> -----Original Message----- > From: Hajo Kirchhoff [mailto:mailinglists@hajo-kirchhoff.de] > Sent: 16 September 2005 08:46 > To: Dave Page > Subject: Re: [ODBC] ODBC Driver on Windows 64 bit > > Hi Dave, > > while we're mailing... Is there a FAQ on how to get involved > in the ODBC > driver development? I found two bugs in the ODBC driver > (detailed below) > and if it's not too time consuming I might want to create a patch. > What's the procedure? Nothing formal - just post the patch to the list with a good description of what it does and one of us will review it and apply if appropriate as soon as we can (or bounce it back to you if there's a problem). We try to make it as easy as possible to contribute :-) Regards, Dave