Verifying Connection To 3rd Party Application

Jul 23, 2005

Is there a way that SQL can automatically look at each users'
connection and make sure it is still connected through the third party
application? The problem is that when a connection to this application
is not terminated properly, the SQL server is not notified of the
disconnect and the user cannot log back into the application until all
the processes are completed and the original session terminated.

Thank you.

View 1 Replies


ADVERTISEMENT

Modifying With 3rd Party Application?

Oct 30, 2006

Hi,
I have recently started using SQL Server with a 3rd party application and have come across a problem and i have no idea how to fix it...

The database has a column of numbers that go up either by 10 or 100 depending on the letter in another column. eg:

100 M
110 P
120 P
200 M
300 M
400 M
500 M
510 P
520 P

The 3rd party application has just been updated and now can add new rows to this table. The only problem is that the added row needs a new number, and the rows below need to be recalculated.

Is there anyway this can be done? Any help or suggestions would be great!

Cheers,
BL

View 1 Replies View Related

Capturing SQL Queries Of 3rd Party Application

Sep 15, 2003

Hello.

I would like to analyze how a particular 3rd party business application interacts with SQL server.

Specifically, I want to capture the "exact" SQL commands (transact-sql statements) that this application issues whenever it completes an operation for the user of this application.

In other words, suppose the application issues the SQL command "INSERT INTO table (a,b,c) values (1,2,3)" to add a new entry to the database. Then, my understanding is that if I instead issue the exact same command with a tool like "SQL query analyzer", the database will be updated in the exact same manner. Hence, I have effectively accomplished the same job that the 3rd party application does without even using it (by idependantly issuing the same command to the database it uses).

Is this possible? Can I obtain all the information I need just by running SQL Profiler?

View 3 Replies View Related

Do I Have The Right To Modify Third-party Application's Stored Procedures?

Jan 26, 2004

Our current concern deals with stored procedures from a third-party application that were modified in order to correct future data inconsistency that was being generated. Since the stored procedures were not encrypted, I was able to modify them and correct the problem. At the same time, we developed a small in-house application to correct the current data inconsistency and we created new stored procedures in the same database. Now I'm concern about if I had the right to modify those stored procedures and additionally, created new ones inside this database? Am I restricted somehow to use our full version of MS SQL Server with a scenario like this?

View 14 Replies View Related

Integration Services :: Failure Sending Mail / Connection Attempt Failed Because Connected Party Did Not Properly Respond

Jul 7, 2015

I recently started working on SSIS packages and I have a package which will Validate a table records and prepare a txt file with all details and sends the email to approriate email ids. The problem i'm facing is I'm getting System.Net.Mail.SmtpException  with inner exception as A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond xx.xx.xx.xx:25. I'm using SMTPConnection and Windows Authentication as credentials.I also add the ISServerExec.exe to the firewall exclusion list still it throws the same error.

View 3 Replies View Related

Using One Single-application Connection Vs. One Connection For Every Operation To SQL-Server Via ADO.NET

Aug 11, 2005

Dear members,I'am thinking about the "best" way to connect to my sql-server viaADO.Net (if there is a best way).My application uses the sql-server very intensively. At the momentevery database-operation opens a connection, executes and then closesthe connection.Another way would be to use only a single connection to the database,which is opened when the application starts.What do you think is the better way to get a high performing sqlserver: using one single application connection vs. using oneconnection for every operation?Cheers, Sebastian

View 2 Replies View Related

Verifying URL's In Table

Mar 30, 2008

Does anyone have a routine that can verify URL's in a database table.  I have a table with several thousand website addresses and I would like a way to check and see which ones resolve and which return Page Not Found error.  I quess my question is how do you interrogate a URL and what do you look for coming back?  Novitiate for many I am sure but not for me.
Thank you.

View 3 Replies View Related

Verifying A Backup

Jun 27, 2006

