File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes OLE DB provider 'SQLOLEDB' reported an error. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OLE DB provider Watch "OLE DB provider New topic
Author

OLE DB provider 'SQLOLEDB' reported an error.

Jet Ink
Greenhorn

Joined: Feb 06, 2002
Posts: 3
Hi,
I use MS SQL Server 2K and jnetdirector as the JDBC driver for Java servlets application in JRun3.1 build 26414. Sometimes I got the following error,
[java.sql.BatchUpdateException: com.jnetdirect.jsql.u: OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.]
java.sql.BatchUpdateException: com.jnetdirect.jsql.u: OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.
at com.jnetdirect.jsql.ae.executeBatch(Unknown Source)
I was told it is not JDBC layer issue but ODBC one. There are two SQL servers are linked under NT4 SP6 to implement batched distributed query.
Someone told me that memory should be the issue, but 4GB should be enough.
Maybe someone has the same error as I got here. Your hints will be highly appreciated!
Thanks,
Jet
 
 
subject: OLE DB provider 'SQLOLEDB' reported an error.
 
Similar Threads
Help needed on SQL Server Error
Saving a jpeg to MS Access
JBoss 4.0 and MSSQL Server 2000
Using Javascript ADODB.Connection to connect MS Sql Server DB?
no sqljdbc_auth in java.library.path