Prev: CLR integration gotchas!
Next: Eliminate #tmp table to single SQL Select statement
From: Navin on 12 Feb 2010 05:54
Creadted ODBC datasource provided DSN name able to fetch fields. But I want
to use Parameter in my query as long as i use the folowing query its fine.

select [Manager Name] from [Manager$] where [Manager Name]=1


when I implement

select [Manager Name] from [Manager$] where [Manager Name]=@Manager gives me
the following error.

An error occurred while executing the query.
ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.
(Microsoft Report Designer)

===================================

ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.
(odbcjt32.dll)

How can I over come the above eroor and use named parmaeter and fetch
required data from excel datasource.


From: Navin on 12 Feb 2010 07:24
Using following parameter resolved the issue, but how do we address the issue
when its mutiple value parameter
select [Manager Name] from [Manager$] where [Manager Name]=?


i need solution for
select [Manager Name] from [Manager$] where [Manager Name]in(?) gets error

"Navin" wrote:

> Creadted ODBC datasource provided DSN name able to fetch fields. But I want
> to use Parameter in my query as long as i use the folowing query its fine.
>
> select [Manager Name] from [Manager$] where [Manager Name]=1
>
>
> when I implement
>
> select [Manager Name] from [Manager$] where [Manager Name]=@Manager gives me
> the following error.
>
> An error occurred while executing the query.
> ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.
> (Microsoft Report Designer)
>
> ===================================
>
> ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.
> (odbcjt32.dll)
>
> How can I over come the above eroor and use named parmaeter and fetch
> required data from excel datasource.
>
>
 | 
Pages: 1
Prev: CLR integration gotchas!
Next: Eliminate #tmp table to single SQL Select statement