2K5 Management Studio and VSS

We are using the Soltution functionality in Management Studio to add and
manage database objects in Visual SourceSafe. The functionality is a great
improvement over that avialable with 2K. However, there is one issue that is
driving us nuts. When you add a project to VSS it creates the actual project
files in a set of nested folders for example, views\views\views. How can we
modify the settings so that it will create the project files in a top level
folder (views)? We have tried editing the project files in VSS and tried
rebinding and sometimes it works and other times it fails. There must be an
ini file or some way to change this behavior.
Regards,
Hello,
If you try to add the files to the solution as links, all the files will be
under this root folder.
Hope this helps.
Thanks
"95Tribe" wrote:

> We are using the Soltution functionality in Management Studio to add and
> manage database objects in Visual SourceSafe. The functionality is a great
> improvement over that avialable with 2K. However, there is one issue that is
> driving us nuts. When you add a project to VSS it creates the actual project
> files in a set of nested folders for example, views\views\views. How can we
> modify the settings so that it will create the project files in a top level
> folder (views)? We have tried editing the project files in VSS and tried
> rebinding and sometimes it works and other times it fails. There must be an
> ini file or some way to change this behavior.
> Regards,

26 - Error Locating Server/Instance Specified

Hi,

Have installed the club site starter kit on my pc and all it works well locally. I've used visual studio to publish my site to my third party webhost. Ive created the DB on their server and altered the connection string to:-

<

connectionStrings><!--<add name="ClubSiteDB" connectionString="Server=xx.xx.xx.xx;Database=somedatabasename;User ID=user;Password=Password;Trusted_Connection=False" providerName="System.Data.SqlClient"/>-->

</

connectionStrings>

Now its on the webhosts server i get a System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).

This occurs when im trying to login in or register.

Can any one help.

Hi Ballantyne

This one usally means that your connection string is wrong - what to do is create a txt file on the web server and then rename it test.udl - now double click it and put in the details to the server and make sure you can connect to the database using the details your storing in your connection string.

Cheers
Gregor

|||

First make sure your connection string is correct.

CheckSQL Server Troubleshooting to set everything properly.

If problem still exists make sure no firewall blocks your connection.

Hope it helps.

2147217887 Error when sending to SQL 2005

I have a Visual Basic 6.0 app that I developed initially using MS SQL Server
7, then MS SQL
Server 2000 and now MS SQL Server 2005. I seem to get this error more often
in 2005 that the older versions. Googling does not seem to give any help.
What are the causes of this error? What can I do to avoid it?
The error happens when I use a command like:
DataRecord3.Fields("PSI_Fifteen") = CStr(PSI_Fifteen)
If I resend the command after the error it always works.
Thanks,
Bob HillerBob and Sharon Hiller (aoklans@.tir.com) writes:
> I have a Visual Basic 6.0 app that I developed initially using MS SQL
> Server 7, then MS SQL Server 2000 and now MS SQL Server 2005. I seem to
> get this error more often in 2005 that the older versions. Googling does
> not seem to give any help. What are the causes of this error? What can I
> do to avoid it?
> The error happens when I use a command like:
> DataRecord3.Fields("PSI_Fifteen") = CStr(PSI_Fifteen)
> If I resend the command after the error it always works.
That seems to be very informative message "Multiple-step OLE DB operation ge
nerated errors. Check each OLE DB status value, if available. No work was do
ne."
That is, there are several possible reasons for the error, or more
exactly, it can be about anything.
One problem may be that the input data is too long for the field. Another
might that there is no metadata available to make it possible to assign
the field a value. The fact that you say that you get this more often
with SQL 2005 indicates this. See
http://lab.msdn.microsoft.com/produ...59-17b0073cfa26
for such a case.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

2005 Walkthrough Database Needed.

How can I get Northwind into SQL Server 2005 Development?

In working through Visual Studio 2005 Pro Walkthroughs the next one needs Northwind. Is it straight forward to add in?

Here are step-by-step instruction to add the Northwind database to SQL Server 2005:Moving Data from SQL Server 2000 to SQL Server 2005|||

Many thanks for the reply.

Will give it a try during the day.

Just slightly puzzled why a MS Walkthrough does not show the included AdventureWorks but will try that too to get started.

Derek.

2005 Reporting Srv cannot connect to Oracle datasource on web server

created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

Most likely the RS web service and the RS windows service cannot access the Oracle client installation due to missing file system permissions. Please read the following KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668

-- Robert

|||

Robert,

