Consecutive values

Hi,
Given the following dataset, how can I determine the maximum number of
consecutive Bs for a given A?
A B
- -
2 1
2 2
2 7
3 2
3 3
3 4
3 6
3 8
3 9
3 10
3 13
3 14
3 15
3 16
4 1
4 3
4 5
4 6
4 7
4 8
4 10
5...
So the output should resemble:
A MAX Count for B
- -
2 2 -- for 1 2
3 4 -- for 13 14 15 16
4 1 -- no consecutive numbers
5...
Thanks
JerryHomework assignment?
Tom Dacon
Dacon Software Consulting
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u1EPMXv5FHA.2600@.tk2msftngp13.phx.gbl...
> Hi,
> Given the following dataset, how can I determine the maximum number of
> consecutive Bs for a given A?
> A B
> - -
> 2 1
> 2 2
> 2 7
> 3 2
> 3 3
> 3 4
> 3 6
> 3 8
> 3 9
> 3 10
> 3 13
> 3 14
> 3 15
> 3 16
> 4 1
> 4 3
> 4 5
> 4 6
> 4 7
> 4 8
> 4 10
> 5...
> So the output should resemble:
> A MAX Count for B
> - -
> 2 2 -- for 1 2
> 3 4 -- for 13 14 15 16
> 4 1 -- no consecutive numbers
> 5...
> Thanks
> Jerry
>|||untested, as I'm at home:
select a, max(maxb - b + 1)
from(select a, b, (select max(b) from t t1 where t.a=t1.a and t1.b=t.b+
(select count(*) from t t2 where t2.a=t1.a and t.b<t2.b and t2.b<t1.b)
) maxb from t) t
group by a
could be easier with row_number()|||>Homework assignment?
I googled up:
Jerry Spivey MCT, MCSE, MCSD Senior SQL|||Homework...nah...question from a friend.
Yeah...MCDBA, MCP...just too many letters! ;-)
Good question though :-)
"Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
news:1131738216.490554.128630@.g43g2000cwa.googlegroups.com...
> I googled up:
> Jerry Spivey MCT, MCSE, MCSD Senior SQL
>|||Alexander,
Thanks for the post. The untested query yeilded the following resultset:
1 1
2 1
3 1
4 1
5 1
6 1
Any other queries to try?
Thanks
Jerry
"Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
news:1131738038.314420.248450@.f14g2000cwb.googlegroups.com...
> untested, as I'm at home:
> select a, max(maxb - b + 1)
> from(select a, b, (select max(b) from t t1 where t.a=t1.a and t1.b=t.b+
> (select count(*) from t t2 where t2.a=t1.a and t.b<t2.b and t2.b<t1.b)
> ) maxb from t) t
> group by a
> could be easier with row_number()
>|||If my friend's enemy is my enemy, then is my friend's homework my homework?
:)
ML|||untested, as I'm still at home and bored:
assuming combination (a,b) is unique
select s1.a, max(s2.ctb-s1.ctb+1)
from
(select a, b, (select count(*) from tb t2 where t1.a=t2.a and
t1.b<=t2.b) ctb from tb t1 ) s1,
(select a, b, (select count(*) from tb t2 where t1.a=t2.a and
t1.b<=t2.b) ctb from tb t1 ) s2
where s1.a=s2.a
and (s2.b-s1.b)=(s2.ctb-s1.ctb)
group by s1.a
not sure what was wrong with the previous one, maybe because I used t
twice, both as the table name and as an alias.
another one:
select a, max(bmin - b +1) from
(
select left_end.a,left_end.b, min(right_end.b) bmin
from
(
select a, b where not exists(
select 1 from tb t1
where t1.a=t.a
and (t1.b+1)=t.b
from tb t)
) left_end,
(
select a, b where not exists(
select 1 from tb t1
where t1.a=t.a
and (t1.b-1)=t.b
from tb t)
) right_end
where left_end.a=right_end.a
and left_end.b<=right_end.b
group by left_end.a, left_end.b) intervals|||On Fri, 11 Nov 2005 11:26:19 -0800, Jerry Spivey wrote:

