Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

odbcad32.exe doesn't open

Posted on 2013-01-13
14
Medium Priority
?
415 Views
Last Modified: 2013-02-19
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
Comment
Question by:ChoateSolutions
  • 5
  • 4
  • 2
  • +2
14 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 38773182
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
 
LVL 20

Expert Comment

by:Marten Rune
ID: 38773716
What does the windows system and application log say when you try to open the ODBC?

Regards Marten
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 38773755
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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:ChoateSolutions
ID: 38894172
I've requested that this question be deleted for the following reason:

No suitable answers. Still having the same problem.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 38877260
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
 

Author Comment

by:ChoateSolutions
ID: 38877286
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
 
LVL 35

Expert Comment

by:David Todd
ID: 38877335
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
 

Author Comment

by:ChoateSolutions
ID: 38877339
David, sorry answered wrong.  User is part of the Administrator group. It's a standalone server in our DMZ.
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 2000 total points
ID: 38877367
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
 

Author Comment

by:ChoateSolutions
ID: 38877437
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
 
LVL 38

Expert Comment

by:Jim P.
ID: 38887458
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
 
LVL 38

Expert Comment

by:Jim P.
ID: 38894173
Gary,

I'm going to post an objection to the deletion as you haven't told us if this worked.
0
 

Author Comment

by:ChoateSolutions
ID: 38906520
jimpen, my developer has verified my manual fix worked.

Thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

971 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