Missing dll file: guys

Showing posts with label guys. Show all posts

Friday, March 30, 2012

Modify [Permission]

hi guys,
My clients cann't update the sql database through ASP scripts.
How can i give the permission to add and modify the rows and columns?
Thank youYou can use SP_ADDROLEMEMBER and give them db_datawriter fixed db role.

Wednesday, March 28, 2012

model report - role attributes unavailable

Hi guys!
In my report model project Im trying to use the attributes of an entity.
This entity has (a number of) subroles coupled to it, which all are available
in the ReportBuilder-app once I drag any entity ground-level attribute on to
the canvas.
Unfortunately Im not able to put out the attributes in the subroles even
though they are visible among the ReportBuilder entity-props so they are not
hidden or anything.
I can drag these role-attribs out, but the mousepointer changes to that
forbidden-sign-thingie when I drag them out. For some reaseon RB does not
want to cooperate here, and Im not able to figure out why.
Anybody recognize this and care to comment?
DavidI found the reason; the cardinality was set to optional-many in both
directions of the role.
changing it to be optional-many/optional-one resolved this.
Hope this helps someone else!
David
"David SundstrÃ¶m" <DavidSundstrm@.discussions.microsoft.com> wrote in message
news:83DE441D-E013-4280-9427-4A7557BB1FB1@.microsoft.com...
> Hi guys!
> In my report model project Im trying to use the attributes of an entity.
> This entity has (a number of) subroles coupled to it, which all are
> available
> in the ReportBuilder-app once I drag any entity ground-level attribute on
> to
> the canvas.
> Unfortunately Im not able to put out the attributes in the subroles even
> though they are visible among the ReportBuilder entity-props so they are
> not
> hidden or anything.
> I can drag these role-attribs out, but the mousepointer changes to that
> forbidden-sign-thingie when I drag them out. For some reaseon RB does not
> want to cooperate here, and Im not able to figure out why.
> Anybody recognize this and care to comment?
> David

Monday, March 26, 2012

Mobile Device Database Develpment Problems

Hi, Guys

I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application.

The following is my development enviroment

Visual Studio .net 2005
Sql Server 2005
Windows CE.Net 4.2
Microsoft ActiveSync 4.2

First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem.

Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine.

I used VS2005 develop a simple database with DataGrid on the form( all the code generated by the VS 2005), when run the program, got error at " int returnValue = this.Adapter.Fill(dataTable)"
error "PlatformNotSupportedException". I don't know what's going on.

I think the connection to the database no problem. Maybe the Mobile device has problem. I insatlled sql.ppc.wce4.armv4.cab file to mobile device.

Can someone help me out?

Thanks.

That usually means SQL Server database is setup with collation not supported on your device. E.g. you have English device and database uses Chinese collation. There are two ways to fix it:

1. Change collation of the database to whatever device supports.

2. Get device which supports collation of the database.

Another possible reason for that issues might be what some dependencies are missing in the OS image. You should contact device OEM in that case.

|||

it is working, after Change collation of the database to Latin1.....

Thanks a lot

Friday, March 23, 2012

MMC Problem

Hi Guys,
Can anybody help me out plz?
When I tried to open Enterprise Manager of SQL server I'm
recieving this error message.
This may be because the file does not exist, is not an MMC console, or was
created by alater version of MMC. This may also be because you do not have
sufficient access rights to the file.
While IIS MMC and other MMC are working fine. Getting problem only with SQL
Server Enterprise Manager.
Thanx in advance.
Probably the easiest thing to do would be reinstall the SQL Client tools.
Rerun setup and just choose to install the client tools.
Donna Lambert
"uzair" wrote:

> Hi Guys,
> Can anybody help me out plz?
> When I tried to open Enterprise Manager of SQL server I'm
> recieving this error message.
> This may be because the file does not exist, is not an MMC console, or was
> created by alater version of MMC. This may also be because you do not have
> sufficient access rights to the file.
> While IIS MMC and other MMC are working fine. Getting problem only with SQL
> Server Enterprise Manager.
> Thanx in advance.
>
|||Hi Donna,
Thanx for your interest.
I uninstalled first then installed again both Server and Client tools,
unfortunately still the problem exists.
Sorry I didn't write complete error message. which read as
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was
created by alater version of MMC. This may also be because you do not have
sufficient access rights to the file.
"uzair" wrote:

> Hi Guys,
> Can anybody help me out plz?
> When I tried to open Enterprise Manager of SQL server I'm
> recieving this error message.
> This may be because the file does not exist, is not an MMC console, or was
> created by alater version of MMC. This may also be because you do not have
> sufficient access rights to the file.
> While IIS MMC and other MMC are working fine. Getting problem only with SQL
> Server Enterprise Manager.
> Thanx in advance.
>

MMC Problem

