Explorer Script Error

Ever time I open Enterprise Manager and select the database to work on, I
recieve an Internet Script Error
LINE: 307
Char: 2
Error: Unspecified
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\10
33\sqlmmc.rll/Tabs.htmlFor that error, Change the view for the database in
Enterprise Manager to something other than task pad. Then
close Enterprise Manager. The reopen Enterprise Manager and
change the view back to task pad. You should be able to
proceed from there without errors.
-Sue
On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
<rrowe68@.hotmail.com> wrote:
>Ever time I open Enterprise Manager and select the database to work on, I
>recieve an Internet Script Error
>
>LINE: 307
>Char: 2
>Error: Unspecified
>Code: 0
>URL:
>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\10
>33\sqlmmc.rll/Tabs.html
>|||Thanks - but if I want to view the task pad - do you know of a fix?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:h6g0qv499idhe0iq9vebftffiuaquuepfh@.4ax.com...
> For that error, Change the view for the database in
> Enterprise Manager to something other than task pad. Then
> close Enterprise Manager. The reopen Enterprise Manager and
> change the view back to task pad. You should be able to
> proceed from there without errors.
> -Sue
> On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
> <rrowe68@.hotmail.com> wrote:
> >Ever time I open Enterprise Manager and select the database to work on, I
> >recieve an Internet Script Error
> >
> >
> >LINE: 307
> >Char: 2
> >Error: Unspecified
> >Code: 0
> >URL:
>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1
0
> >33\sqlmmc.rll/Tabs.html
> >
>|||After changing it to something else other than task pad,
closing Enterprise Manager, you can reopen and then change
the view back to task pad.
I don't think there is any fix other than going through this
routine when you get the error.
-Sue
On Wed, 29 Oct 2003 16:01:43 -0800, "Bob"
<rrowe68@.hotmail.com> wrote:
>Thanks - but if I want to view the task pad - do you know of a fix?
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:h6g0qv499idhe0iq9vebftffiuaquuepfh@.4ax.com...
>> For that error, Change the view for the database in
>> Enterprise Manager to something other than task pad. Then
>> close Enterprise Manager. The reopen Enterprise Manager and
>> change the view back to task pad. You should be able to
>> proceed from there without errors.
>> -Sue
>> On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
>> <rrowe68@.hotmail.com> wrote:
>> >Ever time I open Enterprise Manager and select the database to work on, I
>> >recieve an Internet Script Error
>> >
>> >
>> >LINE: 307
>> >Char: 2
>> >Error: Unspecified
>> >Code: 0
>> >URL:
>>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1
>0
>> >33\sqlmmc.rll/Tabs.html
>> >
>|||That did it -- Thanks.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:rsl0qvk2midqee2rms1rmj8kse0egf232t@.4ax.com...
> After changing it to something else other than task pad,
> closing Enterprise Manager, you can reopen and then change
> the view back to task pad.
> I don't think there is any fix other than going through this
> routine when you get the error.
> -Sue
> On Wed, 29 Oct 2003 16:01:43 -0800, "Bob"
> <rrowe68@.hotmail.com> wrote:
> >Thanks - but if I want to view the task pad - do you know of a fix?
> >
> >
> >
> >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> >news:h6g0qv499idhe0iq9vebftffiuaquuepfh@.4ax.com...
> >> For that error, Change the view for the database in
> >> Enterprise Manager to something other than task pad. Then
> >> close Enterprise Manager. The reopen Enterprise Manager and
> >> change the view back to task pad. You should be able to
> >> proceed from there without errors.
> >>
> >> -Sue
> >>
> >> On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
> >> <rrowe68@.hotmail.com> wrote:
> >>
> >> >Ever time I open Enterprise Manager and select the database to work
on, I
> >> >recieve an Internet Script Error
> >> >
> >> >
> >> >LINE: 307
> >> >Char: 2
> >> >Error: Unspecified
> >> >Code: 0
> >> >URL:
> >>
>>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\
1
> >0
> >> >33\sqlmmc.rll/Tabs.html
> >> >
> >>
> >
>

Explanation wanted about the Service Principal Name ( SPN )

Hello,

In the ErrorLog of my Sql Server , i found this line :

2007-06-26 05:35:18.37 Serveur The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.

Operating System XP Home SP2

SQL Server 2005 Express Edition with Advanced SP1 )

