RE: On the fly DSN creation, why?
The spreadsheet is never imported as the formats can change aswell as the amount of sheets available. Certain people were only allowed to view certain sheets. This was then all interegated with CFGrid until everyone had completed the nessessary information. Then someone downloads the 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 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 the fly DSN creation, why? we wanted to do it so that users were able to upload an excel spreadsheet, which could then be manipulated by other people over a period of time. At the time of writing there was no way to do it in MX that appeared to work. So we have a bank of datasources setup in CF which is then monitored by other code and matched up with ODBC datasources via CFRegistry Much much easier (and secure) than installing MS Office on the server (which has the added problem of being really locked down) and trying to use COM _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> 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 effort to do a DSN less connection in _CFML_. > 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. Yep, I was asked for an example through code, but I don't see a need to do it through code. It can be done with the database engines. You'll probably counter and say that in order to run the DTS your doing it through code anyways. My answer would be yes but your calling a stored procedure. Or firing a Macro. > This is really the same as dsn-less connection, just through DTS and not through CF Yep [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
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 run an Access macro on the server without automation which is a big no-no. Best regards, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: On the fly DSN creation, why?
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'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 stand alone dynamically generated Access database. Same as above. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> 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 stand alone dynamically generated Access database. Same as above. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
I've been thinking about this today and so-far I can't figure out why the need for DSN-less connections. Could a Macro in your Access database not import data from an uploaded Excel Spreadsheet -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Monday, November 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 WHY (sorry if I'm encouraging the repurposement of your thread). Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
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 the fly DSN creation, why? we wanted to do it so that users were able to upload an excel spreadsheet, which could then be manipulated by other people over a period of time. At the time of writing there was no way to do it in MX that appeared to work. So we have a bank of datasources setup in CF which is then monitored by other code and matched up with ODBC datasources via CFRegistry Much much easier (and secure) than installing MS Office on the server (which has the added problem of being really locked down) and trying to use COM [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> 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]
RE: On the fly DSN creation, why?
we wanted to do it so that users were able to upload an excel spreadsheet, which could then be manipulated by other people over a period of time. At the time of writing there was no way to do it in MX that appeared to work. So we have a bank of datasources setup in CF which is then monitored by other code and matched up with ODBC datasources via CFRegistry Much much easier (and secure) than installing MS Office on the server (which has the added problem of being really locked down) and trying to use COM -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 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, November 24, 2003 8:34 AM To: CF-Talk Subject: RE: On the fly DSN creation, why? You can do dynamic ODBC connections in MX by creating a datasource to an empty Access database and use that as a proxy, specifying the real connection string in the FROM clause of your query. SELECT Salesperson, SalesAmount FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".[Sales$] HTH, Sam _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 WHY (sorry if I'm encouraging the repurposement of your thread). Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- > -Original Message- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 12: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] > Sent: Monday, November 24, 2003 8:34 AM > To: CF-Talk > Subject: RE: On the fly DSN creation, why? > > You can do dynamic ODBC connections in MX by creating a > datasource to an empty Access database and use that as a > proxy, specifying the real connection string in the FROM > clause of your query. > > > SELECT Salesperson, SalesAmount > FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".[Sales$] > > HTH, > > Sam > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: On the fly DSN creation, why?
Sure, let's say you want to let a user upload an Access database and import it an existing data source. I am currently stuck figuring out how to do the reverse - extract data to a stand alone dynamically generated Access database. - Original Message - From: Bryan F. Hogan To: CF-Talk 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]
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, November 24, 2003 8:34 AM To: CF-Talk Subject: RE: On the fly DSN creation, why? You can do dynamic ODBC connections in MX by creating a datasource to an empty Access database and use that as a proxy, specifying the real connection string in the FROM clause of your query. SELECT Salesperson, SalesAmount FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".[Sales$] HTH, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
You can do dynamic ODBC connections in MX by creating a datasource to an empty Access database and use that as a proxy, specifying the real connection string in the FROM clause of your query. SELECT Salesperson, SalesAmount FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".[Sales$] HTH, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- > -Original Message- > From: Dave Carabetta [mailto:[EMAIL PROTECTED] > Sent: Sunday, November 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. > > Officially though, the "CF 5" way of creating dsn-less > connections was deprecated because (I believe) JDBC does not > support them. > > Regards, > Dave. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
6.1 has some components listed in the component manager that can probably allow you to do this. MX didnt, I havnt tried using them so i dont know how effective they are. HTH -Original Message- From: Seibert Don R [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 03:42 To: CF-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. > 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 Message] [Subscription] [Fast Unsubscribe] [User Settings]
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. Officially though, the "CF 5" way of creating dsn-less connections was deprecated because (I believe) JDBC 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...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 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 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 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 Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
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 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 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 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 Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
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 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 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 Message] [Subscription] [Fast Unsubscribe] [User Settings]
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. > 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 Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> 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]
Re: On the fly DSN creation, why?
> 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] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> 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 Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> 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 Message] [Subscription] [Fast Unsubscribe] [User Settings]
