by doing this

a. login using administrator > then Click Security > Login > right click > new user

b. new user > click search button then find the user in the domain… (i am doint this temporarily since i really need to run my program.

c. Under server rule click sysadmin

d. under user mapping tick the database that you need

e. make sure that it is grant and enabled under status

once you have chosen the user then click ok

then try running it…

good luck

by the way im using visual basic 6 and MS SQL 2005.. and is used DSN as my connection…

http://www.microsoft.com/downloads/details.aspx?FamilyId=D7E31492-2595-49E6-8C02-1426FEC693AC&displaylang=en

2. Go to Website > Add Reference…  Found the Microsoft Script control, added it, and it’s working.

Learn from http://forums.asp.net/p/1078702/1591861.aspx#1591861

3. Code:

Imports Microsoft.VisualBasic

Partial Class _Default

Inherits System.Web.UI.Page

Protected Sub submit(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles gs.Click

Response.Redirect(”http://www.google.com/search?q=” & q.Text & “&Submit+now.x=10&Submit+now.y=7&Submit+now=Submit+now&res=”)

End Sub

Protected Sub Bcal_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Bcal.Click

Dim sc As New MSScriptControl.ScriptControl()

‘ You always need to initialize a language engine

sc.Language = “VBScript”

‘ this is the expression – in a real program it will probably be  read from a textbox control

‘ Dim expr As String = “12 + 3 * 10″

Dim resu As Double = sc.Eval(q.Text)

res.Text = resu.ToString

End Sub

End Class

ST. JOSEPH – The St. Joseph City Commission approved a property tax abatement for LECO to build a $6.8 million research and development center.

The 28,400-square-foot building, to be called the Elizabeth S. Warren Separation Center, will be located at 2024 Veronica Drive. The building will be constructed in a lot bordered by Hilltop Road on the south, Cleveland Avenue on the west and Veronica Drive on the east. The property is zoned for industrial use.

The commission unanimously approved the 12-year, 50 percent abatement, which represents about $950,000 during the abatement period. Other local taxing agencies will receive $950,000 during that time, City Manager Frank Walsh said.

“I give a lot of kudos to LECO for their expansion and for keeping (the new building) in the city limits,” Commissioner Michael Garey said.

Joel DeBruyne, LECO’s vice president and secretary, said the new building is needed because of space limitations at its current research and development site. LECO creates and builds molecular spectrometry equipment.

“We anticipate much more rapid growth in the separation science,” DeBruyne said.

About 20 to 25 employees, mostly engineers, will be transferred from LECO’s current research and development building and will work in the new building, according to a project fact sheet LECO officials gave commissioners. About 105 people work at the company’s 49,600-square-foot building at 3050 Lakeview Ave.

Company officials said they expect to create five to eight new jobs within three years.

Construction is expected to cost $5.3 million, and equipment will be valued at $1.5 million.

Construction is expected to begin in April and be completed by Oct. 31, Walsh said.