Search results for query: *

Was wondering if someone could point me to documentation or can straighten me out on setting this appliance up in dual wan mode. Reading the user guide it is not clear the best way to configure our ISPs routers. It appears that we need to enable bridging on the routers and re-create the...

Is anybody using this in a SQL2005/Win2003 multi-domain config? I am looking to roll out and run maintenance plan jobs on 15+ stand alone servers on minimum budget. The plans are basic backups and DBCC and this seems like the way to go. I have been though the BOL and manage to connect two...

I found one of my user's machines with the AV no longer installed. No program, reg entries or residual program folders. Is there a log that shows what and when a program has been uninstalled? They are WinXP SP2. Thanks

I have run into a situation where the user has reduced the Expect cost of an item in order to break it out onto a another line. The change shows correctly on the Purchase Order but I found that at the time of receiving the Unit Cost still shows as the original amount. Looking at the Line and...

I have a Partner Endeavor with a processor and 3 206s I am getting a high pitched noise. I have gone as far as pulling all the lines and ext. I have pulled all the 206s in a variety of combinations I checked the outside lines and there is no noise on them. I have changes the power source...

This is kind of long, but I needed to sound this out... About a year ago with the help of our VAR we migrated from NT/SQL7 to Win2003/SQL2000. We had one show stopping issue where they forgot about having to update the macsql.cfg. Corrected and since then the system has been running about as...

If this is posted in the wrong forum please let me know. We have 5 locations currently tied together with spoke and hub Frame that I manage with Pots lines for voice. We are looking at possibly going to a managed VPN solution with integrated voice and we are down to two providers or the...

I am looking to change the default Ship cut off date(OEREQDAT) and text in the Reference field (OE0112CG) and I am unable to figure out a way to access these screens to invoke the VBA editor. There are a couple of screens that I would like to get if they are available to me. Any help would...

I posted this in the SQL forum but is more appropriate for this forum. I am working on recreating the check history report in Crystal to show freight cost per voucher. Using the apDisFil and apOpnHst tables I am able to return what I need except for lines that do not have a freight charge. Once...

I am working on recreating the check history report in Crystal to show freight cost per voucher. Using the apDisFil and apOpnHst tables I am able to return what I need except for lines that do not have a freight charge. Once I get past this I will add the apVenFil back in to complete the report...

I am using MS Query to import data from MSSQL 2000 into a Excel 2003 spreadsheet that I am going to use in a Pivot Table. The problem I am having is that in order to pull the data that I need, I have to use a few aliases that do not come over in the data import process. The problem could be...

I am working on getting Macola client installed and working on a Windows 2003 server. I have tried installing the client in every way I could think of or read about how to by either installing directly from the mapped drive, add and remove programs and even copied the macsql dir to the server...

Does anyone happen to know why the data in the user defined fields (1-5) in the OEORDLIN table would not transfer over to the POORDLIN when a PO is generated? It would be convenient if it did for a project I am working on. We are using Peak/Techtura/Exact OE to PO link. Could this be the...

I have text file it is formatted as follows: PN=1-DIM-CHANGE-T MC= QT=7 PD=1-DIMENSION CHANGE TALL PL=250.00 PN= MC= QT=1 PD=1 TUB SINK PL=0.00 Every PN to PL is a record. I would like to strip away the PD=, PL= etc. and simply insert everything after into the SQL 2000 server. I...

I am trying to pass a list of values (1,2,3,4,5) to a report from a .cfm page. I setup the report with a parameter field that will accept multiple values. The problem I am having is that SQL statement uses Or instead of In. select this from MyTable where this = 1 or this = 2 instead of...

I am trying to do something that seems simple. I want to parse a int field. It always contains 8 characters. The field is used to hold a date yyyymmdd I need to pull the characters 5 and 6. I can pull the first 4 (Left()) and last 2 (Right()) but the middle 2? Mid() would be the perfect match...

I have an 800 and Sales floor ringing to an Ext. The 800 number is ringing to line 8 and to Ext. 23. This Ext is also the main Ext for the sales floor. I need to put an external ringer on this extension. I picked up a GTE Bell/Tone ringer. I have tried all conceivable combinations, none of...

I have a R5 system that is not retaining VM messages. Everything works to that point. I have created new MB and tried to leave messages and intermittently it would retain 1 and not another, more not take the message rather then take it. The other Ext. on the system are all experiencing the same...

I believe I had read a thread here that I cannot for the life of me find now. It contained the list of tables in MS-SQL that get hit during Order Entry. It was for a simple entry (if there is a thing), not pulling from stock. I thought it was OEORDHR, OEORDLIN and OELINCMT plus one or two...