Where to find the connection string in a program

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

Hi. I have just opened a system in my employer's folder which was created by the previous developer about 5 years ago.

However, I am having a hard time checking where the connection string is set up
Can you help me identify where it is coming from/setup?

Here is the connection string set up in web.config

Webconfig Connection String Setup

Here is the page that is referring to the unknown connection string

Default.aspx

And then i tried to "go to Definition " of SupplyConnectionString and I was referred to this.

Dropbox - DLL ConnectionStr.JPG[^]

I tried to navigate through that directory of

C#

App_Code.kkxexofb.dll

but I did not find the file.

Any help please?

What I have tried:

I tried to find the file but had no luck

Posted 7-Mar-16 17:12pm

bjay tiamsic

Updated 7-Mar-16 19:46pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2016-03-07T19:46:00

Solution 1

Web.config file contains 2 definitions of connection string:

SUPPLYConStr
conString

Posted 7-Mar-16 19:46pm

Maciej Los

Comments

bjay tiamsic 8-Mar-16 18:29pm

Yes I understand. but in my page, it refers to the connectionstring "SupplyConnectionString" which is not in web.config

Maciej Los 9-Mar-16 1:54am

SUPPLYConStr is that what you're looking for. SupplyConnectionString is the name of variable which holds SUPPLYConStr value.

bjay tiamsic 9-Mar-16 18:45pm

Thanks for the comment. But it seems like it is not.
As you can see in SUPPLYConStr is Datasource=server31/... (this is a test server)

But when I put breakpoint in Default.aspx ConnectionString.SupplyConnectionString, it returns DataSource=[IPAddress]...which is the live server.

Here's the screen cap
https://www.dropbox.com/s/o3xyub97kywmzq4/Untitled.png?dl=0

Maciej Los 10-Mar-16 1:43am

It doesn't prove i'm wrong. Web based applications settings may be different (development to deployment). Please, read this: How to: Transform Web.config When Deploying a Web Application Project[^]

bjay tiamsic 10-Mar-16 20:09pm

But why does it return different connectionstring when I put breakpoint?

Maciej Los 11-Mar-16 1:55am

Haven't read an article? Everything is explained there.