Hi Guys,
Can anybody help me out plz?
When I tried to open Enterprise Manager of SQL server I'm
recieving this error message.
This may be because the file does not exist, is not an MMC console, or was
created by alater version of MMC. This may also be because you do not have
sufficient access rights to the file.
While IIS MMC and other MMC are working fine. Getting problem only with SQL
Server Enterprise Manager.
Thanx in advance.Probably the easiest thing to do would be reinstall the SQL Client tools.
Rerun setup and just choose to install the client tools.
Donna Lambert
"uzair" wrote:
> Hi Guys,
> Can anybody help me out plz?
> When I tried to open Enterprise Manager of SQL server I'm
> recieving this error message.
> This may be because the file does not exist, is not an MMC console, or was
> created by alater version of MMC. This may also be because you do not have
> sufficient access rights to the file.
> While IIS MMC and other MMC are working fine. Getting problem only with SQL
> Server Enterprise Manager.
> Thanx in advance.
>|||Hi Donna,
Thanx for your interest.
I uninstalled first then installed again both Server and Client tools,
unfortunately still the problem exists.
Sorry I didn't write complete error message. which read as
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was
created by alater version of MMC. This may also be because you do not have
sufficient access rights to the file.
"uzair" wrote:
> Hi Guys,
> Can anybody help me out plz?
> When I tried to open Enterprise Manager of SQL server I'm
> recieving this error message.
> This may be because the file does not exist, is not an MMC console, or was
> created by alater version of MMC. This may also be because you do not have
> sufficient access rights to the file.
> While IIS MMC and other MMC are working fine. Getting problem only with SQL
> Server Enterprise Manager.
> Thanx in advance.
>sql

MMC Problem

Hi Guys,
Can anybody help me out plz?
When I tried to open Enterprise Manager of SQL server I'm
recieving this error message.
This may be because the file does not exist, is not an MMC console, or was
created by alater version of MMC. This may also be because you do not have
sufficient access rights to the file.
While IIS MMC and other MMC are working fine. Getting problem only with SQL
Server Enterprise Manager.
Thanx in advance.Probably the easiest thing to do would be reinstall the SQL Client tools.
Rerun setup and just choose to install the client tools.
Donna Lambert
"uzair" wrote:

> Hi Guys,
> Can anybody help me out plz?
> When I tried to open Enterprise Manager of SQL server I'm
> recieving this error message.
> This may be because the file does not exist, is not an MMC console, or was
> created by alater version of MMC. This may also be because you do not have
> sufficient access rights to the file.
> While IIS MMC and other MMC are working fine. Getting problem only with SQ
L
> Server Enterprise Manager.
> Thanx in advance.
>|||Hi Donna,
Thanx for your interest.
I uninstalled first then installed again both Server and Client tools,
unfortunately still the problem exists.
Sorry I didn't write complete error message. which read as
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was
created by alater version of MMC. This may also be because you do not have
sufficient access rights to the file.
"uzair" wrote:

> Hi Guys,
> Can anybody help me out plz?
> When I tried to open Enterprise Manager of SQL server I'm
> recieving this error message.
> This may be because the file does not exist, is not an MMC console, or was
> created by alater version of MMC. This may also be because you do not have
> sufficient access rights to the file.
> While IIS MMC and other MMC are working fine. Getting problem only with SQ
L
> Server Enterprise Manager.
> Thanx in advance.
>

Monday, March 19, 2012

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.

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.

Friday, March 9, 2012

Missing Resultset

Hi Guys
I have a report where I pass a parameter to a stored procedure that then
returns a resultset to the report.
Everything works well apart from when I choose my *All option. If this *All
option is chosen no data is returned. If run the Dataset and enters the *All
option manually it returns data. If I capture what is sent to the SQLServer
and execute that in Query Analizer it returns data.If I run the report it
comes up empty no errors just no data.
If I run the report with any other option than the *All data is shown the
way it should.
Any Ideas?
Thanks.
Regards
JonasFound the error/mistake.
When you have a report parameter and want to use a Stored Procedure (that at
this stage are not able to recieve a parameter) RS automatically creates a
filter.
Once the filter were deleted everything worked.
Jonas
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:eGr76HPgEHA.396@.TK2MSFTNGP12.phx.gbl...
> Hi Guys
> I have a report where I pass a parameter to a stored procedure that then
> returns a resultset to the report.
> Everything works well apart from when I choose my *All option. If this
*All
> option is chosen no data is returned. If run the Dataset and enters the
*All
> option manually it returns data. If I capture what is sent to the
SQLServer
> and execute that in Query Analizer it returns data.If I run the report it
> comes up empty no errors just no data.
> If I run the report with any other option than the *All data is shown the
> way it should.
> Any Ideas?
> Thanks.
> Regards
> Jonas
>
>

Wednesday, March 7, 2012

Missing Program group

Guys and Girls

I have a server that was running SQL Server 2000 (on Windows 2000
server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to
SQL Server and deleted all files. I have rebooted the server.

I have run an install of 6.5. It seems to have worked all right except
there is no program groups on my start menu. Any ideas what might have
happened?

Regards

Matt<john.bandettini@.rbs.co.uk> wrote in message
news:1117786641.708591.159230@.g49g2000cwa.googlegr oups.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to
> SQL Server and deleted all files. I have rebooted the server.
> I have run an install of 6.5. It seems to have worked all right except
> there is no program groups on my start menu. Any ideas what might have
> happened?
> Regards
> Matt

No idea, but presumably you can easily create your own group and add
shortcuts to the various executables? You could even copy the group from
another machine, if you have one available.

Simon

Missing Program group

Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000
server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have
happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to SQL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to S
QL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You
would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to
S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right
except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>

Friday, March 30, 2012

Modify [Permission]

Wednesday, March 28, 2012

model report - role attributes unavailable

Monday, March 26, 2012

Mobile Device Database Develpment Problems

Friday, March 23, 2012

MMC Problem

MMC Problem

MMC Problem

Monday, March 19, 2012

Mixed bag questions (only 13)

Friday, March 9, 2012

Missing Resultset

Wednesday, March 7, 2012

Missing Program group

Missing Program group

Missing Program group

Missing Program group

Missing dll file

Blog Archive

About Me