Showing posts with label program. Show all posts
Showing posts with label program. Show all posts

Tuesday, March 20, 2012

Cannot open file : C:\Program Files\Microsoft SQL Server\80\Tools\

Why is MICROSOFT not putting out any help on this topic. It is INCREDIBLY
frustrating not to have the documentation.
I'm runnig Win XP Pro w/update Service packs
SQL Server 2000 Developer sp3
I have done the following fruitlessly
Sent the error report when BOL fails because of hh.exe or hhctrl.ocx
Update the version of BOL
Modified the hhcolreg.dat to have the same value as the C:\Program
Files\Microsoft SQL Server\80\Tools\Books\sql80.col
Unregistered and registered the hhctrl.ocx ActiveX Control
LPHi
You may want to post the full error number and message. This may be a
corruption or a permissions issue. Also check that you are not restricted by
a group policy.
Try removing BOL and installing it in a different directory.
John
"LP" wrote:

> Why is MICROSOFT not putting out any help on this topic. It is INCREDIBLY
> frustrating not to have the documentation.
> I'm runnig Win XP Pro w/update Service packs
> SQL Server 2000 Developer sp3
>
> I have done the following fruitlessly
> Sent the error report when BOL fails because of hh.exe or hhctrl.ocx
> Update the version of BOL
> Modified the hhcolreg.dat to have the same value as the C:\Program
> Files\Microsoft SQL Server\80\Tools\Books\sql80.col
> Unregistered and registered the hhctrl.ocx ActiveX Control
> LP

Cannot open file : C:\Program Files\Microsoft SQL Server\80\Tools\

Why is MICROSOFT not putting out any help on this topic. It is INCREDIBLY
frustrating not to have the documentation.
I'm runnig Win XP Pro w/update Service packs
SQL Server 2000 Developer sp3
I have done the following fruitlessly
Sent the error report when BOL fails because of hh.exe or hhctrl.ocx
Update the version of BOL
Modified the hhcolreg.dat to have the same value as the C:\Program
Files\Microsoft SQL Server\80\Tools\Books\sql80.col
Unregistered and registered the hhctrl.ocx ActiveX Control
LP
Hi
You may want to post the full error number and message. This may be a
corruption or a permissions issue. Also check that you are not restricted by
a group policy.
Try removing BOL and installing it in a different directory.
John
"LP" wrote:

> Why is MICROSOFT not putting out any help on this topic. It is INCREDIBLY
> frustrating not to have the documentation.
> I'm runnig Win XP Pro w/update Service packs
> SQL Server 2000 Developer sp3
>
> I have done the following fruitlessly
> Sent the error report when BOL fails because of hh.exe or hhctrl.ocx
> Update the version of BOL
> Modified the hhcolreg.dat to have the same value as the C:\Program
> Files\Microsoft SQL Server\80\Tools\Books\sql80.col
> Unregistered and registered the hhctrl.ocx ActiveX Control
> LP
sql

Cannot open file : C:\Program Files\Microsoft SQL Server\80\Tools\

Why is MICROSOFT not putting out any help on this topic. It is INCREDIBLY
frustrating not to have the documentation.
I'm runnig Win XP Pro w/update Service packs
SQL Server 2000 Developer sp3
I have done the following fruitlessly
Sent the error report when BOL fails because of hh.exe or hhctrl.ocx
Update the version of BOL
Modified the hhcolreg.dat to have the same value as the C:\Program
Files\Microsoft SQL Server\80\Tools\Books\sql80.col
Unregistered and registered the hhctrl.ocx ActiveX Control
LPHi John,
Thanks for getting back with me. I did download and install a new version
first I just installed it to the default location and had the same error. I
then installed it to a different location and it works.
Thanks
"John Bell" wrote:
> Hi
> You may want to post the full error number and message. This may be a
> corruption or a permissions issue. Also check that you are not restricted by
> a group policy.
> Try removing BOL and installing it in a different directory.
> John
> "LP" wrote:
> > Why is MICROSOFT not putting out any help on this topic. It is INCREDIBLY
> > frustrating not to have the documentation.
> > I'm runnig Win XP Pro w/update Service packs
> > SQL Server 2000 Developer sp3
> >
> >
> > I have done the following fruitlessly
> > Sent the error report when BOL fails because of hh.exe or hhctrl.ocx
> > Update the version of BOL
> > Modified the hhcolreg.dat to have the same value as the C:\Program
> > Files\Microsoft SQL Server\80\Tools\Books\sql80.col
> > Unregistered and registered the hhctrl.ocx ActiveX Control
> >
> > LP

Thursday, March 8, 2012

Cannot load SQL Server Enterprise Manager

This morning when I tried to load SQL Server Enterprise Manager I got the
following error message dialog.
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQL Server Enterprise Manager.MCS.
This may be because the file does not exist, is not an MMC console, or was
created by a later version of MMC. This may also be because you do not have
sufficient access rights to the file.
The file exists, I've made the assumption it is an MMC console, I've had the
same version installed since sp-3 was distributed and I'm logged in under a
system adminsitrators account. Further, I've had and run the same setup for
several months with no problems.

Quote:

Originally posted by Charles
This morning when I tried to load SQL Server Enterprise Manager I got the
following error message dialog.
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQL Server Enterprise Manager.MCS.
This may be because the file does not exist, is not an MMC console, or was
created by a later version of MMC. This may also be because you do not have
sufficient access rights to the file.
The file exists, I've made the assumption it is an MMC console, I've had the
same version installed since sp-3 was distributed and I'm logged in under a
system adminsitrators account. Further, I've had and run the same setup for
several months with no problems.

Saturday, February 25, 2012

Cannot install MS SQL 2000 Developer Edition to my computer

When come to Create Instances screen and click next it prompt error message

