Migrating ODBC Datasources

2005-04-06 Thread Greg Luce
I know how to back up datasources in CF5, and I understand the datasources are stored somewhere else in CFMX. Is there a way to migrate CF5 datasources into CFMX? ~| Logware (www.logware.us): a new and convenient web-based time

Re: Migrating ODBC Datasources

2005-04-06 Thread Steven Erat
Greg Luce wrote: I know how to back up datasources in CF5, and I understand the datasources are stored somewhere else in CFMX. Is there a way to migrate CF5 datasources into CFMX? When you install CFMX on the same machine and choose the upgrade option, then during the post-install migration

Re: Migrating ODBC Datasources

2005-04-06 Thread Greg Luce
Well, that would work if it were the same server. I'm installing on a new machine. Seems like the long way around to install CF5 and then upgrade for the sake of using the migration-wizard to copy the datasources. I may have to do that though. On Apr 6, 2005 4:01 PM, Steven Erat [EMAIL PROTECTED]

RE: Migrating ODBC Datasources

2005-04-06 Thread Calvin Ward
can uninstall the 'upgrade' and I can find another reason to use 'quotes'... - Calvin -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 4:22 PM To: CF-Talk Subject: Re: Migrating ODBC Datasources Well, that would work if it were the same server

Re: Migrating ODBC Datasources

2005-04-06 Thread Greg Luce
and not disturb your 'real' web server. Then you can uninstall the 'upgrade' and I can find another reason to use 'quotes'... - Calvin -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 4:22 PM To: CF-Talk Subject: Re: Migrating ODBC

RE: Migrating ODBC Datasources

2005-04-06 Thread Calvin Ward
: Wednesday, April 06, 2005 4:46 PM To: CF-Talk Subject: Re: Migrating ODBC Datasources Ah, that sounds interesting. I didn't want to break anything, and wanted to leave the CF5 running on the old server. Just setting up a new one with CFMX that I want to roll-out in place of the CF5 if all looks good

Weird thing happening with ODBC Datasources

2003-10-16 Thread dsmith
This is totally weird.But what seems to be happening is that if an ODBC Error is generated by one page anywhere on my server, any other ODBC calls will generate the error messagefor that first page that caused the error.Yesterday it crashed the server.However, once I run the page that caused the

RE: Weird thing happening with ODBC Datasources

2003-10-16 Thread Mark A. Kruger - CFG
] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 8:38 AM To: CF-Talk Subject: Weird thing happening with ODBC Datasources This is totally weird.But what seems to be happening is that if an ODBC Error is generated by one page anywhere on my server, any other ODBC calls will generate

Re:Weird thing happening with ODBC Datasources

2003-10-16 Thread dsmith
Yes, I believe what you are saying is correct.I generate an ODBC Error on one page (call it test.cfm), then I call another page (page2.cfm) that has an ODBC call on it, the query from test.cfm will appear with the error message on Page2.cfm.To fix the problem, if I remove the query from test.cfm

two ODBC datasources with one query

2002-09-27 Thread John Elder
Is there anyway to use the the datasource instead of the dbname to join two datasources in cfquery? thanks, John __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics.

RE: ODBC Datasources

2001-12-07 Thread Dunwiddie, Bruce
you have to read the registry for both. gl. -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 11:49 AM To: CF-Talk Subject: ODBC Datasources Is there an easy way to get a list of ODBC datasources on the server through ColdFusion? Also

RE: ODBC Datasources

2001-12-07 Thread Jeffry Houser
The tables in a datasource are stored in the registry? At 10:52 AM 12/07/2001 -0600, you wrote: you have to read the registry for both. gl. -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 11:49 AM To: CF-Talk Subject: ODBC Datasources

RE: ODBC Datasources

2001-12-07 Thread Dunwiddie, Bruce
cfquery name=gettablenames datasource=#somedsn# dbtype=odbc select name from sysobjects where xtype='U' /cfquery -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 11:18 AM To: CF-Talk Subject: RE: ODBC Datasources

