I am coding in ASP.NET C#. I have Microsoft Dynamics GP hosted at a server and my database hosted at another server. I would like the GP database take value from some table there and synchronise it with my database. Which is the best alternative? Data transmission Service(DTS)?
View 1 Repliesi want to use caching in my application
bcz i am depending on same data and in diffrent places i am communicating with database for this data
so i want to use caching and want to store this data after use login into application.
I have created 2 projects in a solution. One project contains Asp.net classes with login page and different other pages.
Another project contains a web service.
When I launch the solution(click F6 in visual studio 2008) the login page can access to the method of the webservice. Both projects are launched.
However when i added this 2 projects into IIS and deploy them (with create command) the login page cannot contact the method of the web service. Even though the web service is running because i can acces it manually. But they cannot communicate each other.
Microsoft Dynamics GP is installed on my system..can I access GP web services?...If I can,how it is possible
View 1 Replies[Code]....
I still a beginner and i want to create a website asp.net with c# and microsoft acess as a database ,the problem that i can't insert new lines in my database
i need to rename microsoft access database in APP_Data folder using ASP.Net - VB.Net
View 1 RepliesFor some reason neither SQL managment studio nor import and export wizard works on my friends network due to some security policy
i asked a question about OSQL two days ago and StackOverflow guys told me it is going to be obselete and that i should use SQLCMD instead.
to cut long things short my question is very precise:
using SQLCMD..1-need to import and export command from AND to MDB/MDF
2-need attach / detach commands
I have an error when visiting my page
The Microsoft Jet database engine cannot open the file 'E:""""""""datab.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I'am developing a commercial website using visual studio.net 2005 and sql server 2005, where i have to import contacts from microsoft outlook 2003 into my web application, so i have searched a code, but it is a console application where it displays the contacts in the command prompt, but i have to retrieve it to my database application in an asp.net application becoz im working in asp.net2.0
the code which i have used to retrive the contacts from the outlook as a console application is follows,
Imports System.Reflection
Imports Outlook
Module Module1
Sub Main()
Dim oApp As New Outlook.ApplicationClass
oApp.AnswerWizard.ClearFileList()
oApp.ActiveWindow()
Dim oContacts As Outlook.MAPIFolder = DirectCast(oApp.Application.ActiveExplorer().Session.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderContacts), Outlook.MAPIFolder)
For Each oContact As Outlook.ContactItem In oContacts.Items
Dim FN As String = oContact.FirstName
Dim MN As String = oContact.MobileTelephoneNumber
Console.WriteLine(FN)
Console.WriteLine(MN)
Next
Console.ReadLine()
I'm looking for a way to parse excel into Asp.Net, the problem I'm experiencing same as in[ URL]
I've searched all web, but no1 seems to have an answer
here's the error
The Microsoft Jet database engine could not find the object 'Cities'. Make sure the object exists and that you spell its name and the path name correctly.
the code is the exact same as in [URL]
I am trying to import excel sheet, got an error like "
The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data"
I have given all necessary permissions but no luck..
My current web application is intented to work within an intranet. it works well with the development server. but when hosting in the IIS and multiple persons starts working with the site, it results in database errors like max pool size achieved, open reader exists etc... Does anybody have a DAL project to use with any database?
View 3 Repliesthis is my 1st time uploading any database to Host Server. I have purchase DiscountASP's domain and MS SQL 2005 database addon. I can make my website to copy to DiscountASP's domain using the Visual Web Developers copy website wizard and it works great.
Now i have a database in my website which i wanna upload to DiscountASP's MS SQL 2005 database that i have bought, but i dont know how to upload it and then how to make the connection between my Website and the uploaded database. Is it that i have to copy the website(containing app_data folder containing database) to the host and it will work, or i need to copy the database separately and then make a connection in my website and then copy the website?
i am having a database in mysql and i want to use that database schema in my project using sql server. i have a Nhibernate c#do code generated by mysql. how can i use that code.
View 1 Repliesafter i create the login page, i m used the login tool and set the role from the ASP.net configuration. Then, inside my project have aspnetdb already, i m asking that m i need to add another database to insert another information or just create new table inside the aspnetdb?
View 2 RepliesOr must it be a SQL Server database? If I'm reading the documentation right, as long as I use Entity Framework and not Linq to SQL, I can go against a Sybase data source. But I'm not certain...
View 1 Replieshow to design following small webproject and database .i am totally new in this area.
I need to quickly develop a system so that everyone can access the status of the job going online into the system
Activities
Move the job between work centers when it's completed.
Transfer button. So when design is done we should be able to click the transfer button and move the job from Design to Procurement
Here are the work centers.
plan cerement TST Shipped Each work center should have due dates User will have to update manually due date for each work center and this will be different for each job.
I'm currently working on an C#/ASP.NET project that will host several differents e-commerce websites, all running in the same application.I use LinqToSql (moving to PLINQO soon) to access my database. The database contains both informations on the website structure (pages, ...) and the products/orders/users data.
My question is, should I use only one database for all the websites, or sould I create a new database (same model) for every new website?I'm now using a single database (with SiteIDs in some tables) but I have a big security concern, I can't just backup/restore the database for ONE website if something goes wrong (e.g. somebody erase all the products on ONE website) and it's an important requirment of the application.
So I was wondering what are the good practices in that case? Is there big cons if splitting dbs?(I would have to make changes to several database instead of one in case of structural changes, but i guess i can make a db version/update system).How the existing CRMs are dealing with that?Is it a performance problem if a database server host a lot of different DataBases? A complex backup/restore tool would be better?
Subquestion:To make a website replication easy, I can also split the pure CMS data (Pages, Texts, ...) in one DB and the e-commerce data (products/categories/orders in another). It can be achieved by some select/insert functions but it would be easier by just copying a database of course.
I am trying to deploy my C# based ASP.Net 3.5 webapp
The hosting service provider said "Access 2003 (.mdb) file has to be put in 'access_db' folder in root folder"
I am currently using
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/access_db/filename.mdb"));
The folder structure is like
ParentFolder/access_db/filename.mdb
ParentFolder/ProjectFolder/<Project files> (App_Data, bin, *.aspx, web.config)
1) I am using a GridView on another page that doesn't allow to connect to a database outside the project folder. What should I do?
2) How do I modify the programmatic connection string ( shown above) ?
I've created a Data Base project with some CLR functions and stored procedures.
I'd like to deploy the assembly under different schema then the default dbo.
Is it possible?
I'm trying to implement my own Membership provider. I don't want to dig in very details but only high level logic. And first I don't understand is how can I use the class User generated from database in my CustomMembershipProvider project?
I thought I shouldn't generate class User in my project which uses my custom provider because it just don't need any users. It's only for login/logout functionality which implements Membership provider, not project that uses it.
Then I thought that I should pass Connection String to my Membership provider in order to make UserEntity somehow and use it inside Membership provider. I have two separate project for Membership provider and for any else project using Membership.
How could I create and use ADO.NET Entity in CustomMembershipProvider project for User table which located in database in other project?
I know nopCommerce and dashCommerce quite well, but I so far have never found any open source shopping cart (including HumanResources and Vendors) bigger than the nopCommerce. I'm wondering whether AdventureWorks database comes together with a web project or other UI projects as an open source. Or it just exists as a sample database only.
View 2 RepliesI'm currently learning from a ready-made tutorial here and I'm at this step [URL] Now my question is : How do I add the database to my project and don't use SQL Server Express? I created the MvcMusicStore database completely on a SQL Server instance, and modified the web.config included follow code
<connectionStrings>
<add name="MusicStoreEntities"
connectionString="Server=.192.168.161.1; Database=MvcMusicStore;Trusted_Connection=true"
providerName="System.Data.SqlClient" />
</connectionStrings>
All other code is same with Tutorial,but the program don't work? I got an error "Entity Command Excution Exception" at this line: var genres = storeDB.Genres.ToList();
Im trying to add a database to the project, and he following error appears. (Im using VB2008)
Local database file
A network-related or intance-specific error occured while establishing a connection to sql express.
The server was not found or was no accessible. Verify that the instance name is correct and that SQL server is configured to allow remote connections. (provider: Shared Memory Provider, error 40- Could not open a connection to SQL server.
i have using sql server 2005 express managment studio, i have create my database and every thing just i want to extact Database and attach it to My asp.net 3.5 Project how?
View 1 Replies