URL parameters for Access / .mdb data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

URL parameters for Access / .mdb data

I’m using an .mdb file in the meantime (before we upsize the data), and I’ve got to pass two parameters in a querystring…..for now I’m just using one in my testing. The other will be a date value. Since it’s an OLEDB datasource, the parameters have to be unnamed….at least that’s what reporting services is telling me. In my querystring, I pass the parameter value like: https://server/Reports/Pages/Report.aspx?ItemPath=%2fMig%2fTesting&?=20003 …but the report doesn’t pull any data. I can run it in the data tab of the report desginer, put in 2003, and the data does come back. Any suggestions? Thanks!