ODBC Datasources

2001-12-06 Thread tom muck
Is there an easy way to get a list of ODBC datasources on the server through ColdFusion? Also, given a datasource, is there a way to get a list of tables from that datasource? tom ~~ Get the mailserver that powers this list at http

RE: ODBC Datasources

2001-12-06 Thread Dave Watts
Is there an easy way to get a list of ODBC datasources on the server through ColdFusion? Yes. You can use CFREGISTRY to read the HKLM\SOFTWARE\ODBC\ODBC.INI key. If you want native data sources, you can read the appropriate CF registry key. Also, given a datasource, is there a way to get

Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread Chris Montgomery
Howdy, Once upon a time, I could set up ODBC datasources through CF Administrator. Recently, after adding a datasource name and clicking on the browse button to go select the database file to complete the installation, no directories ever come up in the window that is supposed to show

Re: Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread Fred T. Sanders
ot; [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 27, 2000 10:25 AM Subject: Setting Up ODBC Datasources Thru CF Administrator Howdy, Once upon a time, I could set up ODBC datasources through CF Administrator. Recently, after adding a datasource name and clicking on the browse bu

RE: Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread Dave Watts
Once upon a time, I could set up ODBC datasources through CF Administrator. Recently, after adding a datasource name and clicking on the browse button to go select the database file to complete the installation, no directories ever come up in the window that is supposed to show

Re: Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread Fred T. Sanders
PROTECTED] Sent: Thursday, April 27, 2000 10:33 AM Subject: Re: Setting Up ODBC Datasources Thru CF Administrator Sounds like something has gotten corrupted. I'm running basically the same setup with no problems here. Sorry I cannot be more help other than saying it should work just fine. W

RE: Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread Chris Montgomery
-Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 27, 2000 10:33 AM To: [EMAIL PROTECTED] Subject: Re: Setting Up ODBC Datasources Thru CF Administrator Sounds like something has gotten corrupted. I'm running basically the same setup

Re: Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread B.Cravens
Have you tested it on other workstations? Make sure it's server side, and not a workstation Java Applets problem. Billy - Original Message - From: "Chris Montgomery" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 27, 2000 10:25 AM Subject: Setting Up ODBC D

RE: Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread Chris Montgomery
-Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 27, 2000 1:01 PM To: [EMAIL PROTECTED] Subject: Re: Setting Up ODBC Datasources Thru CF Administrator Has your system admin changed any permissions on the server??? Just a thought . . . Dave

RE: Setting Up ODBC Datasources Thru CF Administrator

2000-04-27 Thread Reagan, Leman
PROTECTED] Subject: Setting Up ODBC Datasources Thru CF Administrator Howdy, Once upon a time, I could set up ODBC datasources through CF Administrator. Recently, after adding a datasource name and clicking on the browse button to go select the database file to complete the installation, no directories

Re: CF Administartor Does Not Show ODBC DataSources

2000-04-26 Thread Chris Tazewell
Have you installed ablecommerce? Not sure why but that has a habit of hiding previous datasources, but they still exist and CF can access them, you just cant see them on CF administrator Taz Working Ok for almost two years but now my CF Admin only shows the datasources for the latest

RE: CF Administartor Does Not Show ODBC DataSources

2000-04-26 Thread Paul's Mail
: Re: CF Administartor Does Not Show ODBC DataSources Have you installed ablecommerce? Not sure why but that has a habit of hiding previous datasources, but they still exist and CF can access them, you just cant see them on CF administrator Taz Working Ok for almost two years but now my

Re: CF Administartor Does Not Show ODBC DataSources

2000-04-26 Thread Chris Tazewell
, 2000 4:20 PM To: [EMAIL PROTECTED] Subject: Re: CF Administartor Does Not Show ODBC DataSources Have you installed ablecommerce? Not sure why but that has a habit of hiding previous datasources, but they still exist and CF can access them, you just cant see them on CF administrator