I don't know if this is the problem or not but when you talk about the Dreamweaver query it is called UsersDB, with an S in it. When you talk about yours query you call it UserDB It doesn't have the S in it. Those would be different.
Dawn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Hughes Sent: Tuesday, January 16, 2007 11:01 AM To: [email protected] Subject: [DFW CFUG] DB Connection problem Update Hi All, I created, with help, a db query in Dreamweaver and it works. It is identical to the typed in query statment. When I use the Dreamweaver query it works. I then copied the complete query and used in "<cfquery" statement that I had typed. <cfquery name="Recordset2" datasource="UsersDB"> It fails with " Data source UserDB could not be found." I then use the "<cfquery" statement that Dreamweaver created with the rest of the query that I typed. It works. This then appears that there is something hidden in the Dreamweaver created <cfquery name="Recordset2" datasource="UsersDB">. Has anyone ran into htis problem before? Regards Ray >From: miguel olivarez <[EMAIL PROTECTED]> >Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing >List<[email protected]> >To: Dallas/Fort Worth ColdFusion User Group Mailing >List<[email protected]> >Subject: Re: [DFW CFUG] DB Connection problem >Date: Tue, 16 Jan 2007 08:03:36 -0800 (PST) > >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/ _________________________________________________________________ Find sales, coupons, and free shipping, all in one place! MSN Shopping Sales & Deals http://shopping.msn.com/content/shp/?ctid=198,ptnrid=176,ptnrdata=200639 _______________________________________________ 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/
