Discussion:
Problems with missing ODBC driver after WUT 7.5 installation
Tony Overgaard
2010-09-24 10:43:58 UTC
Permalink
Hi ARSLIST,

I have installed the Windows User Tool version 7.5 on a Windows Server
2008 64 bit OS - but unfortunately the AR System ODBC Data Source driver
is missing, so it is not possible to use ODBC driver from other sources
like Excel, SQL etc.



Nothing is found in the Windows registry, when I compare the server with
a working installation on a separate PC (not server OS and not a 64 bit
OS).

On the other PC the ODBC driver is found and working fine towards the AR
Server using AR System ODBC Data Source driver.



So my problem is to find the reason why it is not installed on the
server, and if it could be due to the 64 bit OS.



I also tried to add the ODBC entries found in Windows registry of the
working OS to the 64 bit server OS, but this did not work.

On the 64 bit server I am NOT able to find the ODBC driver, but the
crystal reports is working fine from the User Tool.



I found this information online - but this did not solve the problem
either:

============================================================

On a 64-bit Windows system the User Tool installs properly but the ODBC
driver is missing:

Follow the workaround to install the ODBC driver

The ODBC Driver that installs with the newer AR System client is still a
32 bit ODBC Driver - you have to go to C:\Windows\SysWOW64 and right
click on odbcad32.exe and run as administrator to be able to configure
the ODBC Driver.

The paths mentioned above are related to Windows Vista; the base Windows
folder on Windows 2003 might have a different name like "winnt" (i.e. in
that case, look for c:\winnt\sysWOW64\odbcad32.exe)

============================================================



Do you have any ideas of what could solve this problem?



Thanks in advance for your response.



Kind regards
Mr. Tee


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Nair, Rajesh IN BOM SISL
2010-09-24 14:44:33 UTC
Permalink
Hi
You can configure ODBC through control panel --> Administrative Tools -->Data Sources (ODBC)


Regards
Rajesh
________________________________
From: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] On Behalf Of Tony Overgaard
Sent: Friday, September 24, 2010 4:14 PM
To: ***@ARSLIST.ORG
Subject: Problems with missing ODBC driver after WUT 7.5 installation


Hi ARSLIST,

I have installed the Windows User Tool version 7.5 on a Windows Server 2008 64 bit OS - but unfortunately the AR System ODBC Data Source driver is missing, so it is not possible to use ODBC driver from other sources like Excel, SQL etc.



Nothing is found in the Windows registry, when I compare the server with a working installation on a separate PC (not server OS and not a 64 bit OS).

On the other PC the ODBC driver is found and working fine towards the AR Server using AR System ODBC Data Source driver.



So my problem is to find the reason why it is not installed on the server, and if it could be due to the 64 bit OS.



I also tried to add the ODBC entries found in Windows registry of the working OS to the 64 bit server OS, but this did not work.

On the 64 bit server I am NOT able to find the ODBC driver, but the crystal reports is working fine from the User Tool.



I found this information online - but this did not solve the problem either:

============================================================

On a 64-bit Windows system the User Tool installs properly but the ODBC driver is missing:

Follow the workaround to install the ODBC driver

The ODBC Driver that installs with the newer AR System client is still a 32 bit ODBC Driver - you have to go to C:\Windows\SysWOW64 and right click on odbcad32.exe and run as administrator to be able to configure the ODBC Driver.

The paths mentioned above are related to Windows Vista; the base Windows folder on Windows 2003 might have a different name like "winnt" (i.e. in that case, look for c:\winnt\sysWOW64\odbcad32.exe)

============================================================



Do you have any ideas of what could solve this problem?



Thanks in advance for your response.



Kind regards
Mr. Tee

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
________________________________
Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system.
Thank You.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Tony Overgaard
2010-09-24 16:17:09 UTC
Permalink
Hi Rajesh and ARSLIST,



Thank you for input from everyone.



Could it be because the BMC compatibility matrix does not support User Tool 7.5 with Windows Server 2008 in 64 bit mode, that ODBC is not working.



How do I configure AR ODBC driver from control panel > Administrative Tools > Data Sources (ODBC) - I mean how can I get a separate AR ODBC driver from BMC to configure here, if I do not get it from the User Tool installation, can this driver be downloaded from somewhere else?



Thanks in advance.



Kind regards

Mr. Tee





