I've used DBISAM for years in the XP world...and I have finally moved to Windows 7, 64 Bit, but now my applications no longer work...I figure I have to change something...

What I have always done is build the Registry Settings:

ODBCINST.INI
 ClassBuilder Driver
      Driver = {full path}\dbodbc.dll


My Visual Studio Code then connections to the Driver like this:

dbConn = new OdbcConnection("Driver={ClassBuilder Driver};ConnectionType=Local;CatalogName="
      + WorkAppPath.AppPath + "\\Database;PrivateDirectory="
      + WorkAppPath.AppPath + "\\Database\\Temp;");


I get an error saying that the driver cannot be opened...and it returns (I dont have it on hand at work) that its trying to open the driver as if it is a 64 bit driver instead of a 32 bit driver...From Google.

If I use the ODBC Driver app (odbcad32.exe) in Windows 7, I believe it was in the from the SysWOW64...Then I can see my DBISAM ODBC Driver (ClassBuilder Drriver) linking it to the DBISAM Driver

Which DSN do I want to create? User DSN, System DSN, File DSN ??

And then  what is the code change to point my connection Object to the DSN?   
Something like:

dbConn = new  OdbcConnection("DSN = ClassBuilder Driver");

??
Pete Hollyer

Okay...well I did my usual...look and look...not figure it out...then post a Help message (above)...and then solve my problem...

I'll test these out tonight on my new PC...let you know if these dont fix the issue on the 64 Win 7 box...but I suspect it will...


Below are my answers....

//System DSN Connection
//dbConn = new OdbcConnection("DSN=HOLLYER Driver");

//File DSN This works Too!
//dbConn = new OdbcConnection("FILEDSN=c:\\Program Files\\Common Files\\ODBC\\Data sources\\HOLLYER DRIVER.dsn");

//This Works Too System DSN
//dbConn = new OdbcConnection("DSN=HOLLYER Driver;ConnectionType=Local;CatalogName="
//        + WorkAppPath.AppPath + "\\Database;PrivateDirectory="
//        + WorkAppPath.AppPath + "\\Database\\Temp;");

Peter,

<< Okay...well I did my usual...look and look...not figure it out...then
post a Help message (above)...and then solve my problem... >>



The main issue with 64-bit is detailed here:

http://www.elevatesoft.com/supportfaq?action=view&category=dbisam&question=odbc_driver_64_bit

As long as you make sure to set up the DSN properly using the 32-bit ODBC
Administrator, you should be good.

--
Tim Young
Elevate Software
www.elevatesoft.com