Re: VB 6 ADO vs Microsoft Query Analyzer
From: Greg Linwood (g_linwoodQhotmail.com)
Date: 04/26/04
- Next message: Val Mazur: "Re: Bulk Insert from SQL server to Access"
- Previous message: Maurice Boers: "VB 6 ADO vs Microsoft Query Analyzer"
- In reply to: Maurice Boers: "VB 6 ADO vs Microsoft Query Analyzer"
- Next in thread: Val Mazur: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 09:25:40 +1000
Is your VB6 app receiving an error when it doesn't perform the write? Is the
app checking for errors & notifying you? Sometimes this is simply because
the VB6 / ADO timeout setting is made too low at the connection, or command
level causing the query to "timeout"..
Regards,
Greg Linwood
SQL Server MVP
"Maurice Boers" <maurice@timbersoft.com> wrote in message
news:e6%2310D%23KEHA.3052@TK2MSFTNGP12.phx.gbl...
> Hello
>
> I have a sql update statement thats quite large with several "select
nests".
> It generally takes an hour to run when I need to effect a lot of records.
>
> In VB6 using ADO, I issue the statement and sometimes the update doesn't
> actually preform the write (I think when I get over a certain # of records
> being updated). whereas the same statement (printed my string &
copy/pasted
> in Microsoft Query Analyzer) functions just fine.
>
> Can anyone give me a hint on what ado setting may make VB preform like
query
> analyzer
>
> (I could put my nests in temp tables, but I'm curoius what the difference
in
> defaults are between the 2)
>
> Thanks
> Maurice
>
>
>
- Next message: Val Mazur: "Re: Bulk Insert from SQL server to Access"
- Previous message: Maurice Boers: "VB 6 ADO vs Microsoft Query Analyzer"
- In reply to: Maurice Boers: "VB 6 ADO vs Microsoft Query Analyzer"
- Next in thread: Val Mazur: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
