2
votes
1answer
38 views

C# / SQL Server : “Error Locating Server/Instance Specified” in just one application

I've been trying to find the exact issue to this for hours but so far I just can't figure out what might be wrong. I have a WPF application trying to connect to a remote SQL Server using this ...
0
votes
2answers
70 views

Package and publish Azure Cloud Service with unique Sql Azure connectionStrings

I have a .NET Web solution with an Azure Cloud Service project and a single webrole. I deploy it to the East coast West coast data/compute centers for failover purposes and have been asked to automate ...
0
votes
2answers
32 views

ado.net can't read from my database

This is a really noob-problem but im tearing my hair soon. I'm trying to read from my local database but it gives me nothing. Here is the code: protected void readBtn2_Click(object sender, EventArgs ...
0
votes
0answers
29 views

function runs on scanner emulator, but not scanner itself (C#, SQL)

I'm developing an add-in for a scanner. I've run into problems with a specific function that I'm writing. The problem seems to be with my connection string. The code runs fine on the scanner ...
0
votes
2answers
33 views

MS SQL Server '08 ignoring username and password when requesting a connection with connection string using Integrated security=SSPI

I'm using this connection string to connect to a ms sql server '08 db, "Data Source=qwe;Initial Catalog=dsa;Integrated Security=SSPI;User Id=mydom\unamee;Password=pwd;" but the server is ignoring ...
1
vote
3answers
42 views

Getting error “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”

Normally, I'd be able to figure this out. But, what I have going on is I have an MVC4 app that, in its current state, will NOT connect to any kind of data source. I believe that MVC, out of the box, ...
-2
votes
1answer
29 views

Creating Oracle Database and connecting to it throw c# application [closed]

can anyone tell me step by step, how to create database (any, which could handle triggers, procedures and so on) and a simple connection string in c#, which describes the username, password and ...
0
votes
0answers
44 views

What is the error in this connection string in vb.net?

I have the following connection string <add name="portal_ConnSql" connectionString="Data Source=GFO-SQL03;Initial Catalog=PortalDB_V2;uid=Portal_Usr;Password=20!!P0rt@!" ...
1
vote
2answers
7k views

Provider needed to be specify on a connectionstring?

I have a very funny problem on my application, I get an error as follow: System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, ...
1
vote
7answers
299 views

Web App to SQL Server Not Connecting ( Error Locating Server/Instance Specified)

I know this is an often asked question, but I'm still receiving this error and I have tried: Using localhost, the IP address and the instance name in the connection string Changing the SQL Server ...
0
votes
3answers
41 views

SelectCommand.Connection is not initialized

I'm trying to access my database, from this method in my DataBaseOptions class. I'm using this with ASP.NET for web development. Whenever I run this method, In another class, I get following error: ...
1
vote
3answers
492 views

ASP.NET ConnectionString AttachDbFilename=|DataDirectory|

This is about ConnectionStrings / ASP.NET MVC with Visual Studio 2012 ultimate & SQL Server Express 2012. Following up with this tutorial here: ...
0
votes
1answer
3k views

connection string for remote sql server

I am trying to connect to remote sql server, I would like to know what's the proper way to connect to the server. tcp/ip protocol is enabled. I am trying this way: @"Server=myserver.com\SQLEXPRESS; ...
0
votes
0answers
43 views

SQLite data source path strange issue?

The most basic form of a SQLiteConnection string is "data source = ..." I've tried a demo in which I had a SQLite database file called MyData.sdb, this file was placed right in my demo project folder ...
5
votes
2answers
11k views

Should we set max pool size in database connection string or what happens if we don't

This is my database connection string i did not set max pool size until now. public static string srConnectionString = "server=localhost;database=mydb;uid=sa;pwd=mypw;"; So currently how many ...

1 2 3 4 5 10
15 30 50 per page