Opening A Database Connection [SOLVED]

[realJSOP]

I've written a program using C# that is supposed to access a database. When I try to actually open the connection, I get this exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The database access code is contained in a separate assembly. This same assembly is used in another program (written in VB if that matters) that connects to the same database without any problems at all (on the same machine, with the same user logged in, and using the same connection string). Why am I getting this exception in one program and not in another? EDIT =================== Here are the constructors for both apps: VB: Dim myClass as new MyClass("abc", "def\geh") C# MyClass myClass = new MyClass("abc", "def\geh"); The problem is that VB automatically escapes the backlslash, but c# requires @"def\geh"... Stupid programmer tricks...

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

modified on Tuesday, January 19, 2010 2:32 PM

[loyal ginger]

Maybe some strings not escaped correctly?

[realJSOP]

The connection string is identical (it's created in the common assembly, and that was the very first thing I checked). EDIT =========== Why was this 1-voted?

modified on Wednesday, January 20, 2010 5:50 AM

[Lost User]

A shot in the dark; perhaps a firewall that's blocking one application, and not the other?

I are Troll :suss:

[realJSOP]

I wrote both apps from scratch (neither existed before I got here), and as far as I know, there are no application-specific blocks on our internal firewall.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[Luc Pattyn]

app.config? app manifest? elevation code missing/wrong? :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.
[The QA section does it automatically now, I hope we soon get it on regular forums as well]

---

[realJSOP]

There is no app.config. There is no manifest (unless vb creates on automagically). There is no elevation code. Authorization is via Windows login

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[realJSOP]

Out of curiosity, I created a manifest file, but the vb's version uses the defaults that the C# one does, so I don't think that's the issue.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[Lost User]

The only possibility is a bad connection string.

[realJSOP]

That's what I thought but the connection string for both apps is the same. Solved it (see original post for solution)

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

modified on Tuesday, January 19, 2010 2:36 PM

[realJSOP]

Solved it (see original post for solution)

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001