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!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TonyG

  1. TonyG

    What do I load ?

    Just to let everybody know, I found the answer in a reply from another forum group. Here it is: Dim node As XmlNode = proxy.RetrieveArchivedTrips(strDate, endDate) Dim doc As XmlDocument = node.OwnerDocument doc.AppendChild(node) Thanks for the replies from everybody. Tony
  2. TonyG

    What do I load ?

    I'm sorry Tom. I'll try to give whatever information i can to explain what i want to do. I am trying to use the data returned by this function which is has a type of system.xml.xmlnode and was created by the VS.NET Add web service function as you can see: '<remarks/>...
  3. TonyG

    What do I load ?

    I'm not sure of what you are asking. Do you want me to post the wsdl ? or maybe the soap request information ? I'm still not sure of why you cannot visit that site. I go there all the time and never had any kind of a certificate notice popping up. Thanks, Tony
  4. TonyG

    What do I load ?

    Hello Tsuji. I'm not sure of what it is you cannot trust. What is a priori ? Thanks, Tony
  5. TonyG

    What do I load ?

    Hello. I'm trying to develop a web comsuming client using VS.NET 2003(VB), .NET Framework 1.1.4322, ASP.NET 1.1.4322, WSE2.0 on a WinXP Pro Sp2 comuter. If i comsume this web service: https://xatanet.net/xatanetwebservice/tripexportservice.asmx and do this operation: RetrieveArchivedTrips...
  6. TonyG

    Where string takes forever when using dates only

    Hello MichaelRed. I'm sorry for that. I'm used to other forum areas on the internet that allow posting a question to multiple forums. These forums provide a great way to learn and understand specific products and i appreciate everybody that contributes. I have used these forums many times...
  7. TonyG

    Where string takes forever when using dates only

    Hello Crowley16. Thanks for your reply. I guess i was really looking for suggestions on how to improve the speed of the second, dates only, query. I received a suggestion from someone to use the "EXISTS" clause instead of the "IN" clause, but i don't know how to do that. Any help would be...
  8. TonyG

    Where string takes forever when using dates only

    Hello. When i use the following string in a "DoCmd.OpenReport stDocName, acViewPreview, , strWhere", it gives me the report i want: "[COMPANY NAME] = 'A V H INTERIORS 4061' AND TempStatus.JOBNO In (SELECT JOBNO FROM TempStatus WHERE WORKSTATION= '#2- RECEIVED' AND [TempStatus].TIMESTAMP Between...
  9. TonyG

    Where string takes forever when using dates only

    Hello. When i use the following string in a "DoCmd.OpenReport stDocName, acViewPreview, , strWhere", it gives me the report i want: "[COMPANY NAME] = 'A V H INTERIORS 4061' AND TempStatus.JOBNO In (SELECT JOBNO FROM TempStatus WHERE WORKSTATION= '#2- RECEIVED' AND [TempStatus].TIMESTAMP Between...
  10. TonyG

    How to get needed records based on date of one record

    Hello PH. Thanks for your reply. I tried your suggestion and it yields an empty report. Thanks, Tony
  11. TonyG

    How to get needed records based on date of one record

    Hello. We have a database used just for reporting with status records that have TIMESTAMP and WORKSTATION fields as in: TempStatusRecNo TIMESTAMP WORKSTATION JOBNO 2091705 4/22/2004 6:58:32 AM #4- IN WORK 2803 2091703 4/22/2004 6:55:39 AM #2-...
  12. TonyG

    Use to be able to VPN/RDP. After installing SBS2003, can only VPN

    Hello. If i plug my computer at home (WIN XP Pro SP2) directly into the cable modem, i can VPN and RDP to my office without a problem. Office setup: (SBS2000 SBS2000 server, 2 nics, Zyxel Prestige 650 ADSL Modem, Zyxel Zywall 10 firewall 192.168.1.1, External nic: 192.168.1.2, Internal nic...
  13. TonyG

    Cannot connect to ODBC data source

    Mirtheil, Here is the first part of the log that i saved. =============================================== Database consistency test results. Test was run on: Friday, April 22, 2005 12:48:30 PM DSN: CPDATA Database name: CPDATA Database Location: \\COMPEXSERVER\SYN\CP758\DEMO2...
  14. TonyG

    Cannot connect to ODBC data source

    The failures just said "Failed" under the results column for all files except the "X$" files. Only one "X$" file failed, the "X$View" file failed. How do i use Managed Provider or ODBC instead of OLEDB ? Thanks, Tony
  15. TonyG

    Cannot create ASP.NET Web Application

    Thanks for this link Veep. It helped a lot. But now i have another issue which i will try to find help for in the knowledge bases. Thanks, Tony

Part and Inventory Search

Back
Top