I am wondering if anyone here has ever attempted to connect to the oracle 10g xe database from visual web developer? I have been trying to do this all day, however it is starting to get really irratating! I have downloaded the oracle dataacess dll, and imported it into my application, however I am not sure what to enter as the server name when using the configure data source wizard in VWD. Anyone any ideas?
I have tried using XE, and username/password as hr/hr, however I am getting the error "TNS: could not resolve the connect identifier specified".
I am starting to doubt if it is actually possible to connect to this database using oracle xe. Any ideas at all would be most appreciated!