Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Data provider or other service returned an E_FAIL (Read 7675 times)
usher
YaBB Newbies
*


I Love SQL*XL

Posts: 2
Data provider or other service returned an E_FAIL
23.01.09 at 11:38:18
 
Hello all,
 
I'm a beginner in SQL*XL, when inserting multiple rows from Excel to Oracle tables using SQL*XL, I'm getting the following error message :
 
"Error: Data provider or other service returned an E_FAIL status"
 
Can somebody help me on this ?
 
Thanks,
usher
Back to top
 
 
  IP Logged
usher
YaBB Newbies
*


I Love SQL*XL

Posts: 2
Re: Issue Resolved
Reply #1 - 23.01.09 at 12:01:53
 
I found the solution : in fact, one of the inserted column exceeded the size of the oracle column of my table.
 
That's why I was getting this message.
 
Thanks,
Usher,
Back to top
 
 
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Data provider or other service returned an E_F
Reply #2 - 24.01.09 at 09:45:49
 
Glad you found the cause of the error. Not always every provider/driver gives a descriptive message when you hit a problem. It is always best to reduce your problem to a simpel scenario that works and then to build it out to what you want to do.  
 
What you also can try next time is to use a different driver. Usually OO4O gives good features and error messages. Oracle OLE DB is good too or Microsoft OLE DB for Oracle.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1