Fra: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] På vegne af Nair, Rajesh IN BOM SISL
Sendt: 24. september 2010 16:45
Til: ***@ARSLIST.ORG
Emne: Re: Problems with missing ODBC driver after WUT 7.5 installation



**

Hi

You can configure ODBC through control panel à Administrative Tools àData Sources (ODBC)





Regards

Rajesh

________________________________

From: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] On Behalf Of Tony Overgaard
Sent: Friday, September 24, 2010 4:14 PM
To: ***@ARSLIST.ORG
Subject: Problems with missing ODBC driver after WUT 7.5 installation



Hi ARSLIST,

I have installed the Windows User Tool version 7.5 on a Windows Server 2008 64 bit OS - but unfortunately the AR System ODBC Data Source driver is missing, so it is not possible to use ODBC driver from other sources like Excel, SQL etc.



Nothing is found in the Windows registry, when I compare the server with a working installation on a separate PC (not server OS and not a 64 bit OS).

On the other PC the ODBC driver is found and working fine towards the AR Server using AR System ODBC Data Source driver.



So my problem is to find the reason why it is not installed on the server, and if it could be due to the 64 bit OS.



I also tried to add the ODBC entries found in Windows registry of the working OS to the 64 bit server OS, but this did not work.

On the 64 bit server I am NOT able to find the ODBC driver, but the crystal reports is working fine from the User Tool.



I found this information online - but this did not solve the problem either:

============================================================

On a 64-bit Windows system the User Tool installs properly but the ODBC driver is missing:

Follow the workaround to install the ODBC driver

The ODBC Driver that installs with the newer AR System client is still a 32 bit ODBC Driver - you have to go to C:\Windows\SysWOW64 and right click on odbcad32.exe and run as administrator to be able to configure the ODBC Driver.

The paths mentioned above are related to Windows Vista; the base Windows folder on Windows 2003 might have a different name like "winnt" (i.e. in that case, look for c:\winnt\sysWOW64\odbcad32.exe)

============================================================



Do you have any ideas of what could solve this problem?



Thanks in advance for your response.



Kind regards
Mr. Tee

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

________________________________

Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system.
Thank You.

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Grooms, Frederick W
2010-09-24 17:21:46 UTC
Permalink
Do you have to use the 7.5 user tool or can you use the 7.6.03 user tool?

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] On Behalf Of Tony Overgaard
Sent: Friday, September 24, 2010 11:17 AM
To: ***@ARSLIST.ORG
Subject: SV: Problems with missing ODBC driver after WUT 7.5 installation

**
Hi Rajesh and ARSLIST,

Thank you for input from everyone.

Could it be because the BMC compatibility matrix does not support User Tool 7.5 with Windows Server 2008 in 64 bit mode, that ODBC is not working.

How do I configure AR ODBC driver from control panel > Administrative Tools > Data Sources (ODBC) – I mean how can I get a separate AR ODBC driver from BMC to configure here, if I do not get it from the User Tool installation, can this driver be downloaded from somewhere else?

Thanks in advance.

Kind regards
Mr. Tee

-----Original Message-----
Fra: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] På vegne af Nair, Rajesh IN BOM SISL
Sendt: 24. september 2010 16:45
Til: ***@ARSLIST.ORG
Emne: Re: Problems with missing ODBC driver after WUT 7.5 installation

**
Hi
You can configure ODBC through control panel → Administrative Tools →Data Sources (ODBC)


Regards
Rajesh

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] On Behalf Of Tony Overgaard
Sent: Friday, September 24, 2010 4:14 PM
To: ***@ARSLIST.ORG
Subject: Problems with missing ODBC driver after WUT 7.5 installation

Hi ARSLIST,

I have installed the Windows User Tool version 7.5 on a Windows Server 2008 64 bit OS – but unfortunately the AR System ODBC Data Source driver is missing, so it is not possible to use ODBC driver from other sources like Excel, SQL etc.

Nothing is found in the Windows registry, when I compare the server with a working installation on a separate PC (not server OS and not a 64 bit OS).
On the other PC the ODBC driver is found and working fine towards the AR Server using AR System ODBC Data Source driver.

So my problem is to find the reason why it is not installed on the server, and if it could be due to the 64 bit OS.

I also tried to add the ODBC entries found in Windows registry of the working OS to the 64 bit server OS, but this did not work.
On the 64 bit server I am NOT able to find the ODBC driver, but the crystal reports is working fine from the User Tool.