>Hi,
>Given the following dataset, how can I determine the maximum number of
>consecutive Bs for a given A?
(snip)
>A MAX Count for B
>- -
>2 2 -- for 1 2
>3 4 -- for 13 14 15 16
>4 1 -- no consecutive numbers
>5...
Hi Jerry,
Why should the series (4 5)/(4 6)/(4 7)/(4 8) not be reported as a
consecutive series? An error in your post, I presume.
The following is untested. Check out www.aspfaq.com/5006 if you prefer a
tested reply.
SELECT A, MAX(last - first)
FROM (SELECT f.A, f.B AS first, MIN(l.B) AS last
FROM YourTable AS f
INNER JOIN YourTable AS l
ON l.A = f.A
AND l.B >= f.B
WHERE NOT EXISTS
(SELECT *
FROM YourTable AS b
WHERE b.A = f.A
AND b.B = f.B - 1)
AND NOT EXISTS
(SELECT *
FROM YourTable AS a
WHERE a.A = f.A
AND a.B = l.B + 1)
GROUP BY f.A, f.B) AS seq
GROUP BY A
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

connot connect to the repository with Analysis Service

I have a problem with Analysis Services.

When I open Analysis Manager and try to connect to the SQL server with Analysis Service, the following error message is displayed:

"connot connect to the repository. Error:Could not use ''; file already in use."

the server and my local machine all both using SQL server 2000 with SP4

any help will be appreciate, thanks in advance.

Benjamin

Looks like your repository is not migrated to SQL Server, but still in msmdrep.mdb file. Do you have enough permissions to open it ? Do you have access to $MsOlapRepository share ?

Connectivity issues

Hi,

I get the following error message trying to connect locally to sql server 2005 dev edition on xp sp2 machine.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

I have enabled all protocols , the sql browser is running , sql agent and sql database engine not running. All other services like reporting etc are running.

The server is set up to run under local system account. Logging in as administrator, .

This server is installed as default instance . ( I do have sql exp and sql server 200 dev edition installed as named instances)

Beginning to pull my hair out.

Any help would be greatly appreciated.

Regards,

Well, you said the database engine is NOT running? From the looks of things that's what you're trying to connect to...I'll assume a typo maybe? The DB Engine service must be running if you're trying to connect to the SQL engine...

|||

Thank you Chad for the illuminating response.

The problem is precisely that the database engine will not start , I understand that the engine must running order for me to connect to a database , however I have made no mention of trying to connect to a database.

If you have any helpful suggestions I would really appreciate it.

Thank you

Andy

|||

Hi Andy...honestly, everything you wrote in your initial posting was indicating that you were having trouble trying to connect to the server...per your initial post:

"I get the following error message trying to connect locally to sql server 2005 dev edition on xp sp2 machine."

Then, the error message you posted indicates that you are indeed trying to connect to the server from an application:

"An error has occurred while establishing a connection to the server...."

And, it even describes a connection level provider (named pipes)...

So, given your original posting, it seems you are having trouble connecting to the instance, not getting it running. Myself and others would be more than happy to help you debug why you are having trouble getting the engine to start, but we'd need entirely different information.

If you'd like help with why the engine is not able to start, please post any error messages you notice in the application log, sql server error log, and system log related to the SQL Server instance, that's what we'd need to see to help you understand why the engine will not start.

On a final note, bear in mind that folks on the forums are trying to help you, not trying to insult you, and you'll always get more help if you treat myself and others with respect, not by being smart with us. You may notice that I am an administrator of these SQL forums, so please keep posts as civil as possible.

Regards

|||

HI Chad,

My apologies for coming across so curt , having re-read my response it does seem as though I was being rude , not my intention. Perhaps a bit of frustration creeping in, the problem is that my vocabulary and knowledge is lacking and expressing myself in a meaningful way is difficult and perhaps to some one with your knowledge, confusing.

If I am getting an error as described above when trying to get an instance started (i.e. the error is generated when I try and get the engine started) through Management Studio then I assume that error is relevant and that is what I will report on. Having read your second post it is now obvious that the error describes a connection problem rather than an issue regarding the instance running.( which obviously is as result of the engine not running.)

