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

    VB App Puzzler!

    Hey, Thanks for your help on this! We fixed it. It turned out that the printer port flow control was set to "None". We changed this to "Hardware" and all was fine! Clive
  2. cstrong

    VB App Puzzler!

    Hey, Were using API calls. OpenPrinter, WritePrinter, etc using the winspool.drv library. Clive
  3. cstrong

    VB App Puzzler!

    Hey, Hope you all got your thinking caps on! This one has me stumped!! We have a freight application that prints out UPS labels. If you send only one or two boxes (1 or 2 labels) it is fine. If you send three boxes (3 labels) you get four labels. The label number (1 of 3, 2 of 3 etc) goes all...
  4. cstrong

    Inet Applications

    Hi all, We have an Inet Application which will not work on Win NT 4.0 (SP 6). It was developed in VB (SP 5) We developed it in Win2k and it works fine. However when we ran it in NT, the program executes but the process/task is not killed off. When run from VB on the NT machine, after...
  5. cstrong

    Printing to multiple printers

    Hi all, We have an application in development here that in some instances needs to print to two printers. Each time a shipment is confirmed, a Shipper Label is printed on the default label printer. If the Shipment is outside of the EEC, we have to print an invoice for the shipper to the laser...
  6. cstrong

    VB Application as a Service

    Hello, How would I go about creating a VB app, that can start as a service within Windows NT? Would this app be able to have forms?? Thanks Clive
  7. cstrong

    AS400 and SQL

    Hi, To give you an example of how our DTS works... For our ordering system, we download all of the day's current orders from the system. This takes about 1-2 minutes to download. This is downloaded into a tempory table within the database. We then insert into the main order table only the...
  8. cstrong

    Developing for a Clustered Environment

    Hello All, Hopefully this will be a simple question for you all. We are moving our stand alone applications server to a clustered server solution. One of the consultants mentioned to my manager that we may have to review some of our VB code to ensure there will be no problems with it running...
  9. cstrong

    AS400 and SQL

    Hey Dvannoy, You can create a Linked Server to an AS400 or another way I have done this is to create a DTS object that contains an ActiveX Object using VBScript to connect to the AS400 and pull data into the tables on our SQL Server. Clive
  10. cstrong

    SQLBase => SQL Server

    Is there no other ODBC driver which will allow me to go direct from SQL Server to SQLBase without using MS Access in between? Thanks, Clive
  11. cstrong

    SQL Server and VB

    Hey, I use Hitchhikers Guide to Visual Basic 6.0 and SQL Server - Sixth Edition (Microsoft Press). Covers DAO, RDO, ADO, Design, SQL Server Tools ISBN 1-57231-848-1 Clive
  12. cstrong

    SQLBase => SQL Server

    Hi all, Have any of you had any experience of importing data from and SQLBase DB into a SQL Server? At present I cannot see a way to do this as I have installed SQLBase OLE DB 1.0.0 (that I downloaded from www.centurasoft.com) onto the SQL Server but it fails to register the sqlbaseoledb.dll...
  13. cstrong

    T-SQL Query - NULL's

    Hi all, Quick query problem... I need to query the table to find if there are any partial shipments. If there is a partial shipment, then there will be no shipping name assigned (the field will contain a NULL). So, if there are 10 lines on an order and 8 are picked, the 8 lines will have a...
  14. cstrong

    Macro's & Linked Tables

    Hi all, We have a bit of a problem here. We have a macine on the network which has Access on it. Within the Access database, there is a linked ODBC connection to an SQLBase database. Now, we need the data from SQLBase into our SQL Server. Normally, I'd set up a DTS and insert rows to my SQL...
  15. cstrong

    IP Address of connection

    Hi, Is it possible to get the connections IP address in the same was as you can get the computer name using the HOST_NAME() function? Is there a function in SQL Server for this or does anyone have some code to obtain this? Thanks in advance, Clive
  16. cstrong

    ASP & SQL Server Stored Procedures

    Hey all, OK, we have some stored procedures in one of our test databases which are called from an ASP page on our intranet. The sp is only a simple INSERT statement and only inserts one row each time the SP is called. This works just fine from Query Analyser. However, when called from a ASP...
  17. cstrong

    ASP Pages & Stored Procedures

    Hey all, OK, we have some stored procedures in one of our test databases which are called from an ASP page on our intranet. The sp is only a simple INSERT statement and only inserts one row each time the SP is called. This works just fine from Query Analyser. However, when called from a ASP...
  18. cstrong

    Automation of SQL Scripts

    Hi, Yes, I know how to generate an SQL Script for the database. What I would like to do, is on a weekly basis, create a Database Script for each DB (Mangement are requesting this). What I don't want to do is manually generate a script for each DB each week! I was wondering if I could...
  19. cstrong

    Automation of SQL Scripts

    Hi, Is it possible to run a set of commands to automate the generation of SQL Scripts for a database? I would be scripting every object within the Database. Kind Regards Clive Strong
  20. cstrong

    Update Query....Ignored???

    Hello all, I have a problem within my code, and as yet, cannot see any possible bugs within the sections of code in question. Here's the setup to give you an idea as to what I am doing. Pick Tickets are printed and sent down to the warehouse. The warehouse staff have RF Scanners, so they...

Part and Inventory Search

Back
Top