Thanks for the help, this did in fact solve the issue (once the permissions were granted for the entire Oracle directory). Why would such a helpful article not show up in my searches through the help maze? Is there another entry point to search for these articles other than the help search engine?

thanks again,

Richard

|||

Wow this really helped me out also, had the exact same problem. Thanks. I too had to set the permissions for the entire Oracle directory for this to work. Also take note of which account your installation is using, mine wasn't using the Network Service account but instead a special service account created by the system admins, I had to set the permissions for that account on the folders.

Dave

2005 Reporting Srv cannot connect to Oracle datasource on web server

created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

Most likely the RS web service and the RS windows service cannot access the Oracle client installation due to missing file system permissions. Please read the following KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668

-- Robert

|||

Robert,

Thanks for the help, this did in fact solve the issue (once the permissions were granted for the entire Oracle directory). Why would such a helpful article not show up in my searches through the help maze? Is there another entry point to search for these articles other than the help search engine?

thanks again,

Richard

|||

Wow this really helped me out also, had the exact same problem. Thanks. I too had to set the permissions for the entire Oracle directory for this to work. Also take note of which account your installation is using, mine wasn't using the Network Service account but instead a special service account created by the system admins, I had to set the permissions for that account on the folders.

Dave

2005 Management Studio in slow motion?

I'm running on a dual xeon development box.
Quite often, if I have Visual Studio 2005 up, the Microsoft SQL Server Mangement
Studio will run very slowly.
By slowly, I mean take 2 minutes to open up for modification a stored procedure.
If I run it alone, there is no problem.
What can I do to speed this up?
Thanks in advance, Les Caudle
1) How much ram on the box?
2) Does this occur just the first time the action is attempted or everytime.
The first time incurs a bunch of .NET startup crap.
TheSQLGuru
President
Indicium Resources, Inc.
"Les Caudle" <DotNetWannabe@.newsgroup.nospam> wrote in message
news:bi6a83lj26d12l9l6arcu2kkg6dca8pj8k@.4ax.com...
> I'm running on a dual xeon development box.
> Quite often, if I have Visual Studio 2005 up, the Microsoft SQL Server
> Mangement
> Studio will run very slowly.
> By slowly, I mean take 2 minutes to open up for modification a stored
> procedure.
> If I run it alone, there is no problem.
> What can I do to speed this up?
> --
> Thanks in advance, Les Caudle
|||Hello Les,
I would like to know whether you are using 64 bit machine for Xeon.
I found some related issue which you may refer:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657867&SiteID=1
One issue that can cause this problem is that if the server does not have
access to the internet, then the .NET framework can't access the
crl.microsoft.com website to verify that the digital signatures used to
sign the binaries for managed applications are valid. Each certificate
check has a 15 second timeout in the .NET runtime implementation.
Depending on what features are installed, this can add up to a minute of
start up time for Management Studio.
There are a couple workarounds:
1) Configure a proxy server to allow access to http://crl.microsoft.com
from your server
2) Configure your firewall to return a failure status quickly when it
blocks access to the http://crl.microsoft.com website
3) Disable checks for certificate revocation. You can do this using
Internet Explorer by opening the Interet Options dialog, going to the
Advanced Page, and then unchecking the "Check for publisher's certificate
revocation" checkbox. There are fraudulently signed binaries in the wild
that can make virus-infected applications look like they were published by
Microsoft. Disabling this check should probably not be done on machines
with internet access.
http://support.microsoft.com/kb/906892/en-us
You may experience slow performance when you run 32-bit SQL Server tools on
64-bit operating systems
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Wei - I'm using 32 bit XP Pro.
CPU usage is very low when this happens.
May be a memory issue, as the box only has 1GB (that used to be a lot).
I guess I'm surprised that it slows down to such a crawl at times, just for
certain operations,, while everything else runs at a normal speed, and only for
SQL Server.
Regards, Les Caudle
On Mon, 02 Jul 2007 02:39:13 GMT, weilu@.online.microsoft.com (Wei Lu [MSFT])
wrote:

