why am i prompted for the odbc connection? 1

[sedgely]

i have created 2 pass thru' queries as below, both work fine but the second propmts for the connection everytime it is run, they both use the same connection and everything else seems the same. has anyone any ideas?

passthru 1:

SET DATEFORMAT DMY EXEC sp_exception_CatBAll '01/08/2005','01/08/2005'

passthru 2:

SET DATEFORMAT DMY EXEC sp_YAS_ExcessTurnRoundByHospital '03/07/06','09/07/06'

Cheers, Craig
Si fractum non sit, noli id reficere

 

[lameid]

Try checking the odbc Connect string property of each query. In design view select the view menu and then properties. Chances are the second is different from the first. I would also expect specifying the connect string and then saving the query to fix it assuming you are using a FILE DSN (Machine DSN's work but a File DSN will force the whole connect sctring in instead of referencing the DSN).

 

[sedgely]

thanks for that, you were correct - the second query didn't have the connect string in at all! thats sorted now. Have a shiny thing.

Cheers, Craig
Si fractum non sit, noli id reficere