Mobile Only? Why?

I've just finished installing the workstation tools from the SQL Server 2005
DVD (No database engine).
I've also installed Visual Studio 2005, with just the VB option and the
other standard stuff.
When I start the Management Studio, connect to a server (doesn't matter what
version), then open a new query, the query is disconnected and the only
connection option is for SQL Server Mobile.
Anyone have any ideas?
I've installed (and repaired) the native client. I can browse servers and
see objects, etc., just no queries. I've installed/uninstalled three times.
Thanks all.
Am I correct that you are talking about the New Query dialog box in
Management Studio? On the File menu, point to New, do you see Database
Engine Query as one of the choices?
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
> I've just finished installing the workstation tools from the SQL Server
> 2005 DVD (No database engine).
> I've also installed Visual Studio 2005, with just the VB option and the
> other standard stuff.
> When I start the Management Studio, connect to a server (doesn't matter
> what version), then open a new query, the query is disconnected and the
> only connection option is for SQL Server Mobile.
> Anyone have any ideas?
> I've installed (and repaired) the native client. I can browse servers and
> see objects, etc., just no queries. I've installed/uninstalled three
> times.
> Thanks all.
>
|||Yes, the dropdown (to select a provider) is disabled with SQL Server Mobile
being the selected item.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Am I correct that you are talking about the New Query dialog box in
> Management Studio? On the File menu, point to New, do you see Database
> Engine Query as one of the choices?
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
>
|||I've shopped your e-mail around Microsoft a bit, and we can't think of any
reasonable way you could get into that condition. The obvious but cop-out
answer is that either Management Studio or the underlying Visual Studio is
somehow damaged. It's less likely to be related to the SQL Native Client.
Some more questions:
Are you using the RTM version of SQL Server Management Studio?
How consistent is this problem? That is, there are several ways to open the
Connect to Server dialog box in Management Studio:
- On the File menu, point to New, and then click Database Engine Query
- On the Standard toolbar, click New Query
- On the Standard toolbar, click Database Engine Query
- On the Object Explorer toolbar, click Connect, and then click Database
Engine
Do you only get SQL Server Mobile with any of those ways?
What about registering servers? On the View menu click Register Servers. In
the Registered Servers window toolbar, click Database Engine. Now can you
register a Database Engine by right-clicking Database Engine, point to New,
and then click Server Registration? Now is the Server type listed as
"Database Engine"?
Can you connect to the Database Engine from the Server Explorer of Visual
Studio?
(I'm interested in assisting you but I will not be available again until
Monday. Sorry. Holiday plans.)
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
> Yes, the dropdown (to select a provider) is disabled with SQL Server
> Mobile being the selected item.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
>
|||Yes, I'm using the version handed out in Vegas at the launch.
I have tried all the connection methods detailed below with the same
results. I am able to register, and connect to a database server and browse
objects, etc.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
> I've shopped your e-mail around Microsoft a bit, and we can't think of any
> reasonable way you could get into that condition. The obvious but cop-out
> answer is that either Management Studio or the underlying Visual Studio is
> somehow damaged. It's less likely to be related to the SQL Native Client.
> Some more questions:
> Are you using the RTM version of SQL Server Management Studio?
> How consistent is this problem? That is, there are several ways to open
> the Connect to Server dialog box in Management Studio:
> - On the File menu, point to New, and then click Database Engine Query
> - On the Standard toolbar, click New Query
> - On the Standard toolbar, click Database Engine Query
> - On the Object Explorer toolbar, click Connect, and then click Database
> Engine
> Do you only get SQL Server Mobile with any of those ways?
> What about registering servers? On the View menu click Register Servers.
> In the Registered Servers window toolbar, click Database Engine. Now can
> you register a Database Engine by right-clicking Database Engine, point to
> New, and then click Server Registration? Now is the Server type listed as
> "Database Engine"?
> Can you connect to the Database Engine from the Server Explorer of Visual
> Studio?
> (I'm interested in assisting you but I will not be available again until
> Monday. Sorry. Holiday plans.)
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
>
|||If you can browse objects, I presume that means you can connect with Object
Explorer. What happens in Object Explorer if you right-click a database, and
then click New Query? You should get a Database Engine query window. Does
that work? This will tell us if the Query Editor is working properly.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
> Yes, I'm using the version handed out in Vegas at the launch.
> I have tried all the connection methods detailed below with the same
> results. I am able to register, and connect to a database server and
> browse objects, etc.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||It comes up as a disconnected query. When I right-click in the query window
and select connect, the connection dialog appears.
In this dialog, the dropdown (to select a provider) is disabled and SQL
Server Mobile is the selected item.
Thanks.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
> If you can browse objects, I presume that means you can connect with
> Object Explorer. What happens in Object Explorer if you right-click a
> database, and then click New Query? You should get a Database Engine query
> window. Does that work? This will tell us if the Query Editor is working
> properly.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
>
|||I sorry. I know this must be frustrating for you, but I can think of no
reason for this. Since you have already uninstalled and reinstalled that
should have fixed any damaged binaries or registry entries. I'm out of
ideas. I guess that means you need a call to product support.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
> It comes up as a disconnected query. When I right-click in the query
> window and select connect, the connection dialog appears.
> In this dialog, the dropdown (to select a provider) is disabled and SQL
> Server Mobile is the selected item.
> Thanks.
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
>
|||Thanks for trying, anyway.
I'm out of ideas, also. I have successfully installed it on a second
workstation and laptop, both more or less identically configured.
It's probably about time I rebuilt this one anyway, it's been five years...
Thanks again.
Dave
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:eyd$Pyp9FHA.952@.TK2MSFTNGP12.phx.gbl...
>I sorry. I know this must be frustrating for you, but I can think of no
>reason for this. Since you have already uninstalled and reinstalled that
>should have fixed any damaged binaries or registry entries. I'm out of
>ideas. I guess that means you need a call to product support.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
>
sql

