my dog learned polymorphism*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
no sqljdbc_auth in java.library.path
Saving a jpeg to MS Access
Using Javascript ADODB.Connection to connect MS Sql Server DB?
Help needed on SQL Server Error
JBoss 4.0 and MSSQL Server 2000