spreadsheet which had preprogrammed formulas in the cover worksheet for a
summary. The spreadsheet was then deleted.
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 18:54
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
Hi I'm confus
> Also, you can't run an Access macro on the server without automation
which is a big no-no.
I don't want to get into the politics of having Access installed on the
machine, that's not my concern, it's the users concern. All I want to do
get the reasons why people go through so much time and effor
Bryan,
DTS implies MSSQL and if you're using a DTS to import from an uploaded Excel
or Access database, then somehow you must be passing the path to the Excel
or Access file to the DTS package. This is really the same as dsn-less
connection, just through DTS and not through CF.
Also, you can't r
I would greatly appreciate if you could post an example on how to do this.
I've asked several times without success. Thanks much!
- Original Message -
From: Bryan F. Hogan
To: CF-Talk
Sent: Monday, November 24, 2003 2:03 PM
Subject: RE: On the fly DSN creation, why?
> Sure, let
> Sure, let's say you want to let a user upload an Access database and
import it an existing data source.
If the database you want to import data is in SQL you can use a DTS. If
it is in Access you can use a Macro.
> I am currently stuck figuring out how to do the reverse - extract
data to a sta
ovember 24, 2003 12:14 PM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
In the example I posted, it was to work with an uploaded Excel
spreadsheet. In that case, you don't want a real DSN to it but just a
dynamic connection.
Besides, someone else asked about the HOW, not just WH
Hi I'm confused on this one. Did you create a DTS to import from the
uploaded spreadsheet? If so where does the DSN-less connection come into
play?
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 12:14 PM
To: CF-Talk
Subject: RE: On th
> Besides, someone else asked about the HOW, not just WHY (sorry if I'm
encouraging the repurposement of your thread).
Didn't mean to bother you. I repurposed already. And you answered.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
: Monday, November 24, 2003 17:05
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
Hi All, you missed what I was trying to do. I know how, but I want to
know why. Why do people like create DSNs on the fly?
-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
Sent: Monday
05 PM
> To: CF-Talk
> Subject: RE: On the fly DSN creation, why?
>
> Hi All, you missed what I was trying to do. I know how, but I
> want to know why. Why do people like create DSNs on the fly?
>
> -Original Message-
> From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
> Se
Sent: Monday, November 24, 2003 12:04 PM
Subject: RE: On the fly DSN creation, why?
Hi All, you missed what I was trying to do. I know how, but I want to
know why. Why do people like create DSNs on the fly?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hi All, you missed what I was trying to do. I know how, but I want to
know why. Why do people like create DSNs on the fly?
-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 8:34 AM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
You
mber 23, 2003 11:57 PM
> To: CF-Talk
> Subject: Re: On the fly DSN creation, why?
>
> This is a definite archive search, but I could swear somebody
> posted a way to do this using MS Access. I have no
> recollection at all of the details, but an archive search may help.
>
-Talk
Subject: RE: On the fly DSN creation, why?
Does ColdFusion MX 6.1 give you the ability to create DSNs on the fly?
_
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 23, 2003 8:27 PM
To: CF-Talk
> Hi, I'm wondering why people like creating DSNs on the fly.
C does not support them.
Regards,
Dave.
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 23, 2003 11:26 PM
Subject: RE: On the fly DSN creation, why?
> better word, deprecated...i
better word, deprecated...im pretty sure, either with mx or 6.1
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 23, 2003 11:00 PM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
im not sure, but i think that the connectionString option
im not sure, but i think that the connectionString option has been
disabled?
tony
-Original Message-
From: Seibert Don R [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 23, 2003 10:42 PM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
Does ColdFusion MX 6.1 give you the ability
Does ColdFusion MX 6.1 give you the ability to create DSNs on the fly?
_
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 23, 2003 8:27 PM
To: CF-Talk
> Hi, I'm wondering why people like creating DSNs on the fly.
> What benefit do you think it gives you?
You don't ne
> not always the case, user managed ISP "control panels" would require
on the fly functionality.
Ok, this is a good reason. Thanks for your post.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> In this case it is someone wishing to apply a DSN that is not authorized
> by the host company. Otherwise one has access to the administrator.
not always the case, user managed ISP "control panels" would require on the
fly functionality.
[Todays Threads]
[This Message]
[Subscription]
[F
> You don't need access to the CF Administrator in that case.
In this case it is someone wishing to apply a DSN that is not authorized
by the host company. Otherwise one has access to the administrator.
Thanks for your reply
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscrib
> Hi, I'm wondering why people like creating DSNs on the fly.
> What benefit do you think it gives you?
You don't need access to the CF Administrator in that case.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads]
[This Mes
22 matches
Mail list logo