CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Coldfusion DSN error - Help!

Print topic Send  topic

Author Message
BillQ
Posted: 03/06/2003, 12:12 PM

Hi!

Please advise!

I am unable to get the CC DSN configuration to work with Coldfusion Development Server 5.0. After configuring an access database as the system DSN entitled "Book", which is just the renamed CC database for the Bookstore example, and then generating the CC Bookstore coldfusion code on my local host, I receive this error which I am unable to get past:

Data source Book could not be found.

The error occurred in C:\Inetpub\wwwroot\bookstore\openrs.cfm: line 15
Called from C:\Inetpub\wwwroot\bookstore\Default_Search_Show.cfm: line 40
Called from C:\Inetpub\wwwroot\bookstore\Default.cfm: line 56
Called from C:\Inetpub\wwwroot\bookstore\openrs.cfm: line 15
Called from C:\Inetpub\wwwroot\bookstore\Default_Search_Show.cfm: line 40
Called from C:\Inetpub\wwwroot\bookstore\Default.cfm: line 56

13 :
14 : <CFIF Attributes.MAX_ROWS EQ "-1">
15 : <CFQUERY NAME="CALLER.query#Attributes.Name#" DATASOURCE="#Request.db_connection_DS#" DBTYPE="#Request.db_connection_DB_TYPE#" USERNAME="#Request.db_connection_USER_NAME#" PASSWORD="#Request.db_connection_USER_PASSWORD#">
16 : #PreserveSingleQuotes(Attributes.SQL)#
17 : </CFQUERY>

Thanks,
Bill
BillQ
Posted: 03/06/2003, 2:08 PM

Hi!

I fixed it; I forgot to configure the data source in Coldfusion...DA!

Bill

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.