Endpoint Protection

 View Only

ODBC Connection on 64-Bit Operating System 

Sep 18, 2009 06:28 PM

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"

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Aug 28, 2014 01:46 AM

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.

Aug 04, 2014 04:31 PM

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?)

Aug 02, 2014 08:13 PM

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.

Aug 02, 2014 08:13 PM

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.

Aug 01, 2014 04:35 PM

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. 

 

Aug 01, 2014 04:05 PM

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

Aug 01, 2014 04:03 PM

11.0.5002.333 

Aug 01, 2014 03:53 PM

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

 

Aug 01, 2014 03:48 PM

Could you confirm SEPM version?

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

Aug 01, 2014 03:36 PM

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!

Aug 01, 2014 02:56 PM

Could you post scm-server-0.log. 

 

Aug 01, 2014 02:24 PM

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

Aug 23, 2012 04:09 AM

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.

 

Aug 23, 2012 03:17 AM

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

Sep 20, 2009 08:42 PM

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

Sep 19, 2009 05:14 AM

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

Related Entries and Links

No Related Resource entered.