• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

odbcad32.exe doesn't open

Hello,

I have a Windows Server 2003 Web Edition.   I'm trying to open the ODBC to add a new DSN but it doesn't open.

Whether I open it via the Icon or command line, nothing happens.  No error is shown.  



Thanks.
Gary
0
ChoateSolutions
Asked:
ChoateSolutions
  • 5
  • 4
  • 2
  • +2
1 Solution
 
Jim P.Commented:
It that the 32 or 64 bit edition of 2003?

If it is the 64 bit then you have to run the odbcad33 from the syswow directory.
0
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
What does the windows system and application log say when you try to open the ODBC?

Regards Marten
0
 
Eugene ZCommented:
check if you have latest Win service pack:  
How to obtain the latest service pack for Windows Server 2003
http://support.microsoft.com/kb/889100

check your server event viewer for related to this activity logs : sys apps
Reboot if you can ..a

Run anti virus - just in case..

please tell more about " "the Icon or command line"
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
ChoateSolutionsAuthor Commented:
I've requested that this question be deleted for the following reason:

No suitable answers. Still having the same problem.
0
 
David ToddSenior DBACommented:
Hi,

Silly question, but are you a member of the local administrators group?

Even power user isn't enough, although in that case from memory it does open.

Do you actually have the applet? Have you tried navigating to the appropriate windows directory and open the applet itself and not via a shortcut?

Regards
  David
0
 
ChoateSolutionsAuthor Commented:
Hi David,   The user is a domain admin user.  I've tried every way of opening it up. View windows explorer or command window access.


jimpen: This is a remote client so most of these fixes I can't do as it requires console access which I don't have nor the assistance.  I'm looking at trying to just rebuild a server and replace it with that one.

Gary
0
 
David ToddSenior DBACommented:
Hi Gary,

I suggest that you check that the server is a member of the domain, and domain admins are members in the local admin group.

Regards
  David
0
 
ChoateSolutionsAuthor Commented:
David, sorry answered wrong.  User is part of the Administrator group. It's a standalone server in our DMZ.
0
 
Jim P.Commented:
Can you get something like webex or teamviewer to access the system?

Another option to add an ODBC call is via a registry file.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
"MyODBCCall"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MyODBCCall]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="ServerName\\InstanceName"
"QuotedId"="No"
"AnsiNPW"="No"
"Database"="MyDBName"
"AutoTranslate"="No

Open in new window


Save it as MyODBCCall.reg and then you can just double click on it to add it in.

Note: This one was done on a 64 Bit PC. If it is a 32 bit machine remove the Wow6432Node from the key lines.
0
 
ChoateSolutionsAuthor Commented:
Ugh, thanks jimpen.  Tried to complex things and have did what you suggested.  Well I actually exported a few others that are there with similar info and change the data and imported them.

I've contacted the web developer and he is going to test it.  Will let you know.

Gary
0
 
Jim P.Commented:
Gary

Did this work or not?

If you need more time before you can test it, we can put in a request to stop the deletion. That way you don't have to start from zero.
0
 
Jim P.Commented:
Gary,

I'm going to post an objection to the deletion as you haven't told us if this worked.
0
 
ChoateSolutionsAuthor Commented:
jimpen, my developer has verified my manual fix worked.

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 5
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now