Application To SQL Db

Mar 3, 2007

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.

View 3 Replies


ADVERTISEMENT

Distrib.exe Application Error , Application Failed To Initialize Properly(0xx0000142)

Apr 13, 2008

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

View 1 Replies View Related

What I Need To Run Compiled Application On Another Application?

Sep 11, 2007



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

View 4 Replies View Related

My Asp.net Web Application

Feb 27, 2008

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??
 
 

View 3 Replies View Related

ASP.NET Application To Use DTS

Aug 3, 2005

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!

View 1 Replies View Related

VB Application

Jan 19, 2001

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.

View 2 Replies View Related

SQL WITH WEB APPLICATION

Jun 16, 2000

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

View 1 Replies View Related

SQL 7.0 And NT Application Log

Apr 12, 1999

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.

View 2 Replies View Related

Application Log

Nov 9, 2001

Event Viewer log error "Application log is full". Please any suggestions on how to handle this. THanks

View 1 Replies View Related

Vb.net Application

Jun 26, 2007

i 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

View 1 Replies View Related

Call SQL Job In ASP.NET Application

Jun 27, 2006

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 Related

Regarding Update In Asp.net Application

Oct 2, 2006

i 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 Related

SQL Problems With C#.Net Application

Mar 10, 2007

Below 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'.
 

View 5 Replies View Related

One Application With 2 DataBase

Aug 6, 2007

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 
 

View 7 Replies View Related

Application Is Very Slow

Oct 7, 2007

 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 Related

Im Trying To Run A Application And Getting Following Errors

Nov 17, 2007

Imports 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 

View 1 Replies View Related

Securing Web Application

Dec 11, 2007

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.

View 3 Replies View Related

Asp.Net Mobile Web Application

Jan 22, 2008

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

View 3 Replies View Related

Calling The SP From ASP.NET Application

Feb 8, 2008

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.

View 6 Replies View Related

Using SQL Application Roles From ASP.NET

Nov 1, 2004

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

View 2 Replies View Related

SQL 2000 In A Web Application

Dec 20, 2004

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.

View 2 Replies View Related

I Can't Execute My Asp.net Application With IIS 5.0

Apr 6, 2005

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.

View 1 Replies View Related

Application Log Is Full

Jul 3, 2001

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

View 2 Replies View Related

Application Connectionstring

Apr 1, 2008

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 ?

View 3 Replies View Related

Can't Connect From Web Application

Oct 21, 2004

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

View 1 Replies View Related

How Can I Get The Username From An Application?

Aug 9, 2004

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,

View 7 Replies View Related

Application Role

Aug 18, 2004

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

View 1 Replies View Related

Application Is Hung

Oct 28, 2004

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

View 6 Replies View Related

Triggers And .NET Application

Nov 4, 2005

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

View 4 Replies View Related

Application Log Is Full

Jun 26, 2006

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

View 1 Replies View Related

Please Help Me! Problem With DTS Application

Nov 13, 2006

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

View 4 Replies View Related

DB Security Vs. Application

Feb 3, 2004

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?

View 1 Replies View Related

Multiple Application In The Same Db

Feb 3, 2004

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







Copyrights 2005-15 www.BigResource.com, All rights reserved