Hi All,
For me being an old poor BLIND Squirrel that and I cannot even find FOOD
without help
I want to thank you for pointing out my error.
At times I am blind.
Regards
Ray
From: "Green, Ms. Dawn" <[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 Update
Date: Tue, 16 Jan 2007 11:05:52 -0600
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/
_________________________________________________________________
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/
