How do I move a project between machines?

Hi,

I'm an SQL Server novice.

After developing some websites (VS 2005 VWD), my machine started to crumble. (e.g, SQL Server won't uninstall and lots of other software problems)

So I bought a new machine and set up a clean installation of SQL Server 2005 Standard and Visual Studio 2005 standard.

I copied my old "projects" folder to the new machine but I cannot use it.

1: When I try to import I get a "cannot import external files" error.

2: When I click on a project, it launches VS 2005 and I can edit etc.
However, when I try to run the website in VS 2005, I get the following error.

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) an error

Please can someone let me know how I can get my "old" projects running in my new environment?

Thanks

Ken

Has your sql server name or instance changed if so you will have to change your dataset to represent the new server.|||

Hi Ray,

Thanks for the reply.
Yes - I'm using a completely new setup. New server name and new instance name.

But I'm still struggling to get to grips with the management console. I bought several books on SQL Server 2005 and spent lots of time ploughing through the zillions of help files but I have not yet found a "How to" that meets my level of need to understand what I'm doing with SQL Serverr Management Studio.

So, when you say "change the dataset" I don't know what steps to take to do that. If you have a minute, I would very much appreciate some basic guide that shows me how to "change the dataset to represent the new server".

Its hard being a novice!

Ken

|||In your visual studios project you should have set up your project to connect to the database this is a dataset. It is a setup for a connection to the database from visual studios. You should look in your project, and should be somewhere in your solution depending on which type you are creating.|||

Hi Ray,

Thanks for your comment.

One of the problems I'm experienceing is that most of the well intended advice is couched in metaphorical terms rather than in "Press this then click that" terms.

Let's use the sample SQL Express personal website starter kit as an example.

Which DB?: In the App_Data folder thare are two .mdf files: ASPNETDB.MDF and Personal.mdf I know that the application needs both of these DB's. If I change the connection string, do I have to do it for both of these DB's ?

Connection String?: I have been floundering about in the help files without finding anything that I have found to be helpful. Where do I find the "connection string" to these DB's? what does a connection string look like? , How do I change it? What effect does it have on the rest of the project? Do I have to do anything else to make the app run under SQL Server Standard?

If I can get answers to these questions it will help me to get moving forward.

Thanks for your help.

Ken

How do I move a project between machines?

Hi,

I'm an SQL Server novice.

After developing some websites (VS 2005 VWD), my machine started to crumble. (e.g, SQL Server won't uninstall and lots of other software problems)

So I bought a new machine and set up a clean installation of SQL Server 2005 Standard and Visual Studio 2005 standard.

I copied my old "projects" folder to the new machine but I cannot use it.

1: When I try to import I get a "cannot import external files" error.

2: When I click on a project, it launches VS 2005 and I can edit etc.
However, when I try to run the website in VS 2005, I get the following error.

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) an error

Please can someone let me know how I can get my "old" projects running in my new environment?

Thanks

Ken

Has your sql server name or instance changed if so you will have to change your dataset to represent the new server.|||

Hi Ray,

Thanks for the reply.
Yes - I'm using a completely new setup. New server name and new instance name.

But I'm still struggling to get to grips with the management console. I bought several books on SQL Server 2005 and spent lots of time ploughing through the zillions of help files but I have not yet found a "How to" that meets my level of need to understand what I'm doing with SQL Serverr Management Studio.

So, when you say "change the dataset" I don't know what steps to take to do that. If you have a minute, I would very much appreciate some basic guide that shows me how to "change the dataset to represent the new server".

Its hard being a novice!

Ken

|||In your visual studios project you should have set up your project to connect to the database this is a dataset. It is a setup for a connection to the database from visual studios. You should look in your project, and should be somewhere in your solution depending on which type you are creating.|||

Hi Ray,

Thanks for your comment.

One of the problems I'm experienceing is that most of the well intended advice is couched in metaphorical terms rather than in "Press this then click that" terms.

Let's use the sample SQL Express personal website starter kit as an example.

