if run to a delemia when im out of the hosue and not near a net work i want to be able to run on local, but i dont want to have to change the credientials is there a way i can have it try one and if it snt that or if its neither then send an error code?

So what you are asking is, is there a way to check a networked SQL connection for status without having a network connection?

Perhaps reword your question a little?

Basically I'm trying to connect to the database and try two sets of login credentials,

if you have an internet connection all you have to do is instantiate a connection as normal, then check to see if the resource is available.

If it's not available, try the other one...

Im not quite sure I follow what your plan of attack is...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.