c_fusion
Posts: 2
|
| Posted: 12/10/2007, 7:07 AM |
|
My codecharge ColdFusion app was working with MS Access. Then, I upgraded to SQL. Now it's not working and I get the following error:
500 Operation failed on the data source named "INT5D".
Interesting is that INT5D is not even close to the name of the datasource. I tried confirming the actual data source through a simple cfm open query test.
HELP!!!
Thanks.
|
 |
 |
Oper
Posts: 1195
|
| Posted: 12/10/2007, 10:56 AM |
|
is design Working OK with the SQL database?
when you changed the Deisgn Conection to SQL, did you change the Server COnection as Well?
did you recreate the full project?
any idea what INT5D may be?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
DonB
|
| Posted: 12/10/2007, 11:09 AM |
|
'5D' is the hex value of the ']' character Maybe you have Access
column/field names delimited by [x yz] because the names contain spaces?
Quite popssible if you have used Access querydefs in the construction of
complex queries. Those won't run without transforming them into more
standard SQL syntax (correlated subselects, for example). Access is notable
for it's lax adherence to ANSI SQL standards.
--
DonB
http://ccswiki.gotodon.net
"c_fusion" <c_fusion@forum.codecharge> wrote in message
news:2475d56224f583@news.codecharge.com...
> My codecharge ColdFusion app was working with MS Access. Then, I upgraded
to
> SQL. Now it's not working and I get the following error:
>
> 500 Operation failed on the data source named "INT5D".
>
> Interesting is that INT5D is not even close to the name of the datasource.
I
> tried confirming the actual data source through a simple cfm open query
test.
>
> HELP!!!
>
> Thanks.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
|
