Re: internal ole automation error

Baroc (Baroc@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
In a perfectly working application, i have a situation on one computer
(windows xp - sp2).

At one location where i create a datatable based on a query:
SELECT * from table where Field Like 'a%'
fails. The error is "Internal ole automation error"

Out of 15 computers and different OS i tried, this one machine is the only
one where i get this error.

Not that it is likely that I know the answer, but couldn't you at least
tell what database you are using? Oracle? Access? SQL Server? And more
exactly how is your call packaged? ADO? OleDb Client? OleDb Consumer
Templates?


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Very slow query
    ... with lots if information in Books Online, Books, Courses, the Net etc. ... While testing the query in QA, use the "Show Estimated Query Plan" feature. ... This is what I suggest you also pick up using Profiler. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Many to one Select
    ... It still possible to define a query that has maximum of columns needed, ... INSERT statements with sample data. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: timezones in select statement
    ... > end, in the sense that I don't want it to be pulled back in the query, ... INSERT statements with sample data. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: datetime diff query syntax
    ... I'm trying to make a query that will allow ... seconds of any of the entries in the second ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: waittype=WRITELOG
    ... This long-running query, ... do you perceive any real performance problems? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)