Hey Folks...
Very new to SQL Server. I've inherited numorous SQL Servers and wanted to know how I can tell if a backup is scheduled and how I can tell if it completed successfully? Thanks in advance....

Mike D.

View 5 Replies View Related

Verifying Authentication

Nov 14, 2005

Hi guys,

View 4 Replies View Related

Connection Between A Win Application And Database

May 15, 2008

hi
i m making a win application
for which i have used sql server 2005 .i faced a very big problem that i have made the database but i cannot able to connect the database with winn application .for this purpose i ned coding.so please help me.i need your help urgent.

sheraz

View 4 Replies View Related

Verifying Entry Is Not In DB B4 Inserting

Jun 4, 2007

How do i do that... in sch lab, the lecturer said:    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click        Try            SqlDataSource2.SelectParameters("Title").DefaultValue = txtProductTitle.Text            GridView1.DataBind()            If GridView1.Rows.Count > 0 Then //if no repeated                 Label1.Text = "Existing Record Found. Please enter another Software."            Else                'SqlDataSource1.Insert()                'Label1.Text = txtProductTitle.Text & " successfully added to the database."            End If        Catch ex As Exception            Label1.ForeColor = Drawing.Color.Red            Label1.Text = "An error occured!" & ControlChars.NewLine & ControlChars.NewLine & _            ex.Message.ToString()        End Try    End Sub but its not working for me... the GridView1.Rows.Count is always 0, if there is a repeat, it should be > 0 

View 4 Replies View Related

Programatically Verifying SQL Syntax

Nov 24, 2004

OK, so I'm working on a project that requires the dynamic generation of SQL statements. Now in Visual Studio .NET I'm sure many of you have used that wonderful visual database tool that allows you to magically "verify sql syntax" at the click of a button. It takes a query that looks like this:

"SELECT A.AFFID, A.UserName, A.Pass, A.FirstName, A.LastName, A.Company, A.Street, A.City, A.State, A.ZIP, A.Country, A.phone, P.EMail, A.RecieveEMail, A.SSN, A.JoinDate, A.AffType, P.ProductId, P.BuyerId FROM Affiliates A, Purchases P WHERE (ProductId > 0) ORDER BY 1"

and transforms it into something that looks like this:

"SELECT A.AFFID, A.UserName, A.Pass, A.FirstName, A.LastName, A.Company, A.Street, A.City, A.State, A.ZIP, A.Country, A.phone, P.Email, A.RecieveEMail, A.SSN, A.JoinDate, A.AffType, P.ProductID, P.BuyerID
FROM Affiliates A CROSS JOIN Purchases P
WHERE (P.ProductID > 0)
ORDER BY A.AFFID"

My question is: is there anything in the .NET platform that would allow me to achieve the same kind of result programatically (i.e. transform standard sql to tsql syntax and verify the syntax of the query at run time)?

Any help would be appreciated! Cheers.

View 2 Replies View Related

Need Help In Verifying User Login

Feb 19, 2005

To: All,

Hi, well thanks for reading this thread. Anyway I got a problem where i can't accurately verify whether a user had successfully login to my application.

I got a database to store the user name and password. So whenever a user login, i would use a while loop to read all the user name and password, and an if statement to verify whether the user's name and password matches to the ones stored in the database. This method doesn't work when there are multiple records in my database, because the if statement would compare the user given name and password with all the user name and password in the database. Hence resulting a mismatch.

Well I really hope that you understand what my problem is, really need help with this problem as I'm really clueless. Can somebody please help me, please teach me how to rectify this problem?

Well i think the core problem would be to compare the user name and password with the records in the database one at a time, and once it is found, stop comparing and allow user to enter site.

Yup I think that's all, sorry for the lengthy thread. Anyway thanks a million and have a nice day.

From: iaciz

View 2 Replies View Related

Verifying SQL Server Licensing

Aug 8, 2006

How do I tell what SQL licensing option (processor, device CALS or user CALS) was taken when the server was installed? I have taken over a SQL 2005 server and I would like to check how many CALS (if any) it is licensed for.

