ODBC -- call failed. Invalid character value for cast specification(#0)
I have created a SQL view that works. However, I have linked the SQL view to Access and when I try to open the view in access I get this error. ODBC--call failed Microsoft ODBC SQL Server Driver Invalid character value for cast speicification (#0).
This did work at one time. Not sure what has happened, and why it isn't opening now. I have tried to relink, and refresh the link. Any suggestions?
This did work at one time. Not sure what has happened, and why it isn't opening now. I have tried to relink, and refresh the link. Any suggestions?
Last Comment
CCongdon
Can you show the SQL for the view?
ASKER
CREATE VIEW dbo.AllCombinations_vw
AS
SELECT dbo.CW_tblClaimsDocumentPa
dbo.CW_tblMPlanType.*, dbo.CW_tblBeneLevel.BeneLe
dbo.CW_tblClaimLevel.Claim
FROM dbo.CW_tblMIRSKEY CROSS JOIN
dbo.CW_tblMJSlife CROSS JOIN
dbo.CW_tblMPlanType CROSS JOIN
dbo.CW_tblSystem CROSS JOIN
dbo.CW_tblType CROSS JOIN
dbo.CW_tblStates CROSS JOIN
dbo.CW_tblBeneLevel CROSS JOIN
dbo.CW_tblClaimLevel CROSS JOIN
dbo.CW_tblBeneficiary CROSS JOIN
dbo.CW_tblClaimsDocumentPa
AS
SELECT dbo.CW_tblClaimsDocumentPa
dbo.CW_tblMPlanType.*, dbo.CW_tblBeneLevel.BeneLe
dbo.CW_tblClaimLevel.Claim
FROM dbo.CW_tblMIRSKEY CROSS JOIN
dbo.CW_tblMJSlife CROSS JOIN
dbo.CW_tblMPlanType CROSS JOIN
dbo.CW_tblSystem CROSS JOIN
dbo.CW_tblType CROSS JOIN
dbo.CW_tblStates CROSS JOIN
dbo.CW_tblBeneLevel CROSS JOIN
dbo.CW_tblClaimLevel CROSS JOIN
dbo.CW_tblBeneficiary CROSS JOIN
dbo.CW_tblClaimsDocumentPa
CREATE VIEW dbo.AllCombinations_vw
AS
--------------------------
Remove code above -- keep below
--------------------------
SELECT dbo.CW_tblClaimsDocumentPa
dbo.CW_tblMPlanType.*, dbo.CW_tblBeneLevel.BeneLe
dbo.CW_tblClaimLevel.Claim
FROM dbo.CW_tblMIRSKEY CROSS JOIN
dbo.CW_tblMJSlife CROSS JOIN
dbo.CW_tblMPlanType CROSS JOIN
dbo.CW_tblSystem CROSS JOIN
dbo.CW_tblType CROSS JOIN
dbo.CW_tblStates CROSS JOIN
dbo.CW_tblBeneLevel CROSS JOIN
dbo.CW_tblClaimLevel CROSS JOIN
dbo.CW_tblBeneficiary CROSS JOIN
dbo.CW_tblClaimsDocumentPa
--------------------------
By very nature, in access you already have a view. Create view is not necessary as you are doing it manually.
AS
--------------------------
Remove code above -- keep below
--------------------------
SELECT dbo.CW_tblClaimsDocumentPa
dbo.CW_tblMPlanType.*, dbo.CW_tblBeneLevel.BeneLe
dbo.CW_tblClaimLevel.Claim
FROM dbo.CW_tblMIRSKEY CROSS JOIN
dbo.CW_tblMJSlife CROSS JOIN
dbo.CW_tblMPlanType CROSS JOIN
dbo.CW_tblSystem CROSS JOIN
dbo.CW_tblType CROSS JOIN
dbo.CW_tblStates CROSS JOIN
dbo.CW_tblBeneLevel CROSS JOIN
dbo.CW_tblClaimLevel CROSS JOIN
dbo.CW_tblBeneficiary CROSS JOIN
dbo.CW_tblClaimsDocumentPa
--------------------------
By very nature, in access you already have a view. Create view is not necessary as you are doing it manually.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
