470,596 Members | 1,529 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

Linked sql view changing datatype

I have an A2k mdb that uses a linked SQL 2k view. In SQL Server, the
underlying table uses datatype 'nvarchar'. When I try to view the data in
Access (SQL server works fine for the view), I get:

ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification (#0)

If I use design view to look at the linked view, I see that the 'nvarchar'
columns are now 'number'. I have deleted and re-linked the tables in
question and still get the error. There is alpha-numeric text in these
fields and am having a difficult time understanding the problem, let alone
using the table.
Thanks,

Eric J Owens
Nov 12 '05 #1
0 1831

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Neil | last post: by
8 posts views Thread by Roy J | last post: by
4 posts views Thread by PRadyut | last post: by
57 posts views Thread by Xarky | last post: by
reply views Thread by reynard.michel | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.