Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jcaulder

    One linked server succeeds while others fail to same server

    Yes, I got with my network admin and he confirmed that "host files were not correctly delivered to those machines as part of their original image". It is a DNS issue and I am by no means an expert on that either. Since the IP address works, the problem is resolved and I at least can move...
  2. jcaulder

    One linked server succeeds while others fail to same server

    We have different servers in our environment ranging from Windows XP, Windows Server 2003 and Windows Server 2008. The publisher or server I am trying to link to is Windows Server 2008. All subscribers are running the same SQL Server versions(SQL Express 2008) while publisher is running SQL...
  3. jcaulder

    One linked server succeeds while others fail to same server

    I have an environment with 42 remote subscribers and am trying to create linked server connections from my subscribers to my publisher server so I can run queries from subscribers. I am able to successfully create linked servers from some subscribers but not others. All of the SQL Servers for...
  4. jcaulder

    Accessing two SQL DB's at same time with stored procedures

    Replication management requires an entirely different skill set to maintain than typical SQL Server maintenance. That's probably why you get the resistance. It isn't terribly difficult to set up but when things go wrong, you better know what you're doing. There are many DBAs with no...
  5. jcaulder

    NO_DATA_FOUND exception

    I think this should do it: select table_a.B_ID from table_a left outer join table_b on table_a.B_ID = table_b.ID where table_b.ID IS NULL
  6. jcaulder

    Dynamic WHERE?

    I should first ask "where and how are you creating the query to return the login?" I think you probably have a stored procedure that you are passing in parameters for firstname and surname? If so, whatever your parameter names are should be inserted into the query. If your parameters are...
  7. jcaulder

    Form Change

    It is sometimes difficult to answer a question without having full background. I initially answered the simple question you had suspecting you needed a more robust solution but not wanting to confuse you by complex examples. My guess would be that you are probably binding your controls to a...
  8. jcaulder

    Form Change

    Create an event handler for each object you want to know when its text changes. Inside the event handler, take whatever action you would like to update the form level property or caption: 1)For a text box, while in design view, double click the text box. You can also go to code view, find the...
  9. jcaulder

    Form Change

    Something like the following is close to what you want: Dim c As Control For Each c In Me.Controls MsgBox(c.Name) Next However, I would probably create event handlers for the controls to handle textChanged event and let that set the property on the form or take whatever action necessary. J
  10. jcaulder

    Dynamic WHERE?

    Oops, you wouldn't need the UPPER in the second part of the condition since by default it is case insensitive: declare @name varchar(16) set @name = 'firstname' select * from myTable where (firstname = @name COLLATE Latin1_General_CS_AS AND ID >= 4) OR (firstname = @name AND ID < 4) Sorry...
  11. jcaulder

    Dynamic WHERE?

    I think you can just OR the conditions together to simplify the query and force the table and input parameter to upper case to ignore stored and entered values prior to ID = 4. No need for dynamic SQL... declare @name varchar(16) set @name = 'firstname' select * from myTable where (firstname =...
  12. jcaulder

    How do I clear out a dropdownlist on a web form?

    I assume you fixed this by now but when are you calling Items.Clear()?
  13. jcaulder

    How to manually trigger code within a service?

    Because services normally run without interaction from the user and whether or not anyone is logged on or not, it generally doesn't make sense to provide an interface. What I generally do is provide all of my business logic in a separate dll. I then reference this dll from my service and from...
  14. jcaulder

    Logic Question/Architecture

    It's hard for me to imagine what kind of task you would want to run a maximum number of times without being linked in anyway to a timer. Is a user or some other process going to make the task execute and you don't want them to be able to execute it more than 'n' times? A little more...
  15. jcaulder

    MD5 encryption returns different value on compact framework

    Disregard the post. The information provided to me and posted was inaccurate.
  16. jcaulder

    MD5 encryption returns different value on compact framework

    Just for clarification, the desktop application generates the following value: IctSnx399ivl5GGB1Sub9g== The compact framework generates this: /CrhsbWmX7UNQCDpGpdcug== The text being encrypted is: cjones7308 TIA!
  17. jcaulder

    MD5 encryption returns different value on compact framework

    I have code that encrypts a user password and stores in a database. The initial insertion occurs using a desktop application running full 2.0 .Net framework. When the user attempts to log in on a handheld device running the compact framework, I use the same code to take the supplied user...
  18. jcaulder

    Adding columns to published article in transactional replication

    I am running SQL Server 2008 R2 with merge and transactional replication. I recently added some columns to a published article. The schema change correctly replicated to subscribers under merge replication. However, in transactional replication the columns did not replicate. When I look at...
  19. jcaulder

    private...function test lib &quot;coredll.dll&quot;...what does this do exactly?

    Public Class MyNumericBox : Inherits NumericBox Private Declare Function ShowIM Lib "coredll.dll" (ByVal dwFlag As Integer) As Boolean Private Sub Me_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.GotFocus ShowIM(1) End Sub End Class Obviously...
  20. jcaulder

    why can't renamed dll be accessed from IIS

    I have a dll within a virtual directory on IIS 6.0 running Windows Server 2003 OS. The dll is called sqlcesa35.dll which is used by handhelds to sync data from a CE database to a SQL Express 2008 database on the server. This dll is installed as part of installing Microsoft Server Tools 3.5...

Part and Inventory Search

Back
Top