All,

I am currently using the following code to connect to both Oracle7 and

Oracle8 databases:



myDSN="Provider=MSDAORA;User ID="&userID&";Password="&passWord&";Data

Source="&database&";"



I've read about some problems when using the MSDAORA provider and attempted

to use:



myDSN="Provider=OraOLEDB.Oracle;User

ID="&userID&";Password="&passWord&";Data Source="&database&";DistribTX=0;"



The OraOLEDB works fine for my Oracle8 databases, but I get an Oracle error

when attempting to use this provider on my Oracle7 databases.  If this is

the incorrect forum, I apologize.  Any help?



Joe