|
|
Welcome to Vista Banter. You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to ask questions and reply to others posts, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact support. |
|
|||||||
| Performance and Maintainance of Windows Vista A forum for performance and maintenance tasks in Windows Vista. (microsoft.public.windows.vista.performance_maintainance) |
|
|
LinkBack | Thread Tools | Display Modes |
March 27th 09, 10:45 AM
posted to microsoft.public.windows.vista.performance_maintenance
|
|||
|
|||
Vista64 Perfrom - Data collector output to local SQL
Hi all,
I am running Vista 64. I want to record performance monitoring to a local instance of SQL Express 2008. So, I created a database in SQL and made my Windows login the owner. Created a System DSN using the SQL Server Native Client 10.0, and it tested OK. I have created a data collector set and configured the performance counter to output to the SQL DSN. The collector set is "Run As" my Windows login, which is part of the local Admins group. When I start the collector set I get: When attempting to start the Data Collector Set the following system error occurred: Call to SQLExecDirect Failed with %1. The even 3042 doesn't provide an more information. I can get this working on XP 32 bit using the standard SQL Server ODBC driver, but when I try to use it on the Vista 64 machine it chucks up error 198 (Could not load the set up or translator library). If I run ODBC from syswow64 then I can create the ODBC System DSN but it doesn't get picked up by Pefrmon. What gives? This is annoying. Any workarounds to this problem? Anyone been able to output Perfmon data to SQL on a Vista 64 bit machine? TIA, Jarryd 
|
|
March 27th 09, 10:58 AM
posted to microsoft.public.windows.vista.performance_maintenance
|
|||
|
|||
|
Vista64 Perfrom - Data collector output to local SQL
By the way, it creates the tables in the SQL database, but it doesn't seem
to be able to write to them. What more should I need to do? Can this be an SQL problem if it can create tables? TIA, Jarryd "Jarryd" wrote in message ... Hi all, I am running Vista 64. I want to record performance monitoring to a local instance of SQL Express 2008. So, I created a database in SQL and made my Windows login the owner. Created a System DSN using the SQL Server Native Client 10.0, and it tested OK. I have created a data collector set and configured the performance counter to output to the SQL DSN. The collector set is "Run As" my Windows login, which is part of the local Admins group. When I start the collector set I get: When attempting to start the Data Collector Set the following system error occurred: Call to SQLExecDirect Failed with %1. The even 3042 doesn't provide an more information. I can get this working on XP 32 bit using the standard SQL Server ODBC driver, but when I try to use it on the Vista 64 machine it chucks up error 198 (Could not load the set up or translator library). If I run ODBC from syswow64 then I can create the ODBC System DSN but it doesn't get picked up by Pefrmon. What gives? This is annoying. Any workarounds to this problem? Anyone been able to output Perfmon data to SQL on a Vista 64 bit machine? TIA, Jarryd
|
Linear Mode
