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?

    Hi Thanks for the responses LiveBR is a local ODBC System DSN, which does in fact use the IP address. It resolves fine, and I can query data over it using say... Access, the only issue it that it is using named pipes, whereas the server is configured to only accept TCP/IP George, I tried...
  3. WyldeCarde

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

    Hi all, hopefully a quick and easier answer to this one: I am trying to use OPENDATASOURCE to copy data from one SQL server to another. (I'm aware SSIS is better for this but the scripts are easier for my colleagues to understand and update) I'm falling over at the first hurdle I've written...
  4. WyldeCarde

    Help with inserting data into a remore SQL server table

    Just realised I totally 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...
  5. WyldeCarde

    Help with inserting data into a remore SQL server table

    this is what I have so far, based on what this guys over here was working on - http://tek-tips.com/viewthread.cfm?qid=1577819&page=2 Option Explicit Dim objFSO, strTextFile1, strTextFile2, strTextFile3, strTextFile4, strData, strLine, arrLines, mConnection, filestream1, filestream2...
  6. WyldeCarde

    Help with inserting data into a remore SQL server table

    Good afternoon I have a need to run a succession of SQL scripts from a client PC to update a series of tables on a SQL server running on a VMware session on the PC in question. The client PC doesn't have SQL server installed, and I need to run the SQL scripts via a VB script or similar, can...
  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

    Is there anyway to get 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...
  9. WyldeCarde

    Little help with conditional formatting

    you've totally lost me, I have a list of data here's an example. ATA Reg MSN Date Detail 33-00 T-Bird MSN1 16/04/2008 Detail1 33-00 T-Bird MSN2 11/02/2008 Detail2 So I would like to format the data from after 1st of April. With conditional formatting I can get the...
  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

    Hi all What I am trying to do is, if a date in a subsection of column is less than the date stored in Cell D2, fill the entire row in light grey. If not, fill it in white. So far I have (a lot if it from this very forum)- Which just colours everything in grey regardless of what values are in...
  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