> >
coming from the sql server end of things, look at the
OPENROWSET & OPENQUERY rowset functions
though as other have indicated, you'll need just 1 dsn
that has some sort of access to the other dsn you'll
be talking to.
~~
Get the mailserver tha
> ok... wat i need is to hav multiple DB connection in a query
> statement..
>
> for example.. i need to hav a joint query from a oracle
> database and a ms sql database..
>
> can i actually do this..?
>
>
> .
> .
>
>
> ?? or must it be query within a query?
>
>
> .
> .
>
> .
> .
>
Yes, Access will support that.
http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914&Start=Last
Datasource1=iether of your valid datasources
t2 *the path to the second "database"
*be sure to add the table name as "SecondDBTable"
*SecondDbase is the fi
?
.
.
.
.
.
thanx you ppl.. : )
by the way.. any gd site for CF 5 info to recommend ??
cheers
han
- Original Message -
From: "Darryl Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 05, 2001 4:10 AM
Subject: RE: can CF do mul
Don't think so as you've generally got one datasource per access database..
I'm not really an Access-using person..
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Monday, 5 November 2001 10:05 AM
To: CF-Talk
Subject: Re: can CF do multiple DB connectio
Can Access support cross-database joins?
Will
- Original Message -
From: "Darryl Lyons" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Sunday, November 04, 2001 8:23 PM
Subject: RE: can CF do multiple DB connection?
> If your using db like SQL Serv
: tom muck [mailto:[EMAIL PROTECTED]]
Sent: Monday, 5 November 2001 2:55 AM
To: CF-Talk
Subject: Re: can CF do multiple DB connection?
It sounds like you are confused by why the application.cfm has the DSN
connection defined -- the main reason is so that you don't have to define it
on every
It sounds like you are confused by why the application.cfm has the DSN
connection defined -- the main reason is so that you don't have to define it
on every page and can change it in one place if you need to change it for
any reason. If you want to use more than one, simply define more than one
v
hi... ppl...
i will like to check with u..ppl can cold fusion link to multiple
database at the same time..??
i noticed under application.cfm .. we normally put only 1 DSN connection.
juz wonder.. is it possible to create multiple DSN connection..? and is it
possible to do multiple database
9 matches
Mail list logo