Tagged Questions
15
votes
3answers
18k views
Why does an Entity Framework Connection require a metadata property?
I switched my DAL from using LINQ over to Entity Framework. Because my application connects to different databases depending on the current user, I need to dynamically create the DataContext at run ...
11
votes
4answers
310 views
Where to put the database sensitive information [duplicate]
Possible Duplicate:
How to secure database passwords in PHP?
Recently I was given a website project which was supposed to be done in PHP but I don't have much experience in PHP. Anyway, it ...
9
votes
4answers
4k views
Best practices re sharing IDbConnection or connection string/factory in your .Net code
I'm wondering what would be the best prectice regarding mainataining connections to the database in .Net application (ADO.NET but I guess the practice should be the same for any data layer). Should I ...
8
votes
6answers
1k views
Prompt for Database Connection String
I would like to offer a database connection prompt to the user. I can build my own, but it would be nice if I can use something that somebody else has already built (maybe something built into Windows ...
8
votes
3answers
4k views
What's best way to secure a database connection string?
I am writing a set of database-driven applications in PHP. These applications will run on a Linux server as its own user. Other users will likely be on the system at times, but have very controlled ...
7
votes
2answers
20k views
What is the point of “Initial Catalog” in a SQL Server connection string?
Every SQL Server connection string I ever see looks something like this:
Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database;
Integrated Security=SSPI;
Do I need the Initial ...
6
votes
5answers
8k views
How do I connect to SQLite db file from c#?
I am trying to connect to a sqllite db from with a c# application. I have never worked with SQLLite before.
var connectionString = @"data source='C:\TestData\StressData.s3db'";
connection ...
6
votes
4answers
882 views
How to configure database connection securely
Similar but not the same:
How to securely store database connection details
Securely connecting to database within a application
Hi all, I have a C# WinForms application connecting to a database ...
6
votes
2answers
6k views
the best way to connect sql server (Windows authentication vs SQL Server authentication) for asp.net app
I have a database and a site having forms authentication. It is working fine with VS2008. This time, I am using "Trusted_connection =True". But when it is opened from outside or directly from browser ...
5
votes
3answers
34k views
Classic ASP - SQL Server 2008 Connection String using Windows Authentication
This should be painfully simple, but I cannot come up with a working connection string for a local copy of SQL Server 2008 using Windows Authentication. I've tried using the Data Link Properties tool ...
5
votes
2answers
585 views
Fast database access test from .Net
What would be a very fast way to determine if your connectionstring lets you connect to a database? Normally a connection attempt keeps the user waiting a long time before notifying the attempt was ...
5
votes
2answers
306 views
Can I access sdf (SQL Server Compact database file) kept at some other computer on the same network?
I have done so for SQL Server, now I was trying to do it SQL Server Compact.
I am unable to make a connection string in SQL Server Compact which has the provision for providing ip/server.
4
votes
5answers
580 views
How to check for the existence of a DB?
I am wondering if there is an elegant way to check for the existence of a DB? In brief, how do test the connection of a db connection string?
Thanks
4
votes
1answer
1k views
where to store database string connection in java web app?
I'm about to begin my first project with java
Let me tell how I used to handle these things...
So far now, I've been workin on asp with a com+ componente made with VB6.
The component is registered ...
4
votes
3answers
619 views
Is it possible to add Data source connection wizard in my app?
Data source connection wizard is very convenient tool. Can I add it to my app to allow user choose data source themself in easy way?
