RE: Migrating ODBC Datasources
Conversely, if you are running Enterprise, then you can install that on your target server and use the archive (.car) functionality to move your datasources over, and then upgrade in place on the new server. - Calvin -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 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. But would like to keep the CF5 server running just in case. Greg On Apr 6, 2005 4:35 PM, Calvin Ward <[EMAIL PROTECTED]> wrote: > If you upgrade in place on the CF 5 server, you should be able to move the > neo-query.xml file from the upgraded server to your new server. > > Of course you can upgrade in place and use the built in web server and it > 'should' import your datasources 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 Datasources > > 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]> wrote: > > 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 wizard your CF5 datasources will > > be imported. > > > > The best documentation comes from the CFMX 6.0 docs for the CF5 > > Migration Guide, > > > http://livedocs.macromedia.com/coldfusion/6/Migrating_ColdFusion_5_Applicati > ons/cf_migration_guide.htm > > > > While a detail or two might vary with CFMX 7, the migration works the > > same overall. > > > > Also see http://www.macromedia.com/devnet/mx/coldfusion/migrating.html > > > > -Steven Erat > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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. But would like to keep the CF5 server running just in case. Greg On Apr 6, 2005 4:35 PM, Calvin Ward <[EMAIL PROTECTED]> wrote: > If you upgrade in place on the CF 5 server, you should be able to move the > neo-query.xml file from the upgraded server to your new server. > > Of course you can upgrade in place and use the built in web server and it > 'should' import your datasources 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 Datasources > > 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]> wrote: > > 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 wizard your CF5 datasources will > > be imported. > > > > The best documentation comes from the CFMX 6.0 docs for the CF5 > > Migration Guide, > > > http://livedocs.macromedia.com/coldfusion/6/Migrating_ColdFusion_5_Applicati > ons/cf_migration_guide.htm > > > > While a detail or two might vary with CFMX 7, the migration works the > > same overall. > > > > Also see http://www.macromedia.com/devnet/mx/coldfusion/migrating.html > > > > -Steven Erat > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Migrating ODBC Datasources
If you upgrade in place on the CF 5 server, you should be able to move the neo-query.xml file from the upgraded server to your new server. Of course you can upgrade in place and use the built in web server and it 'should' import your datasources 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 Datasources 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]> wrote: > 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 wizard your CF5 datasources will > be imported. > > The best documentation comes from the CFMX 6.0 docs for the CF5 > Migration Guide, > http://livedocs.macromedia.com/coldfusion/6/Migrating_ColdFusion_5_Applicati ons/cf_migration_guide.htm > > While a detail or two might vary with CFMX 7, the migration works the > same overall. > > Also see http://www.macromedia.com/devnet/mx/coldfusion/migrating.html > > -Steven Erat > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Migrating ODBC Datasources
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]> wrote: > 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 wizard your CF5 datasources will > be imported. > > The best documentation comes from the CFMX 6.0 docs for the CF5 > Migration Guide, > http://livedocs.macromedia.com/coldfusion/6/Migrating_ColdFusion_5_Applications/cf_migration_guide.htm > > While a detail or two might vary with CFMX 7, the migration works the > same overall. > > Also see http://www.macromedia.com/devnet/mx/coldfusion/migrating.html > > -Steven Erat > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Migrating ODBC Datasources
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 wizard your CF5 datasources will be imported. The best documentation comes from the CFMX 6.0 docs for the CF5 Migration Guide, http://livedocs.macromedia.com/coldfusion/6/Migrating_ColdFusion_5_Applications/cf_migration_guide.htm While a detail or two might vary with CFMX 7, the migration works the same overall. Also see http://www.macromedia.com/devnet/mx/coldfusion/migrating.html -Steven Erat ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201780 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Migrating ODBC Datasources
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 tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re:Weird thing happening with ODBC Datasources
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 and call a blank page (test.cfm) the problem goes away. Totally weird... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird thing happening with ODBC Datasources
No - but I'm not sure I understand. You mean that if one page causes ANY type of error - all subsequent calls generate the same error (for any page)? Is there a specific error? Can you duplicate this with a syntax error? -mark -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [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 the error message for that first page that caused the error. Yesterday it crashed the server. However, once I run the page that caused the error with the error removed, everything works fine. It doesn't matter what kind of ODBC driver it is, I've done it with Client Access, Rumba and SQL Server. I'm running CF 5. Has anyone ever seen something like this? Daron Smtih PSEA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 the error message for that first page that caused the error. Yesterday it crashed the server. However, once I run the page that caused the error with the error removed, everything works fine. It doesn't matter what kind of ODBC driver it is, I've done it with Client Access, Rumba and SQL Server. I'm running CF 5. Has anyone ever seen something like this? Daron Smtih PSEA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
two ODBC datasources with one query
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. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Datasources
select name from sysobjects where xtype='U' -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 11:18 AM To: CF-Talk Subject: RE: ODBC Datasources 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 > > >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://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Datasources
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 > > >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://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Datasources
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, given a datasource, is there a way to get a list of tables from that datasource? tom ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Datasources
> 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 a list of > tables from that datasource? I don't know if there's a generic ODBC command to get a list of tables (I seem to remember something about SQLTables, but it's been a while since I've looked at lower-level ODBC programming), and even if there was, I don't know how you'd access that at the passthrough SQL level that you use to interact with ODBC datasources from within CF. However, most databases have this sort of functionality, and you could simply look at the registry info for a given datasource to see what database it uses, then use the database-specific method to get the list of tables. For example, in SQL Server, you can use the sp_tables stored procedure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Datasources
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://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Up ODBC Datasources Thru CF Administrator
Hi Chris, I had this happen also. Although the browse did not function, I was able to type in the file location by hand and it worked. Hope this helps, /LEMAN/ -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 27, 2000 8:25 AM To: [EMAIL 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 ever come up in the window that is supposed to show the directory tree. The hourglass icon just runs and runs. I've made sure the RDS service is running before attempting this but no joy. To work around this, I'm having to use the ODBC Data Source Administrator under Win98's Control Panel to set up datasources. Could this possibly be an MDAC thang? Any suggestions on what to check? My setup: running Studio 4.5.1 on Win98 (1st ed.), MS Access97 databases Chris Montgomery = astutia.com -> http://www.astutia.com [EMAIL PROTECTED] Astute e-business applications & web site development 210-490-3249/888-745-7603 Fax 210-490-4692 Allaire Consulting Partner/Authorized NetObjects Reseller Find a Job in San Antonio -> http://www.sajobnet.com Need professional help? -> http://www.psychadvisor.com = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Setting Up ODBC Datasources Thru CF Administrator
>-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 > No, I'm the only one here - running the single-user Studio version of CF Enterprise 4.5 (I had said 4.5.1 earlier, but that was for Studio...haven't found an update yet on Allaire's site for the single-user version of Enterprise 4.5.1). >-Original Message- >From: B.Cravens [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 27, 2000 2:22 PM >To: [EMAIL PROTECTED] >Subject: Re: Setting Up ODBC Datasources Thru CF Administrator > > >Have you tested it on other workstations? Make sure it's >server side, and >not a workstation Java Applets problem. > >Billy No, only running one machine here. Thanks, all. I guess I'll take this to Allaire support forums and see if anyone there has already found a solution. As others have mentioned, I'm apparently not the only one running into this problem. Cheers, Chris Montgomery = astutia.com -> http://www.astutia.com [EMAIL PROTECTED] Astute e-business applications & web site development 210-490-3249/888-745-7603 Fax 210-490-4692 Allaire Consulting Partner/Authorized NetObjects Reseller Find a Job in San Antonio -> http://www.sajobnet.com Need professional help? -> http://www.psychadvisor.com = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting Up ODBC Datasources Thru CF Administrator
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 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 ever come up in the window that is supposed > to show the directory tree. The hourglass icon just runs and runs. > I've made sure the RDS service is running before attempting this but no > joy. To work around this, I'm having to use the ODBC Data Source > Administrator under Win98's Control Panel to set up datasources. > > Could this possibly be an MDAC thang? Any suggestions on what to check? > My setup: running Studio 4.5.1 on Win98 (1st ed.), MS Access97 databases > > Chris Montgomery > = > astutia.com -> http://www.astutia.com [EMAIL PROTECTED] > Astute e-business applications & web site development > 210-490-3249/888-745-7603 Fax 210-490-4692 > Allaire Consulting Partner/Authorized NetObjects Reseller > Find a Job in San Antonio -> http://www.sajobnet.com > Need professional help? -> http://www.psychadvisor.com > = > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting Up ODBC Datasources Thru CF Administrator
I had something similar happen, updating my IE and a few other system patches managed to replace whatever DLL was causing me grief. Fred - Original Message - From: "Chris Montgomery" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 27, 2000 11:50 AM Subject: RE: Setting Up ODBC Datasources Thru CF Administrator > > >-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 with no problems here. Sorry I cannot be more help > >other than saying > >it should work just fine. What's been installed / uninstalled > >recently? > > > >Fred > > > > I failed to mention that I started experiencing this problem under > version 4.01, before I ever upgraded to 4.5.1. I suspect you're > correct, something must have gotten corrupted, but I can't say exactly > when that might have occurred. > > Chris > > >-----Original Message- > >From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, April 27, 2000 10:40 AM > >To: [EMAIL PROTECTED] > >Subject: Re: Setting Up ODBC Datasources Thru CF Administrator > > > > > >Wait, 1st edition?? I'd go to the updates section of MS and start > >downloading your updates before I did anything else, they're > >free and if you > >have a broadband connection shouldn't take too long. > > > >Fred > > > > I've downloaded Win98 updates on a regular basis. Will check again for > the latest. > > >-Original Message- > >From: Dave Watts [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, April 27, 2000 10:33 AM > >To: [EMAIL PROTECTED] > >Cc: [EMAIL PROTECTED] > >Subject: RE: Setting Up ODBC Datasources Thru CF Administrator > > > > >This sounds like a Java problem; CF Administrator uses the CFTREE Java > >Applet to let you browse the filesystem. You might try using a > >different > >browser, and making sure the URL path /CFIDE/classes works. > > > >Dave Watts, CTO, Fig Leaf Software > > You could be right, and that's one of the things I've suspected to this > point. I've used both IE 5 and Netscape 4.7 with the same results. I > get the "Select File on the Server" window to come up and the > "Retrieving initial directories..." message at the top of the directory > tree, but it never gets beyond that. > > How can I test the /cfide/classes path? > > The other thing I thought might be causing problems is MDAC > related...but then I realized I probably wouldn't be able to > successfully use the ODBC Data Source Administrator if that were so. > Still, I ran the MDAC Component Checker program and received a bunch of > Field Mismatch/FileDescription/FileVersion errors, so maybe it's time to > clean up the MDAC components, too. > > Thanks for the various replies. > > Chris Montgomery > = > astutia.com -> http://www.astutia.com [EMAIL PROTECTED] > Astute e-business applications & web site development > 210-490-3249/888-745-7603 Fax 210-490-4692 > Allaire Consulting Partner/Authorized NetObjects Reseller > Find a Job in San Antonio -> http://www.sajobnet.com > Need professional help? -> http://www.psychadvisor.com > = > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting Up ODBC Datasources Thru CF Administrator
Has your system admin changed any permissions on the server??? Just a thought . . . Dave = "Always Drink Upstream From The Herd!" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: Chris Montgomery <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 27, 2000 11:50 AM Subject: RE: Setting Up ODBC Datasources Thru CF Administrator >-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 with no problems here. Sorry I cannot be more help >other than saying >it should work just fine. What's been installed / uninstalled >recently? > >Fred > I failed to mention that I started experiencing this problem under version 4.01, before I ever upgraded to 4.5.1. I suspect you're correct, something must have gotten corrupted, but I can't say exactly when that might have occurred. Chris >-Original Message- >From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 27, 2000 10:40 AM >To: [EMAIL PROTECTED] >Subject: Re: Setting Up ODBC Datasources Thru CF Administrator > > >Wait, 1st edition?? I'd go to the updates section of MS and start >downloading your updates before I did anything else, they're >free and if you >have a broadband connection shouldn't take too long. > >Fred > I've downloaded Win98 updates on a regular basis. Will check again for the latest. >-Original Message- >From: Dave Watts [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 27, 2000 10:33 AM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: RE: Setting Up ODBC Datasources Thru CF Administrator > >This sounds like a Java problem; CF Administrator uses the CFTREE Java >Applet to let you browse the filesystem. You might try using a >different >browser, and making sure the URL path /CFIDE/classes works. > >Dave Watts, CTO, Fig Leaf Software You could be right, and that's one of the things I've suspected to this point. I've used both IE 5 and Netscape 4.7 with the same results. I get the "Select File on the Server" window to come up and the "Retrieving initial directories..." message at the top of the directory tree, but it never gets beyond that. How can I test the /cfide/classes path? The other thing I thought might be causing problems is MDAC related...but then I realized I probably wouldn't be able to successfully use the ODBC Data Source Administrator if that were so. Still, I ran the MDAC Component Checker program and received a bunch of Field Mismatch/FileDescription/FileVersion errors, so maybe it's time to clean up the MDAC components, too. Thanks for the various replies. Chris Montgomery = astutia.com -> http://www.astutia.com [EMAIL PROTECTED] Astute e-business applications & web site development 210-490-3249/888-745-7603 Fax 210-490-4692 Allaire Consulting Partner/Authorized NetObjects Reseller Find a Job in San Antonio -> http://www.sajobnet.com Need professional help? -> http://www.psychadvisor.com = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting Up ODBC Datasources Thru CF Administrator
I started having this problem when I upgraded to 4.5. I'm interested in hearing how others have fixed it. Erika - Original Message - From: "Chris Montgomery" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 27, 2000 9:50 AM Subject: RE: Setting Up ODBC Datasources Thru CF Administrator > > >-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 with no problems here. Sorry I cannot be more help > >other than saying > >it should work just fine. What's been installed / uninstalled > >recently? > > > >Fred > > > > I failed to mention that I started experiencing this problem under > version 4.01, before I ever upgraded to 4.5.1. I suspect you're > correct, something must have gotten corrupted, but I can't say exactly > when that might have occurred. > > Chris > > >-----Original Message- > >From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, April 27, 2000 10:40 AM > >To: [EMAIL PROTECTED] > >Subject: Re: Setting Up ODBC Datasources Thru CF Administrator > > > > > >Wait, 1st edition?? I'd go to the updates section of MS and start > >downloading your updates before I did anything else, they're > >free and if you > >have a broadband connection shouldn't take too long. > > > >Fred > > > > I've downloaded Win98 updates on a regular basis. Will check again for > the latest. > > >-Original Message- > >From: Dave Watts [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, April 27, 2000 10:33 AM > >To: [EMAIL PROTECTED] > >Cc: [EMAIL PROTECTED] > >Subject: RE: Setting Up ODBC Datasources Thru CF Administrator > > > > >This sounds like a Java problem; CF Administrator uses the CFTREE Java > >Applet to let you browse the filesystem. You might try using a > >different > >browser, and making sure the URL path /CFIDE/classes works. > > > >Dave Watts, CTO, Fig Leaf Software > > You could be right, and that's one of the things I've suspected to this > point. I've used both IE 5 and Netscape 4.7 with the same results. I > get the "Select File on the Server" window to come up and the > "Retrieving initial directories..." message at the top of the directory > tree, but it never gets beyond that. > > How can I test the /cfide/classes path? > > The other thing I thought might be causing problems is MDAC > related...but then I realized I probably wouldn't be able to > successfully use the ODBC Data Source Administrator if that were so. > Still, I ran the MDAC Component Checker program and received a bunch of > Field Mismatch/FileDescription/FileVersion errors, so maybe it's time to > clean up the MDAC components, too. > > Thanks for the various replies. > > Chris Montgomery > = > astutia.com -> http://www.astutia.com [EMAIL PROTECTED] > Astute e-business applications & web site development > 210-490-3249/888-745-7603 Fax 210-490-4692 > Allaire Consulting Partner/Authorized NetObjects Reseller > Find a Job in San Antonio -> http://www.sajobnet.com > Need professional help? -> http://www.psychadvisor.com > = > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Setting Up ODBC Datasources Thru CF Administrator
>-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 with no problems here. Sorry I cannot be more help >other than saying >it should work just fine. What's been installed / uninstalled >recently? > >Fred > I failed to mention that I started experiencing this problem under version 4.01, before I ever upgraded to 4.5.1. I suspect you're correct, something must have gotten corrupted, but I can't say exactly when that might have occurred. Chris >-Original Message- >From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 27, 2000 10:40 AM >To: [EMAIL PROTECTED] >Subject: Re: Setting Up ODBC Datasources Thru CF Administrator > > >Wait, 1st edition?? I'd go to the updates section of MS and start >downloading your updates before I did anything else, they're >free and if you >have a broadband connection shouldn't take too long. > >Fred > I've downloaded Win98 updates on a regular basis. Will check again for the latest. >-Original Message- >From: Dave Watts [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 27, 2000 10:33 AM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: RE: Setting Up ODBC Datasources Thru CF Administrator > >This sounds like a Java problem; CF Administrator uses the CFTREE Java >Applet to let you browse the filesystem. You might try using a >different >browser, and making sure the URL path /CFIDE/classes works. > >Dave Watts, CTO, Fig Leaf Software You could be right, and that's one of the things I've suspected to this point. I've used both IE 5 and Netscape 4.7 with the same results. I get the "Select File on the Server" window to come up and the "Retrieving initial directories..." message at the top of the directory tree, but it never gets beyond that. How can I test the /cfide/classes path? The other thing I thought might be causing problems is MDAC related...but then I realized I probably wouldn't be able to successfully use the ODBC Data Source Administrator if that were so. Still, I ran the MDAC Component Checker program and received a bunch of Field Mismatch/FileDescription/FileVersion errors, so maybe it's time to clean up the MDAC components, too. Thanks for the various replies. Chris Montgomery = astutia.com -> http://www.astutia.com [EMAIL PROTECTED] Astute e-business applications & web site development 210-490-3249/888-745-7603 Fax 210-490-4692 Allaire Consulting Partner/Authorized NetObjects Reseller Find a Job in San Antonio -> http://www.sajobnet.com Need professional help? -> http://www.psychadvisor.com = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting Up ODBC Datasources Thru CF Administrator
Wait, 1st edition?? I'd go to the updates section of MS and start downloading your updates before I did anything else, they're free and if you have a broadband connection shouldn't take too long. Fred - Original Message - From: "Fred T. Sanders" <[EMAIL PROTECTED]> To: <[EMAIL 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. What's been installed / uninstalled recently? > > Fred > > - Original Message - > From: "Chris Montgomery" <[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 button to go select the database file to complete the > > installation, no directories ever come up in the window that is supposed > > to show the directory tree. The hourglass icon just runs and runs. > > I've made sure the RDS service is running before attempting this but no > > joy. To work around this, I'm having to use the ODBC Data Source > > Administrator under Win98's Control Panel to set up datasources. > > > > Could this possibly be an MDAC thang? Any suggestions on what to check? > > My setup: running Studio 4.5.1 on Win98 (1st ed.), MS Access97 databases > > > > Chris Montgomery > > = > > astutia.com -> http://www.astutia.com [EMAIL PROTECTED] > > Astute e-business applications & web site development > > 210-490-3249/888-745-7603 Fax 210-490-4692 > > Allaire Consulting Partner/Authorized NetObjects Reseller > > Find a Job in San Antonio -> http://www.sajobnet.com > > Need professional help? -> http://www.psychadvisor.com > > = > > > > -- > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Setting Up ODBC Datasources Thru CF Administrator
> 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 the directory tree. The > hourglass icon just runs and runs. I've made sure the RDS > service is running before attempting this but no joy. To work > around this, I'm having to use the ODBC Data Source Administrator > under Win98's Control Panel to set up datasources. This sounds like a Java problem; CF Administrator uses the CFTREE Java Applet to let you browse the filesystem. You might try using a different browser, and making sure the URL path /CFIDE/classes works. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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. What's been installed / uninstalled recently? Fred - Original Message - From: "Chris Montgomery" <[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 button to go select the database file to complete the > installation, no directories ever come up in the window that is supposed > to show the directory tree. The hourglass icon just runs and runs. > I've made sure the RDS service is running before attempting this but no > joy. To work around this, I'm having to use the ODBC Data Source > Administrator under Win98's Control Panel to set up datasources. > > Could this possibly be an MDAC thang? Any suggestions on what to check? > My setup: running Studio 4.5.1 on Win98 (1st ed.), MS Access97 databases > > Chris Montgomery > = > astutia.com -> http://www.astutia.com [EMAIL PROTECTED] > Astute e-business applications & web site development > 210-490-3249/888-745-7603 Fax 210-490-4692 > Allaire Consulting Partner/Authorized NetObjects Reseller > Find a Job in San Antonio -> http://www.sajobnet.com > Need professional help? -> http://www.psychadvisor.com > = > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 ever come up in the window that is supposed to show the directory tree. The hourglass icon just runs and runs. I've made sure the RDS service is running before attempting this but no joy. To work around this, I'm having to use the ODBC Data Source Administrator under Win98's Control Panel to set up datasources. Could this possibly be an MDAC thang? Any suggestions on what to check? My setup: running Studio 4.5.1 on Win98 (1st ed.), MS Access97 databases Chris Montgomery = astutia.com -> http://www.astutia.com [EMAIL PROTECTED] Astute e-business applications & web site development 210-490-3249/888-745-7603 Fax 210-490-4692 Allaire Consulting Partner/Authorized NetObjects Reseller Find a Job in San Antonio -> http://www.sajobnet.com Need professional help? -> http://www.psychadvisor.com = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Administartor Does Not Show ODBC DataSources
Sometimes, it's a bit weird. Im not sure what the explanation is. One day I might bother to find out. Im sure they'll say it's nowt to do with them, but It's only ever happened after installing AbleCommerce... and on the same day. I'd say that's a pretty strong case. Anyway, so far Im not fussed really because it still works. Taz > Yes, I have just installed another package from them but have been using > them for two years - Do the missing databases ever show up? > > Paul Burgess > > > -Original Message- > > From: Chris Tazewell [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, April 26, 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 > > > > Taz > > > > > > > Working Ok for almost two years but now my CF Admin only shows the > > > datasources for the latest software I installed - not for all my other > > > sites! Yet all these sites are working and linking OK?! > > > I am a little scared of re-booting and possibley having to re-establish > > all > > > the links for dozens of Db's. Has this happned to anyone before? Using > > > Cf4.01 > > > > > > -- > > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Administartor Does Not Show ODBC DataSources
Yes, I have just installed another package from them but have been using them for two years - Do the missing databases ever show up? Paul Burgess > -Original Message- > From: Chris Tazewell [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 26, 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 > > Taz > > > > Working Ok for almost two years but now my CF Admin only shows the > > datasources for the latest software I installed - not for all my other > > sites! Yet all these sites are working and linking OK?! > > I am a little scared of re-booting and possibley having to re-establish > all > > the links for dozens of Db's. Has this happned to anyone before? Using > > Cf4.01 > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 CF Admin only shows the > datasources for the latest software I installed - not for all my other > sites! Yet all these sites are working and linking OK?! > I am a little scared of re-booting and possibley having to re-establish all > the links for dozens of Db's. Has this happned to anyone before? Using > Cf4.01 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Administartor Does Not Show ODBC DataSources
Working Ok for almost two years but now my CF Admin only shows the datasources for the latest software I installed - not for all my other sites! Yet all these sites are working and linking OK?! I am a little scared of re-booting and possibley having to re-establish all the links for dozens of Db's. Has this happned to anyone before? Using Cf4.01 Paul Burgess -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.