Invalid Character Value for Cast Conversion in Access Linked View

In MS Access, a SQL Server 2008 view linked as a table, when opened offers:

[Microsoft][SQL Server Native Client 10.0]
Invalid Character Value for Cast Specification(#0)

Upon exam, opened view in SSMS and found that the view had several columns with incorrect aliases. Aliases that in fact I had not given at all. The View Designer seems to have added them when I added a third table to the view.

They were not even close to right, and each invalid column had the PREVIOUS Column’s name as it’s alias (all shifted up one position).

Thus, I had:

Name Alias
Col1 Col2
Col2 col3
Col3 col4
Col4 col5
Col5 col6
Col6

Furthermore, it was necessary only to fix the view. The link did not have to be recreated. Once the view was fixed, the existing link in Access opened just fine.

Advertisements

About combatdba

I'm a production DBA at a terabyte-class SQL Server Shop
This entry was posted in S.W.A.T.. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s