View 2 Replies View Related

Check Connection From C# Application To SQL Server.

Jun 28, 2007

Hey anyone,
I got a problem to check a connection whether it is established or not from my C# Application to SQL Server.
I am developing my application which can run in 2 modes:
1. Online: There must be a connection to SQL Server to get new data updates.
2. Offline: I dont need a connection to SQL Server. I set a timer to tick every 5 seconds and it will check the connection with SQL Server and my problem here: (this is my code)1 public static bool checkConnection()
2 {
3 SqlConnection conn = new SqlConnection("mydatasource");
4 try
5 {
6 conn.Open();
7 return true;
8 }
9 catch (Exception ex) { return false; }
10 }

 Yes, it works but my application seems to wait about >3 seconds to get the return "False"; I tried to add "Connect TimeOut=1" in my Connection String, but the problem is still there.
I dont know whether there is a faster way to check the connection to SQL server which is established or not.
Thank you very much,
Joesy

View 5 Replies View Related

Where Do I Declare SQL Connection Variable In My Asp.net Application

Sep 27, 2007

In my asp.net application , I have to open/close SQL databse connection many time, and I dont want to declare Following variable everytime I open SQL database connection
Dim cntec As New SqlClient.SqlConnection(cnStrtec)
Dim datec As New SqlClient.SqlDataAdapter
Dim dstec As New DataSet
Dim cmdtec As New SqlClient.SqlCommand
so do I decalre above variable in module.vb as Public variable or is there any other way to do this.
Please some one give me idea how to do this
thank you
maxmax
 

View 3 Replies View Related

Where Do I Declare SQL Connection Variable In My Application

Sep 27, 2007

In my asp.net application , I have to open/close SQL databse connection many time, and I dont want to declare Following variable everytime I open SQL database connection
Dim cntec As New SqlClient.SqlConnection(cnStrtec)
Dim datec As New SqlClient.SqlDataAdapter
Dim dstec As New DataSet
Dim cmdtec As New SqlClient.SqlCommand
so do I decalre above variable in module.vb as Public variable or is there any other way to do this.
Please some one give me idea how to do this
Please give me some examples
thank you
maxmax

View 1 Replies View Related

Connection To SQL 2000 Database With .Net 1 Application

Nov 12, 2007

Hi there,
 
Has anyone ever encountered problems making .Net applications connect to a SQL database on SQL 2000 with SP3a?
 
It's running on a virtual machine with a Windows Server 2000 Std with SP4, the .Net application is working with .Net Framework 1.1.4322.573. For some reason it can't connect to the SQL database using the specified username and password in the web.config file even though the user exists in the SQL database. I've tried using the SA password but this still doesn't work. I can logon to SQL Query Analyzer using the SA password but not using the other username.
 
The .Net application does work on other systems of mine all of which can run on Windows Server 2000 and 2003, I have compared them but can't find any differences. 
 
Any ideas anybody?
 
Thanks,
 
Chris

View 1 Replies View Related

Establish Connection With SQL Server From VB.Net Application

Jun 11, 2008

