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 derfloh 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: *

  • Users: Klae
  • Order by date
  1. Klae

    Unique Constraint Violation when already checked using WHERE clause

    OK SQLDenis, it was a NULL The business wanted the LinkDate of each file recorded even if it was NULL so I had to allow it to be null and the INSERT Clause did not think NULL = NULL whereas the UNIQUE Constraint does see NULL = NULL so I have changed... AND CAST(nd.LinkDate AS DateTime) =...
  2. Klae

    Unique Constraint Violation when already checked using WHERE clause

    OK I've tried both Queries and they both try to insert the identical 242 rows. So there is no difference, I'm still getting unique data that translates to data breaking a Unique constraint. Does anyone know a way of debugging it so it tells me which row of data violates the constraint? Klae...
  3. Klae

    Unique Constraint Violation when already checked using WHERE clause

    Oh I've noticed a couple of typo with FileVersion fields ignore them. Klae You're only as good as your last answer!
  4. Klae

    Unique Constraint Violation when already checked using WHERE clause

    OK so my original snippet is ... INSERT INTO xemFileStore ([FileName], xemProduct_FK, CRC32, FileSize, FileVersion, LinkDate, [Description]) SELECT DISTINCT nd.[FileName], xp.Product_PK, nd.CRC32, nd.FileSize, nd.InternalFileVersion, nd.LinkDate, nd.InternalFileDescription FROM NewData nd...
  5. Klae

    Unique Constraint Violation when already checked using WHERE clause

    Thanks SQLSister and SQLDenis, I've got SELECT DISTINCT for the data to be inserted so I think I've accounted for that. I can see I might need to include the snippet of SQL tomorrow (I'm in UK so its not work hours) because without you helpful people seeing it I'm not entirely sure I know what...
  6. Klae

    Unique Constraint Violation when already checked using WHERE clause

    Hello I'm pretty up on my MS T-SQL skills but this one is beating me! I have a table with a PK and the rest of the fields are part of a Unique Constraint. When I INSERT data into this table from the flat table (import is not normalized, SQL Job runs procedures to normalize) I have made sure I...
  7. Klae

    I want to VPN out thru BM...

    Hello people, I would like to allow internal clients behind BM to succesfully use a VPN connection out to another Network. Let's say the Internal workstation and BM is site A and I want to VPN out to site B. site B can handle NAT being used by other (than BM) firewall/NAT devices/products. From...
  8. Klae

    AutoExec in a mda file

    Hello, I want to create an add-in which performs a VBA function when the 'database that has my add-in installed' is opened. I want to 'AutoExec' my VBA function but an AutoExec Access Macro in the mda file does not execute and an AutoExec Access Macro in the user's database cannot reference my...
  9. Klae

    SSL Internet connection

    The MACs had there own shared ISDN connection before through a hardware ISDN router. Since the fibre link has been put in it has been requested that these MACs access the internet through the new link. That is all that is to be changed for the MACs. OS X and everything else is as it was. If...
  10. Klae

    SSL Internet connection

    One of our glorious project managers decided to proceed with a project of moving our inhouse printing services to our main optic fibre network. He did this by only involving our COMMS team who know nothing past the IP stack. we have 5 MACs running OS X which now, on the new network cannot logon...
  11. Klae

    Force Local Profile to be used

    How did you set the Terminal Services profile? Did you enter it in as a UNC? e.g. "\\FileServer\HomeShare\ProfileFolder". In the "profileFolder" have you put a profile consisting of all the folders and the ntuser.dat (or ntuser.man) file at the root of...
  12. Klae

    Web Certificates failing

    We had to give in, in the end and give our two users local profiles and not roaming ones and disabled Dynamic Local User and had to tell the users that no one else can log into their PCs and they will not be able to roam around the office. the digital certificates work fine on their local...
  13. Klae

    Cookies being eaten?

    We have Bordermanager as our corporate proxy and cookie handling is a bit erratic. Any website that extensively uses cookies and session-cookies do not work properly. Insurance sites and other secure sites return "cookie expired for no use in 30 minutes" when you are using the website...
  14. Klae

    accessing more than one post office with LDAP

    Thanks for replying, They are both in the domain 'BFBC'. The only thing on the Novell KnowledgeBase is that you can select which post office to return in NWadmin95 and to change it it can only be done in NWadmin95 not NWAdmin32 or ConsoleOne apparently the button is only in NWadmin95! Novell...
  15. Klae

    accessing more than one post office with LDAP

    Hi, We have two post offices on our Groupwise system. (BFBC_PO1 and BFBC_PO2) I have setup access to the address book via LDAP but it is only picking up addresses from BFBC_PO2. how do I get LDAP to return all the addresses from both Post Offices? Klae You're only as good as your last answer!
  16. Klae

    Web Certificates failing

    Hi, We have a Netware 5.1 network and we have some users in our education department (we are a borough council) who needs to use digital certificates through IE5.5. With Novell DLU and Workstation manager the digital certificate becomes corrupt and unuseable. Every one of our users cannot use...
  17. Klae

    Web Certificates failing

    Hi, We have a Netware 5.1 network and we have some users in our education department (we are a borough council) who needs to use digital certificates through IE5.5. With Novell DLU and Workstation manager the digital certificate becomes corrupt and unuseable. Every one of our users cannot use...
  18. Klae

    NT user stuff

    Thanks for that Swi. I remembered the DOS command NET USER and used that a day or so ago now, you know when you have something to code and you just go off on one thinking it's really hard to do and you are trying to do it a really hard way when there is a so simple way that you are completely...
  19. Klae

    NT user stuff

    Hi Guys, I was wondering what the code involved was for adding and deleting NT users from the local Machine User manager. Any help appreciated thanks. Klae You're only as good as your last answer!
  20. Klae

    Servlets on IIS?

    what's tomcat or resin? www.tomcat.com (porn site!) www.resin.com? DNS resolution failed. Klae You're only as good as your last answer!

Part and Inventory Search

Back
Top