SQL Express Database In Published Web Site
Mar 26, 2007
I have been working with Visual Studio 2005 and the Personal Web Site Starter Kit. All is well and working. My problem is that after the database is updated (as in uploading photos and album creation) and the original web site is edited and republished, the web site database is overwritten and all the work is lost. What is the proceedure to either copy the web database to the development site on my computer so updates will not be lost, or a method of publishing that will not loose the up to date content on the web server? I would much prefer to be able to copy the database to my development computer as adding tables to the database is something that needs to be done. Any help on this would be appreciated.
Thanks
View 3 Replies
ADVERTISEMENT
Apr 17, 2007
I'm getting 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) Here's the setup: I have a website I've published on my server, but I haven't moved the SQL DB over to the server. For some reason the testing server can't connect with sql express on my computer. I have named pipes, tcp/ip both on, connections string is "Data Source=AMBA-176SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI"When I'm simply testing the site locally in visual studio it can connect just fine.
View 1 Replies
View Related
Jul 23, 2007
I am trying to add a SQL Server 2005 Express Edition Database to my Web Site. But I am unablr to do so.
I am getting 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)"}
I am unable to understand what exactly is the problem.
Pls Help me out.
Thanx In Advance.
View 2 Replies
View Related
Jul 17, 2007
Can someone please tell me how to retrieve/query the list of fields from an entity of a report data model that has been published on the reporting server programmatically ?
I am trying to upload a report data model to the reporting server and planning to use that model as the data source and consume it through our existing web application?
Thank you ,
Rashid A. Khan
View 1 Replies
View Related
May 14, 2007
hi,
i am tring to use the 'xcopy' way to deploy my web site, this is the connection string i am using:
"Data Source=.SQLEXPRESS;INITIAL CATALOG=;AttachDbFilename='|DataDirectory|HotStage.mdf';Integrated Security=True;User Instance=True"
it works when in debug mode, but after i depoly it to my XP's IIS, it can not login the database, the error message is :
Cannot Login to the default user database. Login Failed. Login Failed for user xxxASPNET
'xxx' is my computer.
i think this problem is cause of improper setting of security, but i really do not know how to set it in this situation, because the database is attached to the db system dynamically.
plz someone help, thx
View 3 Replies
View Related
Jun 8, 2007
Hi
I am nearing the end of creating my Windows App for work. So I tried to publish it, that was fine until I ran the app, from the same PC as I use to develop, with the same login etc. However when I use the published app I can't connect, to the database, return to VS2005 and run my app from within there and no problems. It is SQLEXPRESS (SQL Server 2005), but I have checked the settings there are correct (I assume VS wouldn't connect otherwise).
Help please.
Details...
Server = FRED database =Joe
Connection string (Data Source=FREDSQLEXPRESS;Initial Catalog=JOE;Integrated Security=True
Server (Win2003) and my PC (Win2K) are on the same domain
Using TCP/IP
I can't see how to enable JiT debugging despite the 'help' at the end of this error details...
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
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)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at TrainTrack.frmAddCompetency.frmAddCompetency_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
TrainTrack
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/graham.yetton/Local%20Settings/Apps/2.0/4GZWZKGB.4O3/9XXGWKLB.MTQ/trai..tion_75116344273b6719_0001.0000_b44ce39f580948f8/TrainTrack.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
View 4 Replies
View Related
Nov 9, 2007
I create a WebSite onto the internet.
Then I created a database with MSSQLmanager provided by the WebHosting.
I created a Table and put some data in it.
When I try to access the DataBase an Error says: "Connection cannot be opened. On default settings you cannot access a Database Remotely."
What shall I do to configure my Database.
basically I don't know where to go to change configuration of my Database.
In my intranet I would use SQLServerSuraceArea.
But on Internet I do not know.
someone Help.
Did I miss something ?
View 4 Replies
View Related
Jun 27, 2006
Hello everybody,
Here is the case:
1 €“ When I make a web application with VS 2005 (on a Windows XP Pro SP 2 machine) using a database (with the included SQL 2005 Express) all works fine on my dev computer
2 €“ After publishing that application on my Web server (an old but fresh reformatted machine with Windows 2000 Server SP 4 - but without any special feature of server version such as active directory configured -, IIS 5, SQL 2005 Express SP 1 with Advance Services, both 1.1 and 2.0 frameworks installed on it). I have this error when I call the application from IE:
(Be kind as all my configuration and error messages are in French so I try to translate them the best I can but if translation is not clear tell me €“ and if someone knows how I can have those messages in English tell me also ;-)
Open session failure for user [my web server name]ASPNET
For information I have done/try all the following (and probably more; don€™t remember as I am stuck on this since nearly 2 weeks now ) without success:
- changing the SQL Server surface area exposition to remote connections for TCP/IP, named pipes and both (in fact even when the exposition is set to local I still have the same error€¦)
- adding a [my web server name]ASPNET account with dbo/sysadmin rights with SQL Server Management Studio Express, as well as other special accounts (IUSR and IWAM)
- manually attaching database under SQL Server Management Studio Express and mapping the above accounts to it (and of course modifying the ConnectionString settings in the web.config file accordingly)
- same thing with those 3 accounts but this time for folder and subfolders with full control rights
- publishing my web application with both Publish Site and Copy Site options from VS 2005 (which seem to do exactly the same thing). I am using the Remote site connection option (the one where you need to enter the IP address of the web site and have FrontPage extensions installed on it)
- and all other stuff as mentioned in an earlier post on this matter (http://forums.microsoft.com/msdn/ShowPost.aspx?postid=505487&isthread=false&siteid=1&authhash=7399dc0a380f8452fd1aa40f4b530be62a7a8e70&ticks=632868985326044888)
I can give any complementary information such as error stack trace or web.config file if needed to help me.
For information, I have an older web application running (perfectly) on this server. This one was done with VS 2002/framework 1.0/SQL Server 7.0 database and is now running with framework 1.1/SQL Server 2005 Express on the server. I thought at first that application would be the one to give me headaches as the database was from an older version of SQL Server but I simply attached the .mdf file under SQL Server Management Studio Express and all worked perfectly and immediately€¦
I am not too bad in development but I must confess I am quite a noob as Windows/IIS/SQL server/network administrator so I really need a help on this as I am stuck since nearly 2 weeks and I think I won€™t have many hair left on my head if I don€™t find quickly a solution to that problem.
Thanks in advance.
DreamingBear (in fact NightmareBear would actually sounds better )
View 9 Replies
View Related
Jun 26, 2006
Hi all,
I am stuck with a problem using ASP.Net website. I created a website which accesses a database table in SQL Server 2005. The default.aspx is a form which inserts/updates/deletes data from the database. After creating the website I published it to IIS (Inetpub -> wwwroot). When I use Visual Studio 2005 and build the website and start with debugging. the form comes up and i can insert/update or delete the data from the table as I want. Now, as I have the website published I can access the form from another sharepoint website using the url as
/Employee_Data/Default.aspx">http://<mydesktop>/Employee_Data/Default.aspx
the form shows up but I am not able to access any of the database. I do not see any errors either. Once I click on the button the page just refreshes but nothing else happens. I have my web.config as :-
<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings/>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
</system.web>
</configuration>
Am I missing something? I even have Anonymous access in the IIS inetpub properties. I can even the database as I am the administrator..... I appreciate your suggestions.
Thanks,
Kavya
View 1 Replies
View Related
Dec 28, 2005
Folks.
I just moved my domain to GoDaddy.com. When I run my website locally, everything works fine.
When I ftp it to my server space on GoDaddy.com, I get a "remote connection" error. Does anyone have an example of a connection string I should be using to connect while on the server?
Thanks!
View 2 Replies
View Related
Oct 21, 2006
Hi,
I am writing Stock inventory and POS application.
POS will be used at multiple branches to collect sales, whereby Stock Inventory will be used in HQ for product info maintenance, stock in and etc.
I need to send all of the branch sales records back to HQ and send updated product info such as cost to branches everyday (could be multiple times per day).
I am thinking to use SQL Server Express 2005 at branches and SQL Server 2005 standard at HQ.
Do you think it is workable? What is the mechanism I can use to "transfer" these data?
Please advice.
Thank you
View 1 Replies
View Related
Jan 24, 2008
Are there any way I can make changes to my database without stopping the web site? I'm using SQL Server 2005 Express for my web shop. And each time I have to add or change a table or Stored Procedure I have to stop the site. What I do is to stop the web site (in IIS), restart the IIS and then open the database in the SQL Server 2005 Express Management tool. If I don't "release" the file first I get an error when I try to open the database file in the Management tool.But there must be a better way to do things? I also would like to take bacup of the database without stopping the site, but how? There must be others that have had the same problems? Regards, Sigurd
View 3 Replies
View Related
Jun 6, 2006
Hi,
Plz help!
I built a web site using IIS and ASP.NET 2.0.
My web site has a log on screen and I only configured it with one user without any roles. This web site uses the SQL EXPRESS.(I Have 2 databases: 1 for the security required by the application and the other for my application. for the connectionstring I used a windows authentication security with an instance = true.)
Everything went well on my PC.
When I tried to deploy the web site on another PC, there was a big problem.
When I tried to login with the same user I created, then I have a problem.
The password is incorrect(Why? I don't know).
Maybe there is a problem with the IIS or with the SQL SERVER.
pLZ HELP!!
View 1 Replies
View Related
Jan 9, 2006
Lets say I use the 'enabling roles' for my ASP 2.0 site. This creates a ASPNETDB.DBF SQL Express file.
Later I go to post this to a real web server - which runs the 'full' MS SQL2005 server. What happens to the ASPNETDB.MDF file (or for that matter, any other MDF file I create with SQL Express) when it leaves the Express world and enters the Real world.
View 4 Replies
View Related
May 20, 2006
I have installed SQL Server 2005 Express Advanced Edition. I wan to use it as a database backend for a Web Site I am building which will use the Snitz Forums ASP web. How do I se this up to work with the Snitz product? Yes I am new to databases and have never set up one for use in a web application or site before. I am grateful for any assistance or tutorials which can be given to help me accomplish this task.
View 9 Replies
View Related
Mar 5, 2006
I have installed sql server express 2005 and also visual studio express developer when i run the personal web site sample I get the folowing error
Shared Memory Provider, error: 40 - Could not open a connection to SQL Server
How do I correct this please does any one know ?
View 4 Replies
View Related
Mar 31, 2006
I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express. I ran the aspnet_regsql and it created the aspnetdb database. But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work. I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail. My SQL Server is installed on the Default Instance. Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?
View 1 Replies
View Related
Mar 28, 2007
I am wondering how some of you update your database once it is already been in use. So take for example you have a few tables and users can enter data into the site. Now suppose you either add tables to the db or you add fields to an existing table. I am using sql express 2005 and just want to copy the db over with the copy website but it would overwrite any data users entered.Is there any easy solutions or suggestions for this.Thanks
View 1 Replies
View Related
Jan 15, 2008
I am developing a web site with asp.net 2.0 and c#, using Visual Studio 2005 and Microsoft SQL Server 2005 ( I am still learning about these technologies and languages ).
I transferred my web site files to a new computer.
I created a empty SQL database called "SiteData.mdf", I stopped the SQL server and then I replaced this database with a previous one with the same name and already populated with data.
I used this maneuver in order to avoid having to insert all data again.
The web site works fine when running inside Visual Studio, however when I try to run it in its published format it gives this error message:
Server Error in '/MA' Application.
Cannot open database "SiteData" requested by the login. The login failed.Login failed for user 'CENTAURUSASPNET'.
I also observed that inside the SQL Server Management Studio, in the database properties, it shows "ETHERASPNET" as User or Roles ( however "ETHERASPNET" was created using the old computer's name [ or should I say domain ? ]) but the permissions list correctly displays the new name "CENTAURUSASPNET".
I think that I, probably, should create a new user using the name "CENTAURUSASPNET" because it would use the name of the new computer ( or domain ) and then I should delete the old user name. Actually I tried to do that but I get the message "An object named ‘CENTAURUSASPNET' cannot be found".
So,
1) What should I do to get the database being connected with the published web site ( note: I am publishing it in my own computer for awhile ) ?
2) How do I create the new user name "CENTAURUSASPNET" ?
3) I also would like to know why the name of the database in the Server Explorer panel of VS appears as "centaurus.SiteData.dbo" -while- inside the Object Explorer panel of the SQL Server Management Studio it appears simply as "SiteData" ?
View 2 Replies
View Related
Jul 25, 2000
I am new to the internet field. Can anybody help me in administering the SQL database on the site. Are there any tools so that I can administer the database on the site straight from my PC??? If there, please tell the URLs so that I can refer them. And please tell me other issues which are involved in administering the database on site.
How can I maintain a parellel SQL server database on my PC?? How can I take backup from my site to the SQL database which is placed in my PC?? I want to keep backup of my database in my PC.
Please help me in these issues.
Venkat Reddy
gv.reddy@usa.net
View 2 Replies
View Related
Jul 18, 2007
Hi All,Just wondered if i could ask you for some advice and help.I'm looking to write a site, and one of the functions of the site is to remind the user of a certain event at a certain time. I was wondering how i would do this? or if anyone has a working example i could use?Also I dont quite know what database to use...... would MySQL do the function i am after???? If so then no more problem lol If not what database would you recommend i use?ThanksDanny
View 4 Replies
View Related
Jan 15, 2008
I am developing a web site with asp.net 2.0 and c#, using Visual Studio 2005 and Microsoft SQL Server 2005 ( I am still learning about these technologies and languages ).
I transferred my web site files to a new computer.
I created a empty SQL database called “SiteData.mdf�, I stopped the SQL server and then I replaced this database with a previous one with the same name and already populated with data.
I used this maneuver in order to avoid having to insert all data again.
The web site works fine when running inside Visual Studio, however when I try to run it in its published format it gives this error message:
~~~~~~~~~~
Server Error in '/MA' Application.
Cannot open database "SiteData" requested by the login. The login failed.
Login failed for user 'CENTAURUSASPNET'.
~~~~~~~~~~~
I also observed that inside the SQL Server Management Studio, in the database properties, it shows “ETHERASPNET� as User or Roles ( however “ETHERASPNET� was created using the old computer’s name [ or should I say domain ? ]) but the permissions list correctly displays the new name “CENTAURUSASPNET�.
I think that I, probably, should create a new user using the name “CENTAURUSASPNET� because it would use the name of the new computer ( or domain ) and then I should delete the old user name. Actually I tried to do that but I get the message “An object named ‘CENTAURUSASPNET’ cannot be found�.
So,
1) What should I do to get the database being connected with the published web site ( note: I am publishing it in my own computer for awhile ) ?
2) How do I create the new user name “CENTAURUSASPNET� ?
3) I also would like to know why the name of the database in the Server Explorer panel of VS appears as “centaurus.SiteData.dbo� –while- inside the Object Explorer panel of the SQL Server Management Studio it appears simply as “SiteData� ?
View 1 Replies
View Related
Jul 20, 2005
Hi.Does anyone know any web site with common database models presented andexplained.Database models like calendar, adressbook, storehouse...Thnx in advance
View 1 Replies
View Related
Sep 28, 2007
I have contracted a webproject to be done. My client allready has a website. I need to create another website that replace the existing one with the new look.
This is the problem. The old website has a Database that is associated with user registration & all other data of the company. So, I need to implement the same database to the new website which I am going to develop.
In this case, how can I start? can I add a SQL express databse to the new project and import the data while the development phase? or should I use a SQL server installed while developing the site?
Please give me an easy to understanable reply that I can deal with the old database?
View 6 Replies
View Related
Nov 7, 2006
I have a vb.net web page which I created (a shopping cart). I created this site using vb.net 1.1 and SQL 2000 on my laptop. On my laptop everything works properly, but when I tried moving it to GoDaddy (http://currahee3-506.org/px/default.aspx). In the code, each query to the SQL server is done using stored procedures.
When you first go the page, a drop down is presented. When you select "Shirt" from the category drop down. A second drop down menu is then displayed and will let you select what type of shirt you are interested in purchasing. Select Polo Shirt Without Pocket. Upon doing so, I receive an error message:
Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.
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: Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.Source Error:
Line 143: sqlCommand.Parameters.AddWithValue("@str_ItemName", Trim(DDL_Items.SelectedItem.Text))
Line 144:
Line 145: Dim dataReader As SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 146:
Line 147: dl_Description.DataSource = dataReader
Source File: d:hostingcurraheepxdefault.aspx Line: 145
Keep in mind the Stored Procedure works in my testing environment, but not on GoDaddy. I moved the selected statement into a view on the GoDaddy SQL server, and the view worked perfectly. The tables do exist on the GoDaddy SQL Server.
This is the Stored Procedure:
CREATE PROCEDURE [dbo].[sp_GetItemInfo]
@str_ItemName VarChar(50)
AS
SELECT TOP 100 PERCENTtbl_pxProducts.int_ItemID,tbl_pxProducts.str_ItemName,tbl_pxProducts.int_RetailPrice,tbl_pxImages.str_SmallImageURL,tbl_pxImages.str_MediumImageURL,tbl_pxImages.str_MediumImageBackURL,tbl_pxImages.str_LargeImageBackURL,tbl_pxImages.str_LargeImageUrl,tbl_pxImages.str_SmallImageBackURL,tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold AS int_QtyAvailable,tbl_LookupCategory.str_Category,tbl_pxProducts.Int_SizeID,tbl_LookupSizes.str_Size,tbl_pxProducts.Int_ColorID,tbl_LookupColor.str_Color
FROMtbl_LookupCategoryINNER JOINtbl_pxProductsONtbl_LookupCategory.int_CategoryID = tbl_pxProducts.int_CategoryIDINNER JOINtbl_LookupColorONtbl_pxProducts.Int_ColorID = tbl_LookupColor.int_ColorIDINNER JOINtbl_LookupSizesONtbl_pxProducts.Int_SizeID = tbl_LookupSizes.int_SizeIDLEFT OUTER JOINtbl_pxQtySoldONtbl_pxProducts.int_ItemID = tbl_pxQtySold.int_ItemIDLEFT OUTER JOINtbl_pxImagesONtbl_pxProducts.int_ItemID = tbl_pxImages.int_ItemID
WHERE(tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold > 0)AND(tbl_pxProducts.str_ItemName = @str_ItemName)
ORDER BYtbl_LookupSizes.str_Size
Does anybody have any suggestions as to why this stored procedure is failing?
View 1 Replies
View Related
Jul 31, 2007
I have build a ASP.NET website with a login form. I can create an account but I am not able to login into the site. I have checked the connection string. I have changed the database folder and moved files around to get the database runing from a different folder but it still wont work.
Thanks
Tim
View 2 Replies
View Related
Apr 24, 2008
I've downloaded a copy of Microsoft SQL Server Management Studio Express from MS. Can this product be used to query an SQL database at a web site.
Conversely, is there a command line utility for running SELECT statement queries on my remote web site database?
View 1 Replies
View Related
Jul 20, 2005
Greetings,I am in the process of installing a SQL database at a customerlocation. I have determined that there are 3 ways to do this, and Iwanted to know which is the best of the 3.1 Install From Script.In this method I create the database and its objects in scripts thatare run via osql utility on the SQL server machine. For loading anyinitial data that I need in the database I also run bcp commands.2 Install from a backupIn this method I created an empty database on the SQL server, and thenrestore over it the database from a backup of the database that I needto deploy. Then I add or re-attach the users for the database. Iperform all of these operations using osql as well.3 Install by attaching the data files.In this method I created an empty database on the SQL server, and thenI attach the data files to the database using the sp_attach procedure.Then I add or re-attach the users for the database. I perform all ofthese operations using osql as well.Although it is no problem for me to use any of these methods, I wantedto know from you veterans out there what the best practices are. Andalso if there are any unseen hazards for each method above. Or if Iam totally off-the-target, and there is another method that is thepreferred way.Thanks in Advance,roger
View 5 Replies
View Related
Mar 26, 2008
Hi,
I wanna attach to the database from our domain(ftp site) . it is not in the our network..
thanks,
J
View 3 Replies
View Related
Jan 12, 2007
I make a site in my computer it's work localhost I make mssql connection in localhost but ı don't know how i make mssql connection on website
View 5 Replies
View Related
Jul 19, 2007
Hello,There's information on my Internal SharePoint DataBase that I want to access. How can I do this? Could you help me or at least point me in the right direction.The information I am requesting is just text.Thank you,Mark
View 4 Replies
View Related
Jul 23, 2005
I have an sql script that I ran on my local system using osql. Itcreated all the tables, views, and even inserted sample data into thetables.Now I need to create that same database on a shared hoster site. Onlythe hoster does not allow the running of osql.How can I create my sql server database on my shared hoster site?Can I save and restore my database somehow?Is there a stored procedure I can run which will run the .sql scriptfile?thanks,-Steve
View 4 Replies
View Related
May 24, 2007
Hi,
I am very new to SQL Server and am just starting to look into replication as a possible solution to a problem I have. I have a local database which will be running on either MSDE or SQL Express 2005. I have a database on a webserver running SQL Server 2005 Standard which I wish to keep as an exact copy of the MSDE/Express one. If data is changed in the local db then I want the webserver db to be updated with this data, preferably as the change occurs, but it could be on an hourly schedule if required.
If data in the webserver db is altered then I do not wish for it to update the local db, but I would like it to be assumed that the change is erroneous and reset the item to whatever exists in the local db. In other words, should a table be erroneously dropped or something from the webserver db then the table would be recreated when it syncs with the local db (rather than propogating the change back to the local db and thus losing local data).
Basically I want the web db to be an exact mirror of the local db as often as possible. Given that the webserver is running SQL Server 2005 Standard and the local machine will be running either MSDE or SQL EXPRESS, is this achievable and what would be the best way of achieving it? Should I use merge replication or database mirroring? I have succeeded in getting 1-directional merge replication working by setting the webserver up as a publisher and distributor and setting up a push merge subscription on the local machine with an ExchangeType of 1. However, this won't correct the data in the web db if it is compromised until it is altered locally.
It crossed my mind that I could write a small application to utilise tablediff to compare each table in the DBs and get it to correct the web db if required on a regular basis. Would this be a silly approach?
I would appreciate expert advice!
Max
View 1 Replies
View Related