I have application that is connecting to SQL Server and runs bunch of stored procedures, but I don't think that am able to connect to my database server. When it hits the line to execute the stored procedure it comes up with syntax error saying the syntax error is at the stored procedure. I know how to set up the connection string with web app from the web config, but never done it on an app. Here is the connection string pointing to my server which I pass to my SqlConnection object: "Data Source=ServerXXXX;Initial Catalog=DB;Integrated Security=True; User ID=xxxx; Password=xxxx;"  And that is the code that is using the above connection string:   Public Sub MigrateNFSData(ByVal calcTbl As DataTable, ByVal strDBConnection As String)        Dim sqlServerConn As New SqlConnection(strDBConnection)        'Define stored procedures        Dim command As New SqlCommand        Dim getAccID As New SqlCommand("GetAccountID", sqlServerConn)        Dim getActionID As New SqlCommand("GetActionID", sqlServerConn)        Dim getExchangeID As New SqlCommand("GetExchangeID", sqlServerConn)        'Dim getParrentAccID As New SqlCommand("GetParentAccID", sqlServerConn)        Dim getStatusID As New SqlCommand("GetStatusID", sqlServerConn)        Dim getTraderID As New SqlCommand("GetTraderID", sqlServerConn)        Dim getGroupID As New SqlCommand("GetGroupID", sqlServerConn)        'Define insert records stored procedures        Dim insertAcc As New SqlCommand("InsertAccount", sqlServerConn)        Dim insertAction As New SqlCommand("InsertAction", sqlServerConn)        Dim insertExchange As New SqlCommand("InsertExchange", sqlServerConn)        Dim insertGroup As New SqlCommand("InsertGroup", sqlServerConn)        Dim insertStatus As New SqlCommand("InsertStatus", sqlServerConn)        Dim insertTrader As New SqlCommand("InsertTrader", sqlServerConn)        Try            sqlServerConn.Open()        Catch ex As Exception            'Exception message goes here        End Try        'Set parameters to helper Get Stored Procedures to retreive Id's         getAccID.Parameters.Add("@AccName", SqlDbType.NVarChar)        getAccID.CommandType = CommandType.StoredProcedure        getActionID.Parameters.Add("@ActionName", SqlDbType.NVarChar)        getActionID.CommandType = CommandType.StoredProcedure        getExchangeID.Parameters.Add("@ExchName", SqlDbType.NVarChar)        getExchangeID.CommandType = CommandType.StoredProcedure        'getParrentAccID.Parameters.Add("@ParentName", SqlDbType.NVarChar)        'getParrentAccID.CommandType = CommandType.StoredProcedure        getStatusID.Parameters.Add("@StatusName", SqlDbType.NVarChar)        getStatusID.CommandType = CommandType.StoredProcedure        getTraderID.Parameters.Add("@TraderName", SqlDbType.NVarChar)        getTraderID.CommandType = CommandType.StoredProcedure        getGroupID.Parameters.Add("@GroupName", SqlDbType.NVarChar)        getGroupID.CommandType = CommandType.StoredProcedure        command = New SqlCommand("InsertTradeTransaction", sqlServerConn)        command.CommandType = CommandType.StoredProcedure        'Set Parameters for Insert stored procedures        insertAcc.Parameters.Add("@Account", SqlDbType.Text)        insertAction.Parameters.Add("@ActionName", SqlDbType.Text)        insertExchange.Parameters.Add("@Exchange", SqlDbType.Text)        insertGroup.Parameters.Add("@Group", SqlDbType.Text)        insertGroup.Parameters.Add("@ACCID", SqlDbType.Int)        insertStatus.Parameters.Add("@StatusName", SqlDbType.Text)        insertTrader.Parameters.Add("@Group", SqlDbType.UniqueIdentifier)        insertTrader.Parameters.Add("@IP", SqlDbType.Text)        insertTrader.Parameters.Add("@TraderName", SqlDbType.Text)        'Adding stored Get Stored Procedure's parameters-----------------------        command.Parameters.Add("@OrderNum", SqlDbType.Text)        command.Parameters.Add("@ACC_ID", SqlDbType.Int)        command.Parameters.Add("@Group_ID", SqlDbType.UniqueIdentifier)        command.Parameters.Add("@Trader_ID", SqlDbType.UniqueIdentifier)        command.Parameters.Add("@Exch_ID", SqlDbType.Int)        command.Parameters.Add("@Date", SqlDbType.DateTime)        command.Parameters.Add("@Time", SqlDbType.DateTime)        command.Parameters.Add("@ActionID", SqlDbType.Int)        command.Parameters.Add("@StatusID", SqlDbType.Int)        command.Parameters.Add("@TimeSent", SqlDbType.DateTime)        command.Parameters.Add("@Qty", SqlDbType.Int)        command.Parameters.Add("@Product", SqlDbType.Text)        command.Parameters.Add("@MMYYY", SqlDbType.Text)        command.Parameters.Add("@ExchOrderID", SqlDbType.Text)        command.Parameters.Add("@TimeTicks", SqlDbType.Int)        command.Parameters.Add("@W2G", SqlDbType.Int)        command.Parameters.Add("@W2Exch", SqlDbType.Int)        command.Parameters.Add("@G2ExchDerived", SqlDbType.Int)        command.Parameters.Add("@ExchDate", SqlDbType.DateTime)        'command.Parameters.Add("@ParentID", SqlDbType.Int)        'Paremeters Defenition--------------------------------------        'Write table with computed NFS data to sql server DB        For Each dr As DataRow In calcTbl.Rows            command.Parameters("@OrderNum").Value = dr.Item("OrderNo").ToString()            getAccID.Parameters("@AccName").Value = dr.Item("Acct").ToString()            If getAccID.ExecuteScalar() = 0 Then                insertAcc.Parameters("@Account").Value = dr.Item("Acct").ToString()                insertAcc.ExecuteNonQuery() //THIS IS WHERE IT FAILS and pops up with the message that there is syntax error at this procedure                getAccID.Parameters("@AccName").Value = dr.Item("Acct").ToString()                command.Parameters("@AccName").Value = getAccID.ExecuteScalar()            Else                command.Parameters("@ACC_ID").Value = getAccID.ExecuteScalar()            End If            getGroupID.Parameters("@GroupName").Value = dr.Item("GroupID").ToString()            Try                command.Parameters("@Group_ID").Value = getGroupID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getTraderID.Parameters("@TraderName").Value = dr.Item("TrdID").ToString()            Try                command.Parameters("@Trader_ID").Value = getTraderID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getExchangeID.Parameters("@ExchName").Value = dr.Item("Exch").ToString()            Try                command.Parameters("@Exch_ID").Value = getExchangeID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getActionID.Parameters("@ActionName").Value = dr.Item("Action").ToString()            Try                command.Parameters("@ActionID").Value = getActionID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getStatusID.Parameters("@StatusName").Value = dr.Item("Status").ToString()            Try                command.Parameters("@StatusID").Value = getStatusID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            'getParrentAccID.Parameters("@ParentName").Value = ""            'Try            'command.Parameters("@ParentID").Value = getParrentAccID.ExecuteScalar()            ' Catch ex As Exception            'End Try            command.Parameters("@Date").Value = DateTime.Parse(dr.Item("Exch Date").ToString())            command.Parameters("@Time").Value = DateTime.Parse(dr.Item("Time").ToString())            command.Parameters("@TimeSent").Value = DateTime.Parse(dr.Item("Time Sent").ToString())            If (dr.Item("Qty").Equals(System.DBNull.Value)) Then                command.Parameters("@Qty").Value = System.DBNull.Value            Else                command.Parameters("@Qty").Value = Int32.Parse(dr.Item("Qty").ToString())            End If            command.Parameters("@Product").Value = dr.Item("Product").ToString()            command.Parameters("@MMYYY").Value = dr.Item("MMYYYY").ToString()            command.Parameters("@ExchOrderID").Value = dr.Item("ExchOrderID").ToString()            If (dr.Item("TimeTicks").Equals(System.DBNull.Value)) Then                command.Parameters("@TimeTicks").Value = System.DBNull.Value            Else                command.Parameters("@TimeTicks").Value = Int32.Parse(dr.Item("TimeTicks").ToString())            End If            command.Parameters("@ExchDate").Value = Date.Parse(dr.Item("Exch Date").ToString())            command.Parameters("@W2G").Value = 2            command.Parameters("@W2Exch").Value = 2            command.Parameters("@G2ExchDerived").Value = 2            command.ExecuteNonQuery()            sqlServerConn.Close()        Next    End Sub Thank you guys as always being helpful. 