I found this information online – but this did not solve the problem either:
============================================================
On a 64-bit Windows system the User Tool installs properly but the ODBC driver is missing:
Follow the workaround to install the ODBC driver
The ODBC Driver that installs with the newer AR System client is still a 32 bit ODBC Driver - you have to go to C:\Windows\SysWOW64 and right click on odbcad32.exe and run as administrator to be able to configure the ODBC Driver.
The paths mentioned above are related to Windows Vista; the base Windows folder on Windows 2003 might have a different name like "winnt" (i.e. in that case, look for c:\winnt\sysWOW64\odbcad32.exe)
============================================================

Do you have any ideas of what could solve this problem?

Thanks in advance for y
Rodriguez, Rafael J x23718
2010-09-25 14:34:09 UTC
Permalink
NOTE: If your are on a 64bit machine you cannot configure 32bit ODBC drivers through the normal control panel --> Administrative Tools -->Data Sources (ODBC) as this will only display the 64bit ODBC drivers.

In order to configure 32bit driver you must do it from the following:

C:\Windows\SysWOW64\odbcad32.exe

HTH

________________________________
From: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] On Behalf Of Tony Overgaard
Sent: Friday, September 24, 2010 12:17 PM
To: ***@ARSLIST.ORG
Subject: SV: Problems with missing ODBC driver after WUT 7.5 installation

**
Hi Rajesh and ARSLIST,

Thank you for input from everyone.

Could it be because the BMC compatibility matrix does not support User Tool 7.5 with Windows Server 2008 in 64 bit mode, that ODBC is not working.

How do I configure AR ODBC driver from control panel > Administrative Tools > Data Sources (ODBC) - I mean how can I get a separate AR ODBC driver from BMC to configure here, if I do not get it from the User Tool installation, can this driver be downloaded from somewhere else?

Thanks in advance.

Kind regards
Mr. Tee


Fra: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] På vegne af Nair, Rajesh IN BOM SISL
Sendt: 24. september 2010 16:45
Til: ***@ARSLIST.ORG
Emne: Re: Problems with missing ODBC driver after WUT 7.5 installation

**
Hi
You can configure ODBC through control panel --> Administrative Tools -->Data Sources (ODBC)


Regards
Rajesh
________________________________
From: Action Request System discussion list(ARSList) [mailto:***@ARSLIST.ORG] On Behalf Of Tony Overgaard
Sent: Friday, September 24, 2010 4:14 PM
To: ***@ARSLIST.ORG
Subject: Problems with missing ODBC driver after WUT 7.5 installation


Hi ARSLIST,

I have installed the Windows User Tool version 7.5 on a Windows Server 2008 64 bit OS - but unfortunately the AR System ODBC Data Source driver is missing, so it is not possible to use ODBC driver from other sources like Excel, SQL etc.



Nothing is found in the Windows registry, when I compare the server with a working installation on a separate PC (not server OS and not a 64 bit OS).

On the other PC the ODBC driver is found and working fine towards the AR Server using AR System ODBC Data Source driver.



So my problem is to find the reason why it is not installed on the server, and if it could be due to the 64 bit OS.



I also tried to add the ODBC entries found in Windows registry of the working OS to the 64 bit server OS, but this did not work.

On the 64 bit server I am NOT able to find the ODBC driver, but the crystal reports is working fine from the User Tool.



I found this information online - but this did not solve the problem either:

============================================================

On a 64-bit Windows system the User Tool installs properly but the ODBC driver is missing:

Follow the workaround to install the ODBC driver

The ODBC Driver that installs with the newer AR System client is still a 32 bit ODBC Driver - you have to go to C:\Windows\SysWOW64 and right click on odbcad32.exe and run as administrator to be able to configure the ODBC Driver.

The paths mentioned above are related to Windows Vista; the base Windows folder on Windows 2003 might have a different name like "winnt" (i.e. in that case, look for c:\winnt\sysWOW64\odbcad32.exe)

============================================================



Do you have any ideas of what could solve this problem?



Thanks in advance for your response.



Kind regards
Mr. Tee
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
________________________________
Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system.
Thank You.
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

This message and any attachments are intended only for the use of the addressee and
may contain information that is privileged and confidential. If the reader of the
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Loading...