I think your application variable is fine as the error message is suggesting that the database that you are trying to connect to is 'invalid or not running'. So that suggests to me that CF *has* a dsn name that it is happy with but is then failing to connect to said database...
But I have no idea why it would be causing you a problem just for bot sessions? Maybe you have some special code in place for bots that is affecting this? Cheers, Brett B) Taco Fleur wrote: > I keep getting the following error in my logs > > DataSource dsn_au_com_clickfind > Detail [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC > Driver]The requested instance is either invalid or not running. > ErrorCode 08001 > Message Error Executing Database Query. > > > However, only for bots like Yahoo and Google etc. the error gets called > from the onSessionStart > one of the objects the onSessionStart creates makes a db request, the > cfquery uses the following dsn > #application.client.Datasource.getName()# > > the only thing I can think of is that the application variable is empty > for bots, but I don't see how that is possible, anyone any ideas? > > Cheers > > -- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: http://www.yoursite.net.au --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
