learn java
The moose likes JDBC and Relational Databases 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 The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: OLE DB provider 'SQLOLEDB' reported an error.