Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.
Security Community Blog

ODBC Connection on 64-Bit Operating System

Created: 18 Sep 2009 • Updated: 18 Sep 2009 • 16 comments
Mudit Kumar's picture
+4 4 Votes
Login to vote

It’s important to know which kind of DSN you are suppose to check when you are Troubleshooting ODBC Connection.

If you want to check ODBC Connection on x64 system, you can check or create an ODBC Connection(DSN) for 32 Bit application and also use it for 64 Bit application.

32-bit applications will only look for ODBC connections created in the 32-bit, and 64-bits applications will look for ODBC connections from the 64-bit. 

So if you want to configure DSN for 32-bit application on 64-Bit OS you will have to use:

1. C:\Windows\SysWOW64\odbcad32.exe(Used to check ODBC for Symantec Endpoint Protection Manager)

You want to do the same on 64-bit application on 64-Bit OS you can use:

2. C:\Windows\System32\odbcad32.exe

Note: In case of Symantec Endpoint Protection Manager installed on 64 Bit Operating System we get confused about where to locate ODBC Connection.

So it will be found under "C:\Windows\SysWOW64\odbcad32.exe"

Comments 16 CommentsJump to latest comment

Aniket Amdekar's picture

This proves to be crucial as the ODBC DSN is not usually shown in a 64 bit machine. So everybody starts wondering if there is something wrong with the ODBC Connection.

But its just the fact that the ODBC DSN is not shown in 64 bit servers unless you use the methods mentioned aove.

Nice info Mudit.

Cheers,
Aniket

+2
Login to vote
Symanticus's picture

yes, that is true and thanks for sharing.

in case for other application, I use Oracle Client 10g 32 bit inside the Windows Server 2003 x64

/* Infrastructure Support Engineer */

+2
Login to vote
blackvirus009's picture

its a bit basic question but can u tell me what is ODBC?

-3
Login to vote
Ashish-Sharma's picture
ODBC stands for Open Data Base Connectivity. It is a connection that is created to define a connection between a computer and a database stored on another system. The ODBC connection contains information needed to allow a computer user to access the information stored in a database that is not local to that computer.

 

Thanks In Advance

Ashish Sharma

 

 

+2
Login to vote
ITGal's picture

After running the odbcad32.exe what should be the settings for these tabs: ODBC, Login, ECT. I am having issues with the database service stopping and  many connection errors in the scm-server-0.log.  When I click Test  under ODBC it says "connection failed:Intragrated logins not permitted: tks

0
Login to vote
Chetan Savade's picture

Could you post scm-server-0.log. 

 

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

0
Login to vote
ITGal's picture

log attatached. Also, its probably important to note that space on the c:\ drive where sepm is located is 606 mb. It flucuates between that and 1.5 gigs. I keep having to delte temp files and I dont have the ability to partition this drive at this time.  Thanks!

AttachmentSize
scm-server-0.zip 65.25 KB
0
Login to vote
Chetan Savade's picture

Could you confirm SEPM version?

Could you run the management server configuration wizard? If possible change the database port.

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

0
Login to vote
ITGal's picture

11.0.5002.333 

0
Login to vote
ITGal's picture

What port should i change it to? Its been working, it just started doing this thing where the Symantec DB service stops and I have to manually start it back. It works fine for a bit then stops again. tks

0
Login to vote
Chetan Savade's picture

Refer this article to test the connectivity: http://www.symantec.com/connect/forums/failed-connect-database-server-sepm

 

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

0
Login to vote
ITGal's picture

Ran config wizard   Server: 8444  Web console: 9090

I would like to change the server data folder path, to make a backup. The c:\ is too small to hold the db and it errors when tring to back it up. Is that ok to do? I want to move it to a local drive on the server that has more space. I just dont want to break anything else in this process. 

I did what the artical suggested to test connectivity and get "invalid username or password" I tried several different names and combos. 

 

0
Login to vote
Manipillai's picture

Free some more space I think that should resolve the issue .

Do you have another SQL anywere program running on the Same system?

As I see you have free of 1.5 gb please also attach Carlina.out from sane log folder.

>MK

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

0
Login to vote
Manipillai's picture

Free some more space I think that should resolve the issue .

Do you have another SQL anywere program running on the Same system?

As I see you have free of 1.5 gb please also attach Carlina.out from sane log folder.

>MK

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

0
Login to vote
ITGal's picture

The carlina.out was 33mb so it was too hard to upload on here. Is there something specific for me to look for in it?  This is also the backupexe server so it is also using sql. (I think?)

0
Login to vote
Mudit Kumar's picture

Hi ITGal,

 

It seems like the credentials being used for Database connections are not correct. You will have to find that information and complete the Management Server Configuration Wizard.

Check Symantec Embedded Database Service and make sure it is started. If it is not started try starting it, reboot if possible if another option if the service does not starts normally.

Finding Database credentials is very important as you would need it.

Thanks & Regards,
Mudit Kumar
 

0
Login to vote