Updatable Recordsets for MySQL and Chilisoft ASP running on a Linux server
Sam Wells
connecting to MySQL version 3.23.54 on a Linux web server.
Before dismissing this out of hand as a Chilisoft problem please read on.
I have read all the documentation I can find on the subject but without
success. The UseCursorLib=1 exists in ODBC.INI file and the connection
string but the ASP script below always returns the following error.
ADODB.Recordset.1 error '80004005'
Recordset is read-only
------------------------------------------------------------
connstring =
"driver={MySQL};server=localhost;uid=example;pwd=example;database=mydb;optio
n=NUM;UseCursorLib=1"
set c=server.CreateObject("adodb.connection")
set temp = server.CreateObject("adodb.recordset")
c.ConnectionString = connstring
c.ConnectionTimeout=60
c.Open
temp.ActiveConnection=c
temp.source="select id,tmp from test where id=1"
temp.LockType = 3
temp.cursortype = 3
temp.open
temp("tmp")="the quick brown fox."
temp.update
------------------------------------------------------------
The database isn't readonly because i can use the .execute method to run a
SQL update statement successfully.
The reason why it is required is that it makes handling long BLOB data a lot
easier. Especially updating long BLOB data.
Please could you provide minimum version levels and configuration settings
that might enable this to work.
thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=myo...@freebsd.csie.nctu.edu.tw
Sam Wells
------------------------------------------------------------
thank you
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=myo...@freebsd.csie.nctu.edu.tw
Sam Wells
------------------------------------------------------------
thank you
To unsubscribe: http://lists.mysql.com/myodbc?unsub=m...@news.fjtc.edu.tw
Venu
What is your Connector/ODBC version ? and what was the 'NUM' value in
the above connection string ? Is that 'tmp' field is long blob ? I tried
the same thing from VB-ADO, and it just worked fine.
Thanks
>
> The reason why it is required is that it makes handling long BLOB data a lot
> easier. Especially updating long BLOB data.
>
> Please could you provide minimum version levels and configuration settings
> that might enable this to work.
>
> thank you
>
>
>
>
>
>
--
Regards, Venu
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <ve...@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA
<___/ www.mysql.com
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=myo...@freebsd.csie.nctu.edu.tw
Venu
Venu
--