invalid SQL SErver Driver, ODBC call failed on tables on the Serve

J

Janis

I can open an Access database on terminal services. This database is a
frontend to SQL Server. I can open most of the tables with the World icon
on the server however there are a few of them I can't open. When I open
them I get two messages.
1. ODBC SQL Server Driver Invalid character value for Cast specification.
2. ODBC call failed-- SQL Server driver restricted date type attribute.

Is there something I can do to be able to view these tables also? Is #2
related to something to do with permissions on this database? Is #2 related
to the SQL driver on my computer. I have both SQL Express and MSDE on this
computer and I'm not sure which one it is accessing.

tia,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
ODBC--call failed. 3
Total parameter query and ODBC-call failed 0
TransferSpreadsheet method question 2
importing from SQL Server 2008 Express 0
ODBC Failure, error 18456 1
ODBC SQL Error Bulk Insert - Null values 1
Linking Tables to SQL Server Issue 2

Top