By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,221 Members | 1,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,221 IT Pros & Developers. It's quick & easy.

Linked sql view changing datatype

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.