Data provider or other service returned an E_FAIL status."

[Marini Celestino]

I receive this message "Data provider or other service
returned an E_FAIL status" when i try to read a table in a
Access project, linked to SQL Server.
Who can Help me?

 

[BJ Freeman]

are you using MDB or ADP.

 

[celestino.marini]

i use ADP

-----Messaggio originale---
are you using MDB or ADP.




.

 

[Bose-Einstein statistics]

Check user's right in DB

i use ADP

 

[cele]

i tried with few SQL Server (personal, on server) but the
problem is the same.
i see the tables in the project, i see the structure but
not the data

 

[BJ Freeman]

check the File->connection and test the connection.
also see which dbconn you are using

 

[Jacek Segit]

Witaj BJ,
W Twoim li¶cie datowanym 8 maja 2004 (22:50:05) mo¿na przeczytaæ:

check the File->>connection and test the connection.
BF> also see which dbconn you are using

And install the latest MDAC (2.8?)

Regards
Jacek Segit

 

[vahid]

hjj;p'';
p[iio]
p

 

[EMEsguerra]

Data Provider or other service returned an E_FAIL Status

If you are using VB6 and SQL as back end database,

This error if occurs in your program, I find this best solution that might help you!..

* change the length of the data field which will have a much higher storage like for instance:

- you are updating the Address Field with a varchar data type then if ever you just set only the default such as 50 as length, and when you encoded more that 50, then it will return this error
- by adding more length to that field, will resolve the error..