Coldfusion 9 - DSNs going missing

[Guest]

Hi

Recently we are having DSNs disappear from Coldfusion Admnistrator, the problem is intermittent and only affects a few DSNs at a time. Can anyone offer any advice? We have R1Soft Enterprise backups on the server so we could restore backups, but I am having difficulty finding documentation on the process to correctly restore DSNs on a server.

This is a production webserver with Plesk 10.4.4 control panel.

Server Details
Server Product	ColdFusion
Version	9,0,1,274733
Edition	Standard
Operating System	Windows Server 2008 R2
OS Version	6.1
Adobe Driver Version	4.0 (Build 0005)

Many thanks

[Kaif_Akbar]

Hi,

Which database have you connected through CF datasource? Give database name & version.

Which CF datasource driver(database specific or other driver),  are you using there?

Have you made any changes on the server, after which you started getting this behavior?

Regards,

Kaif Akbar

[Guest]

Hi Kaif

The problem has occured with both MySQL and Access databases, some had been created months or years previously.