ALTER procedure [dbo].[AHD_EmpID_GET]
as
begin declare @User varchar
declare @empid varchardeclare @Pword varchar
select E.EmpID as Code, E.Empcode as Description
from AHD_glb_Employees E
inner join AHD_users U on E.empid=U.empid
--where E.Empid=@empid
end
i have tried this but it is not getting a unique value...........
can u help me pls??
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
Hey,
don't know if it's the right place for this question but i hope you help me.
I made an application with VS 2005 that connecting to sql server file db.mdf
Now i want this application work on another user computer, and of course i don't want to install vs 2005 there.
I did install .net framework, but what i need to do to make the database work? do i have to install sql server on his computer? or is there something more simple?
I know that if i was using access file than i need to install nothing else.
please help!
thanx.
max
I've got an application that needs to:1. Look on the user's machine and locate a file2. Pull that file over to DTS3. Allow DTS to insert this file into a table
I'm sure this can be done....anyone got any article on how to do it?
Thanks!
Hi
I have created a Visual Basic application the connects to my SQL database.
The appliction lets a user click on a button, data is retrieved from the database
and then formatted in Excel. Everything works fine on my machine (this is probably
because i have both VB and SQL installed on my machine)
I have created a .exe and deployed the application on some users desktops. The
problem is that when they click on a button - nothing happens. I dont even get any
error messages! Everything else appears to be fine. I have tested the DSNs and
they appear to be fine too.
Does anyone know why this would happen ??
Thanks, Ruaidhri.
hI,
EVERY ONE.
1)IF I EXECUTE QUERY FROM QUERY ANAL , QUERY & STORE PROC RUN VERY FINE , BUT SAME REPORT IF I DO FROM FRONT END(i.e from web application tool) THEN IT TAKE VERY LONG TIME.WHAT COULD BE THE REASON ?
2) IF I REBOOT MACHINE - SQL SERVER. THEN FROM FRONT END if I RUN ANY REPORT THEN IT WORK FAST BUT NOT same AS OF QUERY ANALY .I DON'T UNDERSTAND THIS .
PLEASE ANY ONE HAS COME ACORSS THIS PROBLEM & HAVE ANY SUGGECTION PLEASE REPLY ME
THANKS
NIRMAL
Whenever a user logs on to SQL-Server there´s
a message in the application log of windows NT
like
"Login succeeded for user 'Domainusername'. Connection: Trusted."
Since we have lots of users. The application log fills up twice a day.
Is there any way to prevent SQL-Server from doing this ?
(I know that there are settings in the event-viewer which clear events
whenever space is needed).
Thanks.
Event Viewer log error "Application log is full". Please any suggestions on how to handle this. THanks
View 1 Replies View Relatedi hv developed an application in vb.net, database is in server and more than 50 PCs i have installed my application. Is this the correct procedure, or else i hv to install it on the server and get the shortcut file in all the PCs.because if suppose i want to send a new patch file that time iam going to uninstall my application in all the PCs and installing it again. It takes time.
if i install this in server and create shortcut on every client pc, then how should i management variables value while coding. Please do let me know. thanks for your help
I'm not sure if this is the right section for the question, but here goes...
I have an application that needs to be run in network client mode. This app is supposed to connect to a SQL 2005 db hosted on a server. As I procede through the installation process I get a prompt when i populate the serverdb information.
'The listener port was responsice, but did not return a primary port number for <servername>. Please verify that <servername> is a valid and running database before proceeding.
A little background is in order:
Host:
Server 2003 Standard
SQL Server 2005
Installed instance of said db
Client:
Windows XP Pro sp2
Network config:
We have a domain with about 125 workstationslaptops. Windows firewall is turned off using a group policy (makes it easier to push apps out to clients). For giggles I made exceptions to the 'turned off' firewall policies for the needed ports etc. This was done on both the host server and the client.
Thank you in advance.
is it possible to call a SQL job from an ASP.NET application? if so, how? I'm using VS.net2003 and am programming in C#I've been searching for a while, but haven't found anything. It doesn't help that one of my keywords when searching is "job(s)."
View 1 Replies View Relatedi created a asp.net application using sql server. it retrieve data from a sql server and shows it in the form. it uses textbox control to show it. i wanna update it or add a new item in database. i wrote the code for it under update and add buttons. when i click on the update button after changing a data in textbox, the page is getting refreshed nad comign back to initial state without getting updated. but when i change the textbox1.text with a string in the code, its getting updated with string without any problem. even same problem for addition too, am using a dataadapeter and dataset for this. when i assign a string to the datset columns, its getting updated well but wheni assign it with textbox.text.tostring, nothing is happenig to database. can anyone help me in this issue, why the data was not sent to the datbase and the page is getting refreshed.. plz need help.. its urgent
View 1 Replies View RelatedBelow is a stored procedure i want to implement. However i am getting errors.
Please read and see if u can correct me.
Thanks
Gareth
Create Procedure UpdateFile
@Filename Varchar(255),
@imgContent Image,
@imgContentType Varchar(max),
@Description Varchar(255),
@RtnDate Datetime,
@UserID Varchar(50)
As
Select UserID from Fileshare
If @UserID = UserID
Begin
UPDATE Fileshare
SET imgContent = @imgContent, imgContentType = @imgContentType, Userid = @UserID, Description = @Description, RtnDate = @RtnDate, FileLock = 0, LockedBy = ''
WHERE Filename = @Filename
-- If the parameter and current value dont match, an error
-- Is raised which i will need to deal with in my app.
--Error message so (without entering anything for the returned error so far is
--Msg 102, Level 15, State 1, Procedure UpdateFile, Line 19
--Incorrect syntax near '@Filename'.
Hai All ,
Iam having the one Application in DotNet2005.But iam using the two database(SqlServer2005).If user's login the application it will check credentials in first database, if he is not having the login credentials it will cheek the second Database. How can I handle in the configuration file?. How can I change the connection string depending upon the Database in my application for database operation (like insert and update).Any one kindly provide the solution.Thanks and regards,sureshK
Dear All,Finally I completed my project. Thanks all you helped me to do it.Now I have the biggest problem. In my application the Data grid is filled with Data from SQL server table which has large number of records. When I run my queries in SS Management Studio it runs very fast. To fill data to datagrid it takes lots of time. How can I reduce this time. How can I increase the performance of my Application.Thanks,Janaka
View 4 Replies View RelatedImports System.Data.SqlClientImports System.DataImports Microsoft.SqlServerPartial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Protected Sub TextBox3_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox3.TextChanged End Sub Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting End Sub Protected Sub Save_Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Save_Button1.Click Dim conn As New SqlConnection() conn.ConnectionString = Data Source=REDSTONE;Persist Security Info=True;User ID=******;Password=******;Unicode=True End SubEnd Class
End of statement expected. C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
'System.Data' is a namespace and cannot be used as an expression. C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
Hi, I am using ASP.Net 2005 with C# language and SQL SERVER 2005...
I am developing an web based application and have to deploy it on server.
I need to prevent my site from the SQL Injection and have to use some algorithms.
What is the best technique or method (Algorithm) in .Net ?
Give some measures to prevent from Hackers.
I am geeting following error while trying to acquire db connection. I use sql server ce2.0 with vs2005
Failed to find or load the registered .Net Framework Data Provider
Hi All,
I have problem in calling the SP from ASP.NET application
@DefApp nvarchar(255)= '' ,@DefBusFunction nvarchar(255)= '' ,@DefImpact nvarchar(255) = '',AS Begin declare @sql nvarchar(4000)declare @whereClause nvarchar(4000)DECLARE @return_value intdeclare @sqlWhere nvarchar(4000) select @sql = 'SELECT DefApp, DefBusFunction, DefImpact FROM Def LEFT JOIN ZFunction ON (def.DefApp = ZFunction.App) AND (Def.DefBusFunction = ZFunction.BusFunction)' if @DefImpact <> '' Set @whereClause = ' where DefImpact ' SET @whereClause = @whereClause + ' = ''' + @DefImpact + '''' set @sqlWhere=@sql + @WhereClauseEXEC @sqlWhereEnd
and i am calling this SP from my ASP.net application to fill the SSRS report. I have written code in ASP.NET like:
sqlCmd = new SqlCommand("subbusample", conn);
sqlCmd.CommandType = CommandType.StoredProcedure;sqlCmd.Parameters.Add(new SqlParameter("@DefImpact", SqlDbType.NVarChar, 255, txtValue3.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter("@DefBusFunction", SqlDbType.NVarChar, 255, txtValue1.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter("@DefApp", SqlDbType.NVarChar, 255, txtValue2.Text.ToString()));
RptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
RptViewer.ServerReport.ReportServerUrl = new System.Uri("http://servername/ReportServer");RptViewer.ShowParameterPrompts = false;
RptViewer.ServerReport.ReportPath = "/folder name/Subbu_Sample";
when i execute it, i am not able to fill the report with data.
Please let me know what i am doing wrong.
Thanks,
SR.
Hi there
Can anyone point me to a good tutorial or give me a run down on using Sql Application roles from my asp.net application. Books Online only give a run down on how to set it up - not how to implement or use it from my code. MSDN no help. Google - same thing.
Any help greatly appreciated.
Thanks in advance
Is there a way to connect to a sql db and read the databases and write them to a webpage? Then is there a way to view the tables in a selected database on a webpage?
I'm trying to make a web based enterprise manager.
Hi,
please i have a problem, i can't execute my asp.net application with IIS 5.0?
i have a message indicating that MYSERVERASPNET can't connect, and that arrive when trying connect to the database under SQL Server 2000.
you have to know that my application work very well with webserver of WebMatrix.
Web Matrix Project : version 0.6
.Net Framework 1.1
Thank you.
I regularly get the message : application log is full. I cleared event viewer's log file but it didn't help.
What is this message about?
Thanks in advance,
Asnate
hi
I have completed a windows db app.
I have saved the db files in the application/bin/ folder.
The connectionstring that i am using is
Code:
sql
Server =(local);Data Source=.SQLEXPRESS;DataBase=;Integrated Security=SSPI
say i wanted to install this app on my home computer, does not have sql express or anything installed.
Now i want to use the application and it must read/write data from the sql db that was saved in the application/bin/ folder.
what is the connectionstring then ?
can anyone please help ?
what im trying to say is that the application must work independent from any SQL manager/express etc.
is that possible ?
Hello,
For my application, I need to consult a database located on a server on the local network. The application is located on my pc. I use the connection string
Code:
"Integrated Security = SSPI;database=dbName;data source=serverName"
(I program in C# and connect with ADO.NET)
When I compile my project as a windows application, this works fine. But when I compile as a web application in ASP.NET and try the same connection, it won't connect. How can this be solved?
Thanks
Hi everybody,
Here the environment is application in 3 layers.
So the user in his client machine, access the application in an application server that sends the request to my sql server database server.
My problem is: when I run sp_who from Query Analyzer, I see the host name that is pre-defined inside code application. But, actually, I need to know the user who is requesting the transactio so I can know right the person who is slowing my database performance....
Do you know, any function, procedure or anything else that I can use in the application code in order to provide the user or the host name from the client machine?????
I hope some answers...
Thank you all,
I am confused . What is considered an application and how SQL would know ?
If I have a web site accessing SQL VIA IIS will SQL Server treat it as an application ? How about MS Excel ?
Also , If I was to use the application of Power builder , using app role , how do control which user can use the app ?
Thanks
Hello Friends,
A user is calling stating that their application is hung - sitting with an hour glass or with the browser not responding. Assume you know the server and the instance and that the server supports multiple instances.
You need to determine if the database could be contributing to the problem or could be the cause of the problem. Describe at a high level what process you would follow to rule the database out or in as the problem.
Any idea!
Thanks,
Frank
Good day,
I have a trigger that fires on insert of a record to the table. What I need to do as well is then fire a VB.NET application, but in the process pass the values that have just been inserted into the table to the VB.net program and use those to perform some functions there in.
Is this at all possible?
Please can someone advise.
Thanks
Can anyone tell me how to empty the Application log ,as I keep getting Application is Full message on the SQL box.
Many thanks
Z
Hello everybody,
I'm a new commer. I'm happy to join dbForum with all of you. :beer:
I'm coding a DTS application for my company's data mart. And it's the first time I code a data movement application in .NET. I use SQL2000sp2 Personal Edition for datawarehouse and WinXPsp Professional.
I have looked around the site http://www.sqldts.com/default.aspx?225 and regst.txt in the SQL-CD to reference DTS.dlls as below:
INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)
---------------------------------------------------------
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll
Example: regsvr32 80ToolsBinndtsffile.dll
The sqlunirl.dll file should reside in the system folder (i.e., winntsystem32 or windowssystem).
I added other dll references successfully but sqlunirl.dll. And I recieve the err:
"C:WINDOWSsystem32sqlunirl.dll" was loaded, but the DllRegisterServer entry point was not found. This file can not be registered." :eek:
As I run my application, it also fire an unhandled exception like this:
"Unable to cast COM object of type 'System.__ComObject' to Interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call the COM component for the Interface with IID
'{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT:0x80004002(E_NOINTERFACE))" :o
And here is the Err details:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
at DTS.Task.get_CustomTask()
at myDTSForNet.Form1.addDataPumpTask(String taskId, String taskName, String sql, String desTable) in E:DATAKmy264myDTSForNetmyDTSForNetForm1.vb:li ne 81
at myDTSForNet.Form1.cmdDoDTS_Click(Object sender, EventArgs e) in E:DATAKmy264myDTSForNetmyDTSForNetForm1.vb:li ne 26
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
myDTSForNet
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///E:/DATA/Kmy264/myDTSForNet/myDTSForNet/bin/Debug/myDTSForNet.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
Interop.DTS
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///E:/DATA/Kmy264/myDTSForNet/myDTSForNet/bin/Debug/Interop.DTS.DLL
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Please help me to solve the problem. Thanks alot. :rolleyes:
best reguard,
khanhmy
We are rolling out mssqlxpress to our development staff and would prefer to alter their permissions so that they can only make changes using mssqlxpress (since it integrates nicely with VSS).
So are choices are to uninstall SQL Enterprise Manager and SQL Query Analyzer, or more preferably, alter their NT Permissions so that they do not have the capability to change anything in the DB's.
My concern is that it seems we can only set their permissions from DB level and not the application, does that sound correct? Has anyone else had to deal with this predicament and is there an alternative to uninstalling the SQL Client tools?
Please correct me if I'm wrong, but isn't it bad parctice to place multiple applications in the sam db. My SA wants me to use the same db for all of the apps I develop and then just name the tables accordingly. Can someone please give more insight on why this is bad, and my chances for doing it right the first time will be better. Thanks.
View 3 Replies View Related