Home NetLinx Studio

i!-Internet Database Plus

John_GloveJohn_Glove Junior MemberPosts: 95
hi together.
i have some troubles with the internet inside application "database plus".
i try it on 2 different webserver's (IIS), with the same problem.
on the diagnostics i receive always "error 404 side not found"
the software makes correct the online connection to the webserver. i make the needed files with the included amx db-wizard, all directories and path's are correct, i can also connect to the website with my webbrowser and become the correct
syntax back (like on the help-file).
is there someone who can help me or have a solution?

thanks a lot
John

Comments

  • ColzieColzie Senior Member Posts: 470
    Bump.

    I am trying to use i-Database Plus as well and am getting the same result. Anyone have any ideas?

    Thanks!
  • HARMAN_icraigieHARMAN_icraigie Technical Trainer II, Harman Professional University Posts: 563
    If you are using XP, the firewall needs to be turned off or the appropriate ports need to be opened.

    Thanks
    Ian
  • ColzieColzie Senior Member Posts: 470
    Even after disabling XP's firewall I get the same result. Here is the debug text. Thanks for any help!

    Line 1 :: ADDING TO QUE: SELECT%20*%20FROM%20%5BEmployees%5D - 14:24:32
    Line 2 :: Memory Available = 10365592 <10208> - 14:24:32
    Line 3 :: Connected Successfully - 14:24:32
    Line 4 :: Memory Available = 10349552 <16040> - 14:24:32
    Line 5 :: OPENING CONNECTION TO localhost:80 ON LOCAL3 - 14:24:32
    Line 6 :: CIpEvent::OnLine 0:3:1 - 14:24:32
    Line 7 :: BUILD HEADER FOR LOCAL PORT 3 - 14:24:32
    Line 8 :: HEADER=GET /employees.asp?hdr=all&sql=SELECT%20*%20FROM%20%5BEmployees%5D&ps=100&start=1&pnl=1 HTTP/1.0$0D$0AUser-Agent: Mozilla - 14:24:32
    Line 9 :: Exiting TCP Read thread - closing this socket for local port 3 - 14:24:32
    Line 10 :: CIpEvent::OffLine 0:3:1 - 14:24:32
    Line 11 :: DB_GET_HTTP_HEADERS FINISHED PROCESSING - 14:24:32
    Line 12 :: HTTP ERROR (404): Not Found - 14:24:32
    Line 13 :: Document Error: Site or Page Not Found - 14:24:32
    Line 14 :: $09$09Access Error: Site or Page Not Found - 14:24:32
    Line 15 :: $09$09Cannot open URL - 14:24:32
    Line 16 :: PROCESS HEADER FOR LOCAL PORT 3; HTTP CODE=404 - 14:24:32
    Line 17 :: ACK QUE FOR LOCAL 3 - 14:24:32
  • DHawthorneDHawthorne Old Timer Posts: 4,584
    Path issue?

    I see the GET command is referencing a relative path, I would try changing the setup to reference absolutes and see what that does for you. That, or there is an environment variable that is supposed to be pre-pending a domain setting and it isn't set.
  • ColzieColzie Senior Member Posts: 470
    Path issue indeed. The wizard created this:

    DB_INIT_CLIENT
    (sDB_CLIENT,dvDB_CLIENT,'localhost',80,'/employees.asp')

    when it should have been
    DB_INIT_CLIENT
    (sDB_CLIENT,dvDB_CLIENT,'172.21.1.128',80,'/employees.asp')

    Thanks for steering me in the right direction!
  • ColzieColzie Senior Member Posts: 470
    Slight correction...the wizard used localhost because that is what I entered into the wizard. Confusion on my part!
Sign In or Register to comment.