Search results for query: *

If memory serves me, the ADODC has a connection string as a property and will use that connection string to connect to the database and then execute the query and make the results available. This would mean that all queries would have to be 2 part: first to set the application role; second to do...

I recently had to do some c# Excel integration and came across a few of these issues too. I have found that if there are any excel objects which have not been set to NULL, the Excel instance will remain. So if you have declared an application and workbook object and not set it both to NULL, the...

The only way I know to get the application name into SQL is as part of the connection string, and certainly that is what Books Online and MSDN tell you about the application name. You say you have to use a defined ODBC driver, when you specify this driver is there no option to add additional...

If I remember correctly you can specify the application name as part of the connection string, I cannot remeber the syntax but a quick search on connection strings will produce an answer. -- Gavin

Look at the SQL function HOST_NAME()... SELECT HOST_NAME() -- gavin

TJRTech, I agree with what you are saying. And like you I am confused by that particular line alluding to stored procedures. I have looked at both from sql profiler and they both look as though they are executed at once with all the results returned to ADO, however the documentation says that...

OK, this has been bugging me for a couple of days now. Let us take the case of the following SQL statement SELECT * FROM table1;SELECT * FROM table2 As I said earlier I believed that using ADO's NextRecordset would mean that each statement is only executed when the NextRecordset function is...

Not sure if that is one round trip or 3... I remember reading some time ago (i.e. years) that when NextRecordset is called the next statement to return a recordset is executed, and not when the original call is done. You may need to double check the ADO documentation regarding this.

Stop Replication: You will need to replace the [LogReaderName] and [DistributionName] with the correct string values for your environment. EXEC msdb.dbo.sp_stop_job @job_name = [LogReaderName] EXEC msdb.dbo.sp_stop_job @job_name = [DistributionName]

I am glad it has worked for you. In my application I just check my main MDI form because as I said in the original post, if your form is in a modal state the style is set on all the forms within your application. -- Gavin

You could use API's to determine whether your application is in a modal state, either by having a modal form open or by having a message box active. When the application is made modal all forms have the disabled style set so you could check any open form in your application. Private Const...

In the past I have found that when confronted by a nasty LIKE or IN (subselect) query, they can be optimised by first doing the LIKE/IN query and putting the results in a temproray table. You can the use the temporary table in an inner join (depending on your data) and this will usually be...

Just a small note to remember about doing this: just because the close menu is disabled does not mean that a user cannot close the form down without clicking on some special button or link. If you press ALT+F4 the form will still close down, you will need to trap for this in the form KeyDown...

Try this, you could put it in a function which accepts the time input and return the time to the next 15 minutes... DECLARE @myDate SMALLDATETIME SET @myDate = '12 march 2004 12:46' SET @myDate = DATEADD(MINUTE, (DATEPART(MINUTE, @myDate) + 14) / 15 * 15 - DATEPART(MINUTE,@myDate), @myDate)...

Hi, Your problem is this statement: Dim XLApp As New Excel.Application Because you have chosen to auto-instantiate the excel object, every call to it will reinstantiate the object, therefore the lines xlApp.Quit Set xlApp = Nothing will not work. What you need to do is instantiate and use...

Try somthing along these lines: Dim bExcelInstalled As Boolean Dim myXL As Object On Error Resume Next Set myXL = CreateObject("Excel.Application") On Error Goto ErrorHandler If (myXL Is Nothing) Then bExcelInstalled = False Else bExcelInstalled =...

Muhammad, See my relpy in the "Visual Basic(Microsoft) -VB.NET" forum - no need to have so many cross-posts... thread796-766440 Gavin

Muhammad, On my system I needed to changed my INI file on the VSS server, and restart VSS. -- Gavin

Hiya, In your SourceSafe ini file there will be some entries which you can edit to force SourceSafe to open the files up with certain applications. Look for something like this: .reg (Win) = notepad.exe .vbp (Win) = notepad.exe .vcp (Win) = notepad.exe .mak (Win) = notepad.exe .bat (Win) =...

Hiya, In your SourceSafe ini file there will be some entries which you can edit to force SourceSafe to open the files up with certain applications. Look for something like this: .reg (Win) = notepad.exe .vbp (Win) = notepad.exe .vcp (Win) = notepad.exe .mak (Win) = notepad.exe .bat (Win) =...