Sharing Data Between Website And Internal Database
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
ADVERTISEMENT
Sep 19, 2007
simple question:
I have create a web site in visual studio with form user authentication. Thats create a mdf database in this path:
c:inetpubwwwrootwebsiteapp_dataaspnetdb.mdf
thats use Sql server
i would like to access this database with c# form application on a network with multi-user.
if i change the drive letter of the path above to f: (mapped drive) or \serverc, i got this message
System.Data.SqlClient.SqlException: The file "h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
i read that sql server did not support database sharing with mapped drive or unc share.
So how can i share website database with c# application???
Note: of course if i develop the website and the application on the same machine its work. I want this application run on several work station accessing all the same mdf database with his web user member.
View 7 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
Nov 15, 2006
Hola!I'm currently building a site that uses an external database to store all the product details, and an internal database that will act as a cache so that we don't have to keep hitting the external database to retrieve the products every time a customer requests a list.What I need to do is retrieve all these products from External and insert them into Internal if they don't exist - if they do already exist then I have to update Internal with new prices, number in stock etc.I was wondering if there was a way to insert / update these products en-mass without looping through and building a new insert / update query for every product - there could be thousands at a time!Does anyone have any ideas or could you point me in the right direction?I'm thinking that because I need to check if the products exist in a different data store than the original source, I don't have a choice but to loop through them all.Cheers,G.
View 2 Replies
View Related
Sep 17, 2004
Hey guys,
I have a quick question about SQL 2000 server data sharing.
I am currently using SQL 2000 Server Enterprise and I need to do synchronous data sharing with flat files. I have an ODBC connection to the files. I was able to easily share this data by using linking in Microsoft Access, however, for the life of me I cannot figure out how to do the same in SQL. We are in the process of converting legacy code. The old code will of course be communicating with the flat files and the new code will be talking to SQL server. So it is vital that the 2 access methods are both pulling the same data. Does anyone have any ideas???
Help would be greatly appreciated
Thanks
Dax
View 3 Replies
View Related
Apr 17, 2007
I am writing a DB-driven application, using Visual Studio. I have a database that i want to be able to move from one computer to another, and still be able to access it. It's probably something simple, but I must be missing out something.
The problem is that if i choose windows authentication, then the DB cannot be used on another computer. I also had no luck when using SQL Authentication.
How can this be done? What form of authentication should be used and how, so that I can just copy my DB from one computer to another, then log into the DB using a username and password?
*Any* help would be greatly appreciated!
View 3 Replies
View Related
Jul 20, 2005
Hi:I'm trying to setup a MS Cluster but I don't know if it is feasible toconfigure it in the way I think.I have two machines with win2k server and MSSQL-2000 one of them iscurrently performing as the production database and the other one isthe backup. The secondary one is keeping updated via the "LogShipping" technic.We almost covered all the other possible failures of the othercomponents (ie: network, power, application servers, etc), the data ismaintaned in a raid which is ok but we want to cover also thepossibility of that failure too (yes, you can call us paranoids!! ).The thing is we want to create a cluster that do not share the data,but each machine of the cluster have thei own set of the same data.My intention is to configure the cluster to detect a failure of onemachine and initiate the failover to the remaing one using theappropiate scripts related to the promotion of a secondary serverkeeped updateusing "log shipping".Have anyone some experience with that kind of solution ??Thanks in advanceLeonardo
View 2 Replies
View Related
Feb 7, 2007
Hi;
I have an ASP.NET application with a SQL Express database.Here is the connection string used on the web application:"Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|admindata.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"
Now, i create a Windows application which will run on the server to perform some scheduled tasks, for the Windows application I used this connection string:"Data Source=.SQLEXPRESS;AttachDbFilename=D:WebSitesmywebsite.comwwwApp_Dataadmindata.mdf;Integrated Security=True;User Instance=True"The problem is, when the web site is running and using the database, the windows application can't connect to the database and i don't know where i'm doing wrong, if it's the web application connection string or, if it's the windows application connection string.
I hope someone had the same experience and can point me to a direction.
Thank you;Emerson Brito
View 7 Replies
View Related
Nov 29, 2007
We receive data files from different external customers, and these files have identical layouts.
I'm planning to set up a package for each customer. Each package will contain a flat file source -> OLEDB transformation dataflow, (followed by other customer-specific data flows).
What I'd like to do is just create this dataflow once, parameterising the flat file and table names. Is it possible to include this dataflow in each customer package so that if the flat file layout changes, I can just modify the connection managers in the one place, and then recompile each package to pick up the changes?
Any advice appreciated.
View 8 Replies
View Related
Oct 17, 2007
Hi,I have some database files (.MDF, .LDF,...) on the server. When I tryto delete them, the warning "Cannot delete file: There has been asharing violation. The source or destination file may be in use."appears.Since I am new to the environment I don't know where the files comefrom and where they might be used.Can anybody tell me what to do to delete those files?Thank you.
View 36 Replies
View Related
May 11, 2007
Hi,
I've read already every thread in this forum regarding this topic with no results.
SQLServer and the corresponding services are at actual update level. The reporting services worked for 4 months without this problem. Suddenly, most of the time all reports return an internal error (it is like 70-30 for internal error) not depending which render format is used.
The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.
Looking in the log files in RS log directory, there is following stacktrace:
w3wp!processing!1!05/11/2007-10:40:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
I don't see any hint in stack trace, Maybe one of yours.
As it seems, after an iisreset the first rendering always works perfect. HD space is enough.
Any ideas?
View 1 Replies
View Related
Apr 11, 2007
Ok,
I am a webdesigner who at the moment does not know SQL (although, I plan on remedying that) so I am developing a page with a DB designer - he is doing the DB work, I am doing the look/feel, but he asked me the following questions, of which I cannot seem to find an answer and the guys who tend our server are useless - so I am hoping someone here can help me. In general what he needs to know is:
"what is the external address (either in domain format or IP) and the equivalent internal address so that we can access the msSQL running on your server. The internal address is needed for the webpages to talk to it, while the external address is needed for development of the pages in visual studio and the database tools." Also, he later sent me an email asking that when I get this info (from someone) that it would be usefull to get a sample string/query to get access to the DB. I am running SQL 2000 and have enterprise manager. Where can I find this information? or how do I figure this out????
Thank you for all the help -- Please let me know if you need any more info.
View 5 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
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
Aug 11, 2015
I am currently reviewing what patch levels various instances are at. One that have come across is a Windows Internal Database (WID), version 11.0.2100.0 (SQL Server 2012 RTM), which is being used for WSUS.
I was thinking about bringing this up to SP 2. I had thought that WID was patched as part of the operating system, not with the SQL Server Service Pack installer. But I have been Googling it, and I cannot find any references to say one way or the other how it is serviced. Does WID is upgraded using the standard Service Pack? Or is there some WSUS magic?
View 0 Replies
View Related
Jan 21, 2008
I'm getting the following error:
An inconsistency was detected during an internal operation in database 'LocalLab2000'(ID:5) on page (1:19992). Please contact technical support. Reference number 5.
I ran DBCC CHECKDB ('locallab2000') and no error messages came up and still have the same problem.
I ran then dbcc checktable ('part') with DATA_PURITY and no error messager came up and the problem still whenever i select anuthing in that particular table.
Any ideas?
Thank you
View 1 Replies
View Related
Jan 21, 2008
I'm getting the following error:
Msg 5242, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation in database 'LocalLab2000'(ID:5) on page (1:19992). Please contact technical support. Reference number 5.
I ran DBCC CHECKDB and there's no error messages neither alloc or consistency.
I ran dbcc checktable ('part') with DATA_PURITY and still no errors, but i still have the inconsistency error message whenever i access this particular table.
Any ideas?
-Ricardo Lozano
View 1 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
Apr 20, 2006
VS2k5 Win2k3IIS6.NET 2.0In my ASP.NET 2.0 app I create and open an SQL connection in the page's constructor and call Dispose() in the destructor. The SQLConnection object is a class member of the page. This page makes heavy use of the SQLConnection object so I felt opening and closing in the constructor/destructor respectively was good design. I know this doesn't take full advantage of connection pooling. Any design input would be very much appreciated.Here's the destructor code:/// Destructor~Officer(){ if( m_objConn != null ) m_objConn.Dispose(); // <-- Exception occurrs here.}/// End DestructorWhen running this particular page through some testing I get the following exception in the destructor at the "m_objConn.Dispose();" line:System.InvalidOperationException was unhandled Message="Internal .Net Framework Data Provider error 1." Source="System.Data" StackTrace: at System.Data.ProviderBase.DbConnectionInternal.PrePush(Object expectedOwner) at System.Data.ProviderBase.DbConnectionPool.PutObject(DbConnectionInternal obj, Object owningObject) at System.Data.ProviderBase.DbConnectionInternal.CloseConnection(DbConnection owningObject, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Close() at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing) at System.ComponentModel.Component.Dispose() at Officer.Finalize() in c:sysprojectsAddOfficer.aspx.cs:line 461) Is this design good/bad?1) Is this a bug?2) Do I need a try/catch in a destructor? Is it good programming practice?3) Why is this happening?4) What is the meaning of life?Any help is appreciated. TIA
View 2 Replies
View Related
Apr 15, 2007
Hi,
I'm after hosting a website with basically a table in it that is linked to a MS SQL Server 2005 database, which I want to update on a pretty much continual basis from my own server PC which I'm running a data mining tool that updates the MS SQL Server 2005 database.
Any idea on how I would achieve this, or any pointers would be much appreciated.
Thanks,
Tom
View 1 Replies
View Related
Mar 24, 2008
Hi,
I created a website in Visual Studio and the data will be stored in SQL Server 2005. I publish the website in a local folder of my machine(because i don't have internet connection in my machine) and want to transfer these files from the internet cafe.
Let me tell you my problem about the "data source". The following statement i extracted from the web.config file and i want to know when i upload my website then what will the data source name. Whether i need to give IP address or name of server or what else. Give me some example?
And more over the following are the two ways connection to the database. the first one i have created database directly in SQL Server and another database i attached in my website directory. Please tell me in both circumstances what would be data source. Please tell me in detail.<connectionStrings>
<add name="BLMSDBConnectionString1" connectionString="Data Source=mycomputername;Initial Catalog=BLMSDB;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="employeeConnectionString1" connectionString="Data Source=mycomputername;AttachDbFilename=|DataDirectory|employee.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient" />
</connectionStrings>
Here i used SQL Server Express in my machine, if the Web server contains SQL Enterprise Edition then in scenario....
Here i am very confusion, if i want i can create database in my machine but in their server how?
Hoping for reply,
thanks..............
Best Regards
Kashif Chotu
View 5 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
Feb 1, 2002
Can someone point me in the right direction. I would like to grab some data from an email (not as an attachment)and load into a table, but I have no idea where to begin. Also, can this data also be retreived from a website?
Thanks
BV
View 1 Replies
View Related
Jun 23, 2008
hi guys,
i want to use SSIS package to download files from an http website.
i am tried using Http connection managers and webservice task but it asking me the wsdl file. i dont know where that file is.
can anyone please guide me? or suggest me any other way to do this?
View 3 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
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
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