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...
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...
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...
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?
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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...
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 "inside" section of the network, with all access controlled through a Checkpoint firewall. The web server is in a DMZ, with a...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.