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

  1. WyldeCarde

    Can you force OPENDATASOURCE to user TCP/IP netork protocol?

    Thanks once again for the suggestion, I set up the alias, checked that I could connect to the alias name via SSMS and then I ran: SELECT * FROM OPENDATASOURCE('SQLNCLI','DRIVER={SQL Server};Data Source=Live24x7;User ID=UN;Password=PW;Network Library=DBMSSOCN').v4BusinessRules.DBO.FileFormats...
  2. WyldeCarde

    Can you force OPENDATASOURCE to user TCP/IP netork protocol?

    ...which makes it no longer resolve at all, which might mean its the right setting but the wrong option for that setting. I will experiment with that ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  3. WyldeCarde

    Can you force OPENDATASOURCE to user TCP/IP netork protocol?

    ...but the scripts are easier for my colleagues to understand and update) I'm falling over at the first hurdle I've written the following: SELECT * FROM OPENDATASOURCE('SQLOLEDB','DRIVER={SQL Server};Data Source=LiveBR;User ID=UN;Password=Pass').v4BusinessRules.DBO.FileFormats Where LiveBR...
  4. WyldeCarde

    Help with inserting data into a remore SQL server table

    ...failed to say thanks for this, although I couldn't get it running remotely due to firewall crap, I got it all runnign from the desktoop of the VPC ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  5. WyldeCarde

    Help with inserting data into a remore SQL server table

    ...= Nothing I don't think he got it working and no one answered his post as yet. I'm more of a data guy than a VB guy so I'm a trifle lost. ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  6. WyldeCarde

    Help with inserting data into a remore SQL server table

    ...The client PC doesn't have SQL server installed, and I need to run the SQL scripts via a VB script or similar, can anyone give a bit of guidance? ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  7. WyldeCarde

    MS access database calling SQL database with login

    Ahh right With the number of different data sources we've got that wouldn't be very practical, but thanks for the tip! ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  8. WyldeCarde

    MS access database calling SQL database with login

    ...the database to remember the password without setting up the links again? Sorry for the necro post, but this is exactly what I was looking for. ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  9. WyldeCarde

    Little help with conditional formatting

    ...the row, I have no idea what you think I would be comparing it to. Unless you think I have an enormous grid of numbers or dates for some reason? ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  10. WyldeCarde

    Little help with conditional formatting

    but not all the cells in the row will equal the cell and only the cells that do will get the formatting applied ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  11. WyldeCarde

    Little help with conditional formatting

    I know you can format cells with conditional formatting but how would I format the entire row the cell was on? ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  12. WyldeCarde

    Little help with conditional formatting

    Oh god it's always something embarrassing whenever I post on here, thanks for the help, sorry for the stupidity ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  13. WyldeCarde

    Little help with conditional formatting

    ...are in there. I get the feeling I'm doing something unspeakably obvious and stupid but my brain has gone all melty and I can't figure it out. ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper"...
  14. WyldeCarde

    Mousewheel scrolling to next record

    Why are the users only allowed to access one record? ********************************************************** If I had my own icecream van the chimes would play "Don't fear the reaper" **********************************************************
  15. WyldeCarde

    Image file attaches to email message????????

    Oh and if it's outlook, what mail format are they using?
  16. WyldeCarde

    Image file attaches to email message????????

    The reason the recipient is seeing this behaviour is because the WMZ extension is used as the self-installing Windows Media Skin file. when they try and run it media player tries and fails to install the skin and then resumes what it was last doing. Unfortunately Microsoft originally intended...
  17. WyldeCarde

    Deleting weekends from Calendar - Outlook 2003

    Just click on view and then Work Week
  18. WyldeCarde

    Freshdownload won't leave firefox alone

    Is it installed as an add on in firefox (not at a PC with firefox but I think you click on Tools --> Addons) You can remove it from there.
  19. WyldeCarde

    Windows XP Pro SP2 "Explorer issue"

    Have you installed or uninstalled Winzip recently?
  20. WyldeCarde

    Trying to access Display Properties, and I get this message. Any help

    If you can run regedit go to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies And delete everything under there, that should sort it out. if you can't run regedit, then you need to make the account you are using an administrator to fix it easily.

Part and Inventory Search

Back
Top