I already have an existing sdf file that is used in a windows application by looking at the current programs folder to find it. I want to use this same database (a copy of it) on an ASP .Net website so won't be hosted in a sql server anywhere want's to be accessed directly, is this possible?
View 1 RepliesI am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?
My Application uses two SQL databses, one for membership/roles (ASPNETDB.MDF) the other for my data. When deploying to a server do I have to use two connection strings, one for each database? I am using the publish to provider wizard with VWD 2008 to replicate the databases on Sqlserver 2008 (Windows server 2008 R2). I have my data connection working fine, I am just trying to get mebership and roles working.
View 3 RepliesIs ther any way for this.
View 2 RepliesI am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
In my asp.net application im using Oracle client. In the connection string, we specify the 3 basic attributes: data source, User Id, and Password. We are using connection pooling. Our data resides in 2 different Oracle schemas. Most of the requests are for data from both Schema1 and Schema2.
Is it possible that the connections are implicitly tied to a schema1 or schema2?
I am new to the asp.net, I am going to create a website which needs to talk to oracle database(i only need get the data only) which is in client place.
I want to know what do i need to do this (what are the requirements)
What i have is Client IP, DB name, Username and Password.
I have asp.net2005 on my system with sql server.
how can i access an AS/400 Database/Table in ASP.net website.I thought i would add something like this in web.config, but it does not work.
<connectionStrings>
<add name="AS400" connectionString="Driver={Client Access ODBC Driver (32-bit)};SERVER=IP Address; USER=usr; PASSWORD=pwd; "/> [code].....
The problem i have would be im getting - 'System.Data.SqlClient.SqlException: Login failed for user 'discountb1'.' error message. my connection string in ASP was the following
"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=CIServer12; DATABASE=BathroomBitsb1; UID=discountb1;PASSWORD=******; OPTION=3"
now just for my simple asp.net page i'm using the following
Code]....
i believe i have done everything right, but its obviously not the case.
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
I have an asp.net website that needs to connect to a dBase file on a remote server. The remote server has a ODBC System DSN connection configured but I have no idea how to connect to it.
View 1 RepliesI am trying to conect to my SQL Server 2008 instance from application in Visual studio unsuccessfully.
This how my Instance appears in SSMS
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Below is an example of a connection string from the book I am following which works if you have SQLExpress on your localhost domain.
I am using SQL Server Enterprise My Server name is DETERMIN (computer) . When I am in SSMS this is how my instance node appears
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Determin is the name of my computer I think its the name of my instance as well not sure, balloonshop is my login. How can I substitute the names properly for the connection string below in order to connect to my instance
[Code]....
[Code]....
When i compile my vs2008 solution which is a web application in debug mode i keep getting message box displayed which says that it cannot connect "whatever.designer.cs". Can
View 2 Repliesi like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..
View 5 RepliesI need a code which can export the data from XML file to the Excel file.
View 3 Replieswriting in .dbf , as following is my code with this error :
[ ERROR [07002] [Microsoft][ODBC dBase Driver] Too few parameters. Expected 3 ]
SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=test;Integrated Security=True");
SqlDataAdapter da = new SqlDataAdapter("select * from test", cn);
DataSet ds = new DataSet();
da.Fill(ds, "test");
string odbccon = "Dsn=TEST.DBF;dbq=E:\FOX;defaultdir=E:\FOX;driverid=533;fil=dBase 5.0;maxbuffersize=2048;pagetimeout=5";
OdbcConnection connection = new OdbcConnection(odbccon);
connection.Open();
OdbcCommand createCommand = connection.CreateCommand();
createCommand.CommandText = "CREATE TABLE test (ID int, name varchar(50),last_name varchar(50))";
createCommand.ExecuteNonQuery();
OdbcCommand insertCommand = connection.CreateCommand();
insertCommand.CommandText = "INSERT INTO test (ID,name,last_name) VALUES (@pID,@pname,@plast_name)";
foreach (DataRow dr in ds.Tables["test"].Rows)
{
int id = int.Parse(dr["ID"].ToString());
string name = dr["name"].ToString();
string last_name = dr["last_name"].ToString();
insertCommand.Parameters.Add(new OdbcParameter("@pID", id));
insertCommand.Parameters.Add(new OdbcParameter("@pname",name));
insertCommand.Parameters.Add(new OdbcParameter("@plast_name",last_name));
insertCommand.ExecuteNonQuery();
}
I have .db file,now i want to view content behind that,can you give me solution to read .db file.
View 1 Repliesinsert the csv file fields into sql server database..how will do it.what will be the code for that...
View 5 RepliesI have tab delimited .xls file. I want read this to a dataset. Oledb connection string is given below. But i'm getting one error on objConn.Open();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0";
OleDbConnection objConn = new OleDbConnection(strConn);
objConn.Open();
Error : External table is not in the expected format.
How can i read tab delimited .xls file to a dataset using oledb connection?
i am working on a project and i have the data in a .csv file.
i want to know how can i retrive data from the .csv file? which control should i use that would have that function?
I want to upload csv file and import the data into sql. but I cant do the import thing. The file is uploaded but it cannot be imported into sql. This is my code. Hope that someone can tell me what is the problem.
[Code]....
We have an MVC application where we have put an excell loader. It works fine in the VS studio environment but on the IIS (64 bit) we get an error message .->
Microsoft.ACE.OLEDB.12.0 provider is not registrated on the local machine.The excell (2010) is 32 bit, but the IIS is 64 bit. Here the code
[Code]....
I expect that the export file will be backup.sql mysqldump --tables -u db_user_name -p db_name >> backup.sql Furthermore, is there any example for that we insert one record with one image file (from the local disk), to the DB table?
View 3 RepliesIm importing a simple data set using sql loader, below is the controll file im using...The field named 'CustName' imports all the records but surround them in the oracle table with single quotes ... eg 'Dave' .. not Dave.. how can i alter the control file to remove these sinngle quotes when the data is imported...The field named 'registered' contains data as 'true' or 'false' in the csv... i need to import this into oracle as 1 for true and 0 for false... how can i alter the control file to do this?
my control file is as follows:
OPTIONS (ERRORS=999)
LOAD DATA
INFILE "c: est.csv"
BADFILE "c: est.bad"
INSERT
INTO TABLE test
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
Not sure how to best accomplish this task. I do have several reports to make in Excel every day. The reports do have a shhet for every week and one column for each day in week. What is the best way to get the excel auto update and get data from the SQL table? As for now I run a query on a webpage and coying the data in to the excel sheet manually. Should I try making a database connection within the excel sheet? Should I try having a ADO connection working in .NET? I really donīt know where to begin.
View 2 Replies