OLE DB error

b0dh1 has asked for the wisdom of the Perl Monks concerning the following question:

I've written a script that basically reads data from a text file and writes it to a db using an OLE DB connection. I've been getting an error from the MS Access ODBC driver, "Not enough storage available to complete this operation". The weird thing is, when I ran the code locally it still worked. The db was being updated despite the error.

Now I've moved the code to a different system and its stopped working. I'm still getting the error message, but the db isn't being updated. (The ODBC driver buffer is set to 2MB, so that shouldn't be an issue).

Anyone seen this before, or have any ideas about what might be going on?

Thanks.

Comment on OLE DB error

Replies are listed 'Best First'.
Re: OLE DB error by buzzcutbuddha (Chaplain) on Jun 06, 2000 at 21:48 UTC
This may also be created by rights and permissions according to where the database is locally or on the network. Make sure that you have the right permissions, etc. Perhaps seeing your code would also help us spot a potential bug in the update statement.	[reply]
Re: OLE DB error by Shendal (Hermit) on Jun 06, 2000 at 21:36 UTC
I have seen this error before when I didn't have write access to the directory which contains the .mdb file. Is it possible that this has changed as well?	[reply]
Re: OLE DB error by Anonymous Monk on Jun 06, 2000 at 23:55 UTC
Thanks for the input. I've run into similiar issues with VBScripts and permissions... I guess since I'm new to perl I was focusing on the code and not the environment. I ended up switching to a SQL database instead of Access and made the whole problem go away. So all is well in the world. Again, thanks.	[reply]