although i had restart my computer.

A previous program Installation created pending file operations on the installation machine. You must restart the computer before running setup.

That message is normally because there is a 'runonce' flag set (and some files to be replaced).

However, if you have re-booted your computer (not just logged off and on), then the flag 'should' be cleared.

|||

yes i had restart even shutdown but still prompt the same errors.

Friday, February 24, 2012

Cannot Install AdventureWorks database.

I downloaded AdventureWorksDB from the CodePlex website and tried to install it. When the install program tried to attach it to SQLEXPRESS, it gave the error (below). I've also tried attaching the database directly using the SQL Management Studio and got exactly the same error.

I'd never heard of having incompatible database versions for SQL Server before. Am I missing a patch for SQLEXPRESS or ?. Thanks.

=================================================================

The database 'AdventureWorks' cannot be opened because it is version 631. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)


Server Name: HP-MEDIACENTER\SQLEXPRESS
Error Number: 948
Severity: 20
State: 1
Line Number: 1

Sounds like the one in Codepley had been attached to SQL Server 2008, you should post that as a bug to the appropiate persons.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

I got the following response from Microsoft Press that solves the problem:

================================

Thank you for contacting Microsoft Press.

Please make sure you are downloading the correct AdventureWorks database for SQL Server 2005. The CodePlex website contains two versions of the database, one for SQL Server 2008 and one for SQL Server 2005. If you are viewing the AdventureWorks database download release for SQL Server 2008 you must click “SQL Server 2005 SP2a” in the Releases box on the right hand side. You can also use the following link to download the SQL Server 2005 version directly at: http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004.

|||

I faced the same problem and your answer helped me too!

Thanks buddy!

|||

Same issue for me too. It's working now. Thanks very much for posting the answer.

|||Ditto. Fixed me too.

Cannot Install AdventureWorks database.

I downloaded AdventureWorksDB from the CodePlex website and tried to install it. When the install program tried to attach it to SQLEXPRESS, it gave the error (below). I've also tried attaching the database directly using the SQL Management Studio and got exactly the same error.

I'd never heard of having incompatible database versions for SQL Server before. Am I missing a patch for SQLEXPRESS or ?. Thanks.

=================================================================

The database 'AdventureWorks' cannot be opened because it is version 631. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)


Server Name: HP-MEDIACENTER\SQLEXPRESS
Error Number: 948
Severity: 20
State: 1
Line Number: 1

Sounds like the one in Codepley had been attached to SQL Server 2008, you should post that as a bug to the appropiate persons.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

I got the following response from Microsoft Press that solves the problem:

================================

Thank you for contacting Microsoft Press.

Please make sure you are downloading the correct AdventureWorks database for SQL Server 2005. The CodePlex website contains two versions of the database, one for SQL Server 2008 and one for SQL Server 2005. If you are viewing the AdventureWorks database download release for SQL Server 2008 you must click “SQL Server 2005 SP2a” in the Releases box on the right hand side. You can also use the following link to download the SQL Server 2005 version directly at: http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004.

|||

I faced the same problem and your answer helped me too!

Thanks buddy!

|||

Same issue for me too. It's working now. Thanks very much for posting the answer.

Cannot Install AdventureWorks database.

I downloaded AdventureWorksDB from the CodePlex website and tried to install it. When the install program tried to attach it to SQLEXPRESS, it gave the error (below). I've also tried attaching the database directly using the SQL Management Studio and got exactly the same error.

I'd never heard of having incompatible database versions for SQL Server before. Am I missing a patch for SQLEXPRESS or ?. Thanks.

=================================================================

The database 'AdventureWorks' cannot be opened because it is version 631. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)


Server Name: HP-MEDIACENTER\SQLEXPRESS
Error Number: 948
Severity: 20
State: 1
Line Number: 1

Sounds like the one in Codepley had been attached to SQL Server 2008, you should post that as a bug to the appropiate persons.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

I got the following response from Microsoft Press that solves the problem:

================================

Thank you for contacting Microsoft Press.

Please make sure you are downloading the correct AdventureWorks database for SQL Server 2005. The CodePlex website contains two versions of the database, one for SQL Server 2008 and one for SQL Server 2005. If you are viewing the AdventureWorks database download release for SQL Server 2008 you must click “SQL Server 2005 SP2a” in the Releases box on the right hand side. You can also use the following link to download the SQL Server 2005 version directly at: http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004.

|||

I faced the same problem and your answer helped me too!

Thanks buddy!

|||

Same issue for me too. It's working now. Thanks very much for posting the answer.

|||Ditto. Fixed me too.

Sunday, February 12, 2012

Cannot Fine Microsoft.SqlServer.ConnectionInfo.dll

The files

Microsoft.SqlServer.Smo.dllMicrosoftSqlServer.ConnectionInfo.dllMicrosoft.SqlServer.SmoEnum.dll

should be found in theC:\Program Files\Microsoft SQL Server\90\SDK\Assemblies directory. However, they are not there. Any ideas why?

Thanks

Bill

Do you have other dll files which should be in the same folder? (for example

Microsoft.SqlServer.RegSvrEnum.dll) What's the installation folder of SQL2005? The assemblies should locate in such folder:

SQL2005Folder\90\SDK\Assemblies

Friday, February 10, 2012

Cannot find the driver for JDBC

Hi all, I am building a program using Java and SQL express and I need the driver in order to connect to the database. I have downloaded I think a version for sql server 2005 but it did not work. Can somebody tell me if such driver exists?

Thank you all

Adam:

Yes, such a driver exists and can be downloaded here:

http://msdn.microsoft.com/data/jdbc/

If you have any issues please let us know.

-shelby

Shelby Goerlitz

Microsoft SQL Server Data Programmability