Tagged Questions

A string containing information necessary for connecting to a service, usually database.

learn more… | top users | synonyms (1)

6
votes
3answers
70 views

Live vs Development connection strings

We have a development database and a production database. What I am trying to prevent is having to change: connectionString="Data Source=server;Initial Catalog=test; connectionString="Data ...
0
votes
0answers
25 views

Open SQL Server CE database exclusively

Is there any way to lock a SQL Server CE database after opening a connection? I've got an application which I want to prevent the database for concurrent connections. In fact, only one user should be ...
0
votes
2answers
13 views

Cannot drop database because it is currently in use - EF code-first

In my configuration I have this: public sealed class Configuration : DbMigrationsConfiguration<App.Repository.NogginatorDbContext> { public Configuration() { ...
0
votes
0answers
24 views

Getting "invalid value for key 'attachbdfilename' error

I am trying to set up a website on a computer which runs the following: Windows XP Pro SP3 SQL Server 2008 R2 SP2 IIS 5.1 .NET 4.0 I developed the website in VS 2012 for Web Express using the VS ...
1
vote
1answer
25 views

connection provider to read xls files

I used the below connection string to read xlsx files. Its working fine. connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 8.0;HDR=NO;\""; ...
0
votes
1answer
21 views

need another connection string to use simple membership provider

I am new to ASP.net MVC. In my MVC application I wanted to have default login functions. Already I have connection string like this for my entity framework connection to application, <add ...
1
vote
1answer
16 views

MVC4 + EntityFramework: metadata only found from within web.config - why is that?

I want to change our EF-driven database-first ASP.NET MVC4 web application in such a way that I can specify the database to connect to at runtime. For the beginning, I simply wanted to substitute the ...
1
vote
0answers
21 views

Which connection string is deprecated?

I'm checking out a customer's files and not being a godlikely savvy on SQL, I'm not sure which of the following syntaxes is to be preferred or more modern. Both seem to do the same thing so I may as ...
0
votes
1answer
28 views

Database connection string works on local machine, but not on deployed server

I'm experiencing a strange issue in my ASP.NET MVC application where my connection string works fine in development on my local machine, but fails to connect to the SQL Server 2008 R2 database when ...
0
votes
0answers
7 views

Redirect default.aspx page if can't connect to db server (using C# .net)

Hello Friends, I Need To redirect the page if i can't connect to sql server(IN CASES when sqlserver is down). Default.aspx should redirect to index.html, i have tried customErrors Mode ...
0
votes
2answers
50 views

SQL Server Express and Entity Framework

I'm new to SQL Server Express (not to SQL Server in general) and I have a problem. I'm using Entity Framework (6-beta) in an ASP.NET MVC application. I created a database using the SQL Server ...
0
votes
0answers
17 views

How to override ConnectionString in TableAdapter

Please give me a code example. public partial class CARSTableAdapter { } To do ... this.Connection.ConnectionString = "................"; I cant find the code to do something like this ...
0
votes
0answers
29 views

Unable to get information from sql server with JTDS 1.2.7

I have a problem with the connection to my ms sql database. This is my connection string jdbc:jtds:sqlserver://AndreaPC:1444/ladym;instance=SQLExpress; All parameters are set right, i changed the ...
0
votes
2answers
36 views

Two hosts in jdbc url

We are using jdbc url like jdbc:mysql://localhost:3306/mysql. How could I set second mysql host in this url? If this is imposible, how could I set in my java application (hibernate) connection to ...
1
vote
1answer
17 views

Can SQL Server Connection String Contain Options like XACT_ABORT?

Can SQL string contain options like XACT_ABORT. For example, I can execute set XACT_ABORT On, but I would like to set this option in connection string. Is it possible? I tried to write XACT_ABORT=On; ...

1 2 3 4 5 … 123
15 30 50 per page