Disappearing System DSNs?

[Jurgen Lindt]

I am trying to add ODBC System DSNs to my system, using the "Data Sources
(ODBC)" tool, in the Control Panel ---> Administrative tools under Windows
2000. When I complete adding a DSN, then click OK, the entry doesn't show
in the list!

If I check the registry or ODBC.INI file, the entries are there, but just
don't show in the "System DSN" tab. Does anyone have any ideas on this? I
don't know what to do.

Thanks.

JL

[John Bell]

Hi

I have never seen this, but it sounds like a privilege type problem,
are you on the latest/same versions of MDAC?

You can download the MDAC component checer from:

http://www.microsoft.com/data/download.htm

You may also want to consider DSN less connections which will remove
the need for any configuration.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q167294&

John

On Sat, 14 Sep 2002 04:02:33 GMT, "Jurgen Lindt" <nos...@nospam.com>
wrote:

[Jurgen Lindt]

Thanks, good suggestions. I would use DSNless connections, but the
application I'm trying to setup the DSN for, doesn't do it that way. It's a
vendor application and requires a System DSN. The MDAC version I'm using is
2.7 SP1.

JL

[John Bell]

Does the DSN dissapear if it is a user DSN? - If it does it looks like
something is not installed correctly.

Do all systems DSNs disappear for that driver even with different
names?

Conversly same name and different drivers?

If this is a file based data source what happens if the file is
located elsewhere?

John

On Sat, 14 Sep 2002 18:18:08 GMT, "Jurgen Lindt" <nos...@nospam.com>
wrote:

>Thanks, good suggestions. I would use DSNless connections, but the

[Jurgen Lindt]

"John Bell" <jrm_...@hotmail.com> wrote in message
news:87b7ouokl3u1a1oj7...@4ax.com...

> Does the DSN dissapear if it is a user DSN? - If it does it looks like
> something is not installed correctly.

No, that's the odd thing. If I setup a User DSN, it appears. If I setup a
System DSN, it goes away. I can't figure it out.

> Do all systems DSNs disappear for that driver even with different
> names?

It doesn't matter which driver I pick, they all disappear in the end when I
click OK. I would have expected it to disappear if the driver DLL didn't
exist, but I've picked random drivers and the same behaviour exists.

> Conversly same name and different drivers?

Yes, same name of connection but using different drivers.

> If this is a file based data source what happens if the file is
> located elsewhere?

I haven't tried a File DSN, will try it for test purposes.

Thanks. I may well re-install MDAC again and see what happens. With this
being a server, I want to limit the number of times it's rebooted.

JL

[John Bell]

Baffling!

The only other possiblity I can think of is registry permission or a
missing registry entry that is 'breaking the chain' so the item is not
being displayed. Do you have any system DSNs that you can compare
against?

John

On Sun, 15 Sep 2002 02:24:39 GMT, "Jurgen Lindt" <nos...@nospam.com>
wrote:

>"John Bell" <jrm_...@hotmail.com> wrote in message

[Jurgen Lindt]

> Baffling!
>
> The only other possiblity I can think of is registry permission or a
> missing registry entry that is 'breaking the chain' so the item is not
> being displayed. Do you have any system DSNs that you can compare
> against?

None, unfortunately. This is re-cycled server and there were previously no
System DSNs setup. This is (I think) the first System DSNs being added.

I think you are correct, it's a registry related problem. Maybe a setting
is corrupted. I may well re-install MDAC and hope that works. If it
doesn't - I'll use REGEDT32 and set all the registry entries to have Admin
permissions.

JL

[John Bell]

Try this:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q285654&

John

On Sun, 15 Sep 2002 17:49:51 GMT, "Jurgen Lindt" <nos...@nospam.com>
wrote:

>> Baffling!