Mixed bag questions (only 13)

Hi everyone,

Ok guys, I’ve summarized doubts regarding SSIS as well as odd behaviour that sometimes I suffer for my lack of knowledge or for other reasons.

So this way, I’m a pain and bore individual only one time…

Question 1:

When you have a ForEach container, i.e using as enumeraton ADO and you are debugging and seeing how is going everything, whats tasks are executing and so on, you never knows if those that were in green (executed succesfully) now are executing again or not.

Well, I’ll try to explain better: In every iteration of the loop, tasks previously executed keep its colour (green) instead of turn into white.

Question 2:

Parameter Size property is a new property for Sql Task when you have installed sp2. Well, what is it for really? I mean I’ve got some .dtsx with Sql Tasks and its values are simply -1

Question 3:

When you’re debugging a dtsx you have in the bottom locals showing you variables and so on. Problems come when you have more than 40 variables… is there any search tool? Ok, you can use

Question 4:

Outline for the tasks is lost all the time. What a nuisance! Concretely it happens in workstations running either sp1 or sp2. Amazingly it works fine in a server (2003). Memory is not related, I’m afraid, in all the scenarios 2Gb.

Question 5:

Is it possible disallow math case for variables?

Sometimes when you’re using lots of variables, it’s easy commit errors when you write code.

Question 6:

Assemblies 1.0/1.1 will be allow in VSA in a future?

Question 7:

Is it possible to change the scope for a variable in run-time? Devious question, I admit…

Question 8:

When you’re writing a Script Task you can export the script into VB extension and then be imported from a project or whatever.

What does make sense?

Question 9:

ScriptTask_32dcba2feae9428386d768f38922e162 (that’s an example) is really stored anywhere? (When you save a script task inside the IDE)

Root NameSpace is too symbolic?

Question 10:

I’m developing against Windows 2003 english version. The whole Sql25k too. No spanish at all but sometimes I receive spanish messages related with SSIS.

I don’t understand how it can be.

Nothing to do with for the fact I’m using Terminal Server, I guess.

Question 11:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1518311&SiteID=1&mode=1

Question 12:

In a foreseeable future C# will be welcomed to SSIS?

Question 13:

Is it true that there is a separate Framework 2.0 for SSIS?

Thanks indeed for the patience!!!

enric vives wrote:

Hi everyone,

Ok guys, I’ve summarized doubts regarding SSIS as well as odd behaviour that sometimes I suffer for my lack of knowledge or for other reasons.

So this way, I’m a pain and bore individual only one time…

Question 1:

When you have a ForEach container, i.e using as enumeraton ADO and you are debugging and seeing how is going everything, whats tasks are executing and so on, you never knows if those that were in green (executed succesfully) now are executing again or not.

