| From: | <Mamatha_Kagathi_Chan(at)DELL(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [pgadmin-support] Help for Migration |
| Date: | 2011-10-24 12:24:05 |
| Message-ID: | 89A978D5BD307B41B174E9250A8D343905A7FB@BLRX10HMBAN02.AMER.DELL.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2011-10-24 17:06:36 | Re: Query tool not open |
| Previous Message | sito-ito | 2011-10-24 08:34:34 | Re: Query tool not open |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-10-24 13:08:08 | Re: Primary key Index Error |
| Previous Message | Håvard Wahl Kongsgård | 2011-10-24 12:11:42 | Problem with newline/tab completing with psql |