How to connect to Oracle 10g XE

Dear All,

How to connect to Oracle 10g XE ? .. I didnot find correct connectionstring..

please help

TIA

Winanjaya

hai winanjay,
http://www.connectionstrings.com

yes, I also have visited there and I followed the connectionstrings from that site.. but it doesnot work.. ;<(

regards

oh, sorry :(

Moved to Database Development

What is the code/connection string that you are using?

When you say it didn't work, what does that mean? Did you get an error? If so, what was it?

Is the database on the same machine as the code? Is there a TNSNames entry for the database? Is there a listener running on the machine the database is on?

What is doesn't work? Is there an error? If there is what is the error message?

Can you connect to the database using SQL*Plus?

Just want to share..
it solved already by using connectionstring below..

mConnStr = "Provider=MSDAORA.1;User ID=myuser;Password=myuserpasswd;Data Source=10.0.0.10;Persist Security Info=False"

any way.. thanks for any reply..

Regards
Winanjaya

I would shift from the MS Oracle driver to the Oracle supplied one. It has a few more fetaures for Oracle