Click here to Skip to main content
15,512,747 members
Home / Discussions / Database
   

Database

 
Questionan intersting sql problem Pin
richardye10-Oct-07 19:46
richardye10-Oct-07 19:46 
AnswerRe: an intersting sql problem Pin
GuyThiebaut10-Oct-07 23:53
professionalGuyThiebaut10-Oct-07 23:53 
AnswerHow to shrink a transaction log - and make sure that it actually shrinks. Pin
GuyThiebaut11-Oct-07 0:04
professionalGuyThiebaut11-Oct-07 0:04 
QuestionSQL Server Replication Pin
Anilkumar K V10-Oct-07 19:10
Anilkumar K V10-Oct-07 19:10 
QuestionProblem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 18:52
Aavesh Agarwal10-Oct-07 18:52 
AnswerRe: Problem Regarding trigger Pin
joemonvarghese10-Oct-07 20:29
joemonvarghese10-Oct-07 20:29 
GeneralRe: Problem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 21:15
Aavesh Agarwal10-Oct-07 21:15 
QuestionTrying to figure out how to secure the db better. Starting with:Limit user access. Pin
foolios10-Oct-07 16:46
foolios10-Oct-07 16:46 
Asp.Net/C#/SQL 2005

I created a user and login under security for the database.

In the web.cfg I have:

<connectionstrings>
<add name="ConnectionString1" connectionstring="Data Source=X2\SQLEXPRESS;Initial Catalog=TheDB;Integrated Security=True"
providername="System.Data.SqlClient">
<add name="ReadOnlyConnectionString"
connectionstring="Data Source=localhost\SQLEXPRESS;Initial Catalog=TheDB;
Integrated Security=False;User ID=userReaderOnly;Password=123"
providername="System.Data.SqlClient">


in the codebehind file:

string connectionString = ConfigurationManager.ConnectionStrings["ReadOnlyConnectionString"].ConnectionString;

SqlConnection conn = new SqlConnection(connectionString);

errors at the line:
conn.Open();

The Error:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Questionmultiple threads accesing msAccess Pin
dsovino10-Oct-07 15:42
dsovino10-Oct-07 15:42 
Questionhow can i insert mpeg files to DB? Pin
ebtihal10-Oct-07 14:25
ebtihal10-Oct-07 14:25 
AnswerRe: how can i insert mpeg files to DB? Pin
Christian Graus10-Oct-07 15:07
mveChristian Graus10-Oct-07 15:07 
GeneralRe: how can i insert mpeg files to DB? Pin
Vidhya Sagar10-Oct-07 17:27
Vidhya Sagar10-Oct-07 17:27 
QuestionTable Column Decimal Value Pin
Brendan Vogt10-Oct-07 6:22
Brendan Vogt10-Oct-07 6:22 
AnswerRe: Table Column Decimal Value Pin
pmarfleet10-Oct-07 6:36
pmarfleet10-Oct-07 6:36 
Questiona problem about m_pConnection->Execute Pin
nibabug10-Oct-07 5:31
nibabug10-Oct-07 5:31 
QuestionBulk insert - Fewer fields than in DB Pin
clint198210-Oct-07 5:17
clint198210-Oct-07 5:17 
GeneralRe: Bulk insert - Fewer fields than in DB Pin
PIEBALDconsult10-Oct-07 7:30
professionalPIEBALDconsult10-Oct-07 7:30 
AnswerRe: Bulk insert - Fewer fields than in DB Pin
GuyThiebaut10-Oct-07 8:01
professionalGuyThiebaut10-Oct-07 8:01 
QuestionCalling reports from server logged in user wise Pin
MSinha10-Oct-07 4:50
MSinha10-Oct-07 4:50 
AnswerRe: Calling reports from server logged in user wise Pin
pmarfleet10-Oct-07 5:49
pmarfleet10-Oct-07 5:49 
GeneralRe: Calling reports from server logged in user wise Pin
MSinha10-Oct-07 6:29
MSinha10-Oct-07 6:29 
GeneralRe: Calling reports from server logged in user wise Pin
pmarfleet10-Oct-07 6:37
pmarfleet10-Oct-07 6:37 
QuestionCreateQueryDef() pause needed Pin
new_phoenix10-Oct-07 4:40
new_phoenix10-Oct-07 4:40 
AnswerRe: CreateQueryDef() pause needed Pin
DQNOK10-Oct-07 6:32
professionalDQNOK10-Oct-07 6:32 
GeneralThere has got to be a more elegant way to do this... Pin
new_phoenix10-Oct-07 11:13
new_phoenix10-Oct-07 11:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.