We're used MySQL for quite a while now as part of a
Linux/Apache/Chilisoft/MySQL environment. We've always connected using a DSN
and that seems to work just fine.
Quoting Tim Fletcher <[EMAIL PROTECTED]>:
> 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.unsub%%
>
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
