Basically I need to use SharePoint as a backend to Cold Fusion, or perhaps that is, use Cold Fusion as a front end for SharePoint.

Let's start with that you could use X or Y instead is not an option. Oh and I have about 36 hours before I get put on the rack

In SPS there are lists with which you can link to from Access and treat them as Access tables. From there you can add, delete, and edit, no problem. Done. Works like a charm.

So I thought great, I will use the access database as a backend for Cold Fusion and I am home free. But while I can read a native table in the same DB just fine, the moment the CF goes to the linked table it breaks CF and badly.

I have tested the linked table and it will open with the special account with max priv I had created to clear any access issues. So I can get to the data with the account.

I have used that account in all the CF services. I have also used the account at the database level as both the main login and the default, and I have tried using it in the query which I should not really do or really have to do.

None of this works. Again, I can get to the data with this account. I have made sure the account has god rights in the SPS and anywhere else it might be needed.

It seems almost as if when it tries to get to that table, it gets hung, and the subsequent time out causes all ODBC datasources to tank with an error so severe that you cannot even add one until the service is stopped and restarted (making trying to debug this really painful, LOL).

Is there a setting I have missed somewhere? This should not be such an issue. My systems guys say they have cleared any issues they can think of regarding security. I know the table is not poisoned, because I have run against the same table imported in as opposed to linked.

Is the MS security preventing the CF from accessing the linked table even though the account has access and while logged in as that account I have no trouble getting to the data although it will prompt me for an account/password on the first time in?

Any thoughts would be most appreciated...

Peyton

This post has been edited by peytonking: 3 Sep, 2006 - 06:41 PM

Moved to Coldfusion.

So Peyton, what happened? How did it turn out? I am wondering how to do basically the same thing. We have always been a UNIX shop (Apache on Solaris) and have been using ColdFusion and PHP with MySQL for some time. Now we are about to get Sharepoint shoved down our throats and we're desperately trying to figure out how to integrate it with everything else we are doing. If anyone has had any success with using Sharepoint as a backend to CF, I'd really like to hear about it. Please email me. Thanks.