Recent content by WyldeCarde

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...

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...

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...

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...

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...

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...

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"...

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...

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...

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"...

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"...

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"...

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...

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

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