Search results for query: *

If I setup the sonicwall to have another dmz address using another port of the switch then plugged into the x4 port and setup that ip to be the new secondary ip on the cisco, would that work?

I have a sonicwall pro 4060. I am trying to setup some ip addresses on it. I have a x0 as lan, x1 as wan, x2 as dmz and x3 as another wan, and x5 as hardware failover. I have one internet connected to x1 and another on x3. I am trying to setup bgp on my network. I have a cisco router hooked up...

right now we have a current connection that is a /27 ip address that is connected by 2 t1 lines. we are given from our provider a new ip which is a /24. I want to test the connection before doing a move to the /24 ip addresses so that our webservers that are in use now dont go down if we were to...

if we have two ethernet ports can i setup the other ethernet port to use the new address?

if I do that how would I setup the ethernet interface to use that new ip address?

Can I do something like this along with the current settings? interface Multilink2 ip address xxx.xxx.xxx.xxx 255.255.255.252 no cdp enable ppp multilink ppp multilink fragment disable ppp multilink group 2 ! interface FastEthernet0/0 ip address xxx.xxx.xxx.xxx 255.255.255.224 duplex...

Hey Guys, I wanted to know if anybody know if I can multilink two ppp connections that are currently setup on one ip address to add on another ip address? Right now we have an ip setup and we are trying to move to bgp and need to change the ip to a /24. They have given us the new ip to setup...

Update ae_dt1 Set field1 = h.Invoice, field2 = h.[Order #], field3 = h.[Cust #], field4 = h.[Cust Name], field5 = h.[Ship To #], field6 = h.[Ship To Name], field7 = h.[Date], field8 = h.[Total] From ae_dt1 a Inner Join Kfx.dbo.HarvestImport h ON...

i did notice after running it that the date column added << and >> on the field so it started like 08/08/2008 and then changed it to <<08/08/2008>>. Any reason why? its good its only like 800 records so i can fix that.

I think that worked thanks!!!

yes i need to update the ae_dt1 sorry

here is an example ae_dt1 invoice cust# custname shipto# shiptoname date total 12345 12 tes1 1 test1 080808 124.45 14567 13 tes2 2 test2 080908 122.11 13448 14 tes3 3 test3 081008 654.34 HarvestImport...

I just ran it and gave me 51,xxx row updated but it didnt update some of the info there. I have some rows that came up blank for all the columns except for invoice #. I am actually trying to only update rows that show a column in the AX database in the ae_dt1 table with a value of 0.

I typed this in and get error: Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'Order'. Update ae_dt1 Set a.field1 = h.Invoice, a.field2 = h.Order #, a.field3 = h.Cust #, a.field4 = h.Cust Name, a.field5 = h.Ship To #, a.field6 = h.Ship To Name...

Update ae_dt1 Set <your col> = <some value>, <your col2> = <some value2> --, ... more cols here From ae_dt1 a Inner Join Kfx.<table owner>.HarvestImport h ON a.InvoiceNumber = h.InvoiceNumber on this coding part what do i type in for the Set <your col1> = <some value>...

is there a way to copy the database to another newly created database that I can do the test on?

where do I actually type in this statement?

The only thing that I can thing of also is that the AX database table columns are called field1, field2, field3 and so on. They are not the same names as the columns in Kfx with actual names to the columns.

yes

ok The database Kfx has a table called HarvestImport. The contents of this table are Cust #, Cust Name, Ship To #, Ship To Name, Date, Invoice, Order # and Total. The other database is called AX and has a table called ae_dt1. The contents of this table are pretty much the same as the...