Acessing another Datasource

[Lo atamo con alambre]

Im working with a CF driven dinamic site called 'Reconquista', and the
datasource it uses is a Coldfusion one.

I need to access a non-CF datasource, from another site called 'Peru', and
recover some information to insert in the datasource of 'Reconquista'.

That module can't be programmed in CF, because CF (as I know in this moment)
does not acess any other datasource format rather than CF's one, and the
datasource Im searching for (in Per?) is a common, MSAcess-driven datasource.

I thought the module can be programmed in ASP, but I dont know how can I made
a connection to the CF_Datasource of 'Reconquista' in that language.

?Is there any form of doing that?

A way to do that would be entablishing a DSN-Less Connection in CF, but that
seems impossible.

Im completely loss with this problem :(:confused;

[Neculai Macarie]

> Im working with a CF driven dinamic site called 'Reconquista', and the

> datasource it uses is a Coldfusion one.
>
> I need to access a non-CF datasource, from another site called 'Peru',

and

> recover some information to insert in the datasource of 'Reconquista'.
>
> That module can't be programmed in CF, because CF (as I know in this

moment)

> does not acess any other datasource format rather than CF's one, and the
> datasource Im searching for (in Per?) is a common, MSAcess-driven

datasource.

>
> I thought the module can be programmed in ASP, but I dont know how can I

made

> a connection to the CF_Datasource of 'Reconquista' in that language.
>
> ?Is there any form of doing that?

Create an ODBC connection to the same database to which 'Reconquista' points
and access that connection from ASP.

> A way to do that would be entablishing a DSN-Less Connection in CF, but

that

> seems impossible.

In CFMX 6 and CFMX 7 I think it's no longer possible to create DNS-less
connections

--
<mack />

[jonwrob]

What do you mean by "CF datasource" and "Non-CF datasource"? CF is a server
side scripting language. It does not store data.

CF connects to all sorts of database products, including (but not limited to)
MS-Access, MySQL, Oracle, Sybase and SQL Server.

As for ASP being able to do something that CF cannot, I challenge anyone to
come up with an example.

JR

[mpwoodward *TMM*]

Lo atamo con alambre wrote:

> I need to access a non-CF datasource, from another site called 'Peru', and
> recover some information to insert in the datasource of 'Reconquista'.

OK, but if you have access to the database server, you can create a CF
datasource to connect to this database. It sounds like there's a bit of
confusion on what a datasource really is. A datasource in CF is nothing
but a pointer to a database server and a specific dataabse on that
server, so if you have access information to the database server, you
can point CF to it as long as you have the right database drivers.

> That module can't be programmed in CF, because CF (as I know in this moment)
> does not acess any other datasource format rather than CF's one, and the
> datasource Im searching for (in Per?) is a common, MSAcess-driven datasource.

Well, this is semi-true, but again if you have access to the database
server you can point CF to it. Now if it's a Microsoft Access database
file that's sitting on a remote server somewhere, that gets a bit hairy
because Access isn't a database server, it's just a file. I'm sure
there is some way to do this but it gets messy and the performance would
be pretty horrible.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion