Try generating "INSERT" statements and executing them.
--
-----------------------------------------------------------------------
Michael J. Ryan | ICQ: 4935386
tracker1(at)theroughnecks(dot)com | AIM/AOL: azTracker1
Roughneck BBS: | Yahoo: azTracker1
http://www.theroughnecks.net | MSN: (email address)
telnet://theroughnecks.net | Trillian: www.trillian.cc
Tim Fletcher wrote:
> 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]
