Question
Cold Fusion with Paradox tables
I didn't know where to ask this, so I will post it here.
I have been using Cold Fusion for 4-5 years with Paradox tables. The site has gotten more and more complex. The site is hosted somewhere else and I don't have any control over their software or drivers.
To the point, today the web host contacted me and complained that I messed something up that is crashing the Cold Fusion server. That it has to do with my access to Paradox tables, which they absolutely DO NOT recommend.
I know they are using the MS ODBC driver, which I also know bites. I can't convince them to purchase a driver and I don't think if they were even allowed (licensing) to install the driver that is provided with Paradox, that they would.
This is a sample error that there are hundreds like in the log files:
"Error","1120","01/17/07","17:22:14",,"ODBC Error Code =
S1000 (General error)<P> [Microsoft][ODBC Paradox Driver]
Reserved error (-5016); there is no message for this error.<P><P>
SQL = ""SELECT ID, Name, RegNo, SNo, BrandNo, Sx, Color,
DOB, BW, Date_Weigh, Weight, Date_Meas, Length FROM
main WHERE (RegNo='T-66374');"" "
My host is going to dump me if I can't clear this up. Not a lot of the Cold Fusion folks are using Paradox, so I don't no how much help I can get with this issue.
I see my options as the following:
1. Switch to SQL tables which will work much better with CF.
2. Switch to Access
3. Switch hosts
4. Get the host to install the BDE and ODBC from a Paradox disk
Comments on choices:
#1 is do-able, but I have an application that uses Paradox tables and I query the tables and upload a subset of data very frequently. How could I get local Paradox tables updated to a remote SQL server?
#2 Not really an option - I don't like Access at all.
#3 Will I find better support for this combination somewhere else? Can someone here recommend a place?
#4 What are the license implications if I could even get them to install BDE and ODBC on their server?
Thanks,
Kirk
I have been using Cold Fusion for 4-5 years with Paradox tables. The site has gotten more and more complex. The site is hosted somewhere else and I don't have any control over their software or drivers.
To the point, today the web host contacted me and complained that I messed something up that is crashing the Cold Fusion server. That it has to do with my access to Paradox tables, which they absolutely DO NOT recommend.
I know they are using the MS ODBC driver, which I also know bites. I can't convince them to purchase a driver and I don't think if they were even allowed (licensing) to install the driver that is provided with Paradox, that they would.
This is a sample error that there are hundreds like in the log files:
"Error","1120","01/17/07","17:22:14",,"ODBC Error Code =
S1000 (General error)<P> [Microsoft][ODBC Paradox Driver]
Reserved error (-5016); there is no message for this error.<P><P>
SQL = ""SELECT ID, Name, RegNo, SNo, BrandNo, Sx, Color,
DOB, BW, Date_Weigh, Weight, Date_Meas, Length FROM
main WHERE (RegNo='T-66374');"" "
My host is going to dump me if I can't clear this up. Not a lot of the Cold Fusion folks are using Paradox, so I don't no how much help I can get with this issue.
I see my options as the following:
1. Switch to SQL tables which will work much better with CF.
2. Switch to Access
3. Switch hosts
4. Get the host to install the BDE and ODBC from a Paradox disk
Comments on choices:
#1 is do-able, but I have an application that uses Paradox tables and I query the tables and upload a subset of data very frequently. How could I get local Paradox tables updated to a remote SQL server?
#2 Not really an option - I don't like Access at all.
#3 Will I find better support for this combination somewhere else? Can someone here recommend a place?
#4 What are the license implications if I could even get them to install BDE and ODBC on their server?
Thanks,
Kirk
AdChoices