Developers Knowledgebase

How to Downgrade Or Convert Database from SQL Server 2005 to SQL Server 2000

noreply@blogger.com (Balu) — Sat, 23 May 2009 09:46:00 +0000

As you may all know, SQL Server 2005 request a minimum of 8GB RAM to work… let’s say satisfactorily. I first didn’t know that and after a while from the upgrade I did from SQL Server 2000 to 2005 my SQL Services were starting to crash three or four times per DAY!!!

At first I thought I was being attacked, but soon I realized it was nothing like that. I then decided to downgrade to a SQL Server 2000 edition. Though I looked around the internet to find some information on how to do that, I got very disappointed when I realized that no actual documentation of any kind could be found for that. So I am posting this thread to inform you on the procedures I had to follow for this action.

Before beginning I must assume, firstly that the user, who will attempt such thing, has a basic knowledge of SQL Environment, secondly that he has the two versions already installed (both 2000 and 2005), that a basic backup of the databases has been created and finally that all the 2005 SQL Server Users have been created at the SQL Server 2000 environment as well.

Step 1: Generating Scripts for the Database Elements and Structures
1. Right-click over the desired Database at 2005, Choose Tasks and the Generate Scripts (Option).
2. At the pop-up Dialog Box click at the Script All Objects in the selected Databases check box, to activate it and then Click the Next Button.
3. Set the following Elements to the following Values
1. Script Collation , set to TRUE
2. Script Database Create, set to TRUE
3. Script of SQL Version, set to SQL SERVER 2000
4. Script foreign keys, set to FALSE
5. Script Triggers, set to FALSE Then Hit the Next button
4. Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.
5. Click Finish

After completing this procedure, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Structure of the Database will be created.

Be careful, the SQL Server 2005 Edition inserts the Views in a random place through the script. Therefore, all the scripts that are referred to the Views MUST be moved to the end of the script. If the Query Analyzer shows some errors do not be bothered. Delete all the elements created from the script and after you fix the code run it again.

