Frustrating Reporting Services problem. New machine fails to deploy reports to report serv

Hi All,
I got a new machine. On my old machine, I had no problem using VS
.Net to deploy Report Projects to our Report Server.
On my new machine, I installed IIS, installed VS .Net, enabled
ASP.Net, performed a Report Designer installation of Reporting
Services.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.
I found the following USENET thread that describes my problem, but I'm
not sure the solution there is the same for me:
http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
All help appreciated.
Thanks a lot,
ChuckCan you navigate to the report manager?
http://MyRServerName/Reports
That is a good troubleshooting step.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> Hi All,
> I got a new machine. On my old machine, I had no problem using VS
> .Net to deploy Report Projects to our Report Server.
> On my new machine, I installed IIS, installed VS .Net, enabled
> ASP.Net, performed a Report Designer installation of Reporting
> Services.
> After I create my report in VS .Net and try to deploy it, I get the
> following error message:
> A connection could not be made to the report server
> http://MyRServerName/ReportServer
> I am a local admin of the machine that the report server is on and I
> have no problem navigating to http://MyRServerName/ReportServer using
> Internet Explorer.
> I found the following USENET thread that describes my problem, but I'm
> not sure the solution there is the same for me:
> http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> All help appreciated.
> Thanks a lot,
> Chuck|||Try running this from command prompt -
rsconfig -c -s127.0.0.1 -dreportserver -aSql -usa -p(your sa password)
"Jeff A. Stucker" wrote:
> Can you navigate to the report manager?
> http://MyRServerName/Reports
> That is a good troubleshooting step.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
> news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> > Hi All,
> >
> > I got a new machine. On my old machine, I had no problem using VS
> > .Net to deploy Report Projects to our Report Server.
> >
> > On my new machine, I installed IIS, installed VS .Net, enabled
> > ASP.Net, performed a Report Designer installation of Reporting
> > Services.
> >
> > After I create my report in VS .Net and try to deploy it, I get the
> > following error message:
> >
> > A connection could not be made to the report server
> > http://MyRServerName/ReportServer
> >
> > I am a local admin of the machine that the report server is on and I
> > have no problem navigating to http://MyRServerName/ReportServer using
> > Internet Explorer.
> >
> > I found the following USENET thread that describes my problem, but I'm
> > not sure the solution there is the same for me:
> >
> > http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> >
> > All help appreciated.
> >
> > Thanks a lot,
> >
> > Chuck
>
>|||I can navigate to http://MyRServerName/Reports using Internet
Explorer. However, the problem remains that I cannot deploy a report
using VS .Net on my new computer.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.

frustrating formats

there are times i realize why people are resistant to .net...
in vb6, i can use: format$(fields!phonenumber,"(###) ###-####")
in vbnet:
1 - problem: no support for string formatting, only numbers
compensate: use csng
result: format(csng(fields!phonenumber),"(###) ###-####")
2 - new problem: empty strings result in an error
compensate: use iif function
result: iif ( len(trim(fields!phonenumber))=0,"",
format(csng(fields!phonenumber),"(###) ###-####"))
3 - new problem: vbnet evaluates ALL THREE EXPRESSIONS, regardless of the
condition. so empty strings still result in an error.
this is inexplicable.
iif(<condition>,<truepart>,<falsepart>) replaces:
if <condition> then
<truepart>
else
<falsepart>
end if
why are all 3 being evaluated?
so, half an hour later, i have no solution.
simple need: i want to display a phone number properly formatted if one
exists, and nothing if it doesn't.
please help!
dushan bilbijaTry an expression like this.
=iif(Fields!phonenumber.Value = Nothing, "",
format(csng(fields!phonenumber.Value),"(###) ###-####"))
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dushan Bilbija" <dbilbija@.msn.com> wrote in message
news:uBwTRH0iEHA.2664@.TK2MSFTNGP11.phx.gbl...
> there are times i realize why people are resistant to .net...
> in vb6, i can use: format$(fields!phonenumber,"(###) ###-####")
> in vbnet:
> 1 - problem: no support for string formatting, only numbers
> compensate: use csng
> result: format(csng(fields!phonenumber),"(###) ###-####")
> 2 - new problem: empty strings result in an error
> compensate: use iif function
> result: iif ( len(trim(fields!phonenumber))=0,"",
> format(csng(fields!phonenumber),"(###) ###-####"))
> 3 - new problem: vbnet evaluates ALL THREE EXPRESSIONS, regardless of the
> condition. so empty strings still result in an error.
> this is inexplicable.
> iif(<condition>,<truepart>,<falsepart>) replaces:
> if <condition> then
> <truepart>
> else
> <falsepart>
> end if
> why are all 3 being evaluated?
> so, half an hour later, i have no solution.
> simple need: i want to display a phone number properly formatted if one
> exists, and nothing if it doesn't.
> please help!
> dushan bilbija
>

