PDA

Click to See Complete Forum and Search --> : connection string quetion


edellavedova
Apr 6th, 2000, 03:21 AM
If I'm using the following connection string for an ADO:

ADOconnection.Open "Provider=MSDAORA.1;Password=pwc2000; _
User ID=edella;Data Source=obwrpt"

Do I need any Oracle configure files on the client maachines? I'm wondernig how OLE DB knows where to find my database (obwrpt)?

Thanks

Bigley
Apr 6th, 2000, 04:32 AM
I'm guessing that you would need to set up an ODBC connection to your database and then refer to that in your connection string. YOu would also need to set up the ODBC connection on all the client machines but just give it the same name so your code does not need to change.