Hi,
i have just migrated a DB from MSSQL to MySQL. but the script i use to populat the DB
is not working now. I use a simple routine to
transfer data from a .csv file to a DB table
while ((not rs.eof))
rs2.addnew
for i=0 to rs.fields.count-1
rs2(i) = rs(i)
next
rs2.update
rs.movenext
wend
Where "Rs" is the .csv and "Rs2" is the MySQL DB. when i execute the script i get the
following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if
available. No work was done.
/import.asp, line 109
I've never used MySQL as a database. Could my problem be comming from the connection
str?
Driver={MySQL};SERVER=XXXX;OPTIONS=;PORT=3306;DATABASE=XXXX;UID=XXXX;PWD=XXXX;
Should i have a perticular value in the OPTION property?
Cheers,
Tim
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
