APOS Dynamic Parameters

[vgopal]

Hi

I am using a APO's to get the dynamic parameters to the reports,I am getting the param values dynamically for the sample reports developed in Access.

But when I try to access my reports developed in sqlserver I am running into an error saying
"Error -2147467259 [Microsfot][ODBC Driver Manager]Data Source name not found and no default driver specified"

I am using the Connection String as
"ConnectionString=Provider=SQLOLEDB.1;User ID=uid;Password=pwd;DataSource=servername;Database=dbname"

I am using OLEDB to connect the Reports to the database .
I physically don't see the OLEDB Driver in the ODBC driver list.

Please respond.
Ur help will be vey much appreciated.....

Thank You
Venu

 

[Turkbear]

Is it a typo or is your first " in the wrong place?

 

[vgopal]

Hi Thanks for ur response.
I just put it in double quotes.
But in the connection string part of the ADDSOURCE
I didnot used the double quotes.
please advise..