[windev] MFC - JET - ODBC and Vista x64

[Weston]

The problem in this case is MS-JET (ie Access) only has a 32 bit ODBC drive=
r under a 64 bit OS... A later version of Access may include a 64 bit drive=
r but until that is done you are stuck using the 32 ODBC driver.

I know there is an ODBC API for creating Data Source connection programmati=
cally, However, I would guess that this would use the default ODBC admin (6=
4 bit in your case) and not work since it wouldn't be able to find the driv=
er.  Once you setup the Data Source in the 32 ODBC admin, it works like nor=
mal... =


  ----- Original Message ----- =

  From: truckleaj-windev at yahoo.co.uk =

  To: Weston =

  Sent: Friday, May 08, 2009 2:24 AM
  Subject: Re: [windev] MFC - JET - ODBC and Vista x64


  Yes, I thought this might be so. But does this mean that the USER has to =
create a data source? And then my program has to use a different connector =
string?

  Andrew




---------------------------------------------------------------------------=
---
  From: Weston <wfryatt at mlinks.net>
  To: truckleaj-windev at yahoo.co.uk; windev at windev.org
  Sent: Friday, 8 May, 2009 8:14:20
  Subject: Re: [windev] MFC - JET - ODBC and Vista x64

  I ran into the same problem a while back with MySQL and Vista 64 bit... T=
he solution to the problem is you have to use the 32 bit ODBC Data Source A=
dministrator... Found in the following path:

    C:\Windows\SysWOW64\odbcad32.exe

  ----- Original Message ----- From: <truckleaj-windev at yahoo.co.uk>
  To: <windev at windev.org>
  Sent: Friday, May 08, 2009 1:46 AM
  Subject: [windev] MFC - JET - ODBC and Vista x64


  > Hello
  > =

  > I am encountering problems with potential Vista x64 users trying to run=
 my 32bit app. I has a connection to a MDB file and uses a very simple conn=
ection string. But on the x64 computers it says no driver can be found.
  > =

  > But I did find this:
  > =

  > http://msmvps.com/blogs/spywaresucks/archive/2007/05/11/897398.aspx
  > =

  > It sounds to me that the user would have to create a connection to the =
database somehow and then I have to modify my connection string parameters.=
 But I am really not sure and this is not ideal as I want my app to run "ou=
t of the box".
  > =

  > Can anyone please provide me some guidance with this matter?
  > =

  > Thank you.
  > =

  > Andrew
  > -------------- next part --------------
  > An HTML attachment was scrubbed...
  > URL: http://lists.windev.org/pipermail/windev/attachments/20090508/be8c=
4f49/attachment.htm
  > -- Windev mailing list at Windev at windev.org
  > =

  > Lost your password?  Need to unsubscribe or change your delivery option=
s?
  > Go to http://lists.windev.org/mailman/listinfo/windev
  > --
  > Search the Windev Archives - www.windev.org =



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.windev.org/pipermail/windev/attachments/20090508/48a5f7e9=
/attachment.htm