Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hey at all,

i've got a problem with Sybase10 on an Server2008 R2 Std. I want to use the windows performance monitor and the performance Counters of Sybase 10. Sybase run as service with system privileges.

When i run dbsrv10 directly from command box (cmd > dbsrv10) and then starting the perfmon then its no problem and then I see the indicators, such as the bottom of the image

i also tested to re-register the dbtrs10.dll (SQL Anywhere Perf Counter) and go to regedit under [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQL_Anywhere_10\Performance] an create a new DWORD

Name: Disable Performance Counters value = 0

I've testet it with Sybase 10 on Server2008, (not working) Vista (not working), Win 7 (not working), XP (it works)

with Sybase 16 on Server 2008 (it works), Windows 8 (it works)

An Example for Sybase 16 (i need this for Sybase 10) alt text

any ideas to fix this?

asked 16 May '14, 10:44

pmiller's gravatar image

pmiller
206162024
accept rate: 37%

Are you using a 32-bit or 64-bit engine?

(16 May '14, 11:04) Volker Barth

Hello again. it's not an Windows or an Sybase Problem. When you are using a deployment-tool or installer like "Wise Installer" or "Install Shield" check up your current installer version. It might be a problem using the 64-bit cmd shell because when you open cmd in 64bit you also use regsvr32 in 64bit mode. Solution: call regsvr32 from sysWOW64 so the cmdshell is started as 32-bit cmd shell and the regsvr32 will be also 32bit.

this is only when you are using an deployment tool or installer, if you try it manually it works with no problems in 32 and 64bit

permanent link

answered 24 May '14, 05:41

pmiller's gravatar image

pmiller
206162024
accept rate: 37%

I guess I have found the error... it's on 64 bit (the regsvr32.exe in 64Bit not works correctly)

When we install Sybase 10 64bit on Server 2008 64Bit there is no value in "cmd > regedit" HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQL_Anywhere_10_64Bit

The engine ist registered as service and its startet but no entry in "cmd > PerfMon"

Solution:

I register the dll with 32-Bit regsvr (on the 64-Bit Machine) C:\Windows\SysWOW64\regsvr32.exe C:\Sybase10x64\x64\dbctrs10.dll

Then i restart the Sybase10-service

it works.

permanent link

answered 19 May '14, 04:37

pmiller's gravatar image

pmiller
206162024
accept rate: 37%

edited 19 May '14, 04:38

Your results would indicate, to me, that you are running a 32bit dbsrv10 service but a 64bit dbsrv10 from the cmdprompt.

(20 May '14, 10:51) Nick Elson S...

the regsvr32.exe in 64Bit not works correctly

What do you mean by that?

AFAIK, you do not really need to call the appropriate bitness of regsvr32.exe for your DLL - if you call the wrong one, it will spawn the correct one and that will register the DLL. Cf. that article:

http://www.differentpla.net/content/2008/10/things-i-learnt-week-regsvr32exe-windows-x64

Therefore it's only important to specify the desired DLL to register, and in your sample you have registered the DLL from the \x64 SA subfolder so it should be the 64-bit DLL... (and if that has been successful, the 64-bit version of regsvr32.exe must work properly:))

(20 May '14, 11:07) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×275
×10

question asked: 16 May '14, 10:44

question was seen: 3,172 times

last updated: 24 May '14, 05:41