Auditing using WinAudit

[m***@gmail.com]

Hello:

I'm using WinAudit to audit 4000 machines in my district. I'm trying
to audit it using an SQL db. I don't want to have to use a File DSN,
but if I have to I will. I've tried the command line
winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
;DATABASE=<database>; /l=log.txt

But checking the log, I error out with an application error. Anyone
else having this problem that might be using WinAudit?

[S Moran]

im curious... when you saw that the name of this group was VBSCRIPT, what
made you continue to post?

Post by m***@gmail.com
I'm using WinAudit to audit 4000 machines in my district. I'm trying
to audit it using an SQL db. I don't want to have to use a File DSN,
but if I have to I will. I've tried the command line
winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
;DATABASE=<database>; /l=log.txt
But checking the log, I error out with an application error. Anyone
else having this problem that might be using WinAudit?

[m***@gmail.com]

Post by S Moran
im curious... when you saw that the name of this group was VBSCRIPT, what
made you continue to post?

Post by m***@gmail.com
I'm using WinAudit to audit 4000 machines in my district. I'm trying
to audit it using an SQL db. I don't want to have to use a File DSN,
but if I have to I will. I've tried the command line
winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
;DATABASE=<database>; /l=log.txt
But checking the log, I error out with an application error. Anyone
else having this problem that might be using WinAudit?- Hide quoted text -

- Show quoted text -

Because there is a thread in this newsgroup that references
WinAudit. And since that thread was active (last reply June 2nd) I
was hoping that those who posted would read this post and then I could
bring it offline. And then, on top of that, I Was hoping to
transition this into vbscript for logons.

So, next time you want to chastise me for posting to this newsgroup, I
would appreciate it that you ask me offline and not in the usenet
group so you don't look like an ass.

[S Moran]

you should make yourself clear then. you should have explained all of that
in your original post then maybe YOU wouldnt have looked like the ass.

Post by m***@gmail.com

Post by S Moran
im curious... when you saw that the name of this group was VBSCRIPT, what
made you continue to post?

Post by m***@gmail.com
I'm using WinAudit to audit 4000 machines in my district. I'm trying
to audit it using an SQL db. I don't want to have to use a File DSN,
but if I have to I will. I've tried the command line
winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
;DATABASE=<database>; /l=log.txt
But checking the log, I error out with an application error. Anyone
else having this problem that might be using WinAudit?- Hide quoted text -

- Show quoted text -

Because there is a thread in this newsgroup that references
WinAudit. And since that thread was active (last reply June 2nd) I
was hoping that those who posted would read this post and then I could
bring it offline. And then, on top of that, I Was hoping to
transition this into vbscript for logons.
So, next time you want to chastise me for posting to this newsgroup, I
would appreciate it that you ask me offline and not in the usenet
group so you don't look like an ass.

[m***@gmail.com]

Post by S Moran
you should make yourself clear then. you should have explained all of that
in your original post then maybe YOU wouldnt have looked like the ass.

Post by m***@gmail.com

Post by S Moran
im curious... when you saw that the name of this group was VBSCRIPT, what
made you continue to post?

I'm usingWinAuditto audit 4000 machines in my district. I'm trying
to audit it using an SQL db. I don't want to have to use a File DSN,
but if I have to I will. I've tried the command line
winaudit/r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
;DATABASE=<database>; /l=log.txt
But checking the log, I error out with an application error. Anyone
else having this problem that might be usingWinAudit?- Hide quoted
text -

- Show quoted text -

Because there is a thread in this newsgroup that references
WinAudit. And since that thread was active (last reply June 2nd) I
was hoping that those who posted would read this post and then I could
bring it offline. And then, on top of that, I Was hoping to
transition this into vbscript for logons.
So, next time you want to chastise me for posting to this newsgroup, I
would appreciate it that you ask me offline and not in the usenet
group so you don't look like an ass.- Hide quoted text -

- Show quoted text -

I could continue this "debate" of who's an ass or not, but honestly I
don't care. I asked for help, and you've provided nothing. So I
appreciate it. Really. I do. Now if you don't have anything
constructive to say, I'd appreciate you not continuing this thread.
Thanks.

[mycow]

Post by m***@gmail.com
I'm using WinAudit to audit 4000 machines in my district. I'm trying
to audit it using an SQL db. I don't want to have to use a File DSN,
but if I have to I will. I've tried the command line
winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
;DATABASE=<database>; /l=log.txt
But checking the log, I error out with an application error. Anyone
else having this problem that might be using WinAudit?

I'll provide you some help.... I tried your command and got the same
Application Error.

When I included the string "PWD=;" in the connection string it worked.

Even if your password is blank you still have to provide the definition in
your connection string.

Also, the user you logon with must have CREATE TABLE privileges if the table
WinAudi2 is missing or if the table has already been created then the user
must have SELECT and INSERT privileges.