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!

Search results for query: *

  • Users: TonyG
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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-...
  5. 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...
  6. TonyG

    Cannot create ASP.NET Web Application

    Hello, I have tried the VB walkthrough of "Creating a Web Application Using Visual C# or Visual Basic" in VS.net 2003 Enterprise Architect. When attempting to create the new project, i get a message that says "The Web server reported the following error when attempting to create or open the...
  7. TonyG

    Cannot connect to ODBC data source

    Hello. I'm trying to connect to a newly created Pervasive ODBC Engine Interface Data Source(called CPDATA) in Visual Studio.Net 2003. In the Data Link Properties dialog, On the Provider tab, I choose "Pervasive SQL V8 OLE DB Provider" On the Connection tab, I enter Data Source=CPDATA...
  8. TonyG

    SDK 8.5 VB tutorial yields no data

    Hello. I'm trying to follow the Pervasive SDK 8.5 tutorial "Using Microsoft Visual Basic with Pervasive data". I'm using VB6.0(SP5) and when i get to the point where i click the start button to run the program(Lesson 2), it doesn't display any data. Any help would be greatly appreciated...
  9. TonyG

    COBOL Link error 2029 with IBM Visualage COBOL

    Hello. I'm trying to compile and link the COBOL sample program provided by Pervasive SDK 8.5 using IBM Visualage COBOL 3.0.7. I get a link error "error LNK2029: "_BTRV@28" : unresolved external". It's a very simple program with five "CALL"s to "_BTRV" and a few moves and displays as you can...
  10. TonyG

    COBOL Link error 2029 with IBM VA COBOL

    Hello. I'm trying to compile and link the COBOL sample program provided by Pervasive SDK 8.5 using IBM Visualage COBOL 3.0.7. I get a link error "error LNK2029: "_BTRV@28" : unresolved external". It's a very simple program with five "CALL"s to "_BTRV" and a few moves and displays as you can...
  11. TonyG

    Can't reinstall Visualage COBOL 3.0.7

    Hello, In all my efforts to figure out my ODBC problem, I uninstalled (using control panel add/remove programs) my Visualage COBOL 3.0.7 and tried to reinstall it. Now it wont reinstall and i can't figure out why. When i attempt to reinstall it, i get the "Modify, repair or remove the...
  12. TonyG

    Visualage COBOL 3.0.7 ODBC sample link error

    When i try to build the ODBC sample i got with VACOBOL 3.0.7, i get link errors of : error LNK2029: _SQLError@32 : unresolved external error LNK2029: _SQLFreeEnv@4 : unresolved external error LNK2029: _SQLConnect@28 : unresolved external error LNK2029: _SQLAllocEnv@4 : unresolved external error...
  13. TonyG

    Looking for Embedded SQL for COBOL Toolkit

    Does anybody know where i can find "Microsoft Embedded SQL for COBOL Programmer's Reference" or "Microsoft Embedded SQL for COBOL Programmer's Toolkit" ? I have Microsoft COBOL 5.0 and MicroFocus COBOL 3.4 and would like to access SQL databases from COBOL. I've tried eBay...
  14. TonyG

    COBOL SQL error trapping question

    Is there a way to trap SQL errors in a Fujitsu Net COBOL for Windows program ? When i use the following code, it compiles and executes OK. If i change "Default" to something like ":DefaultX" and put ":DefaultX" in the DECLARE section, it compiles OK, but when i...
  15. TonyG

    COBOL SQL not giving results expected

    When i use the following SQL statement with START-REG-NO = "1 " and END-REG-NO = "2 ", then when i do the FETCH, i get all of the EVENT_ID's in the PS_RGY table including event id "100000 ". Even if i replace START-REG-NO and END-REG-NO with...
  16. TonyG

    Calculate UPC-E barcode check digit

    Does anybody know how to calculate a check digit for a six digit UPC-E bar code ? I tried several algorithms from various sources and cannot come up with the right check digit. If you use a product that has a UPC-E of "0 872730 9" (the '0' being the normal bar code type for this...
  17. TonyG

    Will FJ Net COBOL for Win read MicroFocus indexed files

    Hello, Does anybody know if Fujitsu Net COBOL for Windows version 7 will read MicroFocus indexed files ? Any help appreciated. Thanks, Tony
  18. TonyG

    Record is too large error during import

    Hello, Trying to import tables from an ODBC connection and receive the following error. Record is too large. (Error 3047) You defined or imported a table with records larger than 2K. This error occurs when you enter data into the record — not when you define the table structure. Redefine the...
  19. TonyG

    How to set Primary/Foreign keys & Referential Integrity

    Hello, I'm working on an AccessXP program that uses externally linked tables thru ODBC from Pervasive.SQL 2000i. The access program runs on a workstation attached to a Netware 6 server. The data resides on the server. When it runs, it goes for over 24 hours and never finishes. We have to...
  20. TonyG

    How to speed up program

    I'm having a problem with an AccessXP program using externally linked tables thru ODBC. The program works fine with a small amount of test data in the tables(couple hundred records in each table). When i attempt to use it on live client data, it runs for over 24 hours and never finishes. We...

Part and Inventory Search

Back
Top