VB & Database, DAO 3.6, Jet 4, Foxpro 2.6 Database problems

DAO 3.6, Jet 4, Foxpro 2.6 Database problems

Author	Message
Chris Bra #1 / 5	DAO 3.6, Jet 4, Foxpro 2.6 Database problems Currently trying to open a Foxpro 2.6 database with DAO 3.6 and Jet 4 (Office 2000) and I keep getting Error 3170 Cannot find installable ISAM. Where can I get an installable ISAM, I have installed the latest MDAC_TYP and this hasnt helped, I have re-installed Visual Basic, Access 2000, And Foxpro 6 but all to no avail Here is my code Dim db As DAO.Database Set db = OpenDatabase("C:\FoxDb\", False, False, "Foxpro 2.6;") . . . And I never get here ! Please Help as I'm loosing large chunks of hair over this ! -- Thanks In Advance... Chris Bray, Software Engineer Key Systems Geotechnical, Redditch, UK. Sent via Deja.com http://www.--*.com/ Before you buy.
Fri, 24 May 2002 03:00:00 GMT

Jim in Clevelan #2 / 5	DAO 3.6, Jet 4, Foxpro 2.6 Database problems Quote: > Currently trying to open a Foxpro 2.6 database with DAO 3.6 and Jet 4 > (Office 2000) and I keep getting Error 3170 Cannot find installable > ISAM. Where can I get an installable ISAM, I have installed the latest > MDAC_TYP and this hasnt helped, I have re-installed Visual Basic, > Access 2000, And Foxpro 6 but all to no avail > Here is my code > Dim db As DAO.Database > Set db = OpenDatabase("C:\FoxDb\", False, False, "Foxpro 2.6;") > . > . > . > And I never get here ! I have not yet experienced the joys of updating to DAO 3.6/Access 2000. However, I looked at the MS web site and found two relevant articles: http://msdn.microsoft.com/isapi/msdnlib.idc?theURL=/library/devprods/... (This reference does not include FoxPro when listing DAO 3.6 Connect syntax, as there was in DAO 3.51) http://support.microsoft.com/support/kb/articles/Q225/0/48.ASP Quote: "The third issue is that Jet 4.0 drops support for the FoxPro IISAM. Any FoxPro tables must be accessed through the FoxPro ODBC driver. If your Jet database uses linked FoxPro tables, and you convert to Jet 4.0, you will have to re-link them to use the FoxPro ODBC driver instead." ...so it sounds like you can't use the old DAO 3.51 syntax to OpenDatabase on FoxPro with DAO 3.6 Jet4; switch to ODBC instead. Or go the ADO route, which has worked for me with Foxpro in VB 6 (SP3) Good luck! -- Jim in Cleveland If you're writing to me, in my address change "REAL_Address.see.below" to "worldnet.att.net" "What's so funny 'bout peace, love & understanding?" - Nick Lowe
Fri, 24 May 2002 03:00:00 GMT

Chris Bra #3 / 5	DAO 3.6, Jet 4, Foxpro 2.6 Database problems Thanks Jim I thought this was going to be the answer, I have no experience using the Foxpro ODBC driver and dont even know where to start !! ADO would not be a problem if I were doing a complete re-code but the whole of my application uses DAO all the way thru and there's a lot to re-write, especially as I have only ever used ADO in C++ Cheers Chris... Quote: > > Currently trying to open a Foxpro 2.6 database with DAO 3.6 and Jet 4 > > (Office 2000) and I keep getting Error 3170 Cannot find installable > > ISAM. Where can I get an installable ISAM, I have installed the latest > > MDAC_TYP and this hasnt helped, I have re-installed Visual Basic, > > Access 2000, And Foxpro 6 but all to no avail > > Here is my code > > Dim db As DAO.Database > > Set db = OpenDatabase("C:\FoxDb\", False, False, "Foxpro 2.6;") > > . > > . > > . > > And I never get here ! > I have not yet experienced the joys of updating to DAO 3.6/Access > 2000. However, I looked at the MS web site and found two relevant > articles: > http://msdn.microsoft.com/isapi/msdnlib.idc? theURL=/library/devprods/vs6/vbasic/dao360/daproconnect.htm - Hide quoted text - - Show quoted text - Quote: > (This reference does not include FoxPro when listing DAO 3.6 Connect > syntax, as there was in DAO 3.51) > http://support.microsoft.com/support/kb/articles/Q225/0/48.ASP > Quote: "The third issue is that Jet 4.0 drops support for the FoxPro > IISAM. Any FoxPro tables must be accessed through the FoxPro ODBC > driver. If your Jet database uses linked FoxPro tables, and you convert > to Jet 4.0, you will have to re-link them to use the FoxPro ODBC driver > instead." > ...so it sounds like you can't use the old DAO 3.51 syntax to > OpenDatabase on FoxPro with DAO 3.6 Jet4; switch to ODBC instead. Or > go the ADO route, which has worked for me with Foxpro in VB 6 (SP3) > Good luck! > -- > Jim in Cleveland > If you're writing to me, in my address > change "REAL_Address.see.below" to "worldnet.att.net" > "What's so funny 'bout peace, love & understanding?" > - Nick Lowe -- Thanks In Advance... Chris Bray, Software Engineer Key Systems Geotechnical, Redditch, UK. Sent via Deja.com http://www.deja.com/ Before you buy.
Sat, 25 May 2002 03:00:00 GMT

croft #4 / 5	DAO 3.6, Jet 4, Foxpro 2.6 Database problems try moving back to Access 95/97. it maybe quicker then learning ADO, as this could be time consumming. time is important on these times of jobs :) MARK * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!
Tue, 04 Jun 2002 03:00:00 GMT

Page 1 of 1

[ 5 post ]