Hi everyone,
The code below runs fine in Access, but in migrating to SQL Server I've run
into this error:
"Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset position
cannot be restarted."
The code (ASP) is:
#######
If Request.Form("Make") <> "" then
set objCommand = server.CreateObject("ADODB.command")
objCommand.ActiveConnection = objConn
objCommand.CommandText = "usp_ANALYZE_MAKE"
objCommand.CommandType = adCmdStoredProc
objCommand.Parameters.Refresh
objCommand.Parameters(1).Value = Request.Form("Make")
set objRS = objCommand.Execute
set objCommand = Nothing
If Not objRS.EOF then
r = objRS.GetRows
End if
If IsArray(r) Then
intRecordCount = UBound(r, 2) + 1
objRS.MoveFirst
End If
Response.Write "<p><b>Your search returned " & intRecordCount & " result(s)
for: </b></p>"
Response.Write "<blockquote>"
Response.Write "<p><b>Make</b></p>"
Response.Write "</blockquote>"
Response.Write "<p>"
Response.Write "<blockquote>"
Do until objRS.EOF
Response.Write Code Here...
objRS.MoveNext
Loop
Response.Write "</blockquote>"
Response.Write "<p></p>"
objRS.Close
set objRS = Nothing
End If
#######
Is this a case of needing to utilize (based on the above code) a different
cursor, or...? There sure are a lot of differences in how Access and SQL
Server allow you to do things (beyond 'basic' DB structure), or perhaps how
'forgiving' each of them are.
Anyone with a suggestion or workaround? Thanks.
Message posted via http://www.droptable.com
http://support.microsoft.com/kb/174225/en-us
http://groups.google.de/groups?hl=de...07%26rnum%3D11
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"The Gekkster via droptable.com" <forum@.nospam.droptable.com> schrieb im
Newsbeitrag news:2723f97d6dc4470492871a765551178f@.droptable.co m...
> Hi everyone,
> The code below runs fine in Access, but in migrating to SQL Server I've
> run
> into this error:
> "Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset
> position
> cannot be restarted."
> The code (ASP) is:
> #######
> If Request.Form("Make") <> "" then
> set objCommand = server.CreateObject("ADODB.command")
> objCommand.ActiveConnection = objConn
> objCommand.CommandText = "usp_ANALYZE_MAKE"
> objCommand.CommandType = adCmdStoredProc
> objCommand.Parameters.Refresh
> objCommand.Parameters(1).Value = Request.Form("Make")
> set objRS = objCommand.Execute
> set objCommand = Nothing
> If Not objRS.EOF then
> r = objRS.GetRows
> End if
> If IsArray(r) Then
> intRecordCount = UBound(r, 2) + 1
> objRS.MoveFirst
> End If
> Response.Write "<p><b>Your search returned " & intRecordCount & "
> result(s)
> for: </b></p>"
> Response.Write "<blockquote>"
> Response.Write "<p><b>Make</b></p>"
> Response.Write "</blockquote>"
> Response.Write "<p>"
> Response.Write "<blockquote>"
> Do until objRS.EOF
> Response.Write Code Here...
> objRS.MoveNext
> Loop
> Response.Write "</blockquote>"
> Response.Write "<p></p>"
> objRS.Close
> set objRS = Nothing
> End If
> #######
> Is this a case of needing to utilize (based on the above code) a different
> cursor, or...? There sure are a lot of differences in how Access and SQL
> Server allow you to do things (beyond 'basic' DB structure), or perhaps
> how
> 'forgiving' each of them are.
> Anyone with a suggestion or workaround? Thanks.
> --
> Message posted via http://www.droptable.com
Showing posts with label runs. Show all posts
Showing posts with label runs. Show all posts
Monday, March 12, 2012
Help with "Error 80040e18: Rowset cannot be restarted."
Hi everyone,
The code below runs fine in Access, but in migrating to SQL Server I've run
into this error:
"Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset position
cannot be restarted."
The code (ASP) is:
#######
If Request.Form("Make") <> "" then
set objCommand = server.CreateObject("ADODB.command")
objCommand.ActiveConnection = objConn
objCommand.CommandText = "usp_ANALYZE_MAKE"
objCommand.CommandType = adCmdStoredProc
objCommand.Parameters.Refresh
objCommand.Parameters(1).Value = Request.Form("Make")
set objRS = objCommand.Execute
set objCommand = Nothing
If Not objRS.EOF then
r = objRS.GetRows
End if
If IsArray(r) Then
intRecordCount = UBound(r, 2) + 1
objRS.MoveFirst
End If
Response.Write "<p><b>Your search returned " & intRecordCount & " result(s)
for: </b></p>"
Response.Write "<blockquote>"
Response.Write "<p><b>Make</b></p>"
Response.Write "</blockquote>"
Response.Write "<p>"
Response.Write "<blockquote>"
Do until objRS.EOF
Response.Write Code Here...
objRS.MoveNext
Loop
Response.Write "</blockquote>"
Response.Write "<p></p>"
objRS.Close
set objRS = Nothing
End If
#######
Is this a case of needing to utilize (based on the above code) a different
cursor, or...? There sure are a lot of differences in how Access and SQL
Server allow you to do things (beyond 'basic' DB structure), or perhaps how
'forgiving' each of them are.
Anyone with a suggestion or workaround? Thanks.
Message posted via http://www.droptable.comhttp://support.microsoft.com/kb/174225/en-us
rnum=11&prev=/ groups%3Fq%3DRowset%2Bcannot%2Bbe%2Brest
arted%2Bmovefirst%26start%3D
10%26hl%3Dde%26lr%3D%26selm%3D%2523NwSu4
7ECHA.1732%2540tkmsftngp07%26rnum%3D11[/ur
l]
HTH, Jens Suessmeyer.
[url]http://www.sqlserver2005.de" target="_blank">http://groups.google.de/groups?hl=d...qlserver2005.de
--
"The Gekkster via droptable.com" <forum@.nospam.droptable.com> schrieb im
Newsbeitrag news:2723f97d6dc4470492871a765551178f@.SQ
droptable.com...
> Hi everyone,
> The code below runs fine in Access, but in migrating to SQL Server I've
> run
> into this error:
> "Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset
> position
> cannot be restarted."
> The code (ASP) is:
> #######
> If Request.Form("Make") <> "" then
> set objCommand = server.CreateObject("ADODB.command")
> objCommand.ActiveConnection = objConn
> objCommand.CommandText = "usp_ANALYZE_MAKE"
> objCommand.CommandType = adCmdStoredProc
> objCommand.Parameters.Refresh
> objCommand.Parameters(1).Value = Request.Form("Make")
> set objRS = objCommand.Execute
> set objCommand = Nothing
> If Not objRS.EOF then
> r = objRS.GetRows
> End if
> If IsArray(r) Then
> intRecordCount = UBound(r, 2) + 1
> objRS.MoveFirst
> End If
> Response.Write "<p><b>Your search returned " & intRecordCount & "
> result(s)
> for: </b></p>"
> Response.Write "<blockquote>"
> Response.Write "<p><b>Make</b></p>"
> Response.Write "</blockquote>"
> Response.Write "<p>"
> Response.Write "<blockquote>"
> Do until objRS.EOF
> Response.Write Code Here...
> objRS.MoveNext
> Loop
> Response.Write "</blockquote>"
> Response.Write "<p></p>"
> objRS.Close
> set objRS = Nothing
> End If
> #######
> Is this a case of needing to utilize (based on the above code) a different
> cursor, or...? There sure are a lot of differences in how Access and SQL
> Server allow you to do things (beyond 'basic' DB structure), or perhaps
> how
> 'forgiving' each of them are.
> Anyone with a suggestion or workaround? Thanks.
> --
> Message posted via http://www.droptable.com
The code below runs fine in Access, but in migrating to SQL Server I've run
into this error:
"Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset position
cannot be restarted."
The code (ASP) is:
#######
If Request.Form("Make") <> "" then
set objCommand = server.CreateObject("ADODB.command")
objCommand.ActiveConnection = objConn
objCommand.CommandText = "usp_ANALYZE_MAKE"
objCommand.CommandType = adCmdStoredProc
objCommand.Parameters.Refresh
objCommand.Parameters(1).Value = Request.Form("Make")
set objRS = objCommand.Execute
set objCommand = Nothing
If Not objRS.EOF then
r = objRS.GetRows
End if
If IsArray(r) Then
intRecordCount = UBound(r, 2) + 1
objRS.MoveFirst
End If
Response.Write "<p><b>Your search returned " & intRecordCount & " result(s)
for: </b></p>"
Response.Write "<blockquote>"
Response.Write "<p><b>Make</b></p>"
Response.Write "</blockquote>"
Response.Write "<p>"
Response.Write "<blockquote>"
Do until objRS.EOF
Response.Write Code Here...
objRS.MoveNext
Loop
Response.Write "</blockquote>"
Response.Write "<p></p>"
objRS.Close
set objRS = Nothing
End If
#######
Is this a case of needing to utilize (based on the above code) a different
cursor, or...? There sure are a lot of differences in how Access and SQL
Server allow you to do things (beyond 'basic' DB structure), or perhaps how
'forgiving' each of them are.
Anyone with a suggestion or workaround? Thanks.
Message posted via http://www.droptable.comhttp://support.microsoft.com/kb/174225/en-us
rnum=11&prev=/ groups%3Fq%3DRowset%2Bcannot%2Bbe%2Brest
arted%2Bmovefirst%26start%3D
10%26hl%3Dde%26lr%3D%26selm%3D%2523NwSu4
7ECHA.1732%2540tkmsftngp07%26rnum%3D11[/ur
l]
HTH, Jens Suessmeyer.
[url]http://www.sqlserver2005.de" target="_blank">http://groups.google.de/groups?hl=d...qlserver2005.de
--
"The Gekkster via droptable.com" <forum@.nospam.droptable.com> schrieb im
Newsbeitrag news:2723f97d6dc4470492871a765551178f@.SQ
droptable.com...
> Hi everyone,
> The code below runs fine in Access, but in migrating to SQL Server I've
> run
> into this error:
> "Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset
> position
> cannot be restarted."
> The code (ASP) is:
> #######
> If Request.Form("Make") <> "" then
> set objCommand = server.CreateObject("ADODB.command")
> objCommand.ActiveConnection = objConn
> objCommand.CommandText = "usp_ANALYZE_MAKE"
> objCommand.CommandType = adCmdStoredProc
> objCommand.Parameters.Refresh
> objCommand.Parameters(1).Value = Request.Form("Make")
> set objRS = objCommand.Execute
> set objCommand = Nothing
> If Not objRS.EOF then
> r = objRS.GetRows
> End if
> If IsArray(r) Then
> intRecordCount = UBound(r, 2) + 1
> objRS.MoveFirst
> End If
> Response.Write "<p><b>Your search returned " & intRecordCount & "
> result(s)
> for: </b></p>"
> Response.Write "<blockquote>"
> Response.Write "<p><b>Make</b></p>"
> Response.Write "</blockquote>"
> Response.Write "<p>"
> Response.Write "<blockquote>"
> Do until objRS.EOF
> Response.Write Code Here...
> objRS.MoveNext
> Loop
> Response.Write "</blockquote>"
> Response.Write "<p></p>"
> objRS.Close
> set objRS = Nothing
> End If
> #######
> Is this a case of needing to utilize (based on the above code) a different
> cursor, or...? There sure are a lot of differences in how Access and SQL
> Server allow you to do things (beyond 'basic' DB structure), or perhaps
> how
> 'forgiving' each of them are.
> Anyone with a suggestion or workaround? Thanks.
> --
> Message posted via http://www.droptable.com
Help with "Error 80040e18: Rowset cannot be restarted."
Hi everyone,
The code below runs fine in Access, but in migrating to SQL Server I've run
into this error:
"Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset position
cannot be restarted."
The code (ASP) is:
#######
If Request.Form("Make") <> "" then
set objCommand = server.CreateObject("ADODB.command")
objCommand.ActiveConnection = objConn
objCommand.CommandText = "usp_ANALYZE_MAKE"
objCommand.CommandType = adCmdStoredProc
objCommand.Parameters.Refresh
objCommand.Parameters(1).Value = Request.Form("Make")
set objRS = objCommand.Execute
set objCommand = Nothing
If Not objRS.EOF then
r = objRS.GetRows
End if
If IsArray(r) Then
intRecordCount = UBound(r, 2) + 1
objRS.MoveFirst
End If
Response.Write "<p><b>Your search returned " & intRecordCount & " result(s)
for: </b></p>"
Response.Write "<blockquote>"
Response.Write "<p><b>Make</b></p>"
Response.Write "</blockquote>"
Response.Write "<p>"
Response.Write "<blockquote>"
Do until objRS.EOF
Response.Write Code Here...
objRS.MoveNext
Loop
Response.Write "</blockquote>"
Response.Write "<p></p>"
objRS.Close
set objRS = Nothing
End If
#######
Is this a case of needing to utilize (based on the above code) a different
cursor, or...? There sure are a lot of differences in how Access and SQL
Server allow you to do things (beyond 'basic' DB structure), or perhaps how
'forgiving' each of them are.
Anyone with a suggestion or workaround? Thanks.
--
Message posted via http://www.sqlmonster.comhttp://support.microsoft.com/kb/174225/en-us
http://groups.google.de/groups?hl=de&lr=&threadm=%23NwSu47ECHA.1732%40tkmsftngp07&rnum=11&prev=/groups%3Fq%3DRowset%2Bcannot%2Bbe%2Brestarted%2Bmovefirst%26start%3D10%26hl%3Dde%26lr%3D%26selm%3D%2523NwSu47ECHA.1732%2540tkmsftngp07%26rnum%3D11
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"The Gekkster via SQLMonster.com" <forum@.nospam.SQLMonster.com> schrieb im
Newsbeitrag news:2723f97d6dc4470492871a765551178f@.SQLMonster.com...
> Hi everyone,
> The code below runs fine in Access, but in migrating to SQL Server I've
> run
> into this error:
> "Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset
> position
> cannot be restarted."
> The code (ASP) is:
> #######
> If Request.Form("Make") <> "" then
> set objCommand = server.CreateObject("ADODB.command")
> objCommand.ActiveConnection = objConn
> objCommand.CommandText = "usp_ANALYZE_MAKE"
> objCommand.CommandType = adCmdStoredProc
> objCommand.Parameters.Refresh
> objCommand.Parameters(1).Value = Request.Form("Make")
> set objRS = objCommand.Execute
> set objCommand = Nothing
> If Not objRS.EOF then
> r = objRS.GetRows
> End if
> If IsArray(r) Then
> intRecordCount = UBound(r, 2) + 1
> objRS.MoveFirst
> End If
> Response.Write "<p><b>Your search returned " & intRecordCount & "
> result(s)
> for: </b></p>"
> Response.Write "<blockquote>"
> Response.Write "<p><b>Make</b></p>"
> Response.Write "</blockquote>"
> Response.Write "<p>"
> Response.Write "<blockquote>"
> Do until objRS.EOF
> Response.Write Code Here...
> objRS.MoveNext
> Loop
> Response.Write "</blockquote>"
> Response.Write "<p></p>"
> objRS.Close
> set objRS = Nothing
> End If
> #######
> Is this a case of needing to utilize (based on the above code) a different
> cursor, or...? There sure are a lot of differences in how Access and SQL
> Server allow you to do things (beyond 'basic' DB structure), or perhaps
> how
> 'forgiving' each of them are.
> Anyone with a suggestion or workaround? Thanks.
> --
> Message posted via http://www.sqlmonster.com
The code below runs fine in Access, but in migrating to SQL Server I've run
into this error:
"Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset position
cannot be restarted."
The code (ASP) is:
#######
If Request.Form("Make") <> "" then
set objCommand = server.CreateObject("ADODB.command")
objCommand.ActiveConnection = objConn
objCommand.CommandText = "usp_ANALYZE_MAKE"
objCommand.CommandType = adCmdStoredProc
objCommand.Parameters.Refresh
objCommand.Parameters(1).Value = Request.Form("Make")
set objRS = objCommand.Execute
set objCommand = Nothing
If Not objRS.EOF then
r = objRS.GetRows
End if
If IsArray(r) Then
intRecordCount = UBound(r, 2) + 1
objRS.MoveFirst
End If
Response.Write "<p><b>Your search returned " & intRecordCount & " result(s)
for: </b></p>"
Response.Write "<blockquote>"
Response.Write "<p><b>Make</b></p>"
Response.Write "</blockquote>"
Response.Write "<p>"
Response.Write "<blockquote>"
Do until objRS.EOF
Response.Write Code Here...
objRS.MoveNext
Loop
Response.Write "</blockquote>"
Response.Write "<p></p>"
objRS.Close
set objRS = Nothing
End If
#######
Is this a case of needing to utilize (based on the above code) a different
cursor, or...? There sure are a lot of differences in how Access and SQL
Server allow you to do things (beyond 'basic' DB structure), or perhaps how
'forgiving' each of them are.
Anyone with a suggestion or workaround? Thanks.
--
Message posted via http://www.sqlmonster.comhttp://support.microsoft.com/kb/174225/en-us
http://groups.google.de/groups?hl=de&lr=&threadm=%23NwSu47ECHA.1732%40tkmsftngp07&rnum=11&prev=/groups%3Fq%3DRowset%2Bcannot%2Bbe%2Brestarted%2Bmovefirst%26start%3D10%26hl%3Dde%26lr%3D%26selm%3D%2523NwSu47ECHA.1732%2540tkmsftngp07%26rnum%3D11
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"The Gekkster via SQLMonster.com" <forum@.nospam.SQLMonster.com> schrieb im
Newsbeitrag news:2723f97d6dc4470492871a765551178f@.SQLMonster.com...
> Hi everyone,
> The code below runs fine in Access, but in migrating to SQL Server I've
> run
> into this error:
> "Microsoft OLE DB Provider for SQL Server error '80040e18'. Rowset
> position
> cannot be restarted."
> The code (ASP) is:
> #######
> If Request.Form("Make") <> "" then
> set objCommand = server.CreateObject("ADODB.command")
> objCommand.ActiveConnection = objConn
> objCommand.CommandText = "usp_ANALYZE_MAKE"
> objCommand.CommandType = adCmdStoredProc
> objCommand.Parameters.Refresh
> objCommand.Parameters(1).Value = Request.Form("Make")
> set objRS = objCommand.Execute
> set objCommand = Nothing
> If Not objRS.EOF then
> r = objRS.GetRows
> End if
> If IsArray(r) Then
> intRecordCount = UBound(r, 2) + 1
> objRS.MoveFirst
> End If
> Response.Write "<p><b>Your search returned " & intRecordCount & "
> result(s)
> for: </b></p>"
> Response.Write "<blockquote>"
> Response.Write "<p><b>Make</b></p>"
> Response.Write "</blockquote>"
> Response.Write "<p>"
> Response.Write "<blockquote>"
> Do until objRS.EOF
> Response.Write Code Here...
> objRS.MoveNext
> Loop
> Response.Write "</blockquote>"
> Response.Write "<p></p>"
> objRS.Close
> set objRS = Nothing
> End If
> #######
> Is this a case of needing to utilize (based on the above code) a different
> cursor, or...? There sure are a lot of differences in how Access and SQL
> Server allow you to do things (beyond 'basic' DB structure), or perhaps
> how
> 'forgiving' each of them are.
> Anyone with a suggestion or workaround? Thanks.
> --
> Message posted via http://www.sqlmonster.com
Help when renaming server
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the database engine up and about. Do any of you have good resources (URL's) or other information which you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
Hi
Look at sp_dropserver and sp_addserver in the BOL.
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the database engine up and about. Do any of you have good resources (URL's) or other information which you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
|||Hi
After having renamed the server, you just need to run sp_dropserver and then sp_addserver. You can look up the syntax in BOL.
Regards
Steen
"Mr. Smith" <nospam@.blindfolded.gone> skrev i en meddelelse news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the database engine up and about. Do any of you have good resources (URL's) or other information which you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
|||There's more to it than only sp_dropserver and sp_addserver. Especially for a 7.0 SQL Server. Check
out http://www.karaszi.com/SQLServer/inf...erver_name.asp for more information.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs
our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the
database engine up and about. Do any of you have good resources (URL's) or other information which
you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
|||Thanks Tibor.
The URL whas just what I needed.
Mr. Smith
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eYs%235vYGFHA.3732@.TK2MSFTNGP14.phx.gbl...
> There's more to it than only sp_dropserver and sp_addserver. Especially
for a 7.0 SQL Server. Check
> out http://www.karaszi.com/SQLServer/inf...erver_name.asp for more
information.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
> Hi.
> Due to corporate guidelines we are "forced" to change the name of our
Windows 2000 server which runs
> our precious SQL 7.0 server. I guess there are some issues I have to deal
with afterwards to get the
> database engine up and about. Do any of you have good resources (URL's) or
other information which
> you may share with me, to enable us rename our server without to much
hassle. Please.
>
> Bst Regards
> Mr. Smith
>
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the database engine up and about. Do any of you have good resources (URL's) or other information which you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
Hi
Look at sp_dropserver and sp_addserver in the BOL.
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the database engine up and about. Do any of you have good resources (URL's) or other information which you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
|||Hi
After having renamed the server, you just need to run sp_dropserver and then sp_addserver. You can look up the syntax in BOL.
Regards
Steen
"Mr. Smith" <nospam@.blindfolded.gone> skrev i en meddelelse news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the database engine up and about. Do any of you have good resources (URL's) or other information which you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
|||There's more to it than only sp_dropserver and sp_addserver. Especially for a 7.0 SQL Server. Check
out http://www.karaszi.com/SQLServer/inf...erver_name.asp for more information.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Windows 2000 server which runs
our precious SQL 7.0 server. I guess there are some issues I have to deal with afterwards to get the
database engine up and about. Do any of you have good resources (URL's) or other information which
you may share with me, to enable us rename our server without to much hassle. Please.
Bst Regards
Mr. Smith
|||Thanks Tibor.
The URL whas just what I needed.
Mr. Smith
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eYs%235vYGFHA.3732@.TK2MSFTNGP14.phx.gbl...
> There's more to it than only sp_dropserver and sp_addserver. Especially
for a 7.0 SQL Server. Check
> out http://www.karaszi.com/SQLServer/inf...erver_name.asp for more
information.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
> Hi.
> Due to corporate guidelines we are "forced" to change the name of our
Windows 2000 server which runs
> our precious SQL 7.0 server. I guess there are some issues I have to deal
with afterwards to get the
> database engine up and about. Do any of you have good resources (URL's) or
other information which
> you may share with me, to enable us rename our server without to much
hassle. Please.
>
> Bst Regards
> Mr. Smith
>
Help when renaming server
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. SmithHi
Look at sp_dropserver and sp_addserver in the BOL.
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.
TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. Smith|||Hi
After having renamed the server, you just need to run sp_dropserver and then
sp_addserver. You can look up the syntax in BOL.
Regards
Steen
"Mr. Smith" <nospam@.blindfolded.gone> skrev i en meddelelse news:uB9V6KYGFHA
.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. Smith|||There's more to it than only sp_dropserver and sp_addserver. Especially for
a 7.0 SQL Server. Check
out http://www.karaszi.com/SQLServer/in...server_name.asp for more in
formation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.
TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs
our precious SQL 7.0 server. I guess there are some issues I have to deal wi
th afterwards to get the
database engine up and about. Do any of you have good resources (URL's) or o
ther information which
you may share with me, to enable us rename our server without to much hassle
. Please.
Bst Regards
Mr. Smith|||Thanks Tibor.
The URL whas just what I needed.
Mr. Smith
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eYs%235vYGFHA.3732@.TK2MSFTNGP14.phx.gbl...
> There's more to it than only sp_dropserver and sp_addserver. Especially
for a 7.0 SQL Server. Check
> out http://www.karaszi.com/SQLServer/in...server_name.asp for more
information.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
> Hi.
> Due to corporate guidelines we are "forced" to change the name of our
Windows 2000 server which runs
> our precious SQL 7.0 server. I guess there are some issues I have to deal
with afterwards to get the
> database engine up and about. Do any of you have good resources (URL's) or
other information which
> you may share with me, to enable us rename our server without to much
hassle. Please.
>
> Bst Regards
> Mr. Smith
>
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. SmithHi
Look at sp_dropserver and sp_addserver in the BOL.
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.
TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. Smith|||Hi
After having renamed the server, you just need to run sp_dropserver and then
sp_addserver. You can look up the syntax in BOL.
Regards
Steen
"Mr. Smith" <nospam@.blindfolded.gone> skrev i en meddelelse news:uB9V6KYGFHA
.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. Smith|||There's more to it than only sp_dropserver and sp_addserver. Especially for
a 7.0 SQL Server. Check
out http://www.karaszi.com/SQLServer/in...server_name.asp for more in
formation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.
TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs
our precious SQL 7.0 server. I guess there are some issues I have to deal wi
th afterwards to get the
database engine up and about. Do any of you have good resources (URL's) or o
ther information which
you may share with me, to enable us rename our server without to much hassle
. Please.
Bst Regards
Mr. Smith|||Thanks Tibor.
The URL whas just what I needed.
Mr. Smith
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eYs%235vYGFHA.3732@.TK2MSFTNGP14.phx.gbl...
> There's more to it than only sp_dropserver and sp_addserver. Especially
for a 7.0 SQL Server. Check
> out http://www.karaszi.com/SQLServer/in...server_name.asp for more
information.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
> Hi.
> Due to corporate guidelines we are "forced" to change the name of our
Windows 2000 server which runs
> our precious SQL 7.0 server. I guess there are some issues I have to deal
with afterwards to get the
> database engine up and about. Do any of you have good resources (URL's) or
other information which
> you may share with me, to enable us rename our server without to much
hassle. Please.
>
> Bst Regards
> Mr. Smith
>
Friday, February 24, 2012
help setting up and using SQLXML web service ?
Hi,
I have an app that connects to a remote SQL database using 1433. It
connecting using a locked down user then runs a stored procedure passing it
XML.
Roger Walter pointed me in the direction of SOAP, SQLXML web service.
I installed:
SoapToolkit 2.0
SoapToolkit 3.0
SQLXML 3.0 sp2
Now this is done i don't see any amendments to IIS (restarted) . What should
i see ?
How do i talk to the webservice ?
What should be install in services ?
Was hoping i can just pass user/pass/xml to webservice to run stored
procedures in same way i am at the moment just with slighty connection
changes.
Please help.
ScottI found this:
1.. Download SqlXml 3.0 (this test was done with Sp2 Beta 1).
2.. Run the installation program. You will need to also install the SOAP
toolkit if you want to use the SqlXml SOAP features.
3.. Open the IIS Virtual Directory Management tool under Start ->
Programs -> SqlXml 3.0 -> Configure IIS.
4.. Create a new virtual directory. Enter the information on the General
tab and the Security tab. When you go to the Data Source tab you should be
able to browse the databases on the server. If you can't then you need to
check your security settings.
5.. Turn on Allow sql= queries so that you can test your setup. Make sure
you turn this off when you are done testing.
I am finding however that i cant browse to my index page in the new virual
directory. This index page is basic aspx for login, no sql connection
required.
I have an app that connects to a remote SQL database using 1433. It
connecting using a locked down user then runs a stored procedure passing it
XML.
Roger Walter pointed me in the direction of SOAP, SQLXML web service.
I installed:
SoapToolkit 2.0
SoapToolkit 3.0
SQLXML 3.0 sp2
Now this is done i don't see any amendments to IIS (restarted) . What should
i see ?
How do i talk to the webservice ?
What should be install in services ?
Was hoping i can just pass user/pass/xml to webservice to run stored
procedures in same way i am at the moment just with slighty connection
changes.
Please help.
ScottI found this:
1.. Download SqlXml 3.0 (this test was done with Sp2 Beta 1).
2.. Run the installation program. You will need to also install the SOAP
toolkit if you want to use the SqlXml SOAP features.
3.. Open the IIS Virtual Directory Management tool under Start ->
Programs -> SqlXml 3.0 -> Configure IIS.
4.. Create a new virtual directory. Enter the information on the General
tab and the Security tab. When you go to the Data Source tab you should be
able to browse the databases on the server. If you can't then you need to
check your security settings.
5.. Turn on Allow sql= queries so that you can test your setup. Make sure
you turn this off when you are done testing.
I am finding however that i cant browse to my index page in the new virual
directory. This index page is basic aspx for login, no sql connection
required.
help setting up and using SQLXML web service ?
Hi,
I have an app that connects to a remote SQL database using 1433. It
connecting using a locked down user then runs a stored procedure passing it
XML.
Roger Walter pointed me in the direction of SOAP, SQLXML web service.
I installed:
SoapToolkit 2.0
SoapToolkit 3.0
SQLXML 3.0 sp2
Now this is done i don't see any amendments to IIS (restarted) . What should
i see ?
How do i talk to the webservice ?
What should be install in services ?
Was hoping i can just pass user/pass/xml to webservice to run stored
procedures in same way i am at the moment just with slighty connection
changes.
Please help.
ScottI found this:
1.. Download SqlXml 3.0 (this test was done with Sp2 Beta 1).
2.. Run the installation program. You will need to also install the SOAP
toolkit if you want to use the SqlXml SOAP features.
3.. Open the IIS Virtual Directory Management tool under Start ->
Programs -> SqlXml 3.0 -> Configure IIS.
4.. Create a new virtual directory. Enter the information on the General
tab and the Security tab. When you go to the Data Source tab you should be
able to browse the databases on the server. If you can't then you need to
check your security settings.
5.. Turn on Allow sql= queries so that you can test your setup. Make sure
you turn this off when you are done testing.
I am finding however that i cant browse to my index page in the new virual
directory. This index page is basic aspx for login, no sql connection
required.
I have an app that connects to a remote SQL database using 1433. It
connecting using a locked down user then runs a stored procedure passing it
XML.
Roger Walter pointed me in the direction of SOAP, SQLXML web service.
I installed:
SoapToolkit 2.0
SoapToolkit 3.0
SQLXML 3.0 sp2
Now this is done i don't see any amendments to IIS (restarted) . What should
i see ?
How do i talk to the webservice ?
What should be install in services ?
Was hoping i can just pass user/pass/xml to webservice to run stored
procedures in same way i am at the moment just with slighty connection
changes.
Please help.
ScottI found this:
1.. Download SqlXml 3.0 (this test was done with Sp2 Beta 1).
2.. Run the installation program. You will need to also install the SOAP
toolkit if you want to use the SqlXml SOAP features.
3.. Open the IIS Virtual Directory Management tool under Start ->
Programs -> SqlXml 3.0 -> Configure IIS.
4.. Create a new virtual directory. Enter the information on the General
tab and the Security tab. When you go to the Data Source tab you should be
able to browse the databases on the server. If you can't then you need to
check your security settings.
5.. Turn on Allow sql= queries so that you can test your setup. Make sure
you turn this off when you are done testing.
I am finding however that i cant browse to my index page in the new virual
directory. This index page is basic aspx for login, no sql connection
required.
Subscribe to:
Posts (Atom)