[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[cobalt-developers] Help: Need Postgres ODBC to save more than 8k

Hello,

 I am  having the problem of writing more then 8,141 bytes to my
postgres database on a Raq 4 cobalt box with chiliasp. 

Has anyone been able to wrtie more than 8k to the db through chiliasp?

Is there a limit somewhere in the chili asp config files that I can
change to get over this hurdle?

Or do I have to configure chiliasp to reference the most recent postgres
driver as well?

If so, how do I modify chiliasp to reference a new driver?
I tried doing this throught the system dsn interface but I cannot get
this to work with postgres.
I also tried a symlink from the chiliasp driver to odbc driver that came
with postgres 7.2.3

The following is the error I get when I to submit more then 8 k:

error '80004005' 


........../testTextfield.asp, line 24 


At first I thought it was the postgres database version, so I
successfully installed a second instance of postgres (version 7.2.3). I
can now successfully write more than 8k to the db through the psql
command interface. I also have linked pgadmin II to the db and again can
write more than 8k though a tcp/ip connection.

Any help in resolving this issue is appreciated

the following is the code I am testing this issue with:
<%
'strConnect = "dsn=testdb"
strConnect =
"Driver={PostgreSQL};Server=localhost;Port=9999;Database=testdb;UID=x;PW
D=x"
set conn = server.createObject("ADODB.connection")
conn.open strConnect

function addrNull(strField)
   if strField = "" then
      addrNull = "null"
   else
      addrNull = "'" & strField & "'"
   end if
end function
function quoteFixer(strField)
   if InStr(strField, "'") > 0 then
     quoteFixer = Replace(strField, "'", "''") 
   else
     quoteFixer = strField
   end if
end function

if request.form("state") = "update" then
      sqlStr = "update text_test set text_field='" &
quoteFixer(request.form("content")) & "' where test_id = 1"
      conn.execute(sqlStr)
      response.write("<p align=center>Your site has been updated!</p>")
      conn.CommitTrans
end if	
set rsTest = conn.Execute("SELECT * FROM text_test where test_id=1")
%>
<html>
<body>
My Postgres Test
<form action="textfieldTest.asp" name="test" method="post">
<textarea name="content" rows=10
cols=80><%=rsTest("text_field")%></textarea>
<input type="hidden" name="myid" value="<%=rsTest("test_id")%>">
<input type="hidden" name="state" value="update">
<br>
<input type="submit" value="go">
</form>
</body>
</html>


Regards,
Michael Aldor