Getting Error: Item cannot be found in the collection corresponding to the requested

Old Pedant · January 14th, 2009, 07:15 PM

QUESTION:

Is there a reason you do
Conn.open "Provider=sqloledb;Server=myserver;Initial Catalog=qdb;UID=Reports;PWD=;"

That is, you start off in database "qdb" and then you have to do the "use msdb" to change to the other database???

Why not just use

Conn.open "Provider=sqloledb;Server=myserver;Initial Catalog=msdb;UID=Reports;PWD=;"

Then you can omit the "use msdb" completely.

???

dalezjc · January 16th, 2009, 10:38 AM

Quote:

Originally Posted by Old Pedant

QUESTION:

Is there a reason you do
Conn.open "Provider=sqloledb;Server=myserver;Initial Catalog=qdb;UID=Reports;PWD=;"

No, I just overlooked that piece of code. But that was the problem.

Thanks so much for all your help. I do appreciate it!

Dale