thanks Bryan... guess this is actually a big problem Allaire has been ducking for the past 12+ months... every OS, every databases, etc. has experienced a big problem at some time with this... there is actually a long thread (9+ pages) of people's comments and anger... still no resolution...
I resolved my dilemma but upgrading to the latest MDAC (2.7) .. had a 2.5 series... also updated my MySQL ODBC driver as I was just one version behind... everything is stable now... hope it stays that way... Gave me a chance to carve out some old datasources and uninstall some software... hate the downtime, but it comes with the job. thanks! -paris -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 19:02 To: CF-Talk Subject: RE: ODBC terror... .. I should be more specific on a machine running MS SQL Server 7 you should have this as one of the entries in your Path variable (entries seperated by semicolon): C:\MSSQL7\BINN (or whatever it is on your machine) on a machine running Oracle you should have this: C:\Oracle\Ora81\bin Bryan Love Macromedia Certified Professional Internet Application Developer / Database Analyst Telecommunication Systems Inc. [EMAIL PROTECTED] "What father would hesitate to say 'if there must be trouble let it be in my day, that my child may have peace'?" - Thomas Paine, An American Crisis -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 3:55 PM To: CF-Talk Subject: RE: ODBC terror... Best guess: Someone installed something on your machine and blew out the PATH system variable. You'll probably have to recreate it. I know on Win NT you right-click My Computer, go to properties, and click the environment tab. You should have a Path variable in the SYSTEM section. I think in Win 2k it's under the ADVANCED tab (instead of the environment tab). Just a guess... Bryan Love Macromedia Certified Professional Internet Application Developer / Database Analyst Telecommunication Systems Inc. [EMAIL PROTECTED] "What father would hesitate to say 'if there must be trouble let it be in my day, that my child may have peace'?" - Thomas Paine, An American Crisis -----Original Message----- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 3:06 PM To: CF-Talk Subject: ODBC terror... So we use a bunch of different databases on one server... including ACCESS, SQL SERVER (connected to another machine) , MySQL (connected to another machine)... we have been running this for the better part of a year solid... A few days ago, the system started regularly throwing this error: Template: D:\INETPUB\WWWROOT\INDEX.CFM ODBC Error Code = () Unable to instantiate environment for 'ODBC.' what in the world causes this? Anyone know of a bug/error/best case steps for eliminate this? when it happens we have to hard reboot the server... no stopping service and restarting stuff... it is becoming way too annoying... all our other systems seem to be working fine... I am stumped. -paris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