View 4 Replies View Related

Application On Start And Database Connection

Nov 24, 2003

Hello,
I was wondering if someone could help me answer this question.

If I had a site like Yahoo, that constantly had users accessing it. Would it be a good or bad idea to automatically open a database connection to SQL Server on Application Start? What would you recommend? Would opening and closing the DB connection on every page save alot of overhead and bottleneck? Thank You.

View 2 Replies View Related

Application Role Losing Connection?

Sep 6, 2007

Hi,

I'm testing the use of application roles for security. The customer I work for has still a lot of ASP intranet applications running. We're migrating the databases to a SQL Server 2005 server.

I've changed the connection string to a user without any permissions but to log on. After that I use an application role for permission to select different tables and to execute Stored Procedures.

The first queries do execute but after that I get "Permission denied", like I haven't got the application role anymore.

Any ideas?

Adrian

View 6 Replies View Related

DB Engine :: Connection Closed From Application End

Jun 30, 2015

The application server gets below error while the job is being run intermittently:

An error occurred while performing connection management

com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:319)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:1839)

[Code] ....

There is no error reported in SQL logs.

View 6 Replies View Related

SQL Server Connection Redirection With VB6 Application.....!

Mar 20, 2008

I have VB6 application on several desktops connected to SERVER A (SQL Server 2005) in TESTING. I know I can change some registry values in VB6 application to connect it to SERVER B(SQL Server 20050 in PRODUCTION.
but it is work on each and every desktop.

Is there any way to do something on SQL Server 2005 Engine end (like Alias) so I don't have to make changes for SERVER Redirection in each and every Desktop machine(client), and Just I make change on SERVER Side.
any help or idea on that?
Thanks,

View 1 Replies View Related

Remote Connection In Sql Express While Run A EXE Application ?

Mar 30, 2008

I am getting this error
"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)(Microsoft SQL Server,Error:2)"
in SQL EXPRESS 2005

1.Just changing the service config settings that is TCP/IP to enable will it work?i changed i run my application but it didn't work they have written the code to the server(connection string to their server- if it was to common how to write the code ?) & is there any other changes ?

2.I have developed a VB.NET EXE file -In that application(inside the code) i am using run time connection string queries to connect to the sql server database & created run time tables.

Suppose if i want to install the application to all clients/users how to Configure that application - self configuration/self installer to the installing machine SQL SERVER.
How can i do this ?

3.Is there any way i can write config file for sql server along with exe application code ? How can i do this ?

Pls answer with details/screenshots or diagramatical (if possible)
pls reply asap

Dotnetnewbie

View 1 Replies View Related

SQLExpresss Losing Connection To VB6 Application

Apr 2, 2007

I have a VB6 application that has MSDE as its current backend. In
testing moving to SLSQLExpress I've noticed, since this application is run on laptops, that if I disconnect the network cable while I'm in the VB6 app I lose "connection" to the database. If I end task on the app and restart it it works fine. If I reconnect the network cable while the app is running and then disconnect it the app runs fine. Also this happens when I'm connected to a wireless network and then disconnect and disable that connection.

In my template.ini file I have DISABLENETWORKPROTOCOLS=0. Is there a setting I'm missing? I can't seem to find anything else to set in the ini file.

View 4 Replies View Related

Verifying Ms Sql Server Desktop Installation

Feb 20, 2005

I am trying to use msde for the startup kits. but i cannot connect to it. How can I do a simple test to verify it is installed and that I can log into the db?

Thanks
Ron

View 1 Replies View Related

Verifying That A Task Completed Successfully

Oct 4, 1999

How can a tell if a tak completed succesfully from a stored procedure?

I have a task which is executed from a stored procedure. The sp_runtask only returns whether the task started successfully. How can I tell if it completed successfully?


Thanks

View 3 Replies View Related

Maintain A Consistent DB Connection Through Application Lifecycle

Nov 10, 2006

Hey everyone, I'm new to .NET and I've recently inheirited a rather large and busy asp.net website.  I was asked to add a testimonials section on each page that will randomly pull a testimonial out of the db.  This is fine, however, I'm getting random errors about the DB connection either being closed or connecting.  Here is the code for the testimonials class: 1 public SqlDataReader GetTestimonials(ref SqlDataReader reader, int iCatID, string sLanguageType)2 {3 SqlCommand cmd = new SqlCommand("sp_DVX_Testimonials_Fetch", Connection);4 cmd.CommandType = CommandType.StoredProcedure;5
6 cmd.Parameters.Add(new SqlParameter("@Cat_ID", iCatID));7 cmd.Parameters.Add(new SqlParameter("@LanguageType", sLanguageType));8
9 reader = cmd.ExecuteReader();10
11 return reader;12 } I know this isn't the best way to do this (especially for each page[this site averages about 1000 hits a day]), so I was wondering was--is there a way to maintain a single DB connection that's set up in the Application_Start that will maintain the connection so I don't have to worry about this error.  If not, does anyone and any ideas as to what would help? Thanks in advance! 

