Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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