Frustrating Error connecting to SQL 2000 from IIS with .NET 2.0

I am getting the following error when connecting to SQL 2000 from IIS with .NET 2.0.

It works perfectly with the Test Server that comes with VS 2005.

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Any suggestions|||

AndsX wrote:

Any suggestions

This question has been asked and resolved by others previously. Ithink you should use the Search feature on these forums to search forthis string and see if previous resolution(s) help you:
"provider: Named Pipes Provider, error: 40"
|||I was expecting this answer :) anyways i made a search on the forum before posting the question . but i could find any resolution to this poblem. Most of them where do with SQL 2005.|||Same problem here. I posted a similar issue a week ago and didn'treally find any resolution. Anyone seen this. Connecting toSQL 2000 right?

Stephen|||

stephenzr wrote:

Same problem here. I posted a similar issue a week ago and didn't really find any resolution. Anyone seen this. Connecting to SQL 2000 right?

Stephen

After lot of tries i found an answer to this problem. In the DB Connection String use integreted Security and add Impersonate Identiy in the config . Hope his solves ur problem also

|||Thanks, I will try that. Are you using SQL username/password authentication or windows auth?

Stephen|||

No go. Do we really need to impersonate. That seems like a significant config change just to go from 1.1 to 2.0?

Stephen

from sql2005express to sql2000 & vice versa

My asp.net website is using sqlexpress2005. I am planning to use sql2000 with this existing website. My questions:

1. How can I transfer the database definitions and actual data from 2005 to 2000? is this possible?
2. What if I have exisiting database in sql2000, can I convert it to be used in sql2005?
3. should I manually recreate the database when converting from one version of sqlserver to another? and how abt the actual data?

PLS HELP. big thanks!

There are lots of options and lots of caveats...

When a SQL2000 database is attached/touched by a SQL 2005 instance it can not easy be moved back. To go from SQL2000->SQL2005 its as simple as back/restore or detach, move file, attach.

Moving data from one place there are lots of options, DTS is probably the easiest but it is not included in SQL2005 express, but it is included in full SKUs of SQL 2000 and the dev edition of SQL 2005.

Its also possible to use scripting to move meta data definitions, a 2000 script should work really easily with 2005, going back the other way is harder and there will be some enhancements coming in a future service pack of SQL Server 2005 to make the generate script wizard more useful here.

|||thanks for the info man! :)sql

From SQL Express to XML file

HI guys,

Is there any tool to import the database from SQLExpress to change it into XML without doing much programming code in .Net?

Thanks!

Chin

Hi Chin,

The short answer is no, SQL Express doesn't include any import/export tools. That said, Transact-SQL provides syntax that lets you represent your data as XML, and you could use that to produce XML and then save that to a file.

Check out my answer to a similar question at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368472&SiteID=1 for links to pertinent BOL topics.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

From SQL Express to XML file

HI guys,

Is there any tool to import the database from SQLExpress to change it into XML without doing much programming code in .Net?

Thanks!

Chin

Hi Chin,

The short answer is no, SQL Express doesn't include any import/export tools. That said, Transact-SQL provides syntax that lets you represent your data as XML, and you could use that to produce XML and then save that to a file.

Check out my answer to a similar question at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368472&SiteID=1 for links to pertinent BOL topics.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

sql

From local to Inet server

Hi..

First of all im a super newb in asp.net and MSSQL.
I had a guy program a website with database, but the guy just stood me up and left me with the files and the server as a file.

Now I need to get them online and working.

The files are FTP on the server so I "just" need the server running

I got the following files:

Justgeek_data.mdf and Justgeek_log.ldf

The server admin interface is:myLittleAdmin.

Any walktrough help or simular would be highly appreciated.

The web is:http://www.bodyplanning.dk

have alook at SQL Server "attach database" process on MSDN

http://msdn2.microsoft.com/en-us/library/ms190794.aspx

|||

Got the database up and running but still errors:

Main page:http://www.bodyplanning.dk/default.aspx

