native error 2812 sqlstate 42000

[Balasubramanian]

i migrated my application (MS Sqlserver 2000 and vb6.0) to a new
system. and i am getting the blow error message in new system but the
old system is working fine without doing any changes.

Description
NativeError 2812
Number -2147217900
Source
SQLState 42000

Method '~' of object '~' failed

I'm missing something because I'm getting
this error when my app runs it's first stored proc:

my connection string is
Provider=SQLOLEDB.1;Extended Properties="""uid=" + str_username
+ ";pwd=" + str_password
+ ";server=" + str_servername
+ ";database=" + str_dbname + """

[Balasubramanian]

Thanks in advance
bala