Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access remote access

Status
Not open for further replies.
law78

law78

Technical User
Apr 23, 2004
78
GB
I have got myself some shared ColdFusion hosting, uploaded my database to their db folder and I have set up an ODBC DSN which is named CFTutorial and I referenced this DSN using the following code:

Code: 
<cfquery name="allEmployees" datasource="CFTutorial">
SELECT *
FROM tblEmployees
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[URL unfurl="true"]http://www.w3.org/TR/html4/loose.dtd">[/URL]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<cfoutput query="allEmployees">#allEmployees.firstName# #allEmployees.lastName# #allEmployees.telephone#<br></cfoutput>
</body>
</html>

All works well locally, it simple displays all the employees in the database but when I try it remotely I get the following error:

Error Occurred While Processing Request
Error Executing Database Query.
Data source not found.

The error occurred in E:\ line 1

1 : <cfquery name="allEmployees" datasource="CFTutorial">
2 : SELECT *
3 : FROM tblEmployees



--------------------------------------------------------------------------------

SQL SELECT * FROM tblEmployees
DATASOURCE CFTutorial

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Remote Address 213.107.224.14
Referrer
Date/Time 16-Nov-04 02:31 PM

Stack Trace (click to expand)
at cfselectTutorial2ecfm1007586982.runPage(E:\ at cfselectTutorial2ecfm1007586982.runPage(E:\

java.sql.SQLException: Data source not found.
at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:133)
at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at cfselectTutorial2ecfm1007586982.runPage(E:\at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)



The above page is located at
Really struggling with what should be a simple tutorial.

Thanks for any help,
 
Sort by date Sort by votes
where do you run it when you say "local"?

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
when you say local i assume you mean you're running the dev version of CF on your computer. when you say remote i assume you mean on your host server after you publish the files. it sounds like you haven't created the datasource on the host's server. or you fat fingered it. either way if you're running this with the files physicaly located in two different locations you need to setup a datasource at each location.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
On my local web server (Coldfusion and JRun)
 
Upvote 0 Downvote
if you local webserver is different than you need to create a datasource. if you have a dev box and a production box each box has to have CF and all the same settings ie. a datasouce on both servers.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
I have created a datasource from their Helm settings >>> ODBC DSNs >>> Create New >>> Type (MS Access) Data Source Name >>> CFTutorial >>> Select MS Access File (I select the file I uploaded to their server, which is the same as local file) >>> Save.

The mdb file is located in a folder named db, the db folder is located outside of the folder, I assume this is correct procedure, they created in there.

Any Ideas?
 
Upvote 0 Downvote
I agree with bombboy, it sounds like there's not a datasource named "CFTutorial" set up on the production server.



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher
 
Upvote 0 Downvote
I do not have access to the Coldfusion Admin page because the hosting is shared, but this is pretty standard for shared CF hosting. I can do most things from their HELM control panel, one of which is add a datasource (ODBC DSN).

Can't really afford hosting that gives me access to the CFMX admin page.

I have sent an email to the hosting company and I am waiting to hear back, they have their dedicated forum but knowone else seems to have had this problem.

?????????????
 
Upvote 0 Downvote
ECOBB would know better, but i don't think just adding a dsn adds a datasource to the CFadmin. that's great though if you're using ASP or PHP.

I may be wrong. someone told me once that CF just looks at the system DSN's and creates the datasource on its own if a system dsn exists with no CF datasource... i haven't tried it and find it a bit far fecthed... but again. i may be wrong. more of ECOBB's territory.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
I assume that you guys are using a dedicated CFMX hosting provider?

I did a lot of research into CFMX hosting and the shared CFMX hosting servers all promised the features of the CFMX admin page but through their own control panel, understandably really, they don't want people logging in to CFMX and editing other peoples data.

Damm, why is so hard, I have been trying this on two shared hosting accounts and I am getting the same problem on each one.

Anyone out there using CFMX shared hosting?

:(
 
Upvote 0 Downvote
i provide cfmx shared hosting...

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
I take it that your customers do not have access to the CFMX admin page?

How much you charge, whats your web address?
 
Upvote 0 Downvote


twister radio and hawk radio are heavy CF sites they both use a program i wrote similar to a shopping cart except it's a radio station administrator. all on the same server using cfmx standard.

i'm not big time enough to offer developers to have access to a control panel and make there own dsn and such. i more target internet radio stations. the admin program handles the website but i manualy create the Datasource in the administrator.

at some point (next month) the station fold that runs the whole show will also be in a virtual. shared hosting even with mx standard isn't as laced with problems as you suggest.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
i can't give you that information here it's against the tt agreement. those are not my hosting biz sites, they are customers that use CF

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
Found this thread, sounds like he was in the same boat as me:


As mentioned I have two shared accounts, one is $7 /month the other is free (for UK residents and limitations in bandwith).

I have been in touch with both and they can't understand why it is not working.

Lee
 
Upvote 0 Downvote
i guess you can try crystaltech then. :)

ask your host if there is a datasource called CFTutorial on the server. accourding to the error there isn't. make sure they're looking at the correct server. sounds like you are using 2.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
 
Upvote 0 Downvote
It is there I checked via FTP, for some reason its not pointing to it.

 
Upvote 0 Downvote
Oh well, never mind, back to the drawing board.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

crdamsel
  • Locked
  • Question
Connect CF to MS Access Code
Replies
2
Views
244
crdamsel
crdamsel
lollieleaver
  • Locked
  • Question
Dreamweaver CS4 - how can I make an Access database downloadable from my site?
Replies
2
Views
256
lollieleaver
lollieleaver
pamDes
  • Locked
  • Question
Hi, I am creating a restrict access
Replies
0
Views
115
pamDes
pamDes
cfuser10
  • Locked
  • Question
CFLDAP and Read only access to pages
Replies
1
Views
271
TruthInSatire
TruthInSatire
Boston495
  • Locked
  • Question
Can ColdFusion use Windows Authentication to access network shares?
Replies
0
Views
193
Boston495
Boston495

Part and Inventory Search

Sponsor

Back
Top