Is That Possible From Live Website Sql Record To Intranet Database ?
Aug 2, 2007
hi.
I would wish to know whether it is possible for me to program the code from html or aspx ( from web hosting server ) to our office intranet database which is window server 2005?
I had tried to google for more info but there are too complicated thing for me to understand.
Actually i am doing the web form feedback form from the website for the public to fill in and submit. i am using the mysql from web server to store the records from the feedback form.
We have another database in our server, ms server 2005 to store records in the intranet office only. i need to get the records from mysql to intranet database. i don`t think there is a automated scripting which allow u to auto update the intranet database from mysql( web server )
So i thought of one thing . program html or aspx to insert records directly to our database intranet . but how ?
I appreciated that.
Regards
newbie on aspnet.
View 3 Replies
ADVERTISEMENT
Feb 8, 2008
Hello,
I have my local development evrioment and my live webserver in colo. The two different machinces both have SQL2005 and copies of roughly the same database. I use the one for developement and the other obviously for production. Currently I read in different connection strings from my web.config file for my live version v my development version so I can have different database names and connection strings.
I'm looking at moving to LINQ, but I can't figure out how I'd achive an equivelent flexibility as database names and connection strings seem to be hardcoded in to the class using it's designer. Obviously if modifing this wasn't possible, nobody would be using LINQ, so how do I work around this?
Thanks,
Joel Barsotti
View 1 Replies
View Related
Aug 6, 2015
I want to restore a database (from an encrypted .bak file) - but *not* over the live original if you take my meaning. Encryption is the standard AES-256 that comes with Sql Server 2014 btw. I don't want the original touched/altered in any way. I would like to capture a success message if possible.I can extract the physical device name of the database in question using the following code:
SELECT physical_device_name, *
FROM msdb.dbo.backupmediafamily
WHERE media_set_id =(SELECT TOP 1 media_set_id
FROM msdb.dbo.backupset
WHERE database_name='MyDatabase'
AND type='D'
ORDER BY backup_start_date DESC)
I would like if the newly restored database was rename to something different than 'MyDatabase' (as shown above) and has different logs than the original. If possible, and capture a success message when restored.
View 5 Replies
View Related
Feb 1, 2005
have 2 databases in sql server 2000
Live
Dev
I need to append all the data from LIVE into DEV environment. I have tried using MS Access (linking tables & importing tables and running APPEND query to update the rows from LIVE to DEV but PK & FK is causing problems as some data will have the same ID's....
Could I use DTS--Access wizard in SQL Server.
What is the best option to use?
Thanks all in advance
View 2 Replies
View Related
Mar 27, 2008
Error!!! 1>Cannot open database "intranet" requested by the login. The login
failed.Login failed for user 'RAGHAVEN-71AF9BASPNET'. Error!!! 2>
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) These both errors r coming simultaneously when start to debug only when i tried to retrive data from database ,
from past two days not able to work on database,plz
help me in solving this ,i tried everything what i know and even on
experts advice from recommended websites, forums and on google search..
View 4 Replies
View Related
Dec 7, 2006
Hello,
I haven written a Windows program in Visual Studio 2005. This program stores data in and retrieves data from a SQL Express database. The customer is starting to use the program and filling the database with data. However the program is still under construction (new functionality will be added) and so is the database (new tables, views etc. will be added).
Of course I could send the customer the new database, but than all data already entered will be lost.....
I'm thinking about using the SQL Management Studio Express and VS2005 to connect remotely to the database (a VPN connection is availabe) but worry about performance issues.... Or should I use some kind of replication / synchronization and how, because this is new to me.
What is the best way to solve this 'problem' ?
View 5 Replies
View Related
Oct 19, 2006
I have a live SQL 2005 database that has ntext fields, when the ntext fields go over 4000 chars the record can no longer be edited. It throws a string or binary data would be truncated error. I tried turning text in row OFF, but it did not work. Can anyone forsee any problems with changing the ntext fields to nvarchar(max) in the live database? Also, I came across sp_tableoption N'MyTable', 'large value types out of row', 'ON', does this work for ntext also? sp_tableoption N'MyTable', 'text in row', 'OFF' did not do anything.Any help would be appreciated.
View 4 Replies
View Related
Feb 5, 2008
Hi,Ive been building a project on a local server and now need to transfer the files and database over to the live server. I have managed to transfer the files quite easily, however I am having a few problems transferring the database using Microsoft SQL Server Management Studio. When I try importing data to the live database, all the data and tables are brought across however some of the values for the fields are lost. For example all the fields which had a primary key no longer have one, and all the set default values for the fields are also lost. Ive been considering just going through every table in the database and re-entering the correct values for the fields, but this seems a bit time consuming and I'm also concerned about possible errors which could arise as there will be an inconsistency.Another method I tried was copying the SQL query across which created all the tables and the correct values for the fields. However when I tried to import the data an error was produced as you cannot import data into a table which has read only fields etc..Does anyone know a solution?Thanks for your time.
View 2 Replies
View Related
Mar 23, 2006
im using the the login controls with asp.net
when i test locally everything works great, its see the ASPNETDB.MDF file, checks the login info and passes the user on to the next page.However when i move the application to the live server it fails, it cant find the datasource that contains users/password etc. here is there 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) So im missing something here, im used to connecting directly to a remote SQL database and accessing the info from there.
Can someone point me in the right direction? Can the MDF file not be used off the server itself without SQL express installed? Do i need to migrate those tables into a real SQL database?Thanks,Sean
View 2 Replies
View Related
Jul 31, 2007
Hi
I'm migrating from access to sql server 2005.
With access, I did full backups every 6 hours, by simply copying the .mdb file to a folder on another hard disk on the server, and then ftp it to a distant server.
I guess i just can't simply do the same with the SQL server .mdf file.
What is the best practice to achieve the same goal ?
Thank you
View 9 Replies
View Related
Sep 11, 2007
I'm not sure this is the exact forum in which to ask this question, so if there is a more appropriate forum, please point me in that direction.
Basically I'm looking for advice and best practices for dealing with an upgrade plan for a hosted database. Here is the situation:
- Hosted software application (.Net)
- Uses SQL Server 2005
- When we upgrade the software application to a new version, there will be schema and data changes that need to be applied to the database
- For the software application, we have considered upgrading an offline machine and then switching old one instantaneously.
- For the database, I'm trying to figure out if we can keep everything live for upgrades, or if we should have a small amount of scheduled downtime to upgrade.
So we have identified 2 basic directions:
1) Keep the database live and apply the new script changes just after the application software is upgraded. This means zero downtime, but we'd have to design and test our application to be backward compatible, so that the new version of the application code could handle both the new schema design, and the old schema design. It seems that this option would add a huge amount of complexity because we would essentially be testing a 3rd app/schema combination.
2) Take a small amount of scheduled downtime and upgrade the application code and database all at once.
Obviously option #2 is the most desirable from a development process point of view, and #1 is the most desirable option from a business point of view (zero downtime).
So, I'm looking for some advice on this. Do most people take the whole system down? Are there 100% live systems that deal with this? Are there other approaches I'm not considering?
Any information would be greatly appreciated. Thanks.
View 4 Replies
View Related
May 12, 2014
,I am creating a database where each record is required to have a twin record in the database.These is a type a value and a type b value and both must be present for the record to be valid.
Customer_ID, Order_Type, Product_Code
54, a, 00345
54, b, 00356
Is this something that would have to be done programmatically, or is it possible to create a constraint of some sort to ensure this?
View 8 Replies
View Related
Jan 31, 2015
I want to Replace The Big Log database with A new one ( A database with same structure).But current DB has many connection .
This is my plan :
1- Create a new database with same structure.
2- Rename current database to olddb with this code :
USE master
GO
EXEC sp_dboption CurDataBase, 'Single User', True
EXEC sp_renamedb 'CurDataBase', 'OldDataBase'
GO
3- Rename Newdb to current DB.
USE master
GO
EXEC sp_renamedb 'NewDataBase', 'CurDataBase'
is it true ? and Tsql code is ok ? (dont forget many of connection to curdatabase (that Is a log db) and loss some seconds data is not problems)
View 4 Replies
View Related
Oct 7, 2015
Client is running X- version of application and corresponding database size is huge. Now client's vendor is releasing Y-version of same application with many database schema changes (like new tables added, new columns added, renamed existing columns and etc) To upgrade to the Y-version, vendor is suggesting to my client that down the system and do the upgrade for application/database to Y-version. We are sure that this process will take days together to upgrade to the Y-version. My client is not ready to down the system for that long. So we are trying to find the solution with minimal down time.The approach we are thinking is,
1) Create the replicated database to another server (server2) from production server(server1) using golden gate with X-version
2) Create new tables/schema updated tables from Y-version database on same server1. Here for Updated schema tables we are planning to use the name <table_name_Y_version> as the same table name exists in X-version.
3)With above 2 steps, golden gate replicate the changes from production to server1 and server1 will have the new Y-version table schema (with different concatenate name ' _Y_version'). BTW , there is no affect for the production
4) At this stage we are planning to find best approach, to fill the '<table_name>_Y_version' from X-version tables. two challenges here a) all data needs to be moved to Y-version tables b) they have to sync data in real time.
we thought of going to
a) ssis package to pump the data to Y-version tables, but real time data will not sync.
b) trigger based technique, previous experience said, lot of load
c) thinking about sql replication.
View 5 Replies
View Related
Dec 27, 2006
Live Webcast tomorrow
Essential Team System for Database Developers
1 PM Central time 12/28
https://www.clicktoattend.com/invitation.aspx?code=112602
View 2 Replies
View Related
Mar 4, 2006
I'm developing a website, its completley 100% Database driven, ever piece of content is from the database, is this a bad idea?
View 4 Replies
View Related
Jun 5, 2006
Hi !
I almost finish my website and ready to upload it to internet. However, I have a thought of how the database will work.
Here's the scenario. My website is a data-driven dynamic website with SQL as the database manager. I have 3 database files.
After I finish with everything, I will have to deploy the application
to the webserver right? Now, let say I deploy / upload it to a hosting
company. Then, people start using my website, all traffic coming in,
and database are getting larger and larger. Then, let say I decide to
make some changes to my website. I change the website here and there.
However, I haven't uploaded / deployed it to the hosting server yet. I
just make the changes in my computer. I test the application and
changes that I make, everything works fine.
My question is: If I deploy / upload my website to the SAME hosting
company after I make some changes, what will happen to the database in
the hosting server? My website has been used my many users and database
is getting larger. If I deploy ./ upload the website that I have made
changes, will it overwrite the database in the hosting server? Or how
does this work?
Anybody has any idea or maybe has already done it?
Any articles or thoughts will be appreciated!!!
thanks you sooo much in advanced!!!
View 6 Replies
View Related
May 15, 2001
My database contains over 50 tables of information - some tables are quite large. Rather than upload the entire database (which I imagine could potentially lock out many users from browsing the website), I would like to upload changes to individual tables. My local database contains the most recent table information. What would be the best way to upload individual tables that would only lock one row at a time while the updates were taking place? A DTS package?
Thanks.
View 1 Replies
View Related
Oct 17, 2004
it must be simple, but not for me!
there's a folder called db in the ftp part of the server and the admin told me to upload my database there,i don't know how to transfer my database in that folder.can you help me?
View 1 Replies
View Related
Sep 21, 2006
HiI'm using sqlexpress on development machine and on client server. I'm building a webapp using membership and role provided for asp. In web.config I have definet membership provider and role provider to point to my database.After web site deployment I get allways message : Failed to update database "c:appapp.MDF" because the database is read-only, and I'm forced to apply rights for ASPNET. More than that somethimes I must re-register users.I have tried to modify in web.config with <remove name="LocalSqlServer"/> <add name="LocalSqlServer"...> but I get errors if I try to design my dataset file:"Cannot get web application service".TIAPaul
View 4 Replies
View Related
Jan 11, 2008
Hello everybody,
I intend to used SQL Express database in my website so that I don't have to go through all the database deployment effort when deplying my website.
In this regard, can anyone please tell me what features would it require in my hosting package so that my application works fine (in database context). Would I have to purchase any additional features (like the way we purchase SQL Server database(s) in hosting package) for SQL EXpress in order to deploy my application??
I look forward to you kind replies.
Thank you.
Zulfiqar Dhuka
View 2 Replies
View Related
Feb 28, 2003
I am currently trying to complete part of my A-level coursework but am stuck.
i am creating a website for a restaurant on which customers can submit information to do with four areas:
---------------------
Bookings
Comments
Job Applications
Pre-order
----------------------
i have used access alot in the past and had no problems creating a running model of my final database.
i have built my website and created the four tables in the alloted MySQL area that came with my website package.
BIG QUESTION:
how do i create the interface for people to submit data and for it to be sent to my database?
i am a complete beginner to MySQL using it for the first time this week so im not sure what i need to do in the slightest to solve this issue
-------------
any help or advice would be VERY VERY gratefull
View 1 Replies
View Related
Aug 3, 2006
Hi all,
How can I deploy my website sql database files, which I have done using Visual web developer. (Visual Studio .net 2005)
Connection srting all these are different in this VWD.
<connectionStrings>
<add name="GoalConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
View 1 Replies
View Related
Oct 23, 2006
HiI’m abut developing a website that has a 200 megabytes SQL database ,in my estimation the maximum online users are 100 users for first year , I want to make shore a SQL express 2005 database in good enough for my purpose. Another question is how much can I count on a SQL express 2005 database? I mean how much it could be grown and abut security (I mean is it as secure as SQL server?). Thanks.
View 3 Replies
View Related
Jul 15, 2007
I don't know whether this question belong here, but....
In the past I had many customers using the same website each with their own domain name and their own database. To accomplish that, I used MS Access and placed each customers database in separate directories. I steered the customer to the correct directory using their domain name. I am now trying to accomplish the same thing using aspnetdb.mdf and other .mdf database files. I am using the aspnetdb.mdf database for membership, etc. I want the aspnetdb.mdf database file to be unique for each customer. Does anyone know how to accomplish what I was doing with MS Access using aspnetdb.mdf? Is there any way to have multiple web.config files each of which would be dedicated to a particular customer?
View 1 Replies
View Related
Sep 26, 2007
I am in the process of designing a web application for our application that will be available to the general public.Basically will be used to collect information for a case report. I need to know if there is a way from our internal database driven application to push certain data up to the website that the database may be behind a firewall so I cannot make a direct connection to the external database. I thought I heard about some sort of data sharing protocol. I then will be storing the users entered data in the website database and pulling it from the internal application. So basically I need a secure way of sending and receiving data between a server/client app on a LAN system to the Web site database that could be hosted outside the LAN.
I hope this made sense.
View 4 Replies
View Related
Nov 26, 2007
Hi,A quick question, is it possible to deploy a website on a shared hosting environment which attaches to a MDF database file stored in the App_Data folder?
View 1 Replies
View Related
Mar 6, 2008
hi there..
I have write a code in the submit button using vb code so that when people key in their email.. it will be saved in my created database called test.mdf. but when i debug it, i tried to write an my email address in the textbox in my website but when i click at the submit button, the web page display the email was not enter in my database.
here is the code, can anybody help me. i'm really lost here..
Protected Sub SubmitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim TestDataSource As New SqlDataSource()TestDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("TestConnectionString1").ToString()
TestDataSource.InsertCommandType = SqlDataSourceCommandType.Text
TestDataSource.InsertCommand = "INSERT INTO Email(EmailAddress, IPAddress, DateTimeStamp) VALUES (@EmailAddress,@IPAddress,@DateTimeStamp)"
TestDataSource.InsertParameters.Add("EmailAddress", emailAddressTextBox.Text)
TestDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString())TestDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now())
Dim rowsAffected As Integer = 0
Try
rowsAffected = TestDataSource.Insert()
Catch ex As Exception
Server.Transfer("test_problem.aspx")
Finally
TestDataSource = Nothing
End Try
If rowsAffected <> 1 ThenServer.Transfer("test_problem.aspx")
ElseServer.Transfer("Test_Confirm.aspx")
End If
End Sub
View 2 Replies
View Related
May 17, 2008
I am creating a website. where the data to be stored in my server. I had my webspace from some service provider.
How can i connect the website and thee database.
--> website is deployed at webspace given by the provider.
--> database is at my server( located in our office).
****************How can i connect these website and database.*******************
View 3 Replies
View Related
Apr 12, 2005
Hi!!!
I have a database called "test_DB" i have one table and some data on it. I uploaded the website and created an SQL Server account to upload the database. Can you please help me to do that task. Is there any step by step directions to do it and what files i need to add ( like ".mdf" or others...) I appreciate your help!!!
Thanks...
View 1 Replies
View Related
Mar 17, 2006
Since VWD Express doesn't support Publish Website, I used 'Copy Website' to deploy my local site to the hosting server. The static page works fine, but when it gets to accessing database, I kept getting the following error:
An attempt to attach an auto-named database for file I:DataWebdnh.sklingling_15726c71-b2bf-479f-bcc3-b7ae43318f3cwwwApp_DataPersonal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Anyone has the same experience? How to resolve this?
Thanks,
View 2 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
Dec 28, 2006
Hi all,
I've got a little problem.
I'm working on a ASP.NET project. The applications has 4-layers. When I look in the Data Access Layer and test the typed dataset, then the "Preview Data" works fine. I see the right records from SQL Server 2005.
But when I run the app (default.aspx) in debug-mode, then the system gives 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Please help.....
View 3 Replies
View Related
