Connecting Visual Basic to sql 2005

[JAMAAL26]

I am working as a freelancer. In my current project I have to upgrade the current version of database from access to SQL Express 2005, so that client can enter the data on their server and simultaneously it can be view on site.
Problem arises when I tried to connect Visual Basic 6 to SQL Express 2005. Can anybody help me with this problem.

[opaper]

Perform following steps for connecting Visual Basic 6 to SQL EXPRESS 2005.
1. Download .Net Framework 3.5
2. Specify MDAC 2.8" Project -> References -> Select Microsoft ActiveX Data Objects 2.8 library
3. Type the following query string, assuming that your UserName= ABC and Password = XYZ
Provider=SQLNCLI.1 in the connection string, such as
"Provider=SQLNCLI.1;Data Source=DataSourceName;
User ID=ABC;Password=XYZ"

[Zecho]

You have import, the database from access and export to SQL Express using its tools.
This process will save your potential amount of time of creating the database and tables in SQL Express 2005.
Then use the similar type of query string.

[MindSpace]

Retrieving SQL Express data into Visual Basic from MHSFLEX GRID
Try the following snippet.
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=" & App.Path & "\northwnd.mdf;Data Source=server1\sqlexpress"
cn.Open

Dim rs As Recordset
Set rs = New Recordset
rs.Open "Select * from orders", cn
Set MSHFlexGrid1.DataSource = rs

Techniques to create views or to display intermediate information while transaction. This technique is known as common table expression.
Following code snippet will create a common table expression
WITH CountTerritories(RegionID, TerritoryCount) AS
(
SELECT
RegionID,
count(*) AS TerritoryCount
FROM Territories
GROUP BY RegionID
)
SELECT * FROM CountTerritories WHERE TerritoryCount =
(
SELECT max(TerritoryCount) FROM CountTerritories
)

Temporary view CoutTerritories is created for single select statement.