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!

Register Log in
  • Congratulations derfloh 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: *

  1. mdacoron

    sonicwall bgp

    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?
  2. mdacoron

    sonicwall bgp

    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...
  3. mdacoron

    multilink ppp two t1 connections with two ips

    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...
  4. mdacoron

    multilink ppp two t1 connections with two ips

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

    multilink ppp two t1 connections with two ips

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

    multilink ppp two t1 connections with two ips

    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...
  7. mdacoron

    multilink ppp two t1 connections with two ips

    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...
  8. mdacoron

    sql update two databases on same server

    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...
  9. mdacoron

    sql update two databases on same server

    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.
  10. mdacoron

    sql update two databases on same server

    I think that worked thanks!!!
  11. mdacoron

    sql update two databases on same server

    yes i need to update the ae_dt1 sorry
  12. mdacoron

    sql update two databases on same server

    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...
  13. mdacoron

    sql update two databases on same server

    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.
  14. mdacoron

    sql update two databases on same server

    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...
  15. mdacoron

    sql update two databases on same server

    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>...
  16. mdacoron

    sql update two databases on same server

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

    sql update two databases on same server

    where do I actually type in this statement?
  18. mdacoron

    sql update two databases on same server

    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.
  19. mdacoron

    sql update two databases on same server

    yes
  20. mdacoron

    sql update two databases on same server

    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...

Part and Inventory Search

Back
Top