On 24 Oct 2011, at 14:24, <Mamatha_Kagathi_Chan@xxxxxxxx> wrote: > Hi , > > I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also successfully able to connect classic ASP to the migrated database. 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 Is that a line in a plpgsql procedure? It looks like you're trying to call a function, but your syntax is entirely wrong. You probably want to read up on: http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/PostgreSQL_x20238_004.htm Curiously enough the rather fine manual isn't very verbose on this subject. In the 9.2-devel docs there is even a section named "Calling functions", but it seems to focus on writing functions instead. Alban Hertroys -- The scale of a problem often equals the size of an ego. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
