Solved

Where are ODBC settings stored?

Posted on 1998-05-18
18
10,798 Views
Last Modified: 2013-12-29
Most of the ODBC settings can be found in the registry under the Software/ODBC/ODBC.INI branch.  However, the Network Library setting is not stored there.  Where is this stored?
0
Comment
Question by:jsullivan
  • 8
  • 7
  • 2
  • +1
18 Comments
 

Expert Comment

by:epoulsen
ID: 1713103
Just a shot in the dark...
I believe this is stored in WIN.INI under the [SQLSERVER] section under a statment
DATABASE=X,Y
Where X is the Network Library and Y is the name of the database.  I don't believe this information is stored in the Registry...I scanned my own registry and I don't see any of my network libraries referred to there.
0
 

Author Comment

by:jsullivan
ID: 1713104
I checked my WIN.INI and I don't see the Network Library info in there.  I also checked ODBC.INI and ODBCINST.INI and couldn't find the info in there either.  Any other ideas?
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713105
Are you sure you're using the 32 bit version of ODBC Admin.  If your changes are
being made in files (odbc.ini, odbcinst.ini) then you are using the wrong version, and won't
see the database.

Note, If this answer does not work, either reject it or comment back.
I'm here to solve your problem and will gladly work with you until
you are satisfied.
It's your page.
Please don't accept or grade until you problem is solved as that will
lock out other techs.
You're under no time limit or restrictions.
Regards,
Bud
0
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

Author Comment

by:jsullivan
ID: 1713106
Yes, I'm definitely using the 32-bit Administrator.  Apparantly it maintains the INI files like the 16-bit version does, probably for backward compatability.

I'm not quite sure what you mean about grading or not grading an answer.  I thought that I had to either grade an answer or reject it.  I'll submit this response without a grade.
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713107
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713108
I mean you don't have to grade this now, nor do you have to accept my answer.
in fact, if I were you I would open this up to other techs by rejecting this answer.

If you're using full 32bit. i don't have the answer but it may be in on of the URL's i posted.

look at them.

Bud
0
 

Author Comment

by:jsullivan
ID: 1713109
Thanks for your suggestions, but I couldn't find the answer to my question on any of those web pages.  I still don't know where ODBC stores the Network Library info.

I'm going to open this question back up now to see if anyone else knows.
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713110
From reading the newsgroups I get the feelimg that they are stored in a .dll file.
How, I've no idea.

Bud
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713111
Your using EASYSOFT?

Go read
http://search.dejanews.com/query_profile.xp?query=ODBC+files&nofilt=1

many questions and answers.
0
 

Author Comment

by:jsullivan
ID: 1713112
No, I'm not using EasySoft - don't even know what that is.  The ODBC data source I'm talking about is a SQL Server data source.  I'd like to programatically set the Net Library for that data source if I can figure out where to do that.
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713113
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713114
1.Log in to the machine you are protecting as the machine or domain administrator. Using regedt32.exe, take ownership
of the following key:

HKEY_LOCAL_MACHINE\
SOFTWARE\
ODBC\
ODBC.INI

2.Set the value "Trace" to "0". The "Trace" value can be found under the following registry key:

HKEY_LOCAL_MACHINE\
SOFTWARE\
ODBC\
ODBC.INI\
ODBC

3.Set the value "TraceDll" to an empty string. The "TraceDll" value can be found under the following registry key:

HKEY_LOCAL_MACHINE\
SOFTWARE\
ODBC\
ODBC.INI\
ODBC

4.Set the permissions for "Everyone" to READ on the "ODBC" key.
5.Remove explicit permissions on the "ODBC" key for any non-administrative users.

For each user, there is a registry file. This file is named %SYSTEMROOT%\profiles\username\ntuser.dat. These files can be
loaded into regedt32.exe using the Registry | Load Hive menu command.

1.Make the HKEY_USERS window active, and click on HKEY_USERS. Using the "Load Hive" command on the "Registry"
menu, find the appropriate hive. When prompted for the key name, use the username you are editing.
2.Take ownership of the key ODBC and its subkeys as was done in the preceding steps. The key will be found in the
following location

HKEY_USERS\
username\
SOFTWARE\
ODBC\
ODBC.INI\
ODBC

3.Set the value "Trace" to "0". The "Trace" value can be found under the following registry key:

HKEY_LOCAL_MACHINE\
username\
SOFTWARE\
ODBC\
ODBC.INI\
ODBC

4.Set the value "TraceDll" to an empty string. The "TraceDll" value can be found under the following registry key:

HKEY_LOCAL_MACHINE\
username\
SOFTWARE\
ODBC\
ODBC.INI\
ODBC

5.Set the permissions for "Everyone" to READ on the "ODBC" key.
6.Remove explicit permissions on the "ODBC" key for any non-administrative users.
7.Unload the hive you just loaded.

The preceding steps secured currently existing registry keys. When creating new users, the 6 steps above need to be
followed.
0
 

Author Comment

by:jsullivan
ID: 1713115
Thanks for you efforts, I've already seen this article.  Unfortunately, as I mentioned earlier, the NetLib info is not in the Software\ODBC branch of the Registry.

I'm not trying to do anything with security, I just want to be able to set the NetLib for our data source programatically.

I have checked into some of the ODBC newsgroups and I have left a message out there with my question.
0
 
LVL 14

Expert Comment

by:smeebud
ID: 1713116
Sorry I can't be more help.

Bud
0
 

Author Comment

by:jsullivan
ID: 1713117
Thanks again for trying.  I do appreciate it.  I'll keep searching through the newsgroups for the answer.
0
 
LVL 2

Accepted Solution

by:
tbaffy earned 100 total points
ID: 1713118
Try this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SQLServer\Client\ConnectTo
DSQUERY

Tom
0
 

Author Comment

by:jsullivan
ID: 1713119
Thank You!!  At first I didn't find it because you had a typo in the key name.  It's actually "MSSQLServer" and not just "SQLServer".

It looks like DSQuery is set to your default Network Library (the one you set up in the Client Configuration utility).  However, if you put a specific Net Library in your ODBC data source, a new key is added.  For example, if you specify a server name of LEGAL and a net lib of DBMSSOCN, a new key will be added: LEGAL=DBMSSOCN,LEGAL

Thanks again for solving this for me.
0
 
LVL 2

Expert Comment

by:tbaffy
ID: 1713120
Sorry about the typo, glad to help!

Tom
0

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question