in reply to Insert into DB problem

I'm not sure that ODBC connections allow you to specify database names in this way.

Try it without the MeterMusicTemp.. altogether, or with MeterMusicTemp fully qualified:
SERVERNAME.MusicMeterTemp.OWNER.QCStuff.

Or use a stored procedure, which would be a far more efficient way of handling this type of insert, and would save you crufting up your code with SQL.

Replies are listed 'Best First'.
Re^2: Insert into DB problem
by pjofnj (Initiate) on May 25, 2005 at 16:55 UTC
    Thanks.. Creating a proc did the job. PJOFNJ
[reply]

In Section Seekers of Perl Wisdom