>Hello Les,
>I would like to know whether you are using 64 bit machine for Xeon.
>I found some related issue which you may refer:
>http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657867&SiteID=1
>One issue that can cause this problem is that if the server does not have
>access to the internet, then the .NET framework can't access the
>crl.microsoft.com website to verify that the digital signatures used to
>sign the binaries for managed applications are valid. Each certificate
>check has a 15 second timeout in the .NET runtime implementation.
>Depending on what features are installed, this can add up to a minute of
>start up time for Management Studio.
>There are a couple workarounds:
>1) Configure a proxy server to allow access to http://crl.microsoft.com
>from your server
>2) Configure your firewall to return a failure status quickly when it
>blocks access to the http://crl.microsoft.com website
>3) Disable checks for certificate revocation. You can do this using
>Internet Explorer by opening the Interet Options dialog, going to the
>Advanced Page, and then unchecking the "Check for publisher's certificate
>revocation" checkbox. There are fraudulently signed binaries in the wild
>that can make virus-infected applications look like they were published by
>Microsoft. Disabling this check should probably not be done on machines
>with internet access.
>
>http://support.microsoft.com/kb/906892/en-us
>You may experience slow performance when you run 32-bit SQL Server tools on
>64-bit operating systems
>Hope this helps.
>Sincerely,
>Wei Lu
>Microsoft Online Community Support
>================================================= =
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>================================================= =
>This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello Les,
Thanks for the update.
I would like to suggest you add the physical memory to have a try and let
me know the memory usage.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

2005 Create new instance, replace sqlexpress

I had installed Sql Express on my machine, now i have Visual Studio Pro
2005 which came with Sql Server 2005 Developer edition. I carefully
uninstalled anything I could find that was related to the express
edition before installing Developer. But still when I try to connect in
Management studio, it gives me only my Sql 2000 instance or a 2005
instance name SqlExpress. It fails trying to connect to the 2005
instance because apparently Express can't be connected to with this
tool.
Do I need to add a new instance? How do I get rid of the old one and
install a new one?
Any guidance appreciated, coming up with nothing in Books online and
this ng.
Bob(rvgrahamsevatenein@.sbcglobal.net) writes:
> I had installed Sql Express on my machine, now i have Visual Studio Pro
> 2005 which came with Sql Server 2005 Developer edition. I carefully
> uninstalled anything I could find that was related to the express
> edition before installing Developer. But still when I try to connect in
> Management studio, it gives me only my Sql 2000 instance or a 2005
> instance name SqlExpress. It fails trying to connect to the 2005
> instance because apparently Express can't be connected to with this
> tool.
> Do I need to add a new instance? How do I get rid of the old one and
> install a new one?
> Any guidance appreciated, coming up with nothing in Books online and
> this ng.
How did you run the install of Developer edition? Did you require a
named instance, or did you select a default instance? If you selected
the default instance, and you had SQL 2000 installed as a default instance,
then that install would have been upgraded to SQL 2005. Have you connected
to the instance check what @.@.version says?
Note that for an upgrage of SQL 2000 to succed you need at least SP3 of
SQL 2000.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi
Uninstall SQL Server Express Edition with all related installation (See in
ADD\REMOVE Program)
Moreover if you have a network (I have encountered some problems when it got
to set security File Stat )
, I'd suggest to unplug a cable and run SETUP
<rvgrahamsevatenein@.sbcglobal.net> wrote in message
news:1138996401.832192.216900@.z14g2000cwz.googlegroups.com...
>I had installed Sql Express on my machine, now i have Visual Studio Pro
> 2005 which came with Sql Server 2005 Developer edition. I carefully
> uninstalled anything I could find that was related to the express
> edition before installing Developer. But still when I try to connect in
> Management studio, it gives me only my Sql 2000 instance or a 2005
> instance name SqlExpress. It fails trying to connect to the 2005
> instance because apparently Express can't be connected to with this
> tool.
> Do I need to add a new instance? How do I get rid of the old one and
> install a new one?
> Any guidance appreciated, coming up with nothing in Books online and
> this ng.
> Bob
>|||Thank you for your replies,
I discovered when I did this same install on my home development
machine that what I had done wrong was to not specify for the Developer
Edition install to create a new named instance.
I was also unaware that VS2005 setup also installs SqlExpress, and that
it's apparently intentional that you end up with both running on your
machine. I'm assuming this is so you have Express available for testing
and deploying client apps containing stand-alone SqlExpress instances?
Bob Graham

2005 Beta 2 install problems

