Invisible ODBC DSN

  • Thread starter Thread starter Jeff Mowatt
  • Start date Start date
J

Jeff Mowatt

I've been attempting to create ODBC system dsn's by editing the
odbc.ini file plus the ODBC.INI and ODBC Data Sources within my HKLM
registry section.

The ODBC is functioning but will not show in the list of DSN neither
will any other I create via odbc itself.

Have I missed something or could this be corruption?

TIA

Jeff Mowatt
 
Asked and answered two days ago.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]
 
Asked and answered two days ago.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]
 
Sorry Dave, I didn't see it before. Thought my message didn't post.

What did you mean by "get the subkey"? I'm storing the values in
hklm\software\ODBC\ODBC.INI and ODBC Data Sources as I and the
structures look the same as a system dsn created via the control
panel.

Regards,

Jeff

Dave Patrick said:
Asked and answered two days ago.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

Jeff Mowatt said:
I've been attempting to create ODBC system dsn's by editing the
odbc.ini file plus the ODBC.INI and ODBC Data Sources within my HKLM
registry section.

The ODBC is functioning but will not show in the list of DSN neither
will any other I create via odbc itself.

Have I missed something or could this be corruption?

TIA

Jeff Mowatt
Click to expand...
Click to expand...
 
Sorry Dave, I didn't see it before. Thought my message didn't post.

What did you mean by "get the subkey"? I'm storing the values in
hklm\software\ODBC\ODBC.INI and ODBC Data Sources as I and the
structures look the same as a system dsn created via the control
panel.

Regards,

Jeff

Dave Patrick said:
Asked and answered two days ago.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

Jeff Mowatt said:
I've been attempting to create ODBC system dsn's by editing the
odbc.ini file plus the ODBC.INI and ODBC Data Sources within my HKLM
registry section.

The ODBC is functioning but will not show in the list of DSN neither
will any other I create via odbc itself.

Have I missed something or could this be corruption?

TIA

Jeff Mowatt
Click to expand...
Click to expand...
 
Importing the relevant info from these keys works for me.

HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

HKLM\SOFTWARE\ODBC\ODBC.INI\
 
Importing the relevant info from these keys works for me.

HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

HKLM\SOFTWARE\ODBC\ODBC.INI\
 
Dave,

Yes, originally I obtained these values from the registry and then
deleted the ODBC dsn so that I could test the re-creation.
I must have made an error which corrupted my ODBC in some way and now
any DSN that I create is invisible.
What I need to do I guess is find a way to re-install ODBC, I tried
installing MDAC 2.5v3 but W2K blocks me, telling me it's already
installed.
Having now fixed my registry update program (Wise install)I'm
confident that I can now update the registry cleanly. But first I need
to bring ODBC back to a good state, All the entries look perfectly OK
in the registry but there is still some kind of corruption and I can't
find out where to go to fix it.

Regards,

Jeff Mowatt




Dave Patrick said:
Importing the relevant info from these keys works for me.

HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

HKLM\SOFTWARE\ODBC\ODBC.INI\

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

Jeff Mowatt said:
Sorry Dave, I didn't see it before. Thought my message didn't post.

What did you mean by "get the subkey"? I'm storing the values in
hklm\software\ODBC\ODBC.INI and ODBC Data Sources as I and the
structures look the same as a system dsn created via the control
panel.

Regards,

Jeff
Click to expand...
Click to expand...
 
Dave,

Yes, originally I obtained these values from the registry and then
deleted the ODBC dsn so that I could test the re-creation.
I must have made an error which corrupted my ODBC in some way and now
any DSN that I create is invisible.
What I need to do I guess is find a way to re-install ODBC, I tried
installing MDAC 2.5v3 but W2K blocks me, telling me it's already
installed.
Having now fixed my registry update program (Wise install)I'm
confident that I can now update the registry cleanly. But first I need
to bring ODBC back to a good state, All the entries look perfectly OK
in the registry but there is still some kind of corruption and I can't
find out where to go to fix it.

Regards,

Jeff Mowatt




Dave Patrick said:
Importing the relevant info from these keys works for me.

HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

HKLM\SOFTWARE\ODBC\ODBC.INI\

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

Jeff Mowatt said:
Sorry Dave, I didn't see it before. Thought my message didn't post.

What did you mean by "get the subkey"? I'm storing the values in
hklm\software\ODBC\ODBC.INI and ODBC Data Sources as I and the
structures look the same as a system dsn created via the control
panel.

Regards,

Jeff
Click to expand...
Click to expand...
 
Dave,

An update on this. I discovered that by deleting all system DSN's from
my registry, I can now re-create them cleanly via ODBC. My script
still fails to produce a visible entry but at least I know how to
recover from the corruption.

Regards,

Jeff
 
Dave,

An update on this. I discovered that by deleting all system DSN's from
my registry, I can now re-create them cleanly via ODBC. My script
still fails to produce a visible entry but at least I know how to
recover from the corruption.

Regards,

Jeff
 
Dave,

You are right. I had an error in my ODBC Data Sources key and that
seemed to making any valid DSN I created subsequently, invisible.

Regards,

Jeff
 
Dave,

You are right. I had an error in my ODBC Data Sources key and that
seemed to making any valid DSN I created subsequently, invisible.

Regards,

Jeff
 
Back
Top