johnb

You seem a little confused as to what provider you are using. Be carefull. Some of the post are telling you to use the Oracle.DataAccess.Client objects, but you mentioned you were using OLEDB. That's a conflict. If you are using OLEDB then try this for your connection string strAdoDCCon = "Provider=MSDAORA.1;Password=123;User ID=user;Data Source=DS.world;" & "Persist Security Info=True" This all changes if you use something other than OLEDB. I would advise that once you make OLEDB work to venture down the ORACLE .NET Provider route since it is mentioned to be 200 percent faster.