Tagged Questions
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 ...