When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
Beta 2 Setup has detected incompatible beta components from Visual Studio or
SQL Server. To proceed, use Windows add or Remove Programs to remove
previous.." etc etc.
I have tried to remove almost everything that has anything to do with .NET.
and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
helps. Can anyone help me?
Thore Berntsen.
NorwayYou might want to post in the SQL Server 2005 setup newsgroup.
For information on access to those groups:
url]
[url]http://www.aspfaq.com/" target="_blank">http://communities.microsoft.com/ne...www.aspfaq.com/
(Reverse address to reply.)
"Thore Berntsen" <notrashmail@.please.zz> wrote in message
news:OFRRUEaiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
> Beta 2 Setup has detected incompatible beta components from Visual Studio
or
> SQL Server. To proceed, use Windows add or Remove Programs to remove
> previous.." etc etc.
> I have tried to remove almost everything that has anything to do with
.NET.
> and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
> helps. Can anyone help me?
> Thore Berntsen.
> Norway
>
>|||I receive the same messages as you received and followed the same processes
you followed but nothing helped me at all. I ,too , am looking for someone t
o help me sort this problem out...
Barkın nulu
Turkey
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...|||There will be more people able to help you sort the problem out if you post
in the SQL Server 2005 newsgroups.
For information on access to those groups:
url]
[url]http://www.aspfaq.com/" target="_blank">http://communities.microsoft.com/ne...www.aspfaq.com/
(Reverse address to reply.)
"BARKIN NULU" <barkin.unuulu@.huk.gov.tr> wrote in message
news:uvlvrrjlEHA.2864@.TK2MSFTNGP14.phx.gbl...
> I receive the same messages as you received and followed the same
processes you followed but nothing helped me at all. I ,too , am looking for
someone to help me sort this problem out...
> Barkın nulu
> Turkey
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

2005 Beta 2 install problems

When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
Beta 2 Setup has detected incompatible beta components from Visual Studio or
SQL Server. To proceed, use Windows add or Remove Programs to remove
previous.." etc etc.
I have tried to remove almost everything that has anything to do with .NET.
and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
helps. Can anyone help me?
Thore Berntsen.
Norway
You might want to post in the SQL Server 2005 setup newsgroup.
For information on access to those groups:
http://communities.microsoft.com/new...elcomePage.htm
http://www.aspfaq.com/
(Reverse address to reply.)
"Thore Berntsen" <notrashmail@.please.zz> wrote in message
news:OFRRUEaiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
> Beta 2 Setup has detected incompatible beta components from Visual Studio
or
> SQL Server. To proceed, use Windows add or Remove Programs to remove
> previous.." etc etc.
> I have tried to remove almost everything that has anything to do with
..NET.
> and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
> helps. Can anyone help me?
> Thore Berntsen.
> Norway
>
>
|||I receive the same messages as you received and followed the same processes you followed but nothing helped me at all. I ,too , am looking for someone to help me sort this problem out...
Barkın nulu
Turkey
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||There will be more people able to help you sort the problem out if you post
in the SQL Server 2005 newsgroups.
For information on access to those groups:
http://communities.microsoft.com/new...elcomePage.htm
http://www.aspfaq.com/
(Reverse address to reply.)
"BARKIN NULU" <barkin.unuulu@.huk.gov.tr> wrote in message
news:uvlvrrjlEHA.2864@.TK2MSFTNGP14.phx.gbl...
> I receive the same messages as you received and followed the same
processes you followed but nothing helped me at all. I ,too , am looking for
someone to help me sort this problem out...
> Barkın nulu
> Turkey
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

2005 Beta 2 install problems

When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
Beta 2 Setup has detected incompatible beta components from Visual Studio or
SQL Server. To proceed, use Windows add or Remove Programs to remove
previous.." etc etc.
I have tried to remove almost everything that has anything to do with .NET.
and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
helps. Can anyone help me?
Thore Berntsen.
NorwayYou might want to post in the SQL Server 2005 setup newsgroup.
For information on access to those groups:
http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Thore Berntsen" <notrashmail@.please.zz> wrote in message
news:OFRRUEaiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
> Beta 2 Setup has detected incompatible beta components from Visual Studio
or
> SQL Server. To proceed, use Windows add or Remove Programs to remove
> previous.." etc etc.
> I have tried to remove almost everything that has anything to do with
.NET.
> and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
> helps. Can anyone help me?
> Thore Berntsen.
> Norway
>
>|||I receive the same messages as you received and followed the same processes you followed but nothing helped me at all. I ,too , am looking for someone to help me sort this problem out...
Barkın Ünüulu
Turkey
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...|||There will be more people able to help you sort the problem out if you post
in the SQL Server 2005 newsgroups.
For information on access to those groups:
http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BARKIN ÜNÜULU" <barkin.unuulu@.huk.gov.tr> wrote in message
news:uvlvrrjlEHA.2864@.TK2MSFTNGP14.phx.gbl...
> I receive the same messages as you received and followed the same
processes you followed but nothing helped me at all. I ,too , am looking for
someone to help me sort this problem out...
> Barkın Ünüulu
> Turkey
> **********************************************************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...