Data provider or other service returned an E_FAIL status."

  • Thread starter Marini Celestino
  • Start date

M

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?
 
Ad

Advertisements

C

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
 
B

BJ Freeman

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

Advertisements

J

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
 
Ad

Advertisements

Joined
Jan 18, 2010
Messages
1
Reaction score
0
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..

 

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

Top