View 4 Replies View Related

Application Connection String Using Windows Auth

Feb 7, 2008

OK

We have always used sql servwer login to the servers for all our applications for out intranet apps

And we use windows auth to do development

So when we do that we logon to wuindows, and then just connect, with no password required

But how does an application "logon" to connect to a database

Is it just in the connection string just like sql server auth

or is it different?

View 2 Replies View Related

Connection From Windows Application To Mobile Device(*.sdf)

Jan 21, 2008



Hi,
I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code:


Dim cnn As New SqlCeConnection


cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf"


cnn.Open()

But I get the following error:

The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ]

Any help would be greatly appreciated!
Leila

View 5 Replies View Related

Please Provide Help On How To Get Connection Tab For A Selected Provider In Web Application

Oct 15, 2007

Hi Sir

In My web application i am using the ".UDL" file functionality.

<![endif]--><!--[if !vml]-->The €˜Select Provider€™ tab will be used to allow users to specify the OLE DB Provider to be used for the connection. now i am able to get all provides available in system. But i have a problem how to get the cossesponding connection tab at runtime.

please save, i am in crusial stage.

Thanks In Advance.

etlu me srinu

View 3 Replies View Related

Windows Application With Connection To Database On A Server

Apr 21, 2008



Hi all,

I think I can do this, just want to check

