Tim,
Sounds like the ColdFusion userid does not have permissions to change
the /opt/coldfusion/odbc/odbc.ini file.
CF does not throw an error when this happens (because this shouldn't
happen).
--
Tom Jordahl
Allaire Development
Tim Storm wrote:
> Update 2: It appears as though changes in the CF admin panel are not being
> saved in
> /opt/coldfusion/odbc/odbc.ini as I would assume they should be.
>
> If I manually set a datasource to the new server in the odbc.ini, it doesn't
> verify.
>
> My take on what is happening -
> for whatever reasons, when I make a change on the admin panel, it isn't
> properly updating the odbc.ini file.
> When I verify the odbc connection, it looks like it is good because it is
> verifying the old information, and not the information I just supplied.
>
> If anyone has a clue, I'm listening!
>
> Tim
> ----- Original Message -----
> From: "Tim Storm" <[EMAIL PROTECTED]>
> To: "CF-Linux" <[EMAIL PROTECTED]>
> Sent: Sunday, December 31, 2000 9:53 AM
> Subject: RE: odbc datasources not persistant across cf restarts
>
>
>
>> Update: I just tried creating a new datasource to a previously unused
>> database on the new server, and it is failing verification, but if I
>
> change
>
>> a current datasource to the new database name and server it verifies just
>> fine.
>>
>> Aha! it only looks like it changed... it evidently didn't even change to
>
> the
>
>> new server or the new database name - it couldn't have, it is still
>
> showing
>
>> information from the old datasource on that dsn.
>>
>> this sucks!
>>
>> Tim
>> ----- Original Message -----
>> From: "Tim Storm" <[EMAIL PROTECTED]>
>> To: "CF-Linux" <[EMAIL PROTECTED]>
>> Sent: Sunday, December 31, 2000 9:40 AM
>> Subject: odbc datasources not persistant across cf restarts
>>
>>
>>
>>> <reaching out through internet and placing hands firmly around Allaire's
>>
>> neck>
>>
>>> I have CF451sp2linux - on redhat 6.2
>>>
>>> Scenario 1:
>>> I have datasources verified....
>>> I delete a datasource from the coldfusion administrator admin panel
>>> I ./stop ./start
>>> Looky there! the datasource is back!
>>>
>>> Scenario 2:
>>> I have datasources verified...
>>> I change the server of a datasource from localhost to an external
>>
> machine-
>
>> it verifies
>>
>>> I ./stop ./start
>>> Looky there! the datasource is set to localhost!
>>>
>>> I've tried deleting a datasource, and recreating it... but as seen in
>>
>> datasource 1, it doesn't matter - it doesn't seem to recognize the changes
>> anyway!
>>
>>> Happy freaking new year Allaire, may you write some code in 2001 that
>>
>> doesn't require complete understanding of the internal structure of the
>> software so the user can make simple changes like a database move.....
>>
>>> and YES, I am fully ready to insert my foot in my mouth if someone can
>>
>> point the blame for this issue back at me.
>>
>>> <holding foot in hand, ready to bite>
>>>
>>> Tim Storm
>>> FatWallet.Com
>>>
>>>
>>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.