Re: ODBC and OLE DB

[KM]

in reply to ODBC and OLE DB

Win32::ODBC doesn't have an execute() method (which is really what that error is telling you). Instead use the Sql() method.
I don't know what module you are using for the 'OLE DB' (Win32::OLE?). Why aren't you just using Win32::ODBC (or DBD::ODBC) for both operations? I'm confused as to why you have textfile-&qt;DB->textfile. Why not just go textfile->textfile, or textfile->textfile->DB?

Cheers,
KM