Re: Performance Monitor / Database Storage using ODBC

Andrew,

I tried csv, tsv, blg and circular blg...it doesn't make any difference.
Still the ' error.

Any other possibilities ?

Xavier

"Andrew J. Kelly" wrote:

What type of file are you using to log to, Binary? All I can think of is to
try different file types to see if there is one that works better with ODBC.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"PetitGosaimass" <PetitGosaimass@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@xxxxxxxxxxxxxxxx
Andrew,

thank you for this answer.
Yes, I log striaght into SQL Server from Perfmon.

Following your advice, I used relog, but unfortunately, the same problem
occurs when it tries to insert the CounterDetail line with the containing
the
quote mark.
Same problem as with the Performance Monitor. Same ODBC Problem I guess
regarding quotation mark and quoted identifiers.

You will find below the SQL Batch and the error caught in the SQL Profiler

Any other workaround ?

Xavier


SQL Error
Exception : Error: 105, Severity: 15, State: 1
USer Error Message : Ouvrez les guillemets après la chaîne de caractères
',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
AddCounterDetails'.
SQL Batch
begin transaction AddCounterDetails insert into CounterDetails values
('\\MyServer','Disque physique','Long. moy. de file d'attente du
disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select @@Identity
commit
transaction AddCounterDetails

"Andrew J. Kelly" wrote:

Are you logging directly from Perfmon to SQL Server? If so try logging to
a
file first and then using Relog to load to a table. I am not sure if this
will matter or not since they both use ODBC but there may be a slight
difference in the way Relog works over Perfmon when connecting.

relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
SQL:YourDSN!YourDescriptor

Type relog.exe /? for details on the commands.


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"PetitGosaimass" <PetitGosaimass@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:A61547C7-2655-4B44-99B1-F44C102A3380@xxxxxxxxxxxxxxxx
Hello,

i am trying to to store some performance monitor counters into a SQl
Server
Database (SQL 2005 Std, on a W2K3 cluster environment).

It seems to be working, using an ODBC Datasource with the SQLServer
driver
(th native client is not compatible with an odbc feature according to a
message in the event viewer).

But, it cannot return on Physical Disk Queue Length. And the reason
seams
quite simple : my server is French...thus there is a quote in "Longueur
de
file d'attente", which produces this error. Same problem with any other
counter that includes a quote ' in its name.

And it doesn't seem that the performznce monitor sends tsql batch using
quotes, which would have help with the quoted_identifiers ON.

Do you have any work around for this problem ?

Thank you very much

X.M.





.

Relevant Pages

  • Re: Performance Monitor / Database Storage using ODBC
    ... Andrew J. Kelly SQL MVP ... try different file types to see if there is one that works better with ODBC. ... >>> counter that includes a quote ' in its name. ...
    (microsoft.public.sqlserver.tools)
  • Re: Performance Monitor / Database Storage using ODBC
    ... All I can think of is to try different file types to see if there is one that works better with ODBC. ... I log striaght into SQL Server from Perfmon. ... Following your advice, I used relog, but unfortunately, the same problem ... occurs when it tries to insert the CounterDetail line with the containing the ...
    (microsoft.public.sqlserver.tools)
  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... is not less complicated than ODBC and ties the user to a single ...
    (comp.lang.c)
  • Re: Quick primer on Unidata-to-SQL Server Connectivity?
    ... but creating a view and then running an SQL query with more than one ... but somewhat extensive experience with UniData SQL. ... until some things improved in UniData ODBC. ...
    (comp.databases.pick)
Loading