What db?  If it is sql server, make sure you are specifying your
database or username as well, like this:
$SqlStatement = "insert into [db].[username].[ELM](HOSTNAME,EVENTID)
values
'$myserver',$eid)";
        if ($db->Sql($SqlStatement)){
            print "SQL failed.\n";

- jason scott gessner
    [EMAIL PROTECTED] 


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:perl-win32-admin-admin@;listserv.ActiveState.com] On Behalf Of
Veeraraju_Mareddi
Sent: Wednesday, October 23, 2002 6:17 AM
To: [EMAIL PROTECTED]
Subject: Win32::ODBC error


$SqlStatement = "insert into ELM(HOSTNAME,EVENTID) values
'$myserver',$eid)";
        if ($db->Sql($SqlStatement)){
            print "SQL failed.\n";

This is giving a error Invalid object name 'ELM'

This SQL statement is not giving any error ,when i execute this in SQL
query
manager.


Please suggest .

Thanks

-Rajuveera
************************************************************************
** 
This email (including any attachments) is intended for the sole use of
the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
distribution or forwarding of any or all of the contents in this message
is
STRICTLY PROHIBITED. If you are not the intended recipient, please
contact
the sender by email and delete all copies; your cooperation in this
regard
is appreciated.
************************************************************************
**
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to