Parsing a Text file to a database

[jabond007]

Hi

I am trying to parse a text file into a recordset (ADO) and ultimately into the database
I am using the following connect string :"Provider=MSDAORA.1user id=scott;password=tiger;Data Source=Alpha"

the recordset is dynamic and i use the following sysntax
Select a,b,c from TAB where 1=0;
i get an error when it encounters Recordset.AddNew.

the error is "Operation requested by application is not supported by the provider"

Could somebody tell me why

 

[swilliams]

When you open the connection, are you specifying any locking to be used on the connection?? Or any other optional parameters??

Simon

 

[jabond007]

no i am not mentioning any parameters.

I think i found the problem. I believe it is a ADO version conflict in the Registry of the System. I just got it corrected and now it seems ok. Microsoft components !!!!!!!!!!!!!!!!!!!!!!!!

Any application using ADO would overwrite the existing ADO. thus the error. I hope thats the only problem.

thanks anyway