<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "ODBC;DATABASE=name;UID=post;PWD=post;DSN=PostgreSQL"
ConnectionString = ConnectionString&"Driver=PostgreSQL;Server=xxx.xxx.xxx.xxx;"&"Database=name;"&"Port=5432;Uid=admin;Pwd=admin"
conn.Open connectionString
'Set adors = New ADODB.Recordset
' adors.CursorType = adOpenDynamic
' adors.LockType = adLockPessimistic
' adors.Open "name", conn, , , adCmdTable
set ddd = conn.Execute("select * from news")
do while (not ddd.eof)
response.Write"<tr>"
for index=0 to (ddd.fields.count/1)
response.write"td"&ddd(index)&"</td>"
next
response.write "</tr>"
ddd.movenext
loop
ddd.close
'adors.close
%>
라고 하면
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Could not connect to the server; Could not connect to remote socket.
/bbs/post.asp, line 6
라는 에러가 나요....
|