Search results for query: *

Hi LED888, Tried your suggestion. Running cfgmgr didn't add scm1 as we hoped. lsdev -cC tape still give the same 5 devices (4 rmt's and 1 smc0). I've captured the output of cfgmgr, but can't seem to find any obvious error. The PV122T is connected to scsi4, so that's what I looked for. Can...

Hi LED888, Well it is 2 separated devices as you said. 1> Dell PV122T library, non-IBM --> TSM driver 2> IBM LTO-2 Tape drive, IBM --> IBM ATape driver I guess we came the right way by downloading IBM ATape driver for the tape. But when you said that we would use TSM driver for non-IBM...

Hi Mag0007, Thanks for the advice. But this is a running Production server, so I can't just re-install AIX. Here is what lsdev -Cc tape gave us: rmt0 Available 1D-08-00-0,0 SCSI 4mm Tape Drive rmt1 Available 1V-08-00-3,0 IBM 3580 Ultrium Tape Drive rmt2 Available 1D-08-00-6,0 IBM 3580 Ultrium...

Hello, We are trying to get our new Dell PV122T LTO2 Autoloader to work with TSM 5.2.3 on IBM p650 running AIX5.2. But we can't even get the OS to see the library, and the tape drive it sees can't be added to TSM either. Dell doesn't officially support AIX, i.e. no AIX driver, but they do...

Hello everyone, I've been working with MS SQL servers and T-SQL for a while, but never with DTS. I think I have to take the plunge now, but I need major help on this first time. I have to import data into an existing table in SQL2k server from single or multiple Excel 2002 files (each with...

Right, klat2beradanik2. The patch that Symantec is talking about is a patch to allow WinXPSP2 to "see" that NAV is working, and thus will not show the warning that you mentioned about SP2 not recognizing that NAV is working. And for lander215, here is the link on MS site...

Thanks lander215, But now I have conflicting information from Microsoft (who says there is a problem) and Symantec (who says there is no problem). So, not only do I still don't know what is the problem between NAV and SP2, I now know that at least one of the two companies is lying to their...

Hello all, I'm planning to roll out SP2 to my WinXP users. But I found a note on Microsoft Website stating that there is a known problem with NAV Corporate Edition v. 8.1, which is what we are using. I've tested it on a few PCs, but I can't seem to find any problem with NAV. That makes me...

Thanks avertere, What you said made perfect sense. In fact, we have that working (outside calling in or VPN-client controlling internet server). However, what I'm trying to do is inside calling out or internal PC remote controlling a server outside, which is connected to HQ using VPN. This...

Hi ChicagoTechNet, I can get the Admin to do specific things. He's just not very active about looking for solutions. If I can tell him what to do or what to try, he's willing to help. So, if you could, please describe the solution. The more specifics the better, but I'll take whatever you...

Dear all, I'm just a regular VPN user, not an admin. I need to remote control a server at a branch office connected to the HQ over VPN, and my admin just couldn't be bothered to help investigate. We uses CheckPoint Firewall-1 as our firewall and VPN gateway at the HQ. The server at a branch...

Thanks DBomrrsm, that did the trick. Simple, yet effective. I guess I'll have to learn more about the join command and concept to apply somewhere else. Katy44, You're absolutely right. There are some duplicate ID in the SOURCE table. I think I'm lucky this time that the records with the...

Hello SQL experts, It's me the SQL newbie again. This time I'm trying to update a table with data from another table. Seems like a simple thing, but I can't seem to get it right. Here's some background info: <TARGET Table> ID,Title,Firstname,Lastname,Nationality,Religion,Sex <SOURCE table>...

hmckillop, Thank you so very much. For extremely quick response and for a perfect solution. The code worked perfectly on the first trial (after making changes as you suggested, of course). Thank you very much again, dragony

Dear helpful SQL experts, I'm very new to SQL Server, but have to help my team with data cleansing on MS SQL Server 2000. I've got a set of data that contains a field with Title, Name, Lastname all in one field (ex. Mr. John Smith). I have to split that field into 3 new fields (Title, FName...

Hello everyone, I'm not really a programmer, but need help writting stored procedure that will copy data from an source table (a result of importing data from a text file using DTS) to a destination table with more columns and some data transformation along the way. Here are the table...

I'm not sure if I understand you correctly. But if you are indeed trying to do this in Access (and not VB), then here's something I've done to import a text file into a table. DoCmd.TransferText acImportFixed, "CommissionSpec", "tblImport", "C:\data\commission.txt", False This is to import a...