Can I have an sql server database (mdf file) on a server and allow windows applications at different site manipulate the database.

As far as I am concerned the only thing that needs to be configued is the connection string..is this correct.

[i would rather use windows applications rather than asp pages]

If I can, the best way to manipulate the database is to use stored procedures. How would I do the following to create and execute the following proposed procedure:

Insert data into a table
Update another table as a result

Execute the store procedure on a form to execute these two statements

Thanks in advance

Peter

View 5 Replies View Related

Stored Procedure For Verifying Data Existence

Jun 26, 2006

Hello All,
I'm trying to develop a stored procedure that would do one of TWO things:
1.  Return a 'status' that a value does not exist, if I were to provide the parameter via an ASP.NET2.0 page
2.  If it does exists, to return the row data associated with that value (id number)
The stored procedure would search a SQL Server table within it self first.  It that fails it would look at an Oracle table (work order table).  And if that fails to return a 'row' to look through another Oracle table (work request table).  If that doesn't occur, then it would throw the result as described in #2.
If the result exists in one of the TWO Oracle tables it would then insert that row into the first SQL Server table that the stored procedure searched through AND would return the row set to the ASP.NET page.
While all this is happening, I was hoping to get some insight as to how to create a "Please Wait..." feedback and then moving to the final result.
Looking forward to the wise words of the many on this forum, as I have experienced in the past!  :)
 

View 2 Replies View Related







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