Ask a Question related to Coldfusion Database Access, Design and Development.
-
krazykrisi #1
Error accessing database
This is not working for some reason it is telling me that ds_products does not
exist. here is the code...
<CFQUERY NAME="products" DATASOURCE="ds_products">
SELECT ProductName
FROM tblProducts
</CFQUERY>
<html>
<head>
<title></title>
</head>
<body>
<h1>Product Listing</h1>
<ul><li><CFOUTPUT QUERY="products">
#ProductName#
</CFOUTPUT></li></ul>
</body>
</html>
krazykrisi Guest
-
Accessing database
I've succesfully built cfm webpage from the getting started tutorial of CF MX7. Refering to the tutorial i wonder if i can let a user to edit the... -
Accessing database using a date
From time to time I access records in the database using a date and time field. My ISP has just upgraded from ColdFusion 5 to ColdFusion MX 6.1. My... -
ADO error accessing - Access Database
Hello, I have an Access database that is setup as a System Datasource on a Win2k Server. This Access database is accessed by about 15... -
Accessing a database from two locations
I just found this group so I don't know if this has been discussed previously. Is there a simple way for my partner and me to use the same... -
accessing database question
Is there a downside to using multiple tables in an Access database file that is having information written to the different tables and accessed at... -
hatethisnamegame #2 Re: Error accessing database
1. make sure you have the dsn setup in windows
2. make sure you have the dsn setup in cf administrator
3. is ds_products the actual dns name and is capitalization identical?
4. is ds_products actually an application or session variable referencing the
real dsn? In which case it should be DATASOURCE="#application.ds_products# or
"#session.ds_products#"
hatethisnamegame Guest
-
krazykrisi #3 Re: Error accessing database
what do you mean by dns? ds_products is a folder within the site folder which contains the products database.
krazykrisi Guest
-
LL@Work #4 Re: Error accessing database
Follow these steps:
1. Open your ColdFusion Admnistrator
2. Click "Datasources"
3. Do you see "ds_products" listed?
If so, click the check box to verify the connection.
If not, ds_products is probably a variable and you are missing the <cfset>
command usually stored in the application.cfc/cfm (<cfset #ds_products# = >)
This article may help you understand odbc connections. It is written for
ColdFusion 5:
[url]http://livedocs.macromedia.com/coldfusion/5.0/Installing_and_Configuring_ColdFus[/url]
ion_Server/datasources8.htm
LL@Work Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
