Could be that the user that you are logging in with does not have the correct default database. Just a guess.
--- Ray Hughes <[EMAIL PROTECTED]> wrote: > Hi All, > > I am having trouble connecting to a database. > > I receive " Data source UserDB could not be found." > when running my cf web > page. > > In the cf administrator, the DB connection for > USERDB verification test > passes with OK. > > This is a WINS SQL 2005 db server 4 ACCess Db > connections and one new MSSQL > connection. > > In Cf administrator I have the following: > CF Data Source Name "UsersDB" > Database "UsersDB" > Server: "Server_Name" > Username: Correct one > Password: Correct one > > In winsql I can connect to the "USERDB" DB using the > same information > and read the tables using this db tool. > > Futher I can connect to an ACCESS db and receive the > error of: > Executing Database Query. > The Microsoft Jet database engine cannot find the > input table or query > 'usersTBL'. Make sure it exists and that its name is > spelled correctly. > > Therefore I can connect to the server and to a MS > Access DB. > > This MSSQL connection was just added yesterday. > > > Could someone point in the the right direction. > > Regards > Ray > > _________________________________________________________________ > Get live scores and news about your team: Add the > Live.com Football Page > www.live.com/?addtemplate=football&icid=T001MSN30A0701 > > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.HostMySite.com > www.teksystems.com/ > _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
