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 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: *

  1. bnhcomputing

    Response.BinaryWrite Issue

    THANKS, the typos were the problem. Now that I got that working, I was hoping I could avoid the need to right the file altogether. <---Code-----> cn.Open application("dataconn") rs.Open "SELECT TOP 1 DocID, Doc_IMG, DocumentName FROM documents",cn,2,3 mydocument = rs("DocumentName") myBuffer =...
  2. bnhcomputing

    Response.BinaryWrite Issue

    Same result, regardless what content type I use. Additionaly, what content type would you have for say (Autocad, paradox, word perfect, dll, tubo tax .tax files) these are just a few, there are thousands out there. -- bnhcomputing
  3. bnhcomputing

    display a word document from sql server

    I have the same exact problem. I even tried directly streaming from a file. The source DOC is valid, the destination is twice(2) the size, and all junked up as described.
  4. bnhcomputing

    Response.BinaryWrite Issue

    <%@ Language=VBScript %> <% Response.Buffer=true Response.clear set st = server.CreateObject (adodb.strem") Response.ContentType = "application/unknown" Response.Addheader "ContentType", "application/unknown" Response.Addheader "Content-Disposition", "inline; filename=test.doc" st.open...
  5. bnhcomputing

    Installing VB 6 Application Question

    When VB6 or a portion thereof is installed, it potentially updates certain DLL’s that Microsoft considers operating system specific. Given this, I would expect the application to behave radically or even fail without the reboot. Another option that comes to mind, although I have not tested...
  6. bnhcomputing

    Relationships in Access 2000 with VB6

    It would appear that you are using a DAO record set. From what I see in the MSDN documentation, this can be easily done using a ADO record set instead. The MSDN documentation talks about Hierarchical Cursors that allow this type of thing. Hope this points you in the right direction, good luck...
  7. bnhcomputing

    Why Doesn't my form Update in VB6

    Been down that road. Progressbar.Refresh and Form.refresh. I put several of these statements throughout the loop. No change. Any other ideas?
  8. bnhcomputing

    MS Access 2000 Locks databse when form is opened

    I have an Access 2000 database that consists of two related tables, and a form/subform combination. If I open the database, I seem to be OK. However, if I open the main form, then the database is locked, and no one else can add data to the database. I have checked all of the “locking”...
  9. bnhcomputing

    Why Doesn't my form Update in VB6

    I have a VB6 application. It reads data from an ASCII file and updates an Access database via an ODBC connection using ADO. The application works great. I added a form and some progress controls to inform the user as to what is happening. Sometimes the form is OK, but most of the time, the...
  10. bnhcomputing

    MySQL Backup

    I am using MySQL in a client server environment with a VB client. I guess I'm more familiar with MS-SQL where a backup agent is used. If I just copy the files, what happens if the files get out of sinc during the copy? MySQL AB mentions an administration utility, but it doesn't look like this...
  11. bnhcomputing

    MySQL Backup

    Sorry for not being more specific. Running on WIN2000, MySQL version 4.0.16-nt Thanks, Hubert
  12. bnhcomputing

    MySQL Backup

    I need to backup my MySQL database while it is in use. What is the recommended procedure / tool for backing up MySQL without shutting it down? Thanks in advance, Hubert Hoffman
  13. bnhcomputing

    Foreign Key Question

    PERFECT!!! Thank you very much. Only have constraints on the Xref tables and when I delete from a main table, the Xref tables are all cleared out automatically. Thanks again for helping me understand how to read. Hubert Hoffman
  14. bnhcomputing

    Foreign Key Question

    If I remove the constraint from the employee table, then it is possible to remove records from the employee table without removing the records from the Xref table leaving alienated records in the Xref table. It was my understanding that the constraint with the cascade delete would prevent this...
  15. bnhcomputing

    Foreign Key Question

    I want it both ways, but lets just start out with the employee table. The way I read this is: If I delete a record from employee, then delete all records with the same employeeID from the Xref table. If I add records to employee, do nothing. Am I misreading? Once this works, then I will...
  16. bnhcomputing

    Foreign Key Question

    CREATE TABLE `employee` ( `EmployeeID` varchar(10) NOT NULL default '', `FirstName` tinytext NOT NULL, `LastName` tinytext NOT NULL, `EStatus` char(1) NOT NULL default '', `HireDate` date NOT NULL default '0000-00-00', `TermDate` date default NULL, `ReviewDate` date default NULL...
  17. bnhcomputing

    Foreign Key Question

    If I set the foreign keys, then I can not insert into any of the three tables. Without the foreign keys, then I can add records. EmployeeID 1, JobId 1, then I add a record to the Xref table 1,1. This works OK, but then there aren't any constraints. If I add the constraints before adding any...
  18. bnhcomputing

    Foreign Key Question

    Sorry for the lack of information. I am using: version 4.0.16-nt on a win2000 server innoDB is my table type. Hubert Hoffman
  19. bnhcomputing

    Foreign Key Question

    Table 1: Employee has employeeID and other info. Table 2: Jobs has jobid, jobtitle and other info. Table 3: EmplxrfJob Has employeeID and jobid only. I should be able to set a foreign key in all tables so that: Emplyee Table Employee added, OK. Employee deleted, cascade delete...
  20. bnhcomputing

    Office 2000 and Excel

    Additional Information: I have installed Office 2000 on a WIN2K server running terminal services. At this time the server has only the administrator user. This happens everytime I start Excel, and Only Excel. Thanks again, for any information. Hubert Hoffman

Part and Inventory Search

Back
Top