Step 2: Moving the data from 2005 to 2000
1. After completing the previous step successfully, moving the data follows. Right-click at the 2005 database you used to run the previous step and select Tasks and then choose the Export Data (option).
2. From the pop-up Dialog Box, select the Source Db and Click at the Next Button.
3. At the next step you will have to choose the destination server and the destination Database for the Data to be exported. Then Click Next.
4. A List of all the Source Database’s Elements will appear in the screen. Select one by one all the Elements you wish to move and for each one click at the button Edit Mappings (Located at the bottom right corner of the Dialog Box just under the Elements list). A new Dialog box will pop-up. Select the Delete rows in Destination Tables option and activate the Enable Identity Insert Option. (Remember to repeat this action for each of the selected Element from the list that will be moved.
CAUTION!!! A malfunction of the SQL Server 2005 has been found. Not sure why, after multiple tries I have observed that when I tried to move more than twelve Elements at once, the Export Data Wizard of SQL Server 2005 seemed to disable the Enable Identity Insert Option that was activated over the Edit Mappings Dialog Box. But if the number of the selected Elements is smaller than 12 no problem seemed to appear.
Step 3: Generating Scripts for the Database Foreign Keys and Triggers

Finally, to successfully finish the downgrade of the Database, the Triggers and the Foreign Keys of the DB must be produced. The procedure that should be followed is the one stated next:
1. Right-Click at the SQL 2005 Database and Select from Tasks Menu the Generate Scripts Option.
2. Using the pop-up Dialog Box make sure that the check box Script All Objects in the selected Databases is not enabled and hit the Next Button.
3. Set all the Elements on the List to a False Value except the ones that follow:
1. Include IF NOT EXISTS , set to TRUE
2. Script Owner, set to TRUE
3. Script of SQL Version, set to SQL SERVER 2000
4. Script foreign keys, set to TRUE
5. Script Triggers, set to TRUE
6. Then Hit the Next button
4. After finishing reading the Elements of the Database, a new list will appear at the Dialog Box. Make sure that you select ONLY THE TABLES of the Database and hit the Next Button.
5. At the screen that follows hit the Select All button and the Next.
6. Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.
7. Click Finish Button.

After completing this procedure, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Foreign Keys and the Triggers of the Database will be created.

After these steps the database should be fully functional under the SQL Server 2000 edition.

Source : http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/46e3ecf9-6eab-4aa0-9453-11e7269efb6e

Demonoid Invitation Codes For Free

noreply@blogger.com (Balu) — Sat, 09 May 2009 14:09:00 +0000

Since there is no membership open for the public in Demonoid.com, I have received a huge number of requests to send the Invitation code. To fulfil all my visitors expect I have collected some Invitation code collection and posted the same below. Use it to sign-up in Demonoid.com and enjoy the power of Demonoid.com.

If you need more invitations codes leave your request in the comment section.

sjvi2cfx7n47hrygkrsqogcfevd4lml36y
iuqow7etincjc2fr7awh1z1hejtxgtjqb9x

Do not forget leave your thanks in the comments and also send this page to your friends. Congratulations to those 3 visitors who registered with the code sent by me! check back here regularly to get more Invitation updates.

Note: Visitors who suceeded, please do not forget to seed your torrent as long as possible to alive in Demonoid and the sponser.

How to Increase IIS ASP Script Timeout (IIS 6.0)

noreply@blogger.com (Balu) — Thu, 08 Jan 2009 05:39:00 +0000

When you set the ASP script timeout, you specify, in seconds, the default length of time that ASP pages allow a script to run before terminating the script and writing an event to the Microsoft Windows® Event Log. The minimum value for this property is one second and the default value is 90 seconds. The corresponding metabase property is AspScriptTimeout Metabase Property.

Important You must be a member of the Administrators group on the local computer to perform the following procedure or procedures. As a security best practice, log on to your computer by using an account that is not in the Administrators group, and then use the runas command to run IIS Manager as an administrator. At a command prompt, type runas /user:Administrative_AccountName "mmc %systemroot%\system32\inetsrv\iis.msc".

To change ASP script timeout

1.	In IIS Manager, double-click the local computer, right-click the starting-point directory of the application you want to configure, and then click Properties.
2.	Click the Directory tab, and then click Configuration.
3.	Click the Options tab.
4.	In the Application configuration section, in the ASP script timeout box, click the up or down arrow to set the number of seconds before an error message is returned.
5.	Click OK.

Source http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/2275a2ba-5b12-4e18-8266-8a3b0678e419.mspx?mfr=true

How to send an e-mail message with attachments by using Visual Basic .NET

noreply@blogger.com (Balu) — Wed, 03 Dec 2008 07:10:00 +0000

This article describes how to use the Microsoft Outlook Object Library to send attachments in an e-mail message by using Microsoft Visual Basic .NET.

To send attachments in an e-mail message by using Visual Basic .NET, follow these steps:

Start Microsoft Visual Studio .NET.
On the File menu, point to New, and then click Project.
In the Visual Basic Projects types list, click Console Application.
By default, the Module1.vb file is created.
If Office Outlook 2003 is installed on your development computer, add a reference to the Microsoft Outlook 11.0 Object Library. If Outlook 2002 is installed on your development computer, add a reference to the Microsoft Outlook 10.0 Object Library. To do so, follow these steps:
1. On the Project menu, click Add Reference.
2. Click the COM tab, locate Microsoft Outlook 10.0 Library (for Office 2002) or Microsoft Outlook 11.0 Object Library (for Office 2003) or Microsoft Outlook 12.0 Object Library (for Office 2007), and then click Select.
3. In the Add References dialog box, click OK.
4. If you are prompted to generate wrappers for the libraries that you selected, click Yes.
In the code window, replace the code with the following:

Module Module1
Sub Main()
' Create an Outlook application.
Dim oApp As Outlook._Application
oApp = New Outlook.Application()
' Create a new MailItem.
Dim oMsg As Outlook._MailItem
oMsg = oApp.CreateItem(Outlook.OlItemType.olMailItem)
oMsg.Subject = "Send Attachment Using OOM in Visual Basic .NET"
oMsg.Body = "Hello World" & vbCr & vbCr
' TODO: Replace with a valid e-mail address.
oMsg.To = "user@example.com"
' Add an attachment
' TODO: Replace with a valid attachment path.
Dim sSource As String = "C:\Temp\Hello.txt"
' TODO: Replace with attachment name
Dim sDisplayName As String = "Hello.txt"
Dim sBodyLen As String = oMsg.Body.Length
Dim oAttachs As Outlook.Attachments = oMsg.Attachments
Dim oAttach As Outlook.Attachment
oAttach = oAttachs.Add(sSource, , sBodyLen + 1, sDisplayName)
' Send
oMsg.Send()
' Clean up
oApp = Nothing
oMsg = Nothing
oAttach = Nothing
oAttachs = Nothing
End Sub
End Module

Search for the TODO text string in the code, and then modify the code for your environment.
Press the F5 key to build and to run the program.
Make sure that the e-mail message and the attachment have been sent.
The above example will sent a mail in silent mode that is without previewing the message to the users and also without asking the users confirmation.
To preview the message and to ask the user to click the "Send" button, just replace oMsg.Send() code with oMsg.Display()

Original source : http://support.microsoft.com/?kbid=313803 (Thanks to MicroSoft)

Numeric Decimal TextBox – Made easy with VB.Net (2005&2008)

noreply@blogger.com (Balu) — Thu, 18 Sep 2008 12:11:00 +0000

You just need to put this code in TextBox1 Leave event. Try this

Private Sub TextBox1_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.Leave

Dim d As Decimal = Me.TextBox1.Text Me.TextBox1.Text = Decimal.Round(d, 2).ToString("f2")

End Sub

The "f2" formats a floating point number with 2 decimal points

How to create a Numeric TextBox in VB.Net (2005 & 2008)

noreply@blogger.com (Balu) — Thu, 18 Sep 2008 10:49:00 +0000

If you are using VB2005 or VB2008 simply use this validation code into your textbox change event.

Method-I

Private Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged

If Not IsNumeric(Me.TextBox1.Text) Then

MsgBox("Please enter numeric value only", MsgBoxStyle.Information)

Me.TextBox1.Text = 0

End If

End Sub

Method-II

Private Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged

Dim d As Double

Dim result As Boolean result = Double.TryParse(Me.TextBox1.Text, d)

If result = False Then

MsgBox("Please enter only numeric value", MsgBoxStyle.Information) Me.TextBox1.Text = 0

End If

End Sub

For Non .net users:

Private Sub txtage_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtage.KeyPress

If KeyAscii(e) <> 57 Then

If KeyAscii(e) <> 8 Then e.Handled = True

End If

End Sub

Public Function KeyAscii(ByVal UserKeyArgument As KeyPressEventArgs) As Short

KeyAscii = Asc(UserKeyArgument.KeyChar)

End Function

Method-III

Public Class NumericTextBox

Inherits TextBox

Private SpaceOK As Boolean = False

' Restricts the entry of characters to digits (including hex),

' the negative sign, the e decimal point, and editing keystrokes (backspace).

Protected Overrides Sub OnKeyPress(ByVal e As KeyPressEventArgs)

MyBase.OnKeyPress(e)

Dim numberFormatInfo As NumberFormatInfo = System.Globalization.CultureInfo.CurrentCulture.NumberFormat

Dim decimalSeparator As String = numberFormatInfo.NumberDecimalSeparator

Dim groupSeparator As String = numberFormatInfo.NumberGroupSeparator

Dim negativeSign As String = numberFormatInfo.NegativeSign

Dim keyInput As String = e.KeyChar.ToString()

If [Char].IsDigit(e.KeyChar) Then

' Digits are OK

ElseIf keyInput.Equals(decimalSeparator) OrElse keyInput.Equals(groupSeparator) OrElse keyInput.Equals(negativeSign) Then

' Decimal separator is OK

ElseIf e.KeyChar = vbBack Then

' Backspace key is OK

' else if ((ModifierKeys & (Keys.Control | Keys.Alt)) != 0)

' {

' // Let the edit control handle control and alt key combinations

' }

ElseIf Me.SpaceOK AndAlso e.KeyChar = " "c Then

Else

' Consume this invalid key and beep.

e.Handled = True

End If

End Sub

Public ReadOnly Property IntValue() As Integer

Get

Return Int32.Parse(Me.Text)

End Get

End Property

Public ReadOnly Property DecimalValue() As Decimal

Get

Return [Decimal].Parse(Me.Text)

End Get

End Property

Public Property AllowSpace() As Boolean

Get

Return Me.SpaceOK

End Get

Set(ByVal value As Boolean)

Me.SpaceOK = value

End Set

End Property

End Class

How to store images in SQL server (2000 & 2005) for files types .bmp, .jpg, *.gif etc.,

noreply@blogger.com (Balu) — Mon, 11 Aug 2008 10:19:00 +0000

Oops.

I am tuning this page to fulfil your requirement. Thanks for your patience

How to use the OpenFileDialog for Uploading picture (browse for picture) in vb.net, vs.Net:

noreply@blogger.com (Balu) — Sat, 26 Jul 2008 05:34:00 +0000

If you are using VS.Net you can drag an OpenFileDialog, 3 buttons, textbox and a picturebox to your form.
With your first button (Browse). Double click the button "Browse" and add the following into the click event.

vb.net Syntax

OpenFileDialog.Title = "Get Image"
OpenFileDialog.ShowDialog()

Go back to your form and double click the OpenFileDialog. Add this code

textbox.text = OpenFileDialog.FileName

Go to your second button (Upload) click event and add

if (textbox.text.Trim() <> "")
Then
PictureBox.Image = Image.FromFile(textbox.text)

Finally in the third button (Remove). Open the click event for this button and add.

Picturebox.image = Nothing

This should take care of browsing, displaying path, uploading and removing the image
from your form.

If you wish to apply a filter for browse a specified type of files only, for example if you wish to display only image files like JPEG, Bitmap, PNG files or GIF files only into the dialog box then add the following code additionally to the above event.

With OpenFileDialog

'.InitialDirectory = "C:\"

.Filter = "All Files|*.*|Bitmaps|*.bmp|GIFs|*.gif|JPEGs|*.jpg"

.FilterIndex = 4

End With

You can change the filter index to set image extension at first open. In this code filter index = 4 will set to jpeg (since *.jpg is in fourth place), so the dialog box will show only JPG files and the file type drop down menu will set for "JPEG" files while opening the dialog box. Change filter index as u need.

By default the picture will not show in stretch mode. You can stretch by setting the in through the properties window or by add the following code:

If OpenFileDialog.ShowDialog() = DialogResult.OK Then

PictureBox.Image = Image.FromFile(OpenFileDialog.FileName)

PictureBox.SizeMode = PictureBoxSizeMode.StretchImage

PictureBox.BorderStyle = BorderStyle.Fixed3D

lblFilePath.Text = OpenFileDialog.FileName()

End If

Please ask your questions and doubts about this thread by Leaving Your Comments (No SignUp Required) to enable me to clear all. Please click the below "Comments" link to do so.

How to connect SQL Server 2005 and its Connection Strings (C, C++, C#, Visual Studio 2008 & VB.NET)

noreply@blogger.com (Balu) — Thu, 05 Jun 2008 07:03:00 +0000

SqlConnection (.NET)

Standard security

Data Source=ServerAddress;Initial Catalog=DataBase;User Id=Username;Password=YourPassword;

Standard Security alternative syntax

Server=ServerAddress;Database=DataBase;User ID=Username;Password=YourPassword;Trusted_Connection=False;

Trusted Connection

Data Source=ServerAddress;Initial Catalog=DataBase;Integrated Security=SSPI;

Trusted Connection alternative syntax

Server=ServerAddress;Database=DataBase;Trusted_Connection=True;

Connecting to an SQL Server instance

Server=ServerName\theInstanceName;Database=DataBase;Trusted_Connection=True;

Trusted Connection from a CE device

Data Source=ServerAddress;Initial Catalog=DataBase;Integrated Security=SSPI;User ID=domainname\Username;Password=YourPassword;

Connect via an IP address

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=DataBase;User ID=Username;Password=YourPassword;

Enabling MARS (multiple active result sets)

Server=ServerAddress;Database=DataBase;Trusted_Connection=True;MultipleActiveResultSets=true;

Attach a database file on connect to a local SQL Server Express instance

Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\dbfile.mdf;Database=dbname;Trusted_Connection=Yes;

Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Server=.\SQLExpress;AttachDbFilename=|DataDirectory|dbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Using an User Instance on a local SQL Server Express instance

Data Source=.\SQLExpress;Integrated Security=true;AttachDbFilename=|DataDirectory|\mydb.mdf;User Instance=true;

SQL Native Client ODBC Driver

Standard security

Driver={SQL Native Client};Server=ServerAddress;Database=DataBase;Uid=Username;Pwd=YourPassword;

Trusted Connection

Driver={SQL Native Client};Server=ServerAddress;Database=DataBase;Trusted_Connection=yes;

Connecting to an SQL Server instance

Driver={SQL Native Client};Server=ServerName\theInstanceName;Database=DataBase;Trusted_Connection=yes;

Prompt for username and password

oConn.Properties("Prompt") = adPromptAlways

Driver={SQL Native Client};Server=ServerAddress;Database=DataBase;

Enabling MARS (multiple active result sets)

Driver={SQL Native Client};Server=ServerAddress;Database=DataBase;Trusted_Connection=yes;MARS_Connection=yes;

Encrypt data sent over network

Driver={SQL Native Client};Server=ServerAddress;Database=DataBase;Trusted_Connection=yes;Encrypt=yes;

Attach a database file on connect to a local SQL Server Express instance

Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\dbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=|DataDirectory|dbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Database mirroring

Data Source=ServerAddress;Failover Partner=mirrorserver;Initial Catalog=DataBase;Integrated Security=True;

SQL Native Client OLE DB Provider

Standard security

Provider=SQLNCLI;Server=ServerAddress;Database=DataBase;Uid=Username;Pwd=YourPassword;

Trusted connection

Provider=SQLNCLI;Server=ServerAddress;Database=DataBase;Trusted_Connection=yes;

Connecting to an SQL Server instance

Provider=SQLNCLI;Server=ServerName\theInstanceName;Database=DataBase;Trusted_Connection=yes;

Prompt for username and password

oConn.Properties("Prompt") = adPromptAlways

oConn.Open "Provider=SQLNCLI;Server=ServerAddress;DataBase=DataBase;

Enabling MARS (multiple active result sets)

Provider=SQLNCLI;Server=ServerAddress;Database=DataBase;Trusted_Connection=yes;MarsConn=yes;

Encrypt data sent over network

Provider=SQLNCLI;Server=ServerAddress;Database=DataBase;Trusted_Connection=yes;Encrypt=yes;

Attach a database file on connect to a local SQL Server Express instance

Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\dbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=|DataDirectory|dbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Database mirroring

Data Source=ServerAddress;Failover Partner=MirrorServer;Initial Catalog=DataBase;Integrated Security=True;

Please ask your questions and doubts about this thread by Leaving Your Comments (No SignUp Required) to enable me to clear all. Please click the below "Comments" link to do so.

How to connect MS Access 2007 (And a collection of MS Access connection strings)

noreply@blogger.com (Balu) — Thu, 05 Jun 2008 06:37:00 +0000

MS Access 2007 OLE DB & OleDbConnection (.NET framework) connection strings

Open connection to Access database 2007:
"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=c:\ yourdbpath \ DBName.accdb; User Id=admin; Password="

Open connection to password protected Access database 2007:
"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=c:\ yourdbpath \ DBName.accdb; Jet OLEDB:Database Password=YourPassword"

Open connection to Access database 2007 located on a network share:
"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\\ServerName\ShareName\SharePath\ DBName.accdb"

Open connection to Access database 2007 located on a remote server:
"Provider=MS Remote; Remote Server=http://Server-IP; Remote Provider=Microsoft.ACE.OLEDB.12.0; Data Source=c:\ yourdbpath \ DBName.accdb"

MS Access ODBC connection strings

Standard Security:
"Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=C:\yourdbpath\DBName.mdb;Uid=Your_Username;Pwd=YourPassword;"

Workgroup:
"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\ yourdbpath \ DBName.mdb; SystemDB=C:\ yourdbpath \ DBName.mdw;"

Exclusive "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\ yourdbpath \ DBName.mdb; Exclusive=1; Uid=YourUsername; Pwd=YourPassword;"

MS Access OLE DB & OleDbConnection (.NET framework) connection strings

Open connection to Access database:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\ yourdbpath \ DBName.mdb; User Id=admin; Password="

Open connection to Access database using Workgroup (System database):
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\ yourdbpath \ DBName.mdb; Jet OLEDB:System Database=c:\App1\ DBName.mdw"

Open connection to password protected Access database:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\ yourdbpath \ DBName.mdb; Jet OLEDB:Database Password=YourPassword"

Open connection to Access database located on a network share:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\ServerName\ShareName\SharePath\ DBName.mdb"

Open connection to Access database located on a remote server:
"Provider=MS Remote; Remote Server=http://Server-IP; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\ yourdbpath \ DBName.mdb"

Please ask your questions and doubts about this thread by Leaving Your Comments (No SignUp Required) to enable me to clear all. Please click the below "Comments" link to do so.

How to connect SQL Server (A Collection of SQL connection strings)

noreply@blogger.com (Balu) — Thu, 05 Jun 2008 06:24:00 +0000

SQL ODBC connection strings

Standard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"

SQL OLE DB connection strings

Standard Security:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL OleDbConnection .NET strings

SQL SqlConnection .NET strings

Standard Security:
1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" < br>2. "Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection:
1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"
2."Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"

Please ask your questions and doubts about this thread by Leaving Your Comments (No SignUp Required) to enable me to clear all. Please click the below "Comments" link to do so.

Developers Knowledgebase

How to Downgrade Or Convert Database from SQL Server 2005 to SQL Server 2000

Demonoid Invitation Codes For Free

How to Increase IIS ASP Script Timeout (IIS 6.0)

How to send an e-mail message with attachments by using Visual Basic .NET

Numeric Decimal TextBox – Made easy with VB.Net (2005&2008)

How to create a Numeric TextBox in VB.Net (2005 & 2008)

How to store images in SQL server (2000 & 2005) for files types *.bmp, *.jpg, *.gif etc.,

How to use the OpenFileDialog for Uploading picture (browse for picture) in vb.net, vs.Net:

How to connect SQL Server 2005 and its Connection Strings (C, C++, C#, Visual Studio 2008 & VB.NET)

How to connect MS Access 2007 (And a collection of MS Access connection strings)

How to connect SQL Server (A Collection of SQL connection strings)

How to store images in SQL server (2000 & 2005) for files types .bmp, .jpg, *.gif etc.,