Which DB?: In the App_Data folder thare are two .mdf files: ASPNETDB.MDF and Personal.mdf I know that the application needs both of these DB's. If I change the connection string, do I have to do it for both of these DB's ?

Connection String?: I have been floundering about in the help files without finding anything that I have found to be helpful. Where do I find the "connection string" to these DB's? what does a connection string look like? , How do I change it? What effect does it have on the rest of the project? Do I have to do anything else to make the app run under SQL Server Standard?

If I can get answers to these questions it will help me to get moving forward.

Thanks for your help.

Ken

How do I get the value of a column in the last row of my table?

With out using @.@.identity or count(*) how do i retrieve a value in a column in the last row of my table.

here is the situation. ASP.net project has several sessions open. a user needs to get the value of a column in the last row inserted in a particular table.

Select CallID from Calls where 'it is the last row inserted'

thanks in advance.

you can email me at !cbmorton!@.!gmail.com!

Chris Morton

Hard to get the last row in a relational database. Last means many things: last inserted, last in clustered index, last in another sort, last in a particular index, last in the data page.

Does your table have an Identity column, timestamp, CreatedDate that defaults to getDate()? You need something.

|||

In relational databases the data is by definition unordered, therefore the last data row entered is functionally the same as the first row entered.

That being said, if you have an inserted date/time column you could select from the table where the column equals the max(datetime) value in the table.

How do I get the value of a column in the last row of a table?

With out using @.@.identity or count(*) how do i retrieve a value in a column in the last row of my table.

here is the situation. ASP.net project has several sessions open. a user needs to get the value of a column in the last row inserted in a particular table.

Select CallID from Calls where 'it is the last row inserted'

thanks in advance.

you can email me at !cbmorton!@.!gmail.com!

Chris Morton

Define last row?

maybe this will do what you want but it is kind of dangerous because you might pick up the inserted row from another connection

Select Max(CallID) from Calls

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||i do want to pick up the last inserted row from another connection|||

There is no "last" row because SQL Server stores data as it comes in within its own storage schema. There is only a last row if you do a order of the query executed. There could be also a last *physical* row if the table includes a clustered index, which is physically ordered.

But if you want to have the last row in a resultsset, you have to order it backwards and get the TOP 1

e.g. SELECT TOP 1 SomeColumn From SomeTable Order by SomeOtherorthesamecolumn DESC

BTW, this is a public newsgroups, as long as you have MSN Alerts activated you will get a notice everytime a new answer arrives. Private communication should only be done if the thread is extended immensly due to details asking and answering back and forth, but also then the answer and the solution should be posted back here, to help other which might be in the same situation with a similar question.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

how do i get started

I hope some one can help with this most basic of
questions. I am working on a project that requires a
mediium size data base and so MSDE look like a good fit.
Problem is that in all my VB 6.0 work i never did any data
base work and i cant find any good way to get started. I
am lookign for samples and things to help me conect, read
write and update tables. All the MSDN resources talk about
what you can do but none tell me how.
Thanks to any one who can help
"steven davis" <stevend@.parabit.com> wrote in message
news:24ed601c45fdb$8cabc380$a401280a@.phx.gbl...
> I hope some one can help with this most basic of
> questions. I am working on a project that requires a
> mediium size data base and so MSDE look like a good fit.
> Problem is that in all my VB 6.0 work i never did any data
> base work and i cant find any good way to get started. I
> am lookign for samples and things to help me conect, read
> write and update tables. All the MSDN resources talk about
> what you can do but none tell me how.
> Thanks to any one who can help
While this book is geared for MS Access/SQL Server developers, most, if not
all of the concepts (and code) will translate to what you need to do. I
highly recommend it.
Microsoft Access Developer's Guide to SQL Server
by Mary Chipman, Andy Baron
ISBN: 0672319446
Steve
|||Also another starter's book which uses MSDE is 'Beginning Visual Basic .Net databases' by Wrox
But what programming language are you using..
dev
"Steve Thompson" wrote:

