I might also add that if you are on a MX 7 Ent box this is a great
example of how asynchronous cfm calls can really speed up an app. You
can make an async call to a cfc which would do the remote update, no
delays in your actual page rendering time and no try catch needed
around the call. These asyn
I have a couple of applications where I want to update two database
servers simultaneously. I have just set up a datasource for each
server on my CFserver, and run the update query twice - once with each
datasource name. No need for connect strings.
It breaks if the remote server isnt available
Might I add that in CF 7 the complete ColdFusion Admin has an API so
you could make datasources dyhnmically that way...I would guess with a
little investigation you could figure out how to do simular in MX 6...
Adam H
On Sun, 6 Mar 2005 12:35:19 -0600, Jared Rypka-Hauer - CMG, LLC
<[EMAIL PROTEC
Oi... having an internet connection is a security risk.
I locked my keys in the car the other night. I had to make a simple
tool and slid it down between the body of the car and the top of the
door, to hit the electric lock button. It took less than 30 seconds to
steal my own car. But it was lock
:[EMAIL PROTECTED]
> Sent: Sunday, 6 March 2005 3:23
> To: CF-Talk
> Subject: RE: CFQUERY accessing MS SQL DB on another CF
> server
> [snip]
> Many shared hosting providers don't include the username /
> password in the
> DSN definition in the CF Admin (forcing you to
>>it is trivial to write a CF template to get the
>>raw code of everyone else's CF templates to get their usernames and
>>passwords;
It is at least as trivial (at least in CF 5) to write a CF template to get the
CF administrator password,
so storing the datasource password in it is not safe eit
't sandbox, don't expect any security at
all.
-Original Message-
From: James Holmes
Sent: Sunday, 6 March 2005 3:19
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
Unless they are using sandboxing on CF Enterprise, like ay decent ISP
should.
-Origin
: Sunday, March 06, 2005 2:05 AM
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
In fact, without sandboxing, it is trivial to write a CF template to get the
raw code of everyone else's CF templates to get their usernames and
passwords; since in this case the datasource i
Unless they are using sandboxing on CF Enterprise, like ay decent ISP
should.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 3:23
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
[snip]
Many shared hosting
Well, you can't do it in the cfquery tag, so it's no way.
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 3:13
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
CFAdmin's instructions are to provid
IMO hard-coding a database username/password in your app is only a
security risk if the wrong people already have access to your file
system, in which case you likely have bigger issues than the database
username in your application code.
Many shared hosting providers don't include the username /
CFAdmin's instructions are to provide the following ConnectionString. It is
that way
or no way.
ConnectionString = "DRIVER=SQL Server;SERVER={ipaddress};UID={username};
PWD={password};APP=;DATABASE={database}"
I can't figure out where to put it?
Security is not an issue in this case. Some publi
Well, hard coding your SQL username & password is a security risk and IMHO
bad practice.
You should let the CFAdmin handle that for you.
Warmest Regards,
Phillip B. Holmes
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 06, 2005 12:46 AM
To: CF-Talk
Add the server as a datasource.
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 2:46
To: CF-Talk
Subject: CFQUERY accessing MS SQL DB on another CF server
MX 6.1
In some of the earlier versions you could query a db on other servers around
the I
14 matches
Mail list logo