Well, I’ll try to explain better: In every iteration of the loop, tasks previously executed keep its colour (green) instead of turn into white.

What's the question? This has been discussed in a couple of threads. Because the dev environment responds to events from from the running package, it is possible that it will not reflect the exact order of execution. And if you have tasks in your loop that take sufficent time, you will notice that they do go to yellow while they execute, and then green again when they finish.

enric vives wrote:

Question 2:

Parameter Size property is a new property for Sql Task when you have installed sp2. Well, what is it for really? I mean I’ve got some .dtsx with Sql Tasks and its values are simply -1

It's to allow you to specify the length of string parameters when they are output parameters from stored procedures. -1 is the default - it tells SSIS to use the defaults from the provider.

enric vives wrote:

Question 4:

Outline for the tasks is lost all the time. What a nuisance! Concretely it happens in workstations running either sp1 or sp2. Amazingly it works fine in a server (2003). Memory is not related, I’m afraid, in all the scenarios 2Gb.

What outline are you referring too?

enric vives wrote:

Question 5:

Is it possible disallow math case for variables?

Sometimes when you’re using lots of variables, it’s easy commit errors when you write code.

Again, not sure what you are asking for.

enric vives wrote:

Question 7:

Is it possible to change the scope for a variable in run-time? Devious question, I admit…

No.

enric vives wrote:

Question 9:

ScriptTask_32dcba2feae9428386d768f38922e162 (that’s an example) is really stored anywhere? (When you save a script task inside the IDE)

Root NameSpace is too symbolic?

It's stored in the .dtsx package.

enric vives wrote:

Question 12:

In a foreseeable future C# will be welcomed to SSIS?

Yes.

enric vives wrote:

Question 13:

Is it true that there is a separate Framework 2.0 for SSIS?

If you are refering to the .NET framework, it has it's own assemblies, but it still uses the same .NET framework as everything else.

|||

John answered most. I'll take the ones he skipped.

enric vives wrote:

Question 3:

When you’re debugging a dtsx you have in the bottom locals showing you variables and so on. Problems come when you have more than 40 variables… is there any search tool? Ok, you can use

Not that I know of. This sounds like a request for Visul Studio rather than SSIS. Got to http://connect.microsoft.com/visualstudio

enric vives wrote:

Question 6:

Assemblies 1.0/1.1 will be allow in VSA in a future?

I very much doubt it.

enric vives wrote:

Question 8:

When you’re writing a Script Task you can export the script into VB extension and then be imported from a project or whatever.

What does make sense?

Sorry Enric, not quite sure what you're asking here.

enric vives wrote:

Question 10:

I’m developing against Windows 2003 english version. The whole Sql25k too. No spanish at all but sometimes I receive spanish messages related with SSIS.

I don’t understand how it can be.

Nothing to do with for the fact I’m using Terminal Server, I guess.

Well there must be something on your machine that defines you as being Spanish. There MUST be. Otherwise how would it know? I think you can answer this one better than we can.

enric vives wrote:

Question 11:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1518311&SiteID=1&mode=1

Looks like Jay has answered this for you.

-Jamie

|||

enric vives wrote:

Question 5:

Is it possible disallow math case for variables?

Sometimes when you’re using lots of variables, it’s easy commit errors when you write code.

No. Variable names in SSIS are case sensitives so you have to deal with that.

|||

In the first place thanks a lot for your information.

Regarding 8:

I meant, you obtain class and then you can import from a Visual Basic .Net project.

4:

For all the tasks, either of them. I understand it's not problem related with memory.

|||

enric vives wrote:

In the first place thanks a lot for your information.

Regarding 8:

I meant, you obtain class and then you can import from a Visual Basic .Net project.

4:

For all the tasks, either of them. I understand it's not problem related with memory.

You can write dotnet assemblies in VB.Net and call them from the SSIS Script Task. Is that what you mean?

-Jamie

|||

No, just in reverse mode, I meant you can write classes from SSIS Script task and call them from the Visual Studio.

|||No, you can't. Why would you want to?|||

enric vives wrote:

No, just in reverse mode, I meant you can write classes from SSIS Script task and call them from the Visual Studio.

Like John said, no you can't. If you want to put "stuff" into an assembly that can be shared between SSIS and other things...you need to build the assembly in Visual Studio, not in SSIS (or the SSIS Script Task).

Does that answer the question?

-Jamie

|||Yes, thanks for that.