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/
