Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Business Layer Generator error in case sensitive SQL ser
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01244313
Message ID:
01244766
Views:
12
Rusli,

>I encounter a problem that suspiciously due to my SQL server is case sensitive. The error stack is very long, I cannot find the log file (where is it anyway?), so I will higlight it:
>a. Error: Invalid Column Name : CDEFAULT, Invalid Column Text.
>b. I think the error originated in OakLeaf.Main.Data.mmData.GetStoredProcedureParameter line 950 which has a SQL select into the backend server with param.CDEFAULT (CDEFAULT all capital.)
>c. If I choose NOT to create Data Access Layer, then the error won't happen.
>d. I chose "Use dynamic SQL statements"
>e. The error also happen if you click "View SQL Script" button which visible if you choose "Create New Procedure" in "Generate Data Access Layer" step.
>
>Any suggestions how to handle this problem? I dare not rebuild the BLG. :) I cannot change my SQL Server to case insensitive either, my customer required it.

I made a hot fix to MM .NET 2.4 that addresses this problem. Just use your previous download credentials to download this hot-fixed version (if you don't still have them, send me a private e-mail).

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform