Re: No db access after publishing web site

1. Is the SQL Server Express database in the new application's App_Data folder ?

2. Are you detaching/attaching the SQL Server Express database correctly ?




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Agos" <agostino.guberti@xxxxxxxxxxxxx> wrote in message
news:Oxjai.14263$BU3.11885@xxxxxxxxxxxxxxxxxxxxxxxx
I published my application in the same file system (different folder) on same PC.
This is the connection string I use
<add name="pagoConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial
Catalog=pago;Integrated Security=True;User Instance=False"
The database is in folder
C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data
My working solution is in D:\WEB\WASP
I published in C:\WEB\WASP
and it also works except than the db WEB forms with gridview


"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> ha scritto nel messaggio
news:%23R7L%23zgqHHA.3456@xxxxxxxxxxxxxxxxxxxxxxx
Sounds like your connection string needs to be different
at the server where you published your application to.



Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Agos" <agostino.guberti@xxxxxxxxxxxxx> wrote in message
news:6Ciai.14217$BU3.3863@xxxxxxxxxxxxxxxxxxxxxxxx
I developed my first web site using Visual studio 2005.
It works very well with Visual Studio. But after I published the web site in a file system
folder in my PC using
the instructions I found in Visual studio help Walkthrough: Publishing a Web Site, I can
navigate the web forms
except the ones with connections (using Gridview, details view) to the database (SQL Server
2005).

What didn't I do?

Thank you

Agos






.

Relevant Pages

  • Re: Backup still not working
    ... So you may try to rebuild the RSM database if the ... > rename the existing files in this folder to a .old file extension, ... > this time unchecks "First Storage Group" under Microsoft Exchange Server. ... > 1) Open SQL Server Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: Build
    ... As Kalen already mentioned, there is no such thing "build" in SQL Server, that term is must be about "Building a Project or Solution in Visual ... here you are talking about a specific application which seems to need more than one database and noone here except for you knows about the sample application you are working on now. ... From what I've learned, there are actually several databases that exist for every "solution", located in the output folder and project folders. ... If you can explain what you mean by "build" and some examples of what files you refer to then we might be able to add some... ...
    (microsoft.public.sqlserver.setup)
  • Re: Build
    ... SQL Server 2005 Express ed starter kit, ... But the sample database ... located in the output folder and project folders (bin/debug folder and the ... you refer to then we might be able to add some... ...
    (microsoft.public.sqlserver.setup)
  • Re: Mail Word 2000 to 2003
    ... Word MVP web site http://word.mvps.org ... > The data is in the same folder as the main document. ... >> Move the database to the defined 'data sources' folder (or maybe the ...
    (microsoft.public.word.mailmerge.fields)
  • Securing a web DB
    ... We are putting up a ASP.NET based web site using SQL Server database. ... Users of the web site get to see confidential data. ...
    (comp.security.misc)