Search results for query: *

Anyone seen this before?

Looking for help with creating a macro to launch a command or script on a remote server, and return success or fail.

Looking for some help or advice. Trying to create a Macro that will concatenate 4 columns A-D with a ~ separator in Column F. It needs to start in E2 and continue till empty cell in column D. I have tried the below so far but fails to continue past E3. Sub ConCat() ' ' ConCat Macro ' ' Dim...

I am trying to reduce the processing time of a spreadsheet that contains the following formula. The constants need to remain constant but the rest will need to reflect the position in the worksheet e.g. as it would if the formula were copied across columns...

We have a site to site vpn setup between a cisco asa 5505 and a checkpoint NG firewall. We can do all the normal browsing of networks etc, but when we try and use a cisco ip phone, it rings once then goes engaged. If we use the VPN desktop client we are able to use IP communicator ok and all...

I have a holding table with imported data from an external source. All columns are set to Varchar(50). When I try and run a script that takes this data and populates the correct table I get "conversion failed when converting to datetime error" data in Varchar field reads 22/11/2008 00:00:00...

We have 4 CTX servers in a farm and 70 clients. Each PC that connects has a policy that sets the printers in session. These printers are mapped through from local clients. Printing is extremely slow, and puts a strain on the CTX servers if more than 10 users connected. Servers are W2K3 SP2 with...

Hi I have 2 tables, and need to append one column in table 1 with another column from table 2 where a certain columnID is the same. Insert Into T1.C1 Select C2 from T2 WHERE T1.C3 = T2.C3 Getting could not be bound error? Any help please.

Need some help on this if possible. Have an application that uses a DB on SQL 2005. Error reported by App is that it failed to load msxmlsql.dll. Have trawled net and found all hotfixes ie http://support.microsoft.com/kb/941105 but nothing worked. I used SQL profiler and it get "Error 18055...

Hi How do I truncate the length of a data entry in a column. Column set to nvarchar (20) but column for import in set to MAX. I want to import these records but truncate them to max of 20 for that column only.

I have a table with several columns of all varchar data. We then run a SP to move the data to a new table, one of which has a datetime setting. If the varchar data is in format ddmmyyyy it get The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value...

Not sure this is the right place, but here goes. Have an app that uses SQL via Citrix. When app prints it creates temp file in a specified folder we have set in the database. We now want to separate this further by changing the folder location to include the ClientName variable that Citrix uses...

Having a few issues around auto created printers. I have a Zebra Label printer with a defined user stock page size of 70mm*38mm. Whn I log into mt published application, the printer auto creates, uses the correct driver, but the stock size has reverted to default user of 101.6mm*101.6mm and is...

I am trying to import data from Excel to a table in an SQL database. One of the column's is a PriKey with a unique number. How do I get the import from Excel using SSIS to auto generate the next number in the column, so that every import of data has a unique number per row inserted.

We have an application that references a .ini file to direct a specific print to a printer. We have 170 PC's with 100 printers that access this app via Citrix. When a user logs in to the app it will auto create all the local attached printers and assign an Nexx number. We then have all the...

I have a VB3 app that works as it should on Windows 2000 but gives some strange output when run on Windows 2003. App has some dll's and VBX controls in the System folder but nothing that is installed in the tradtional sense. I have tried using compatibility mode to no avail. Is there any major...

I have a really bad 16 bit application called HighEdit V4. When the program and Dll's are called under windows 2000 and before it brings up the correct template (table format address label), if I do the same on Windows 2003, where the table should be I get a black box, and if I click on it it...

Have a wierd problem with our ASA Firewall. Simple setup, core network setup with various VLANS, and a static route to direct anything from a specific network via the ASA interface. After about 5 to 10 minutes the link from the VLAN to the ASA stops responding, and will only come alive if a ICMP...

I am looking to export data from SQL to an external program. Currently we have a table setup to take answers to some questions. Some of these questions require multiple answers, therefore creating another row within the table. I would like to identify these multiple rows from the same question...

I am trying to create a view that will display data from 2 colunms in one table. In one of the columns there is generic text which is ok, but also a numbered reference to a column in another table. I would like to retain the text data but replace the numeric value with the corrosponding data...