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 Chriss Miller 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: *

  • Users: ncscott
  • Content: Threads
  • Order by date
  1. ncscott

    Re-establishing Transaction Log URGENT

    OK, so here's the story. I administer an e-commerce database. Recently my backup tape drive started to go on the fritz, ejecting every tape about 2 minutes after insertion and throwing cyclic redundancy errors. I figure the tape drive is on its last legs. So I ask the network administrator...
  2. ncscott

    Migrating SQL 2000 queries to 2005

    I have several queries that were part of a DTS package in the old SQL 2000 system. This database is migrating to 2005, and I am having to re-build the function. Mostly it hasn't been a problem, except for a series of SQL query groups that necessarily declare variables. When viewing the query...
  3. ncscott

    usb 2.0 pcmcia orientation issue

    I have a Dell Inspiron 4000 laptop, it has USB 1.1, however the port has stopped working properly, and I would like to upgrade to USB 2.0. Here is my dilemma. The machine has two PCMCIA slots, arranged one on top of the other. I use a Netgear PCMCIA Wireless NIC in one of the slots. Like most...
  4. ncscott

    UNSPSC Version translator

    I have some product data that has the UNSPSC codes from an older version of the UNSPSC code standard. I am trying to translact the existing codes to UNSPSC version 13.3, and the manufacturer has been no help. Does anyone know of a tool or website out there that can assist me with this translation?
  5. ncscott

    Converting catalog files

    While it's not EDI-specific, this seems the most appropriate forum to find advice pertaining to an e-procurement purchasing system. The system I work with is web-based and can use either XML or EDI for document transport. Anyway, my dilemma is pretty simple. The best way I can import a...
  6. ncscott

    Biztalk Server Repository (2002)

    Hey guys. I'm having trouble with a recently-installed Biztalk instance in my development environment. Whenever I try to access WebDav, which is a vital function when trying to create channels, I get an error msg saying that No BizTalk Server repository was found on...
  7. ncscott

    Conditional Mapping Question

    Okay, I'm pretty new to Biztalk mapping. I am creating a map to translate purchase orders from one format to another. The Source document uses a single element for addresses, with the attribute "type", which will have a value of either "ShipTo" or "BillTo" depending on which address it is...
  8. ncscott

    Access Update Query from VB6

    I have a form written in VB6 that, among other things, accepts a value for the variable "varRackLocation" and one for "varSerialNumber" and then is supposed to perform the following database query: UPDATE [tablename] SET [RackLocation] = varRackLocation where [SerialNumber] = varSerialNumber...
  9. ncscott

    Setting field focus

    I have a table-linked form I've created in VB 6. Here's what I'm trying to do. We have: Field 1 Field 2 Field 3 Here is the desired behavior. Upon form activation, focus goes to field 2. A value is entered. If this value matches one of a list of values, that value is entered in field 1...
  10. ncscott

    McAfee Services not starting

    I have two servers, both Compaq D380 G3's running 2000 Server. Both have McAfee VirusScan. Currently I am not able to start the McShield service on either machine. I can start the Network Associates Task Manager, but it drops off after a few minutes. Whatever is going on it's happening to two...
  11. ncscott

    Accessing Tables across databases

    I have two databases (in the same SQL instance), and I am trying to access a table in database A from a stored procedure which resides on database B. The format of the query is simply: select field1, field2, field3 from DatabaseB..Tablename I have this query working find on my local...
  12. ncscott

    Syntax error converting datetime from binary/varbinary string.

    I have a procedure which runs fine on our old SQL 7 database but which refuses to run on our new SQL 2000 database. This proc involves selecting a timestamp value out of a table that is a binary, and inserting it to a column in a temp table that is declared as a datetime. When I run the proc...
  13. ncscott

    IDKey changes in SQL 2000?

    My company has recently updated out ERP and databases from SQL 7.0 to SQL 2000. I am having trouble with a stored procedure which worked under the old platform. The proc populated a table which is used for reporting. It involves an INSERT <table> SELECT () The select statement...
  14. ncscott

    Crystal 8.0 and 9.0 runtimes coexist?

    Does anyone know if Crystal Reports 8.0 runtimes and Crystal Enterprise 9.0 runtimes can coexists on the same server? We have StarProjects running on the same server as our Crystal 9.0 APS, and Star installs a Crystal 8.0 runtime.
  15. ncscott

    SQL Server with multiple processors

    We have a somewhat odd situation. We have a test environment for our new up-and-coming ERP. The ERP has been running and being tweaked on this system for approx. 6 months, but now it's becoming apparent that we need more space for the final work before rollout. The existing box has four 18GB...
  16. ncscott

    Help with error

    I'm relatively new to ASP programming. I have a user login page that is throwing an error to the browser which reads, Microsoft VBScript compilation error '800a03f6' Expected 'End' /*******.asp, line 83 This error is being thrown on page load, as opposed to when one of the buttons is...
  17. ncscott

    Enabling full-text search

    When SQL 2000 was installed, full-text search was not enabled. Is there any way to enable it without reinstalling?
  18. ncscott

    Problem with remote backup

    Here's my situation. I have a database server (SQL) and a web server. Backup Exec 9.0 resides on the database server. The database server is located in the &quot;inside&quot; section of the network, with all access controlled through a Checkpoint firewall. The web server is in a DMZ, with a...
  19. ncscott

    Communication ports used by Remote Agent

    Can anyone tell me what ports and services are used by the Backup Exec 9.0 Remote Agent for Windows? One of the servers I am backing up is seperated from the server which houses Backup Exec by a firewall and I need to know what ports and services to allow through to allow the Remote Agent to work.
  20. ncscott

    Capabilities of SQL 2000 Personal Edition

    I have a soon-to-be-production environment of a Web/Application Server and a database server running SQL 2000 Standard Edition. I am looking to create a test environment. I am wondering if I could use SQL Personal Edition as the database for the test environment. Transaction volume would be...

Part and Inventory Search

Back
Top