> "steven davis" <stevend@.parabit.com> wrote in message
> news:24ed601c45fdb$8cabc380$a401280a@.phx.gbl...
> While this book is geared for MS Access/SQL Server developers, most, if not
> all of the concepts (and code) will translate to what you need to do. I
> highly recommend it.
> Microsoft Access Developer's Guide to SQL Server
> by Mary Chipman, Andy Baron
> ISBN: 0672319446
> Steve
>
>
|||"dev_kh" <devkh@.discussions.microsoft.com> wrote in message
news:11AF35E9-E1EA-45FE-A72A-E95F1AA734B3@.microsoft.com...
> Also another starter's book which uses MSDE is 'Beginning Visual Basic
..Net databases' by Wrox
> But what programming language are you using..
It sounded like VB 6 from his original post...
Steve
|||Hello.
Yes i am using vb 6.0. It looks to me like MSDE is simply
SQL 2000 with out the manager graphical interface. If that
is so then maybe i can just read an SQL & VB book. Am i
correct?
thanks.

>--Original Message--
>"dev_kh" <devkh@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:11AF35E9-E1EA-45FE-A72A-E95F1AA734B3@.microsoft.com...
is 'Beginning Visual Basic
>..Net databases' by Wrox
>It sounded like VB 6 from his original post...
>Steve
>
>.
>
|||hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:2564501c46169$ef458eb0$a601280a@.phx.gbl...
> Hello.
> Yes i am using vb 6.0. It looks to me like MSDE is simply
> SQL 2000 with out the manager graphical interface. If that
> is so then maybe i can just read an SQL & VB book. Am i
> correct?
you are correct...
I've found
http://www.amazon.com/exec/obidos/AS...948653-0983837
quite intuitive for beginners... it's a little bit dated and offer no cover
about .Net.. but addresses quite all typical scenarios for MSDE solutions..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||My book "Hitchhiker's Guide to Visual Basic and SQL Server (6th Edition)"
should help quite a bit. Yes, it's a bit dated but focuses solely on SQL
Server (and MSDE).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
<anonymous@.discussions.microsoft.com> wrote in message
news:2564501c46169$ef458eb0$a601280a@.phx.gbl...[vbcol=seagreen]
> Hello.
> Yes i am using vb 6.0. It looks to me like MSDE is simply
> SQL 2000 with out the manager graphical interface. If that
> is so then maybe i can just read an SQL & VB book. Am i
> correct?
> thanks.
>
> message
> is 'Beginning Visual Basic

How do I find someone to help with Sql Server 2005 BI Project?

I've been building out a data warehouse of my product's usage with some
segmentation of our customer base. I am doing this using SQL Server 2005
Integration Services, Analysis Services and Reporting Services. My problem
is, I am doing this as a "side project" and I am not making enough progress
.
That brings me to my question...how can I find a SQL Server 2005 consultant
who knows the new BI services that have been released with SQL Server 2005.
I've been looking all over the net to find someone, and I am at a loss. My
office is in Boston and I'd ideally like to get a consultant who can come
work out of our offices for some period of time, but I am can't find anyone.
Anyone have any advice on where to go to find these folks?Hi Peter,
I'm in Boston, and can connect you with someone in my network who can help.
Send me a private e-mail with more about your project requirements, etc.
amachanic (at) datamanipulation (dot) net
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"PeterF" <PeterF@.discussions.microsoft.com> wrote in message
news:53D41611-4BDC-4ACA-90DB-20AB7D452D59@.microsoft.com...
> I've been building out a data warehouse of my product's usage with some
> segmentation of our customer base. I am doing this using SQL Server 2005
> Integration Services, Analysis Services and Reporting Services. My
> problem
> is, I am doing this as a "side project" and I am not making enough
> progress.
>
> That brings me to my question...how can I find a SQL Server 2005
> consultant
> who knows the new BI services that have been released with SQL Server
> 2005.
> I've been looking all over the net to find someone, and I am at a loss.
> My
> office is in Boston and I'd ideally like to get a consultant who can come
> work out of our offices for some period of time, but I am can't find
> anyone.
> Anyone have any advice on where to go to find these folks?