Skip to main content
May 16, 2007
Question

Datasource Error Message

  • May 16, 2007
  • 2 replies
  • 324 views
I'm receiving an odd "Datasource Error newLFC could not be found" message.

I say this message is odd because the page uses this datasource to insert a record into a users table and then fails later on the page when updating the courses table. Therefore, I know the datasource does exist and that this actual page successfully uses the datasource. In addition, this page worked fine on our internal server, but the problem has arisen when we moved it to an external server, so the SQL statement syntax is accurate.

Any thoughts on other problems that might cause this message. The second SQL insert does require information from the first SQL insert. So the page does contain multiple hits to the database.

In addition, I extended the timeout on the page to ensure that the multiple hits weren't just timing out and displaying an inaccurate error message.

Thanks in advance
This topic has been closed for replies.

2 replies

BKBK
Community Expert
Community Expert
May 19, 2007
Oh, and, it helps to mention your Coldfusion version, database server and whether or not they're on the same machine.

BKBK
Community Expert
Community Expert
May 19, 2007
Perhaps the datasource settings in the Coldfusion Administrator contain an IP address, a server name or property that changes when you move servers.