Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

APOS Dynamic Parameters

Status
Not open for further replies.

vgopal

IS-IT--Management
Aug 18, 2003
9
US
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
 
Is it a typo or is your first " in the wrong place?

[profile]
 
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..

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top