Member Avatar for Regie

I have a problem with my asp script that used to insert a data to postgreSQL database.This is the script :


<%
Dim sConnection, objConn , objRS ,sql

sConnection ="DRIVER={postgreSQL};SERVER=localhost;database=sury a;UID=postgres;PASSWORD=admin;port=5432"

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open(sConnection)

sql="insert into test(number,name) values('3','abcd')"
set objRS = objConn.execute(sql)

objRS.close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

<html>
<body><a href="Laporan Pengaduan.asp">Go</a></body></html>


I've create the form that submit into this script and that script definitly right,but this script always CANNOT BE DISPLAYED.Surely my database is working well, and i could insert the data straightly into postgreSQL.Someone please help me

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by oscarsierra
Member Avatar for oscarsierra

Suppose this line after the query will help Conn.Execute (SQL)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.