Hello
I'm desperate for some help with this one guys.
we have an old training database called registrar which uses foxpro tables. we have been using the odbc which gets installed with it. It is the old odbc driver that is no longer suported.
we have been running assessments which update and insert records into the fp tables.
out of the blue we started getting the "can't find installable isam" error rebuilt the server three times now, it works for a while and then the error starts again.
so firstly if anyone know's a way around that, that would be the easiest solution for me.
since then, i tried using the VFP odbc driver, this works except for when i'm trying to insert dates from an ASp page with SQL.
here's the statement:
mySQL = "INSERT INTO PLAN (DUE, EARLIEST, USER_ID, UPDATED, XUNIQUEKEY, XCODE) VALUES (#"& DueDate &"#, #"& DueDate &"#, 'PREG', #"& transdate &"#, '123456', 'VR116' );"
then i get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Visual FoxPro Driver]Syntax error
I can insert everything else except the dates
it used to work with the old driver as well
any help welcome
kind regards
Matt uk
I'm desperate for some help with this one guys.
we have an old training database called registrar which uses foxpro tables. we have been using the odbc which gets installed with it. It is the old odbc driver that is no longer suported.
we have been running assessments which update and insert records into the fp tables.
out of the blue we started getting the "can't find installable isam" error rebuilt the server three times now, it works for a while and then the error starts again.
so firstly if anyone know's a way around that, that would be the easiest solution for me.
since then, i tried using the VFP odbc driver, this works except for when i'm trying to insert dates from an ASp page with SQL.
here's the statement:
mySQL = "INSERT INTO PLAN (DUE, EARLIEST, USER_ID, UPDATED, XUNIQUEKEY, XCODE) VALUES (#"& DueDate &"#, #"& DueDate &"#, 'PREG', #"& transdate &"#, '123456', 'VR116' );"
then i get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Visual FoxPro Driver]Syntax error
I can insert everything else except the dates
it used to work with the old driver as well
any help welcome
kind regards
Matt uk