Search results for query: *

We have a G3 V6 system. Does anybody know how I can increase the quantity of VDN's allowed in our system? Our capacity shows a maximum of 99, we need more. Ron--

I have a database with address, number and street fields. The address field has to contain the full address. The number field needs to contain just the street number. The street field needs to contain the street. The address field already contains the complete address. I need to select the...

I am working on a conversion and I have run into a problem concerning duplicate rows. I ultimately have to insert the data in the table where the conversion is being done into another table. In the new table three fields make up the primary key. Due to various factors the in the conversion...

I need to run a select distinct from query analyzer to update a table. Below is my attempt that did not work. Any ideas? Thanks, Ron-- insert into dbo.AccountZoneTbl0 (acct_cancelcode, AccountNumber, S_ActNbr, System_no, MAS_ZoneID, o_mas_zoneid, fmt, [Description], GroupID...

I have a situation where I have account numbers that contain letters. I need to change the letters to numbers creating an int value. I have several thousand account numbers to change and several different letters to convert. I would like to convert an "A" to 1, "B" to 2, "C" to 3, etc. Any...

I have an interesting situation. We are currently undergoing a conversion from one automation system to another. The new system uses SQL 2000, the old system is a DOS btreive system. We are able to export our btreive data to an Access database then to SQL. However, we have to make several...

Does anybody know if it is possible to install a remote IP phone that will connect to an old v6 G3? Thanks, Ron--

I'm having trouble getting a new network module to work correctly with an older Cisco 2621 router manufactured in 2002. The part number I expected on the card we ordered was NM-4E but I note it is NM-4E= instead. Can anyone confirm if the NM-4E= is compatible with the older Cisco 2600 series...

I have been running an internet server with my own DNS for some time. I have never messed with reverse lookup zones. We are having a problem sending emil to some addresses such any aol address. The error messge we get is a problem with reverse lookup. I have tried several thins to get the...

I have used Access for several years but am new to using ODBC. I have a .asp web page that was written for me that is supposed to read from an Access database. It worked fine on the authors server but I can’t get to work correctly on my server. My server is a Windows 2000 server. I have...

I have been struggling with getting a new 2 span T-1 set up. I have the first span up an running. The DS1 is isdn-pri, the 24 channel is the D channel. The second span provides 24 B channels and uses the D channel of the first span. If I change the signal group as follows: Change Associated...

I need to set up a trunk group with 2 T-1's. The first T-1 used channel 24 as the D channel, the second is just another 24 channels. I currently have trunk group 8 set up with 23 channels. I have another TN-464F in slot 16 of the A cabinet. I'm not sure how to exactly set this up. Any help...

I have a G-3 V6 switch, I have set up a new T-1 PRI. The new PRI is connected to SBC and will provide our local telephone service. We currently are using Nuvox for our local service. I currently have the new PRI up and running and all of our outbound local calls are going out on the new PRI...

I am trying to get a new T-1 PRI set up in my G3si V6 switch. I think I have everything set up correctly but when I status the trunk group I get OOS/FE-PINS-idle on all of the channels. Our providor, SBC says they see the channels are idle. Any ideas as to what I may have wrong? I would...

When I look at the content of a text field that contains multiple lines in Enterprise Manager all I see is <Long Text>. Is there a way to reveal the contents? Thanks, Ron--

I need a transact SQL routine that will allow me to edit (update) an address field. For example if the address in PremiseAddress is 1234 East 1st Avenue Suite 100, I need to edit it to be 1234 E 1st AV Ste 100. As you can see I need to abbreviate East, Avenue and Suite. We are converting data...

I am working on a conversion that starts with a btrieve database. The author of the original database has written a program to convert the data to an Access database which I am importing into my SQL database. The problem I have is that all fields are padded with char(0). If a field has a...

I am a new sql 2000 user/administrator. I am just learning the programming syntax. I am trying to do and insert function to take rows from one table and add them to another table where certain conditions are met. Each of the two tables have an autonumber key field named zipdef_no. I have tried...

I would love to hear the gray market horror stories. I have just recently learned of the Lucent gray market. Does anybody have any actual information concerning Avaya's actions concerning the gray market? Thanks

Hello, I administer a G3si V6 switch. We are a small concern, only 15 employees. We do however have about 750 inbound telephone numbers. Our switch is currently configured for 600 ports and we are approaching that limit. First, we need more ports and Avaya has quoted what I feel is an...