Visual Studio '05 Help connecting to SQL :(

owen2433

owen2433

owen2433

Associate
Joined
4 Dec 2007
Posts
103
Hey... Posted here before but im having severe stress with Visual Studio 2005.


Im at University Greenwich. Trying to work on Oracle..

I have installed Oracle fine, i can access the Obiwan (What the sql server at uni is called) server from sql*Plus without a problem and do the work perfectly. However, when it comes to visual studio, i try to go to Tools> Connect to Database... It gives me an Error about listener EVERYTIME. I have tried everything, i have IIS installed on my home computer, but the only thing that seems to work is accessing my sql tables from Obiwan server from home that works on sql plus as it does at uni, just making it into visual studio isnt working. I enterred my username and password and set the Server as " obiwan.gre.ac.uk" which when setting up a connection for oracle is what i got told to put to access my sql tables from the UNI server .

Still nothing after that. I don't know what to do can you please help?

:confused::confused::confused:
 
Connection strings

It's difficult to comment without seeing the code, is this a win app, web app or service?

Take a look at your connection string, head over to http://www.connectionstrings.com and compare yours with what is on show, make sure you are using the correct credentials to access the db, also consider firewall settings although if you are accessing the db with sqlplus I'd suspect you are fine in that regard...

good luck,
J.
 
You must log in or register to reply here.
Back
Top Bottom