Hi ,
I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also successfully able to connect classic ASP to the
migrateddatabase. But when the page reaches a stage where it is accessing a procedure I get the following error.
PostgreSQL Native Provider error '80040e14'
ERROR: syntax error at or near "' 789500'" LINE 1: EXEC Visadetailinsert ' 789500','No','Select visa','','','Se... ^
/postgresql/EmployeeDetails.asp, line 645
Where as the object is in valid state when seen from Pgadmin.
Kindly advice what I should check next to resolve this issue.
Thanks,
Mamatha