( idem for another workstation with XP Pro SP2 and same version of SQL Server 2005 Express

My problem is :

i want use the windows authentification but my computers are on Worhkgroup linked by a router ( no window server )

i have read that's possible to connect from a remote computer to a computer having a SQL Server 2005 Express through SPN

How can i do it ? ( activating NTLM ? but how ?)

I'm writing a C# program which must be executing on several computers with a SQL Server 2005 Express installed on a particular computer. These computers will belong to a domain of Windows Server 2003.

As i can't connect to this "normal" network, i am trying to simulate this network at home because i want to test this program and especially the possible locks problems.

I don't know whether i'm querying with the "correct" forum.

Sorry for my poor english.

I shall appreciate any help about this problem

Have a nice day

hi,

actually is not "a problem", as the message in the log already states.. it's informational only..

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

http://support.microsoft.com/kb/909801/en-us

regards

Expected end of statement

i got this kind of error type:

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/wanhe/services/update_succeed.asp, line 80, column 129
sqlStrDB = "update applicant set Name='"&username&"', Gender= '"&gender&"', Age='"&age&"',Marriage='"&maritalstatus&"',HighEdu='"&hEducation&"',EngScore='"&engScore&"',ToeflScore='"&toeflScore&"',IeltsScore='"&ieltsScore&"',FysmScore='"&fysmScore&"',NcetScore='"&ncetScore&"',Tel='"&coTel&"',Mobile='"&coMobile&"',Email='"&coEmail&"',AppSchool='"&appSchool&"',AppMajor='"&appMajor&"',Comment='"&coComment&"',companyNameCN='"&coNameCN&"',companyNameEN='"&coNameEN&"',CoAddress='"&coAddress&"',CoPostal='"&coPostal&"' where ID = "&userID&""

this is my coding:
<%
dim cnStrDB
dim rcSetDB
dim sqlStrDB

'create connection and recordset objects
Set cnStrDB = Server.CreateObject("ADODB.Connection")
Set rcSetDB = Server.CreateObject("ADODB.Recordset")

' connection string
dim pathDB
dim providerDB

' change this path to your database path
pathDB = "C:\Inetpub\wwwroot\wanhe\services\oApplication.mdb "
providerDB = "Microsoft.Jet.OLEDB.4.0"

' defining database connection (connectionstring.asp)
cnStrDB.ConnectionString = pathDB
cnStrDB.Provider = providerDB
cnStrDB.Mode = 3

cnStrDB.open
dim username
Dim coNameCN
Dim coNameEN
Dim coAddress
Dim coPostal
dim gender
dim age
dim maritalstatus
dim hEducation
dim engScore
dim toeflScore
dim ieltsScore
dim fysmScore
dim ncetScore
dim appSchool
dim appMajor
Dim coTel
Dim userID
Dim coMobile
dim coEmail
dim coComment

username = request.form("userName")
coNameCN = request.form("txtCoNameCN")
coNameEN= request.form("txtCoNameEN")
coAddress= request.form("txtCoAddress")
coPostal= request.form("txtPostal")
coTel= request.form("Tel")
coMobile= request.form("Mobile")
coEmail= request.form("Email")
coComment= request.form("Comment")
gender= request.form("Gender")
age= request.form("Age")
maritalstatus= request.form("Age")
hEducation= request.form("highEdu")
'response.write hEducation
'response.end
engScore= request.form("EngScore")
toeflScore= request.form("ToeflScore")
ieltsScore= request.form("IeltsScore")
fysmScore= request.form("FysmScore")
ncetScore= request.form("NcetScore")
appSchool= request.form("AppSchool")
appMajor= request.form("AppMajor")

userID=Request.cookies("ID")

sqlStrDB = "update applicant set Name= '"&username&"', Gender= '"&gender&"', Age='"&age&"',Marriage='"&maritalstatus&"', HighEdu='"&hEducation&"', EngScore='"&engScore&"',ToeflScore='"&toeflScore&"',IeltsScore='"&ieltsScore&"',FysmScore='"&fysmScore&"',NcetScore='"&ncetScore&"',Tel='"&coTel&"',Mobile='"&coMobile&"',Email='"&coEmail&"',AppSchool='"&appSchool&"',AppMajor='"&appMajor&"',Comment='"&coComment&"',companyNameCN='"&coNameCN&"',companyNameEN='"&coNameEN&"',CoAddress='"&coAddress&"',CoPostal='"&coPostal&"' where ID = "&userID&""

rcSetDB.ActiveConnection = cnStrDB
rcSetDB.cursorType = 3 'for add record into database
rcSetDB.cursorLocation = 3
rcSetDB.open(sqlStrDB)

%>

i know it's somehting wrong with
HighEdu='"&hEducation&"
but i cant find where is wrong

anyone can helps me??
thanks a lot
:()Maybe that "" at the end should have been ";"?

You should really use prepared statements with bind variables. Not only do they improve performance and remove a security loophole, they also make it easier to write your SQL:

sqlStrDB = "update applicant set Name=?, Gender=?, Age=?,Marriage=?, HighEdu=?, ... , CoPostal=? where ID = ?;"|||same error message|||your first line:
sqlStrDB = "Your statement" _ (add the "_" at the end)

your second line:
& "Your statement" (add "&" at the first)

try to manipulate it if error happens again. I think it should work because you have to separate your string to another lines by these characters.

regards.

chris|||the problem is the variable name
i change to another name can liao

by the way thanks for ur help