What causes a 'Parameter Information cannot be derived from SQL statements with sub-select queries' error?
From: Bill N (billnielsen_at_hotmail.com)
Date: 06/29/04
- Next message: Sydney Lotterby: "How to get ID field from inserted table in a join using BetterADO"
- Previous message: simon dot burrows at staffplan dot co dot uk: ""No such system DSN as x""
- Next in thread: Brian Bushay TeamB: "Re: What causes a 'Parameter Information cannot be derived from SQL statements with sub-select queries' error?"
- Reply: Brian Bushay TeamB: "Re: What causes a 'Parameter Information cannot be derived from SQL statements with sub-select queries' error?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Jun 2004 09:10:12 -0400
I get this error from one of my customers but I can't seem to duplicate it
here. What causes this error?
******ADO Errors*******
*Error Number: -2147467259 *
*Source: Microsoft OLE DB Provider for SQL Server
*Description: Parameter Information cannot be derived from SQL
statements with sub-select queries. Set parameter information
before preparing command.
*Native Error: 0
*SQL State : 42000
***********************
Thanks,
Bill N
- Next message: Sydney Lotterby: "How to get ID field from inserted table in a join using BetterADO"
- Previous message: simon dot burrows at staffplan dot co dot uk: ""No such system DSN as x""
- Next in thread: Brian Bushay TeamB: "Re: What causes a 'Parameter Information cannot be derived from SQL statements with sub-select queries' error?"
- Reply: Brian Bushay TeamB: "Re: What causes a 'Parameter Information cannot be derived from SQL statements with sub-select queries' error?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
