Issue with DatabaseFactory.CreateDatabase

[venkaa]

Hello friends, I have the following piece of code to call a stored procedure in SQL database: Database db = DatabaseFactory.CreateDatabase(_DatabaseInstanceName); DBCommandWrapper cmdWrapper = db.GetStoredProcCommandWrapper(spName); cmdWrapper.AddInParameter("c_WksID", DbType.Int32, c_WksID); .... In line 1 where I call the DatabaseFactory, I am not getting a good connection string to my database. If I interrogate db, in the watch window, I see that Connection String has an "error: Cannot obtain value" against it. I have lot of stored procedures wrapper in my code and everything works except this. Can someone please please help me? Thanks. -arvind

[Mr Brown Shoes]

Does the line DatabaseFactory.CreateDatabase(_DatabaseInstanceName) work elsewhere in your code? If not, is the connection string set up properly in your config file? If so, is your code able to access the config file?