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

    Map Drive

    I have an ASP page that allows user to browse to a file on local machine or mapped drive, then open it. If the file is on local c:\, ASP will try to look for the c:\ on server, instead of c:\ on user machine. How can I fix it ?
  2. HaveTrouble

    Global Database

    Each customer has one database in my system. Customer can login from a front-end ASP site to view data in their database. Now I want to setup a "super login" who can view the data in all databases. Some of the reports will need to pull the data from multiple databases. What's the best way to...
  3. HaveTrouble

    Image manipulation

    Is there a way to create a Tiff image using visual basic 6.0 ? I have a database of sales order information. I want to create an order sheet for each order and save it as tiff image on my server. How can this be done ?
  4. HaveTrouble

    auto-update date/time when row is updated

    I have a date/time field in one table. Is there a way to make this date/time field auto-updated to current date/time whenever the row is updated ? I have queries everywhere to update this table so change the query to update date/time field is not an option for me. Please help.
  5. HaveTrouble

    Table size limit

    Is there a limit of how many rows of data can be in a table ? We have a web form with SQL statement to insert data directly to a table. It produces timeout error once a while after table reaches 300,000+ rows. Is it because the table size reaches the limit ?
  6. HaveTrouble

    Form validation

    What's the best way to do dynamic format validation ? I have an ASP (page1.asp) that can be accessed by multiple clients and a setting page for clients to define which fields on page1.asp is mandatory. What's the best way to do this kind of form validation ?
  7. HaveTrouble

    Call ASP for processing and return value

    I have an ASP page (page1.asp) to gather information to be passed to a 3rd party JSP(process.jsp) page for data processing. 3rd party will return value to my ASP page (page2.asp). Is there a way I can create a DLL to pass all data to page1.asp for formatting and process everything, and then...
  8. HaveTrouble

    SQL event log

    Everytime an SQL statement runs on a table, did SQL log it somewhere ? If yes, how can I view the log ?
  9. HaveTrouble

    SQL performing question

    I want to pull a report that will join multiple tables (around 4 tables. some from same database and some from different databases) and perform some simple calculation such as field A * field B. Say there are 50,000 entries in the main table. Which way is the most efficient way to pull report...
  10. HaveTrouble

    include file question

    My web folder has 3 subfolders - common\ and customer\ and vendor\. I have 2 invoice.asp pages, one in customer\ and one in vendor\ which looks like: <!-- include file="format.asp" --> <!-- include virtual="\common\invoice.asp" --> <!-- include file="addbottom.asp" --> invoice.asp has a form...
  11. HaveTrouble

    Include file problem

    I have a page (main.asp) in root folder that will call a page in another folder. The root folder page looks like : <!-- include file="format.asp" --> <!-- include virtual="\common\invoice.asp" --> <!-- include file="addbottom.asp" --> \Common\invoice.asp is a form and will be submitted to...
  12. HaveTrouble

    include file

    My website has 2 types of user setup - customer and seller. My server has 1 folder with all ASP available to customer and 1 folder for seller. There are some pages (view invoice) common to both users that I wish to put into a common folder so I only keep 1 source code. Customer and seller can...
  13. HaveTrouble

    Call DTS from ASP

    I've created a DLL that will initiate DTS, then have a ASP to call the DLL. The DLL is tested fine. However, when I run the ASP, it kept having "Invalid class string" error. What could be the problem ?
  14. HaveTrouble

    DTS global variables question

    I try to create a DTS package that will export data from several tables into a coma delimiter file. What I did is create a connection to database, then a destination file object, then create a transform data task between the 2 objects. The transform data task will execute a stored procedure to...
  15. HaveTrouble

    Send email

    What's the best way to send email from VB 6.0 ? I tried CDO but it won't work if there is attachment with file size > 4M. I tried outlook but it works in 1 server but not the other. Below are the codes for outlook. It errors out in .send: Set objMail = appOutlook.CreateItem(0) objMail.To...
  16. HaveTrouble

    SQL Join query question

    I have 3 tables to join together. Table 1 has 1 row (always 1 row), table 2 has 2 and table 3 has 3. Instead of producing 6 rows, is it possible to produce only 3 rows ? eg. table 1 inv=123 table 2 inv=123 item=1 inv=123 item=2 table 3 inv=123 date=5/12/03 inv=123 date=5/13/03...
  17. HaveTrouble

    Initiate VB/DLL from ASP

    My current ASP is calling DLL (written in VB6) and return confirmation page after DLL finished processing. DLL will be sending email with information requested. Sometimes DLL is taking long time to process and I don't want user to wait forever. Is there a way for ASP to initiate and pass...
  18. HaveTrouble

    EXE Question

    can EXE and DLL developed in VB6.0 run on machine (windows) without full VB installation ?
  19. HaveTrouble

    Permission Denied when recompile DLL

    I kept getting permission denied error when recompile DLL. This DLL is called from an ASP page. I tried remove DLL from component services, and click "Unload" button on website property in IIS but none of them work. The only thing that seems to work is reboot the server. Can someone help ?
  20. HaveTrouble

    VB Interface to Printronix printer

    Anyone has experience in installing driver and developing interface to print to this printer from windows application ?

Part and Inventory Search

Back
Top