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!

  • Congratulations strongm 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. CarrahaG

    Set the value of a column in one table based on the sum of column values in another table

    Hello George Your script worked perfectly. Thank you. Regards, Georges
  2. CarrahaG

    Set the value of a column in one table based on the sum of column values in another table

    Hi George The resulting table is correct. The reason the value for DISC_COD is null for ITEM_NO 1003 in the resulting table is because it was null in the first place. Regards, Georges
  3. CarrahaG

    Set the value of a column in one table based on the sum of column values in another table

    Hi Skip I have always thanked members with a formal reply who have responded to my questions in which they have been helpful. It is many more times than once. In several cases, I did not get a helpful response in time and I had to find an alternative solution. In those cases where the...
  4. CarrahaG

    Set the value of a column in one table based on the sum of column values in another table

    Hello I would like to update the column in one table based on the results of a query from another table. I have two tables IM_ITEM and IM_INV tables. In the IM_INV table I would like to sum up the location quantities for each item. If the quantity is zero, I would like to set the...
  5. CarrahaG

    DBCC CHECKDB cannot fix database

    ...run the command with the REPAIR_ALLOW_DATA_LOSS, the same error occurs: DBCC CHECKDB(BHT, REPAIR_ALLOW_DATA_LOSS) Running the command select * from pduser.PDCPS_DOC_LIN where CDOC_ID in (101321732044, 101321732866, 101321734503, 101321735658) gives the result: CDOC_ID...
  6. CarrahaG

    Windows 2008 Server can not access NAS share using UNC path and NETBIO

    Hi kmcferrin Just did the NBTSTAT -R. Still no luck.
  7. CarrahaG

    Windows 2008 Server can not access NAS share using UNC path and NETBIO

    Hello kmcferrin The node type is the same on all computers and is set to Hybrid. WINS is not enabled on any of the computers. Also GlobalNames Zones are not used.
  8. CarrahaG

    Windows 2008 Server can not access NAS share using UNC path and NETBIO

    Hello kmcferrin All the computers and NAS are on the same subnet. I know I could add the netbios name in the lmhost file of the Windows 2008 server but I wanted an explanation as to why only this server behaves differently than all the other servers and computers on the same network. We...
  9. CarrahaG

    Windows 2008 Server can not access NAS share using UNC path and NETBIO

    Hi joepc This solution does not help. Also, as I mentioned above, we do not have a problem mapping the share using the IP address in the UNC path. The problem we have is mapping the share using the NETBIOS name. Also, the problem is not domain wide. It is only with one particular...
  10. CarrahaG

    Windows 2008 Server can not access NAS share using UNC path and NETBIO

    Hi joepc This solution does not help. Also, as I mentioned above, we do not have a problem mapping the share using the IP address in the UNC path. The problem we have is mapping the share using the NETBIOS name. Also, the problem is not domain wide. It is only with one particular...
  11. CarrahaG

    Windows 2008 Server can not access NAS share using UNC path and NETBIO

    Hi When I run ping -a on the IP address of the QNAP I get the hostname. When I run nslookup in interactive mode, I get the following: Default Server: Unknown Address: ::1
  12. CarrahaG

    Windows 2008 Server can not access NAS share using UNC path and NETBIO

    Hello We have a Windows Server 2008 R2 that is NOT able to open a share on a NAS using its NETBIOS name. However it CAN open it using the IP address. The NAS and the Windows Server 2008 are both joined to a Windows 2008 domain. There are other computers on the network that are part of the...
  13. CarrahaG

    Can not establish a Windows VPN connection

    Hi, But I cannot connect even via the LAN and the firewall is disabled on the server? I am the administrator of the network and I did not stop remote access on the server.
  14. CarrahaG

    Cannot establish a VPN connection to Windows Server 2003

    Hello I use to be able to connect via Windows VPN to my Windows 2003 Server but something has happened and I can no longer connect. I am trying to make a VPN connection from a Windows XP Pro client on the local LAN (to take our firewall out of the picture) but I keep getting the error...
  15. CarrahaG

    Can not establish a Windows VPN connection

    Hello I use to be able to connect via Windows VPN to my Windows 2003 Server but something has happened and I can no longer connect. I am trying to make a VPN connection from a Windows XP Pro client on the local LAN (to take our firewall out of the picture) but I keep getting the error...
  16. CarrahaG

    Changing the manufacturer friendly name for external USB drive

    Hi No I do not mean the disk label. If you go under the device manager under Disk Drives, you will see the Device Friendly Name. I want to be able to change that friendly name.
  17. CarrahaG

    Changing the manufacturer friendly name for external USB drive

    Hi, Is there a way to modify the manufacturer friendly name for an external USB Seagate Freeagent Go drive? The reason we need to do this is that we are using VMware workstation which requires you to disconnect the external usb drives from the menu when removing them from the guest OS...
  18. CarrahaG

    SQL Expression Fields to retrieve data from Pervasive.SQL database

    Hi LB My report works. I just read about SQL Expressions and wanted to know if I could improve my report performance by using them. The concept of using SQL statements so that the server is able to handle some of the processing by reducing the number of records that the client works with...
  19. CarrahaG

    SQL Expression Fields to retrieve data from Pervasive.SQL database

    My report is taking too long and I want to use a SQL Expression so that the server will only pass the records needed for my crystal report. The problem is that I am not sure if SQL Expressions are designed for reports that are not accessing SQL databases directly. We need to access a...
  20. CarrahaG

    SQL Expression Fields to retrieve data from Pervasive.SQL database

    BTW, In regards to what I have tried before, the answer is not much since I really do not have any documentation on how to work with use the SQL Epxressions Field with a Pervasive.SQL database.

Part and Inventory Search

Back
Top