I checked the error log and found a network error which I googled , it seems as though if the via protocol is the culprit , having disabled this protocol the engine started .

The network error in the log:

TDSSNIClient initialization failed with error 0x7e, status code 0x60.

Thank you and my apologies once again.

|||

No worries, I definately understand frustation, we're all quite accustomed to that unfortunately. Glad you were able to get things working,

Regards,

sqlsql

connectivity error while registering a new group

While registering sqlserver group I am getting the following
error message
"You must upgrade your SQL Enterprise Manager and SQL DMO (SQL-OLE) to SQL server (SQL DMO) to connect to server."
Can any one please guide me how to overcome this proble.
thanx regardsLook at Knowledge Base Article:

HOW TO: Administer Different Versions of SQL Server by Using SQL Server Enterprise Manager (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q225/5/45.asp&NoWebContent=1)sqlsql

ConnectionWrite(WrapperWrite()) Error

When the VB application attempts to connect to our SQL Server 2000 sp3 db, the following error is logged:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (WrapperWrite())

Does anyone know what is causing this? I haven't found any helpful info anywhere.

Thanks,

JulieI think this is just ADOs way of saying it can't find the server, or SQL isn't running - check your ODBC connection?|||Have you looked at this Knowledge Base Article:

FIX: RPC Clients Unable to Login to SQL Server with Windows Authentication (http://support.microsoft.com/default.aspx?sd=msdn&scid=kb;en-us;311111)|||Yes, I have read this article, and determined that this doesn't apply to my situation since the ODBC connection is using TCP/IP Network Library (as opposed to Multiprotocol/RPC) and the server is NOT configured to use "Windows only" authentication.

Kind of odd since this vb app has been running against the same db on the same server for almost 2 years now and this is the first time I've seen this error message.

connections to MSDE with .net installed

Hi,
Does the .net framework take up a connection to MSDE when starting up? We
are experiencing the following scenario:
Start up computer
Start our program that uses MSDE and the .net framework
Runs very slow
Shut down program on all computers
Stop MSDE service and Start again and it runs fine.
The reason I ask about the .net framework is that our program ran fine
before we migrated it to .net.
It seems like the govenor kicks in as soon as the machine is started - maybe
..net checks liscences or something?
..Net does not automatically take up connections or check licenses to MSDE or
any other DBMS. Run SQL Profiler (you have the Developers Edition of SQL
Server, don't you?) and see if any unexpected connections are being made to
the MSDE instance.
Jim
"Andrew" <Andrew@.discussions.microsoft.com> wrote in message
news:BF7838CC-CC14-4953-82A4-280A7B8213F7@.microsoft.com...
> Hi,
> Does the .net framework take up a connection to MSDE when starting up? We
> are experiencing the following scenario:
> Start up computer
> Start our program that uses MSDE and the .net framework
> Runs very slow
> Shut down program on all computers
> Stop MSDE service and Start again and it runs fine.
> The reason I ask about the .net framework is that our program ran fine
> before we migrated it to .net.
> It seems like the govenor kicks in as soon as the machine is started -
maybe
> .net checks liscences or something?

Connections made by call to createStatement?

Hi:
I am using the following code to test connections made to an SQL Server 2000
database:
Statement stmt = con.createStatement ();
stmt.executeQuery ("select * from control");
stmt = con.createStatement ();
stmt.executeQuery ("select * from control");
stmt = con.createStatement ();
stmt.executeQuery ("select * from control");
con has previously been set up as a Connection object obtained via a call to
DriverManager.
When I look at the output of sp_who in SQL Query Analyzer, I see that a new
SQL Server process has been created each time that createStatement is called
(actually, not the first time; only one process exists after that call, and
that process appears after the call to DriverManager.getConnection).
I'm trying to avoid the JDBC driver make multiple connections to the SQL
Server for performance reasons; if it really is making a new connection each
time, that would obviously require some time which I don't want to waste.
It's possible I'm misinterpeting the output of Query Analyzer, and that
multiple database processes can be listed that are all using the same actual
connection (this seems possible, as the output of stmt.getConnection()
remains the same each time a stmt object is allocated in the code above).
Can anyone explain this behavior?
Thanks,
Ryan
Add the property 'selectMethod=cursor' to your connection-getting and this
odd behavior of the driver will go away.
Joe
Ryan McFall wrote:

> Hi:
> I am using the following code to test connections made to an SQL Server 2000
> database:
> Statement stmt = con.createStatement ();
> stmt.executeQuery ("select * from control");
> stmt = con.createStatement ();
> stmt.executeQuery ("select * from control");
> stmt = con.createStatement ();
> stmt.executeQuery ("select * from control");
> con has previously been set up as a Connection object obtained via a call to
> DriverManager.
> When I look at the output of sp_who in SQL Query Analyzer, I see that a new
> SQL Server process has been created each time that createStatement is called
> (actually, not the first time; only one process exists after that call, and
> that process appears after the call to DriverManager.getConnection).
> I'm trying to avoid the JDBC driver make multiple connections to the SQL
> Server for performance reasons; if it really is making a new connection each
> time, that would obviously require some time which I don't want to waste.
> It's possible I'm misinterpeting the output of Query Analyzer, and that
> multiple database processes can be listed that are all using the same actual
> connection (this seems possible, as the output of stmt.getConnection()
> remains the same each time a stmt object is allocated in the code above).
> Can anyone explain this behavior?
> Thanks,
> Ryan
>

ConnectionRead (InvalidParam()) error

I get the following error sometimes when I execute a store procedure from SQ
L
Query Analyzer. After a few more attempts, the query succeeds... How can I
troubleshoot this network error...
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (Inv
alidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection BrokeFirst thing to check, just like the message stated, "General network error.
Check your network documentation." The fact that it sometimes works and
sometimes not points to an unstable network.
hth
Quentin
"Shaila" <Shailaja @.discussions.microsoft.com> wrote in message
news:03329249-66CC-4806-91A9-D5434C3130D9@.microsoft.com...
>I get the following error sometimes when I execute a store procedure from
>SQL
> Query Analyzer. After a few more attempts, the query succeeds... How can I
> troubleshoot this network error...
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (InvalidParam()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broke

ConnectionRead (InvalidParam()) error

Somtimes I get the following error in SQL query Analyzer when executing a
store procedure. After a few attempts the query succeeds but how can i
resolve this issue...
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (Inv
alidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection BrokeHi,
This is due to the network that you are having. Due to network congestion u
might be facing this problem. Try to enhance the network and try again
"Shaila" wrote:

> Somtimes I get the following error in SQL query Analyzer when executing a
> store procedure. After a few attempts the query succeeds but how can i
> resolve this issue...
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (I
nvalidParam()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broke

ConnectionRead (InvalidParam()) error

Somtimes I get the following error in SQL query Analyzer when executing a
store procedure. After a few attempts the query succeeds but how can i
resolve this issue...
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection BrokeHi,
This is due to the network that you are having. Due to network congestion u
might be facing this problem. Try to enhance the network and try again
"Shaila" wrote:
> Somtimes I get the following error in SQL query Analyzer when executing a
> store procedure. After a few attempts the query succeeds but how can i
> resolve this issue...
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broke

ConnectionRead (InvalidParam()) error

I get the following error sometimes when I execute a store procedure from SQL
Query Analyzer. After a few more attempts, the query succeeds... How can I
troubleshoot this network error...
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection BrokeFirst thing to check, just like the message stated, "General network error.
Check your network documentation." The fact that it sometimes works and
sometimes not points to an unstable network.
hth
Quentin
"Shaila" <Shailaja @.discussions.microsoft.com> wrote in message
news:03329249-66CC-4806-91A9-D5434C3130D9@.microsoft.com...
>I get the following error sometimes when I execute a store procedure from
>SQL
> Query Analyzer. After a few more attempts, the query succeeds... How can I
> troubleshoot this network error...
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (InvalidParam()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broke

ConnectionRead (InvalidParam()) error

I get the following error sometimes when I execute a store procedure from SQL
Query Analyzer. After a few more attempts, the query succeeds... How can I
troubleshoot this network error...
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broke
First thing to check, just like the message stated, "General network error.
Check your network documentation." The fact that it sometimes works and
sometimes not points to an unstable network.
hth
Quentin
"Shaila" <Shailaja @.discussions.microsoft.com> wrote in message
news:03329249-66CC-4806-91A9-D5434C3130D9@.microsoft.com...
>I get the following error sometimes when I execute a store procedure from
>SQL
> Query Analyzer. After a few more attempts, the query succeeds... How can I
> troubleshoot this network error...
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (InvalidParam()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broke

ConnectionRead (InvalidParam()) error

Somtimes I get the following error in SQL query Analyzer when executing a
store procedure. After a few attempts the query succeeds but how can i
resolve this issue...
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broke
Hi,
This is due to the network that you are having. Due to network congestion u
might be facing this problem. Try to enhance the network and try again
"Shaila" wrote:

> Somtimes I get the following error in SQL query Analyzer when executing a
> store procedure. After a few attempts the query succeeds but how can i
> resolve this issue...
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broke

ConnectionOpen (PreLoginHandshake()). General Network Error

Hi all,
I'm getting the following error on my SQL on a local machine when running a
client program that connects to sql server located at the same machine. What
does it means? Do i have to configure in SQL settings?
[DBNETLIB]ConnectionOpen (PreLoginHandshake()). General Network Error.
thanks,
joelNormally this message would indicate a timeout of some kind attempting to
connect. Open the SQL Client Network Utility and see if Shared Memory is
enabled. If it is not enable it and see if the problem goes away. Local
connections by default should use shared memory so it would appear that
this is not enabled.
Rand
This posting is provided "as is" with no warranties and confers no rights.

connection to SQL from asp.net page

I am using an asp.net page with vb.net. The following connection in my web.config file will connect the database to my page no problem:

"Data Source=MIAPPS1;Initial Catalog=MASTER_DB;Integrated Security=SSPI;"

However, when I add data to the page and try to preview it in the browser I get the following error:

"System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."

I'm kind of perplexed as to why I can attach a database to my page, test the connection view data -but not be able to connect when previewing through the browser.

Any Ideas?

BillHave you added the ASP.NET account to the server server authorized logins?|||I have added an account ASPNET. Is it ASPNET or ASP.NET. The error message also showed, null for the login, does this still point to the ASPNET login issue?|||Yes. The errors means that you either trying to connected to SQL with SQL Authication while only Windows Authentication is enabled, or that the windows account you're using is not one enlisted into the sql logins account.

If you're using IIS5 the account is ASP.NET, if using IIS6 is the Network Service account

Connection to SQL

I am gettin the following error,,

Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Invalid connection string attribute

This is the string can anyone help?

Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSLogin as New DataSet

DBConn = New OleDbConnection("Provider=sqloledb;" _
& "server=localhost;" _
& "InitialCatalog=BOOKSTORE;" _
& "User Id=sa;" _
& "Password=Pswd:")

DBCommand = New OleDbDataAdapter _
("Select StudentID from " _
& "Students Where " _
& "StudentName = '" & txtStudentName.Text _
& "' and Password = '" & txtPassword.Text _
& "'", DBConn)
DBCommand.Fill(DSLogin, _
"StudentInfo")
If DSLogin.Tables("StudentInfo"). _
Rows.Count = 0 Then
lblMessage.Text = "The student name and password " _
& "were not found. Please try again."
Else
Session("StudentID") = DSLogin.Tables("StudentInfo"). _
Rows(0).Item("StudentID")
Session("StudentName") = txtStudentName.Text
Response.Redirect("./home_room.aspx")
End IfAre you using Mixed mode or windows authentication for sql Server?

Also, I thoght you needed to open the connection first, not totally sure.

Connection to Server Failed - Analysis Services

Hi,
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows X
P
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a loca
l
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Serve
r
> Failed" error message when we attempt to register our local server using M
S
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy.
Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 20
00
> and MS Analysis Services with SP3 installed for both components on Windows
XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a lo
cal
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIAT
E
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member o
f
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:

> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these step
s:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes
.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member
of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:

> No, I mean, is the actual Analysis Services Service running on the machine
?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these st
eps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services o
n
> the local machine.
>
> "Simon Worth" wrote:
>

Connection to Server Failed - Analysis Services

Hi,
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows XP
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a local
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.
Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Server
> Failed" error message when we attempt to register our local server using MS
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy. Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 2000
> and MS Analysis Services with SP3 installed for both components on Windows XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a local
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIATE
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.
|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member of
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:

> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>
|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>
|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:

> No, I mean, is the actual Analysis Services Service running on the machine?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>
|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
> the local machine.
>
> "Simon Worth" wrote:
>

connection to right dB in server SQL server 7.0

I have the following SP.
the problem is when the execute is performed it gets another DB with a
similar name.
physicianlaboratories_Interface.
I am leaning towards the name is to long. if so what is max length for a
unique name.
Alter Procedure ADP_CompleteXMLOrderImport
@.Storename varchar(50)
As
set nocount on
IF @.SToreName = 'physlabs'
BEGIN
EXECUTE physicianlaboratories_com..ADP_CompleteXMLOrderImp ort
RETURN 0
END
return
Hi,
The max length for Database name is 128 characters.
Just try the "[ ]"
Alter Procedure [ADP_CompleteXMLOrderImport]
@.Storename varchar(50)
As
set nocount on
IF @.SToreName = 'physlabs'
BEGIN
EXECUTE [physicianlaboratories_com]..[ADP_CompleteXMLOrderImport]
RETURN 0
END
return
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||thanks, tried the [] did not do anything.
I believe there is also a maximum length for Unique DB names.
it also may be constraint of the ODBC driver.
"Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
news:52j#sy8OEHA.3800@.cpmsftngxa10.phx.gbl...
> Hi,
> The max length for Database name is 128 characters.
> Just try the "[ ]"
> Alter Procedure [ADP_CompleteXMLOrderImport]
> @.Storename varchar(50)
> As
> set nocount on
> IF @.SToreName = 'physlabs'
> BEGIN
> EXECUTE [physicianlaboratories_com]..[ADP_CompleteXMLOrderImport]
> RETURN 0
> END
> return
>
> HTH
> Ashish
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>

connection to right dB in server SQL server 7.0

I have the following SP.
the problem is when the execute is performed it gets another DB with a
similar name.
physicianlaboratories_Interface.
I am leaning towards the name is to long. if so what is max length for a
unique name.
Alter Procedure ADP_CompleteXMLOrderImport
@.Storename varchar(50)
As
set nocount on
IF @.SToreName = 'physlabs'
BEGIN
EXECUTE physicianlaboratories_com..ADP_CompleteXMLOrderImport
RETURN 0
END
returnHi,
The max length for Database name is 128 characters.
Just try the "[ ]"
Alter Procedure [ADP_CompleteXMLOrderImport]
@.Storename varchar(50)
As
set nocount on
IF @.SToreName = 'physlabs'
BEGIN
EXECUTE [physicianlaboratories_com]..[ADP_CompleteXMLOrderImport]
RETURN 0
END
return
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||thanks, tried the [] did not do anything.
I believe there is also a maximum length for Unique DB names.
it also may be constraint of the ODBC driver.
"Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
news:52j#sy8OEHA.3800@.cpmsftngxa10.phx.gbl...
> Hi,
> The max length for Database name is 128 characters.
> Just try the "[ ]"
> Alter Procedure [ADP_CompleteXMLOrderImport]
> @.Storename varchar(50)
> As
> set nocount on
> IF @.SToreName = 'physlabs'
> BEGIN
> EXECUTE [physicianlaboratories_com]..[ADP_CompleteXMLOrderImport
]
> RETURN 0
> END
> return
>
> HTH
> Ashish
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>