Click here to Skip to main content
15,867,756 members
Home / Discussions / Database
   

Database

 
Questionan intersting sql problem Pin
richardye10-Oct-07 18:46
richardye10-Oct-07 18:46 
AnswerRe: an intersting sql problem Pin
GuyThiebaut10-Oct-07 22:53
professionalGuyThiebaut10-Oct-07 22:53 
AnswerHow to shrink a transaction log - and make sure that it actually shrinks. Pin
GuyThiebaut10-Oct-07 23:04
professionalGuyThiebaut10-Oct-07 23:04 
QuestionSQL Server Replication Pin
Anilkumar K V10-Oct-07 18:10
Anilkumar K V10-Oct-07 18:10 
QuestionProblem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 17:52
Aavesh Agarwal10-Oct-07 17:52 
AnswerRe: Problem Regarding trigger Pin
joemonvarghese10-Oct-07 19:29
joemonvarghese10-Oct-07 19:29 
GeneralRe: Problem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 20:15
Aavesh Agarwal10-Oct-07 20:15 
QuestionTrying to figure out how to secure the db better. Starting with:Limit user access. Pin
foolios10-Oct-07 15:46
foolios10-Oct-07 15: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 14:42
dsovino10-Oct-07 14:42 
Questionhow can i insert mpeg files to DB? Pin
ebtihal10-Oct-07 13:25
ebtihal10-Oct-07 13:25 
AnswerRe: how can i insert mpeg files to DB? Pin
Christian Graus10-Oct-07 14:07
protectorChristian Graus10-Oct-07 14:07 
GeneralRe: how can i insert mpeg files to DB? Pin
Vidhya Sagar10-Oct-07 16:27
Vidhya Sagar10-Oct-07 16:27 
QuestionTable Column Decimal Value Pin
Brendan Vogt10-Oct-07 5:22
Brendan Vogt10-Oct-07 5:22 
AnswerRe: Table Column Decimal Value Pin
pmarfleet10-Oct-07 5:36
pmarfleet10-Oct-07 5:36 
Questiona problem about m_pConnection->Execute Pin
nibabug10-Oct-07 4:31
nibabug10-Oct-07 4:31 
QuestionBulk insert - Fewer fields than in DB Pin
clint198210-Oct-07 4:17
clint198210-Oct-07 4:17 
GeneralRe: Bulk insert - Fewer fields than in DB Pin
PIEBALDconsult10-Oct-07 6:30
mvePIEBALDconsult10-Oct-07 6:30 
AnswerRe: Bulk insert - Fewer fields than in DB Pin
GuyThiebaut10-Oct-07 7:01
professionalGuyThiebaut10-Oct-07 7:01 
QuestionCalling reports from server logged in user wise Pin
MSinha10-Oct-07 3:50
MSinha10-Oct-07 3:50 
AnswerRe: Calling reports from server logged in user wise Pin
pmarfleet10-Oct-07 4:49
pmarfleet10-Oct-07 4:49 
GeneralRe: Calling reports from server logged in user wise Pin
MSinha10-Oct-07 5:29
MSinha10-Oct-07 5:29 
GeneralRe: Calling reports from server logged in user wise Pin
pmarfleet10-Oct-07 5:37
pmarfleet10-Oct-07 5:37 
QuestionCreateQueryDef() pause needed Pin
new_phoenix10-Oct-07 3:40
new_phoenix10-Oct-07 3:40 
AnswerRe: CreateQueryDef() pause needed Pin
DQNOK10-Oct-07 5:32
professionalDQNOK10-Oct-07 5:32 
GeneralThere has got to be a more elegant way to do this... Pin
new_phoenix10-Oct-07 10:13
new_phoenix10-Oct-07 10: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.