I have a .net web application (framework 2.o) and SQL Server 2005 as my backend. I need to design an application which fetches a particular unique pin number to a customer and then mark this record as used. The problem I face is as the no of concurrent users are more , same pin number is getting allotted to multiple users.
View 3 RepliesIs there any way i connnect a Access 2007 database from SQL Server stored procedure using oledb connection so that i can copy some records from that database?I am asked to achieve this through stored procedure only without using DTS or SSIS.
View 7 RepliesI used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 Repliesi had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
View 2 RepliesMy asp.net 2.0 is deployed in web hosting.. now here in my server i have configure a static ip.. so how to access my ms sql database all over the world.. i need to know is that i need to write directly connection string in a webconfig of my static ip.. or i need to create a instance of my static ip to ms sql server 2005 to access the database..
View 7 RepliesFor a while I've used shopping cart software in classic ASP that could use Access database or MS SQL Server.
I am now using a asp.net shopping cart application by the same company
[URL]
However this program only supports MS SQL Server and not Access.
Would it be possible to export the SQL Server as an Access database (I've moved Access databases to MS SQL, so why not the other way)? Is there a way to support stored procedures in Access, and if not, any workarounds in ASP.net?
I ve an issue of uploading an .xls file to the server and picking it from server and loading the record to a table in the datatbase from the server. The code works on the application system but after publishing it i ve an error that read Could not find a part of the path 'C:inetpubwwwrootEngineDbUploads634207083546865207.xls'. please can any one put me through on how to sort this out. below is the code
protected void btnUpload_Click(object sender, EventArgs e) { string FileName = FileUpload1.PostedFile.FileName;
string saveDir = @""; string appPath = Request.ApplicationPath; string savePath = appPath + saveDir + Server.HtmlEncode(FileUpload1.FileName); String fileExtension = string.Empty; String path = Server.MapPath("~/Uploads/"); //try //{ //
The Files is not supported.You can only upload .xls Files format."; //} } //check if Files to be uploaded is with the extenstion name
xls. bool CheckFilesType(string FileName) { return Path.GetExtension(FileName).ToLower() == ".xls"; }
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) 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)
View 1 RepliesI want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
Im using enterprise Manager data access code block and have a table in sql server 2005 with a column type of 'bigint'
when querying against this table and adding in a parameter, there isnt a long datatype available, so is Int32 an equivalent ?
[Code].....
the idea id I need to send data to the client to the server to inform the server of some events at the client, and i need to send data from server to the client to inform the client of some results on the server. now from client to server is easy I use xhr easy enough. and to send data from server to client I thought of using long polling in xhr so to test I wrote the following code:
[code]
<!-- Test.aspx -->
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test.aspx.cs" Inherits="Test" %>
the difference between SQL Server 2000 and SQL Server 2005 features.
View 3 Repliesthe main difference between sql server 2005 and 2008 in interview point of view?
View 2 Replieswhat would be the user name and password of http://localhost/Reports to access SERVER 2005 Reporting service
View 7 RepliesI need help making selections on my installation of SQL Server 2005 Developer Edition onto my Laptop (the only computer in my house). I need to develop a couple of different databases and use them from my Visual Studio applications. Then I will upload the SQL databases and the Web Applications to GoDaddy for deployment to general public.My question is that installation is asking me questions I honestly don't know how to answer because I am using a different SQL this time around after reformatting my hard drive"
1. Do I use Default or Named Instance?2. Do I use the Built-In System account or a Domain User account?3. If answer 2 is Domain User then I am in trouble because I don't think I have a Domain, and I don't know what one is. Where would I find the user name, the password, and the domain?
Migrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 RepliesPrevious developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
How can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesDoes anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 RepliesCould anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below. sql server 2000 features | Extra features added/supported in 2005 | Extra features supported in 2008
View 2 Replies assist me rectifying the error in following sql stored procedure?
Sql Query:- [Code]....
I have created the above Stored Procedure for inserting datas into any table but while I execute the above proceedure its throwing some error.
I am using Sql Server 2005,My table structure is below.
Create Table ComentTable(id int,coments varchar(4000))
insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')
insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')
how to write storeprocedure update coments column replace %27 to '
I have one asp.net 2.0 application with MS Sql 2005 database.. As i deploy this database with client Machine.. now what i need is i need to take a backup of MS Sql 2004 database.. so is that any free tool is available which take daily backup...
View 16 RepliesI have created my database in SQL Server 2005 Enterprise Edition and now planning to tranfer this databse to another server, But this other server is SQL Server Standard Edition, So if i try to attach my database which is created in Enterprise Edition will get sucesully connected to Standard Version ? or i will get any error message or i am doing something wrong ? This situation is fine or Version should be kept same ?
View 2 Replies