I am using SQL Server 2005 and i have a application that using FoxPro.
Can I load the data into SQL Server's table from FoxPro? if yes, i would like schedule this job daily, can i write it in Store Procedure and run daily in special time?
I need to write a code in asp.net that pick xml file and load it's content into sql table. How it can be done?Which way is better, to create the table dynamically every time I pick an xml and after I done with it to delete it.. or to create the table manually once, and just fill it and truncate it during doing the job?
View 5 RepliesI need to query two table from different databases residing on two different servers.
Scenario:
1st Server : Abc
Database: DB1
Table: Accounts
2nd Server: Xyz
Database: DB2
Table: Clients
The common linking information between Clients and Accounts is "email_id". I'm sure a lot you are saying why am I not maintaining both tables on single server but there is a lot going on behind scenes and if I move tables, I'll have to modify many dependent web pages.
I would like to create a gridview where all of the items in one table are listed and a checkbox is checked if that item also shows up in another table. The difficulty comes in the fact that table are not only in different databases, but possibly on different servers.
Is there any way to do this via ASP.NET connection strings, so that it doesn't matter where the databases live? I'd rather use connection strings, because I don't want to hard-code credentials into the queries (OPENROWSET or whatnot).
We are using Two servers for our application managed by a load balancer. One of which server contains Windows server 2003 & other one contains Windows server 2008. When a request is served by windows 2003 server and its subsequent goes to the other one (2008 server). Users gets log out. Are we need same Operating systems on both systems because( when request served by 2008, and subsequent on 2003 is served without any issue).
View 1 RepliesI have two PCs with Windows Server 2003 standard adition installed on them, each are in a saperte room, and having SQL Server 2005 Express. Now I want to let Myserver to connect to server1 with a readonly access to a database on it. I figured to create a user acount on server1, and make it as a login account in SQL Server and grant the appropreate privilage. Now I'm wandering are there any security risks regarding this approch.
View 1 RepliesWe host a SaaS application on 4 windows 2008 servers loadbalancer via a LVS. We use infragistics and Ajax Control Toolkit on several pages, one page represents a list of people using a Web Datagrid, each time a person is clicked in the list, an Ultra Web Tab component is updated at the botom of the page with detailed information on that person. After a certain amount of clics on different people (number of clics can be between 1 and 5) Scriptresource.axd craches with the following error :
[Code]....
I don't get this error when I run my application on one server using the server's private IP adress. I tried to synchronize the dates of the dlls System.Web and System.Web.Extensions on each server, I still get the same error.
We have 2 asp.net web servers working through the LoadBalancer that are accessible externally. Earlier, for all applications we did logging into DB. Now we have 1 more app that doesn't work with DB, it is used for 'messages transferring'. On TEST environment it does logging into files into a local folder.
If we deploy it "as is" to PROD we will have 2 separate log files... that is not very good idea. Connecting to DB just for logging doesn't seem reasonable too...
Possible solution could be store log file into a shared folder somewhere on another server.
C:Program FilesMicrosoft SQL Server100COM>tablediff -sourceserver "warehousebox"
-sourcedatabase "table1" -sourcetable "siqvirtual" -destinationserver "mainbox" -de
stinationdatabase "table1" -destinationtable "siqvirtual" -destinationuser "sarah"
-destinationpassword "hello" -strict -f "c:fooDiff.sql"
Since these table are on two different boxes and 2 different versions, I am getting error message that tables cant be compared because they have different schema's.Schema's are the same but they are on different machines and different servers. What is a work around it?
Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
May you tell me how can I transfer data from a table to another table, the condition of non-repetition rows
as a procedure in database MS QSL server 2005 ,Works in the first day of the month I use the first table in the prodation environment it is contain the employee data and the second to update first table only
I have come from MS Access and am working through a couple of textbooks on ASP.NET 4. I am using the Gridview control connected to an SQL data source control.
As an exercise I am converting my simpliest MS Access page which is simple a form to request a new stock item in our engineering stores. I have a normalised table called [stock_requests] and part of this is a field calle [failure_mode]. This field is an integer and there is another table listing the possible values for this field.
This other table is called [failure_modes] and has two field:
[id] < the primary key
[mode] < the text to be displayed
In my main table [stock_requests] in the field [failure_mode] I store the [id] from the [failure_modes] table for the applicable record in the [failure_modes] table. So for example if someone wanted to select "Catastrophic" as the failure mode the [stock_requests].[failure_mode] field would be 1; if the user selected "Gradual" as the failure mode the [stock_requests].[failure_mode] field would be 2 etc.
Now, the gridview wants to display "1" or "2" but I want to display "gradual" or "catastrophic" without using views and all the headaches that brings. I have managed to sort out editting by using a templated field where I have a drop down list in this cell and I databind to a second SQL data source (imaginatively called SqlDataSource2).
what is the best method for displaying the text 'Catastophic' or 'Gradual' etc. when in normal mode (view mode)? Is it another templated field and what is the basic approach I should use? I reckon I should be able to work it out once someone points me in the right direction.
I am binding same data Table to Combo box and List Box on the WindowsForm Load.
When I select a value in Combo box automatically that value is also getting selected in List Box and same thing when I select a value in List Box that value is also getting selected in Combo Box.
Selection should be only for that particular control, how can I achieve this ?
ServerName.Database.dbo.TableIn above convention can we use IP address instead of ServerName?
View 1 Replieshow to check performance of sql server query with load ,also wants to create load by any tolls like load runner,if any url for download load runner or any other tolls by which we can create load please give me some idea related to it.
View 1 Replieshow to load the data from excell sheet to sql server.. that is i have data in excell sheet with four columns..
so i am trying to create sam four columns in sql server table..
then how to trsnfer the data from excell to sqlserver?
Cannot load linq-sql Data Context Type Error
[Code]....
I am trying to set up my web site on a stand alone server using Windows Server 2003 with IIS 6 which will access SQL server database (2008) on windows 2008 R2 server (also not in the domain) I am using form authentication and I have configured a custom identity account in IIS6. The local account is on both servers with same password and I have registered the account using aspnet_regiis.exe -ga The application pool in my iis6 has the custom local account set as the identity and my web.config file has the appropriate tags in the system.web element <identity impersonate="true" />
The problem is the local account does not seem to get passed to the sql server. Right now my iis settings are anonymous access (using the local acct vs isr) and no authentication specified under that - I did try Integrated and basic but it prompts for the username and password which I do not want. One article I read stated this: windows authentication does not support delegation (passing credentials from one server to another) and is limited to the one hop rule, only a primary token can be passed to a second server. windows
authentication on iis (all versions) gives the thread a secondary(impersonation) token which can not be used to access any network resouce
I have a datasource (quite heavy to run) and a Gridview on the page.
By default when the page is loaded the datasource and Gridview bind and display. However since the datasource is heavy I want on page load these 2 will not bind.
I want them to bind only on a button click. How to stop the datasource and Gridview from binding on 1st page load ?
how can I get data from more than one table using sqldatasource,,, am trying the following code but i get error "Invalid column name 'Category_tbl.CategoryI"
[Code]....
am trying to get data from more than one table but I think I have an error in the syntax plz anyone can help methis is the code
[Code]....
I have a small problem I want to fetch some data from sql table. Table looks like as
sno acno amnout cash
1 A-100 5000 withdrawal
2 A-101 7000 Deposit
3 A-100 8000 Deposit
4 A-101 6000 Deposit
5 A-101 1000 withdrawal
And i want to records something like this:
acno Deposit withdrawal
A-100 8000 5000
A-101 13000 1000
I have a big problem, some how i changed the CreateNewBoundFile, because the heading were mispell (Qrt instead of Qtr. I only changed the BOLD part.
strQuery = "SELECT [Industry Title] AS Industry_Title, [Area Name] AS Area_Name, [Year], [Ownership Title] AS Ownership_Title, [Ownership Code] AS Ownership_Code, [NAICS Code] AS NAICS_Code, [Qrt 1 Disclosure] AS Qrt_1_Disclosure, [Qtr 2 Disclosure] AS Qrt_2_Disclosure,
[Qtr 3 Disclosure] AS Qrt_3_Disclosure, [Qtr 4 Disclosure] AS Qrt_4_Disclosure, [Annual Disclosure] AS Annual_Disclosure"
vArea = Context.Items("Area")
vYear = Context.Items("Year")
vAggLevel = Context.Items("AggLevel")
vIndustry = Context.Items("Industry")
vOwnership = Context.Items("Ownership")
strQuery = strQuery & ", [Qrt 1 Establishments] AS Qrt_1_Establishments, [Qtr 2 Establishments] AS Qtr_2_Establishments, [Qtr 3 Establishments] AS Qtr_3_Establishments, [Qtr 4 Establishments] AS Qtr_4_Establishments"
strQuery = strQuery & ", [Annual Establishments] AS Annual_Establishments"
strQuery = strQuery & ", [Jan], [Feb], [Mar], [April], [May], [June], [July], [Aug], [Sept], [Oct], [Nov], [Dec]"
strQuery = strQuery & ", [Annual Avg Emp] AS Annual_Avg_Emp"
strQuery = strQuery & ", [Qrt 1 Wages] AS Qrt_1_Wages, [Qrt 1 Taxable] AS Qrt_1_Taxable, [Qrt 1 Avg wk wage] AS Qrt_1_Avg_wk_wage, [Qtr 2 Wages] AS Qtr_2_Wages, [Qtr 2 Taxable] AS Qtr_2_Taxable, [Qtr 2 Avg wk wage] AS Qtr_2_Avg_wk_wage, [Qtr 3 Wages]
AS Qtr_3_Wages, [Qtr 3 Taxable] AS Qtr_3_Taxable, [Qtr 3 Avg wk wage] AS Qtr_3_Avg_wk_wage, [Qtr 4 Wages] AS Qtr_4_Wages, [Qtr 4 Taxable] AS Qtr_4_Taxable, [Qtr 4 Avg wk wage] AS Qtr_4_Avg_wk_wage"
strQuery = strQuery & ", [Total Annual Wages] AS Total_Annual_Wages, [Taxable Annual] AS Taxable_Annual, [Avg wk wage] AS Avg_wk_wage, [Avg Annual Pay] AS Avg_Annual_Pay"
strQuery = strQuery & " FROM [vQCEWHIST]"
CreateNewBoundField("Qrt_1_Disclosure", "Qrt_1 Disclosure", False)
CreateNewBoundField("Qrt_2_Disclosure", "Qrt_2 Disclosure", False)
CreateNewBoundField("Qrt_3_Disclosure", "Qrt_3 Disclosure", False)
CreateNewBoundField("Qrt_4_Disclosure", "Qrt_4 Disclosure", False)
CreateNewBoundField("Annual_Disclosure", "Annual Disclosure", False)
Because of the mis spell Qrt, so i change it to Qtr.
CreateNewBoundField("Qrt_1_Disclosure", "Qtr_1 Disclosure", False)
CreateNewBoundField("Qrt_2_Disclosure", "Qtr_2 Disclosure", False)
CreateNewBoundField("Qrt_3_Disclosure", "Qtr_3 Disclosure", False)
CreateNewBoundField("Qrt_4_Disclosure", "Qtr_4 Disclosure", False)
CreateNewBoundField("Annual_Disclosure", "Annual Disclosure", False)
After i changed it, when going to SQL server express, looking at the original table, some how most of the data were changed to 0 and 1, some of them still stay the same, but most of it has been changed to 0 or 1.
I am building an app (ASP.NET 3.5 + SQL 2005) that allow users to schedule meetings and these meeting will show in the users to-do list.
One kind of meeting, when scheduled, should show into ALL users to-do list.
I have 3 tables:
#1 - Users -> UserID
#2 - Meetings -> MeetingID
#3 - Member_Meeting -> UserID+MeetingID
What I need is:
Based on the scheduled meeting, read all users from table #1 and add their info in the table # 3 with the MeetingID (which I can get from the UI, because it will happen when they create the meeting).
I have been browsing about it, but so far, I couldn't find a good source of info to start with.
I have two tables cust and order_cust cust table have cust_id, name, addr, zip columns and order_cust have order_id and cust_id columns I take input from user for cust table i.e. name, addr, zip... the cust_id is an IDENTITY column so generates the value automatically Now I want to insert the last generated cust_id into order_cust (order_id is also an IDENTITY column)
How can I achieve that using stored procedure?