Sub pages:

http://www.bodyplanning.dk/frmLogin.aspx

|||

It is likley that there is a user set up in the database, which also needs to exist at the global level in SQL Server.

Look in Security/Logins in SQL server, then add any users in the database you have attached, and set the passwords.

In the web.config file for the site, ensure that the usernames and passwords match up

From excel file into MS SQL server

I need to find a way to upload an Excel file into an MS SQL database
using a web control front end. I have my ASP.Net control (using C#)
uploading a file to a directory, but the server people now tell me that
I cannot have a writeable area for the web and have a DTS see it as this
is too much of a security risk. So, I need a way to read the file
directly into the database. I've no idea how to do this. Does anyone
have ideas? I know loading MS Office into the web server is out of the
question. The webserver and database server are not the same physical
machine.
Thanks.
Yes you can upload any file directly into SQL Server.
Here's an example:
http://SteveOrr.net/Articles/EasyUploads.aspx
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"no one" <noone@.yahoo.com> wrote in message
news:41FEF4E4.7EED35A4@.yahoo.com...
>I need to find a way to upload an Excel file into an MS SQL database
> using a web control front end. I have my ASP.Net control (using C#)
> uploading a file to a directory, but the server people now tell me that
> I cannot have a writeable area for the web and have a DTS see it as this
> is too much of a security risk. So, I need a way to read the file
> directly into the database. I've no idea how to do this. Does anyone
> have ideas? I know loading MS Office into the web server is out of the
> question. The webserver and database server are not the same physical
> machine.
> Thanks.
>
|||Thanks for the link, but this is not what I want to do. I want to put the
data from the file into a table, not the file itself.
"Steve C. Orr [MVP, MCSD]" wrote:
[vbcol=seagreen]
> Yes you can upload any file directly into SQL Server.
> Here's an example:
> http://SteveOrr.net/Articles/EasyUploads.aspx
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://SteveOrr.net
> "no one" <noone@.yahoo.com> wrote in message
> news:41FEF4E4.7EED35A4@.yahoo.com...
|||"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>
|||"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>
<snip>
Have a look at DTS - it can load directly from Excel (or most other things)
to MSSQL, and you can change the source and destination connections at
runtime. This link discusses executing a package from ASP:
http://www.sqldts.com/default.aspx?207
Otherwise, you can parse the file and generate your own INSERT statements
(slow), or convert it to a flat text file and then use bcp.exe or BULK
INSERT to load the data.
Simon
|||I'm not sure what all security restrictions they want you to
follow, but one option is to use Openrowset and read the
file into a table using T-SQL, e.g.
insert into YourTable
SELECT * FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0; HDR=NO;Database=C:\YourFilet.xls',
'SELECT * FROM [Sheet1$]')
-Sue
On Tue, 01 Feb 2005 12:25:52 GMT, no one <noone@.yahoo.com>
wrote:
[vbcol=seagreen]
>Thanks for the link, but this is not what I want to do. I want to put the
>data from the file into a table, not the file itself.
>"Steve C. Orr [MVP, MCSD]" wrote:
|||Oh, I now see your dilemma. That's fairly complex functionality.
My only idea is this 3rd party product that can open an excel file from a
memory stream and will allow you to extract data from it:
http://www.SteveOrr.net/Reviews/AsposeWord.aspx
http://www.aspose.com/Products/Aspose.Excel/
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>

From excel file into MS SQL server

I need to find a way to upload an Excel file into an MS SQL database
using a web control front end. I have my ASP.Net control (using C#)
uploading a file to a directory, but the server people now tell me that
I cannot have a writeable area for the web and have a DTS see it as this
is too much of a security risk. So, I need a way to read the file
directly into the database. I've no idea how to do this. Does anyone
have ideas? I know loading MS Office into the web server is out of the
question. The webserver and database server are not the same physical
machine.

Thanks.Yes you can upload any file directly into SQL Server.
Here's an example:
http://SteveOrr.net/Articles/EasyUploads.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"no one" <noone@.yahoo.com> wrote in message
news:41FEF4E4.7EED35A4@.yahoo.com...
>I need to find a way to upload an Excel file into an MS SQL database
> using a web control front end. I have my ASP.Net control (using C#)
> uploading a file to a directory, but the server people now tell me that
> I cannot have a writeable area for the web and have a DTS see it as this
> is too much of a security risk. So, I need a way to read the file
> directly into the database. I've no idea how to do this. Does anyone
> have ideas? I know loading MS Office into the web server is out of the
> question. The webserver and database server are not the same physical
> machine.
> Thanks.|||Thanks for the link, but this is not what I want to do. I want to put the
data from the file into a table, not the file itself.

"Steve C. Orr [MVP, MCSD]" wrote:

> Yes you can upload any file directly into SQL Server.
> Here's an example:
> http://SteveOrr.net/Articles/EasyUploads.aspx
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://SteveOrr.net
> "no one" <noone@.yahoo.com> wrote in message
> news:41FEF4E4.7EED35A4@.yahoo.com...
> >I need to find a way to upload an Excel file into an MS SQL database
> > using a web control front end. I have my ASP.Net control (using C#)
> > uploading a file to a directory, but the server people now tell me that
> > I cannot have a writeable area for the web and have a DTS see it as this
> > is too much of a security risk. So, I need a way to read the file
> > directly into the database. I've no idea how to do this. Does anyone
> > have ideas? I know loading MS Office into the web server is out of the
> > question. The webserver and database server are not the same physical
> > machine.
> > Thanks.|||"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:

<snip
Have a look at DTS - it can load directly from Excel (or most other things)
to MSSQL, and you can change the source and destination connections at
runtime. This link discusses executing a package from ASP:

http://www.sqldts.com/default.aspx?207

Otherwise, you can parse the file and generate your own INSERT statements
(slow), or convert it to a flat text file and then use bcp.exe or BULK
INSERT to load the data.

Simon|||Oh, I now see your dilemma. That's fairly complex functionality.
My only idea is this 3rd party product that can open an excel file from a
memory stream and will allow you to extract data from it:
http://www.SteveOrr.net/Reviews/AsposeWord.aspx
http://www.aspose.com/Products/Aspose.Excel/

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>> Yes you can upload any file directly into SQL Server.
>> Here's an example:
>> http://SteveOrr.net/Articles/EasyUploads.aspx
>>
>> --
>> I hope this helps,
>> Steve C. Orr, MCSD, MVP
>> http://SteveOrr.net
>>
>> "no one" <noone@.yahoo.com> wrote in message
>> news:41FEF4E4.7EED35A4@.yahoo.com...
>> >I need to find a way to upload an Excel file into an MS SQL database
>> > using a web control front end. I have my ASP.Net control (using C#)
>> > uploading a file to a directory, but the server people now tell me that
>> > I cannot have a writeable area for the web and have a DTS see it as
>> > this
>> > is too much of a security risk. So, I need a way to read the file
>> > directly into the database. I've no idea how to do this. Does anyone
>> > have ideas? I know loading MS Office into the web server is out of the
>> > question. The webserver and database server are not the same physical
>> > machine.
>>> > Thanks.
>|||DTS has been mentioned.
3rd parties that also do the job: SQLWays , DBUnit.|||"no one" <noone@.yahoo.com> wrote in message
news:41FEF4E4.7EED35A4@.yahoo.com...
>I need to find a way to upload an Excel file into an MS SQL database
> using a web control front end. I have my ASP.Net control (using C#)
> uploading a file to a directory, but the server people now tell me that
> I cannot have a writeable area for the web and have a DTS see it as this
> is too much of a security risk. So, I need a way to read the file
> directly into the database. I've no idea how to do this. Does anyone
> have ideas? I know loading MS Office into the web server is out of the
> question. The webserver and database server are not the same physical
> machine.
> Thanks.

Did you know cross-posting is one of the things some ISPs pick to identify
spam?

This'd be a whole lot easier if your app was windows rather than web.
Coz you don't have any way to be running c# on our client machine.

Is this really an extranet app?
I'd be concerned about who's loading what out a spreadsheet onto my database
server.
It does sound like a good way to open up a hole for hackers to walk in
through.
Uploading excel spreadsheets is also a good way to get a big heap of bad
data into a system.

Anyhow, it piqued my interest so I did a search on "javascript excel"
Here's an interesting page I found.
http://www.planet-source-code.com/v...d=2180&lngWId=2

Some gotchas but maybe they're not a problem for you.

--
Regards,
Andy O'Neill

from asp classic & asp.net to Access database changing to sql server

Hello,
We are re-writing our site in asp.net using sql server. Most of the site uses asp classic and it was to an access database. During the conversion we have everything working correct to SQL Server except for the asp.net connection string. There is an important part of the application using asp.net which works fine with our connection string to the access database. To recap our problem is the connection string from asp.net to sql server.

This code works fine for the asp.net to access in the web.cnfg file
</microsoft.web>
<connectionStrings>
<add name="SalesConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>
<add name="ODBCSalesConnectionString" connectionString="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb"/>
<add name="RawConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\inventoryStatus.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web
The code in the global.asa which works fine for classic asp to sql server also works fine and is as follows

'--Project Data Connection
Application("sales_ConnectionString") = "Driver={SQL Native Client};Server=DMSERVER01;Database=SQLsalesMain;UID=nTrack;PWD=nTrack2k3"
Application("sales_ConnectionTimeout") = 15
Application("sales_CommandTimeout") = 30
Application("sales_CursorLocation") = 3
Application("sales_RuntimeUserName") = ""
Application("sales_RuntimePassword") = ""

Our programmer who set this up is out for a couple of weeks and I would appreciate any help in the correct connection string from asp.net to the sql server database in the web.cnfg file

Thanks

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\inventoryStatus.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>

The above is your problem and your developer not knowing the meaning of User instance because it is for development only database unless you plan to deploy in Express the reason there is no such thing as User instance in full edition SQL Server so read the content of the MSDN link carefully or your code will not run. The text below is from the MSDN link. Hope this helps.

(SQL Server Express Edition allows only a single connection to an .mdf file when you connect with a connection string that has User Instance set to true.)

http://msdn2.microsoft.com/en-us/library/ms228037.aspx
http://www.connectionstrings.com/?carrier=sqlserver2005

|||

<add name="SalesConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>

The above is the connection we are talking about.

Thanks...

|||That is not a SQL Server connection string that is the reason I gave you the link to the connection string site. Hope this helps.|||

Thanks,

I know that is not a SQL Server connection string. I was asking for help based on the way the salesMain connection string for SQL in the posted. I have how asp classic connects to SQL, which works fine and was asking how to get it to work with asp.net. I have both connection strings shown in the code in the first post.

Dave

|||

<add name="SalesConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>

<connectionStrings>
<add name="salesMain" connectionString="Server=(local);Integrated Security=True;Database=salesMain;"
providerName="System.Data.SqlClient" />
</connectionStrings>

I have started the correct connection string but you have to add your server name to get it right because you cannot put SQL Server database in inetpub in a network drive because SQL Server decides where the database goes and it is the location below. What I mean is in RDBMS(relational database management systems) the server controls where the database goes. You still have to correct the previous connection string I pointed out to you because again there is no user instance in full SQL Server. You or your developer have to spend time to know connection strings and SQL Server permissions or your application will not run. Hope this helps.

C:\Program Files\Microsoft SQL Server\MSSQL\DATA

http://forums.asp.net/thread/1491403.aspx

From ADO.NET 1.1 to SQL 2005 and SQL 2008

Dear Sirs.

I have Client Server Application
on Client Side i have .NET 1.1 WinForm Application
on Server Side i have SQL Server 2000

I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access

1)

I'd like to upgrade Server Side to SQL Server 2005 (I will copy same database with users to sql2005)

Should i update Clients to .NET 2.0 too ?
Do i need install Native Client Lib on Client ?

2)

when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?

Thank you in Advance.

Should i update Clients to .NET 2.0 too ?

You don′t need to, for better reliability and without any further test and turning on the whole testing machine, I would use the 1.1 Fw.

Do i need install Native Client Lib on Client ?

You don′t need to but can do this.

2)

when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?

Yes, thats the plan (Even if you use OLEDB providers) :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I'm using SQL Data Provider in Name space System.Data.SqlClient

|||dito.|||What do you mean ? in word "dito" ?|||The same applies for SQLClient

Freeze panes when report is exported to Excel

I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel?

I have the feeling the answer is no, but I thought I'd check.

Hi, there is a property named FixedHeader. I didn′t try that this deep yet (only for table header) , but it would be worth a try. I guess you will your own rendering extension as the rendering for Excel didn′t brought back the right results with fixed headers for me (worked well in HTML, but not in Excel)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

I'm having the exact same issue. Has anyone been able to accomplish this successfully?

Jens Suessmeyer: I tried the property option but that didn’t work for me. The closest to what I’m trying to accomplish (that I’ve gotten); it’s using a report header which freezes the first row (or whatever u have in the header) yet by design it doesn’t accomplish what I (and rs12345) am trying to do.

The only option that I see out there is purchasing OfficeWriter by SoftArtisans or just try to figure out how they do it and write the code (It seems they use scripts... not sure yet).

Any ideas anybody? (or links :) )

|||Sorry, we don't support programmatic setting of Freeze Panes. The only

thing Excel export uses Freeze Panes for is for the PageHeader when

SimpleHeaders=false (the default).

Excel export ignores the FixedHeaders property.

OfficeWriter would support your use case, because you author the report in Excel and can set the freeze panes when designing the report. You could also use the ExcelApplication class from OfficeWriter to modify the output file.

OfficeWriter doesn't use VBA scripting, if that's what you mean; it reads, modifies, and writes the binary BIFF8 Excel format.

Freeze panes when report is exported to Excel

I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel?

I have the feeling the answer is no, but I thought I'd check.

Hi, there is a property named FixedHeader. I didn′t try that this deep yet (only for table header) , but it would be worth a try. I guess you will your own rendering extension as the rendering for Excel didn′t brought back the right results with fixed headers for me (worked well in HTML, but not in Excel)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

I'm having the exact same issue. Has anyone been able to accomplish this successfully?

Jens Suessmeyer: I tried the property option but that didn’t work for me. The closest to what I’m trying to accomplish (that I’ve gotten); it’s using a report header which freezes the first row (or whatever u have in the header) yet by design it doesn’t accomplish what I (and rs12345) am trying to do.

The only option that I see out there is purchasing OfficeWriter by SoftArtisans or just try to figure out how they do it and write the code (It seems they use scripts... not sure yet).

Any ideas anybody? (or links :) )

|||Sorry, we don't support programmatic setting of Freeze Panes. The only

thing Excel export uses Freeze Panes for is for the PageHeader when

SimpleHeaders=false (the default).

Excel export ignores the FixedHeaders property.

OfficeWriter would support your use case, because you author the report in Excel and can set the freeze panes when designing the report. You could also use the ExcelApplication class from OfficeWriter to modify the output file.

OfficeWriter doesn't use VBA scripting, if that's what you mean; it reads, modifies, and writes the binary BIFF8 Excel format.

freeze header

Hello,
I am using ReportViewer control in my asp.net application. It works fine,
however is it possible to keep header frozen when I scroll-down?
Thanks,
Jim.Not presently - you might be able to solve this by creating two browser
controls one above the other. The first which shows the headers and the
second to show the data. This would be pretty hacky.
We're look at this feature for a future version.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:7B5913F6-72E2-4AC4-97EA-A77AF945F3F9@.microsoft.com...
> Hello,
> I am using ReportViewer control in my asp.net application. It works fine,
> however is it possible to keep header frozen when I scroll-down?
> Thanks,
> Jim.
>

free distribution of "Database Engine"

Hi:

I'm an asp.net programmer and my database is in access format.
My server is Windows Server 2003 Enterprise Edition Service Pack 1.
I do not need microsoft access installed on my server to access my database through asp.net.

I want migrate my database to sql server 2005

Could I access my database in sql server 2005 format (mdf) through asp.net without sql server 2005 installed on the server?

could I buy to microsoft only "Database Engine"? or
Is there a free distribution of "Database Engine"?

Thanks!!

There is a free version of SQL Server 2005, SQL Server Express..

http://msdn.microsoft.com/vstudio/express/sql/

The data does need to be on some machine somewhere with SQL Server installed.

|||

Hi,

You do not need Access installed on the server, only the runtime (which I think ships with Windows these days, at the very worst the runtime is freely distributable if you have VSTO). You should take a look at SQL Server 2005 Express edition (http://msdn.microsoft.com/vstudio/express/sql/download/). Free, and as easy (or easier) to use as Access.

Hope this helps.

Framework Equivalent in MSSQL?

Introduction:
I want to put database based asp.net web site on a windows server.
For the asp.net files there is a free framework that will run the asp.net
files on the server.
The Question:
Is there any free PROGRAM that can run the .mdf and .ldf files on the
server?
And what is the name of that program?
Bishoy George
bishoy@.bishoy.com"Bishoy George" <bishoy@.bishoy.com> wrote in message
news:%23OPKnGAVGHA.5900@.tk2msftngp13.phx.gbl...
> Introduction:
> I want to put database based asp.net web site on a windows server.
> For the asp.net files there is a free framework that will run the asp.net
> files on the server.
> The Question:
> Is there any free PROGRAM that can run the .mdf and .ldf files on the
> server?
> And what is the name of that program?
SQL Server 2005 Express Edtion.
David|||it's name is MSDE (now SQL server express) if you're not planning on
more than a few concurrent connections. Otherwise you have to pay - or
SQL server would be free.|||Are you saying that there's a limit to the number of concurrent users in MSD
E
and SQL Server 2005 Express?
ML
http://milambda.blogspot.com/|||"ML" <ML@.discussions.microsoft.com> wrote in message
news:B8808488-053B-4525-9546-7C67A32A6F22@.microsoft.com...
> Are you saying that there's a limit to the number of concurrent users in
> MSDE
> and SQL Server 2005 Express?
>
There is no user limit in either product, but both products have baked-in
performance limitations.
In MSDE there is a workload throttle that slows down performance beyond 5
concurrent workloads. In SQL Server 2005 Express Edition you can only use 1
CPU and 1 GB of memory.
David|||There's no such limit in either of them. MSDE has a performance throttling f
unctionality which added
a wait for each I/O when you had more than 8 concurrently executing queries.
No such in Express. But
there are limits on db size, number of processors and memory, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ML" <ML@.discussions.microsoft.com> wrote in message
news:B8808488-053B-4525-9546-7C67A32A6F22@.microsoft.com...
> Are you saying that there's a limit to the number of concurrent users in M
SDE
> and SQL Server 2005 Express?
>
> ML
> --
> http://milambda.blogspot.com/|||Yes. Of course there's a limit. Otherwise everyone could just run sql
servers for free. I believe that they've slackened it a bit from the 5
for MSDE, but it's still limited. Last thing I read on it said that as
connections go above 5 MSDE massively throttles the performance of the
SQL server, so it's not an error thrown kind of limit, but your SQL
server becomes rubbish.|||The workload governor is said to be removed in the SQL 2005 Ecpress version.
Not trying to argue, just want clear facts. :)
ML
http://milambda.blogspot.com/|||Ecpress = Express
(in this particular case ;)|||> Yes. Of course there's a limit. Otherwise everyone could just run sql
> servers for free. I believe that they've slackened it a bit from the 5
> for MSDE, but it's still limited.
There is no longer any limitation that has aything to do with the number of
users, number of connections, or number of concurrent queries. The limit is
that Express will only be able to use 1 GB of memory, a single CPU, and the
database size is limited to 4GB. So, if one or more of those criteria do
not meet the requirements of your app, look elsewhere. I imagine there are
pleny of apps out there that could have 1000 concurrent users on Express and
work fine. On the flip side, if I tried real hard, I could design an
application that would completely suck wind with more than 1 concurrent
user, even if deployed to Enterprise edition with 32 GB of RAM. So the
question is more about design and requirements than any artificial
limitation.

> connections go above 5 MSDE massively throttles the performance of the
> SQL server,
[It's actually 8, not 5/]

> so it's not an error thrown kind of limit, but your SQL
> server becomes rubbish.
Have you actually experienced performance throttling THAT BAD on MSDE? Or
is it just hearsay? Granted, I would not personally deploy MSDE or Express
to a production application (because I want to sleep at night), but I have
not been able to reproduce this "rubbish" in some pretty serious testing.
A

Framework Equivalent in MSSQL?

Introduction:
I want to put database based asp.net web site on a windows server.
For the asp.net files there is a free framework that will run the asp.net
files on the server.
The Question:
Is there any free PROGRAM that can run the .mdf and .ldf files on the
server?
And what is the name of that program?
Bishoy George
bishoy@.bishoy.com
SQL Server Express?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Bishoy George" <bishoy@.bishoy.com> wrote in message
news:Od2l9CAVGHA.2444@.TK2MSFTNGP14.phx.gbl...
> Introduction:
> I want to put database based asp.net web site on a windows server.
> For the asp.net files there is a free framework that will run the asp.net
> files on the server.
> The Question:
> Is there any free PROGRAM that can run the .mdf and .ldf files on the
> server?
> And what is the name of that program?
> Bishoy George
> bishoy@.bishoy.com
>

Framework 3.0 in OS, need Framework 2.0 for SQL Server 2005

Hi,

Can anybody help me with the following problem:

I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0

Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0

Can't install 2.0, get the message that 3.0 is already installed.

Please help me!!

Ren

.NET 3.0 is actually an addon for the 2.0 framework.

Check out http://www.sqlskills.com/blogs/bobb/2007/09/19/SQLServer2008AndNETFrameworkVersions.aspx for more information.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Vista Ultimate actually comes with .NET Framework 2.0 installed by default. So it is already there.

If you check the \windows\microsoft.net\framework directory you should see v2.0.50727 and this is the .NET Framework 2.0 so SQL Server 2005 should not ask to install it.

|||

Hi,

The directory is there but still SQL Server 2005 give the error-message ".NET Framework 2.0 is not installed or damaged on this computer". I run Vista Ultimate on 32-bit machine. Is there a way to re-install .NET Framework? Already installed SDK and hoped that with that installation Framework 2.0 would be re-installed but that didn't work either :-(

Tried to call Microsoft but they charge € 300 for trying to solve my problem, no garantuees..

If I was sure that a new installation of Vista would solve the problem I would do that, but can't see why a new installetion would solve the problem.. Is there a way to re-install the .NET Framework-software?

Ren

|||

I would check out this post:

http://blogs.msdn.com/astebner/archive/2007/03/26/how-to-repair-the-net-framework-2-0-and-3-0-on-windows-vista.aspx

But I am not sure that there is an easier way to get this fixed. Because they are OS components, you would have to do some sort of repair.

Framework 3.0 in OS, need Framework 2.0 for SQL Server 2005

Hi,

Can anybody help me with the following problem:

I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0

Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0

Can't install 2.0, get the message that 3.0 is already installed.

Please help me!!

Ren

.NET 3.0 is actually an addon for the 2.0 framework.

Check out http://www.sqlskills.com/blogs/bobb/2007/09/19/SQLServer2008AndNETFrameworkVersions.aspx for more information.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Vista Ultimate actually comes with .NET Framework 2.0 installed by default. So it is already there.

If you check the \windows\microsoft.net\framework directory you should see v2.0.50727 and this is the .NET Framework 2.0 so SQL Server 2005 should not ask to install it.

|||

Hi,

The directory is there but still SQL Server 2005 give the error-message ".NET Framework 2.0 is not installed or damaged on this computer". I run Vista Ultimate on 32-bit machine. Is there a way to re-install .NET Framework? Already installed SDK and hoped that with that installation Framework 2.0 would be re-installed but that didn't work either :-(

Tried to call Microsoft but they charge € 300 for trying to solve my problem, no garantuees..

If I was sure that a new installation of Vista would solve the problem I would do that, but can't see why a new installetion would solve the problem.. Is there a way to re-install the .NET Framework-software?

Ren

|||

I would check out this post:

http://blogs.msdn.com/astebner/archive/2007/03/26/how-to-repair-the-net-framework-2-0-and-3-0-on-windows-vista.aspx

But I am not sure that there is an easier way to get this fixed. Because they are OS components, you would have to do some sort of repair.

Framework 3.0 in OS, need Framework 2.0 for SQL Server 2005

Hi,

Can anybody help me with the following problem:

I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0

Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0

Can't install 2.0, get the message that 3.0 is already installed.

Please help me!!

Ren

.NET 3.0 is actually an addon for the 2.0 framework.

Check out http://www.sqlskills.com/blogs/bobb/2007/09/19/SQLServer2008AndNETFrameworkVersions.aspx for more information.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Vista Ultimate actually comes with .NET Framework 2.0 installed by default. So it is already there.

If you check the \windows\microsoft.net\framework directory you should see v2.0.50727 and this is the .NET Framework 2.0 so SQL Server 2005 should not ask to install it.

|||

Hi,

The directory is there but still SQL Server 2005 give the error-message ".NET Framework 2.0 is not installed or damaged on this computer". I run Vista Ultimate on 32-bit machine. Is there a way to re-install .NET Framework? Already installed SDK and hoped that with that installation Framework 2.0 would be re-installed but that didn't work either :-(

Tried to call Microsoft but they charge € 300 for trying to solve my problem, no garantuees..

If I was sure that a new installation of Vista would solve the problem I would do that, but can't see why a new installetion would solve the problem.. Is there a way to re-install the .NET Framework-software?

Ren

|||

I would check out this post:

http://blogs.msdn.com/astebner/archive/2007/03/26/how-to-repair-the-net-framework-2-0-and-3-0-on-windows-vista.aspx

But I am not sure that there is an easier way to get this fixed. Because they are OS components, you would have to do some sort of repair.