Delphi 6 OLEDB Question

The string that we create for our connection object is as follows:

'Provider=SQLOLEDB.1;Persist Security Info=True;Data
Source=SQLSERVER;Initial Catalog=VMI;User ID=user;Password=password'

What get's sent to SQL Server is the following:

'Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User
ID=user;Initial Catalog=VMI;Data Source=CC-PF-DEV;Use Procedure for
Prepare=1;Auto Translate=True;Packet Size=4096;Workstation
ID=CC-PF-DEV;Use Encryption for Data=False;Tag with column collation
when possible=False

How do I get the Use Procedure for Prepare set to 0, so it doesn't use
temp. stored procs?

We are having some very strange results when queries are run from the
app versus when they are run from SQL Query Analyzer, for example a
query from the app makes 2 Million Page reads, but when run from Query
Analyzer it only takes 2000 page reads. Most of the queries and stored
procs are very complex, so our entire system is slowing to a halt.

Any help would be greatly appreciated and thanks in advance.

.

Relevant Pages

  • Re: Large XML file opinions
    ... > have an app that will need to Query (read only operations is all I'll ever ... > I am wondering if I shouldn't just create a table in SQL server, ... > a routine that dumps the XML file's values into corresponding SQL server ...
    (microsoft.public.dotnet.xml)
  • Going Nuts!
    ... Object Explorer (MS SQL Server Management Studio Express), ... to do a query using the query text editor, only two of the tables showed up. ... In my app, the connection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Mail merge with Word 2003 and SQL 2005 on a date and time field.
    ... If you want to query the SQL Server database directly, your best bet is probably to create a view that returns the date in either text format, e.g. '20070611' or numeric format, e.g. 20070611, and let the user select from those dates instead. ... the data to SQL and still use Access as a front end for this app. ... query to pull all records. ...
    (microsoft.public.word.mailmerge.fields)
  • Delphi 6 OLEDB Question
    ... What get's sent to SQL Server is the following: ... query from the app makes 2 Million Page reads, ...
    (borland.public.delphi.database.ado)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)