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 Rhinorhino 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: jfield817
  • Content: Threads
  • Order by date
  1. jfield817

    Activex Component Cant Create Object

    Hi All, I am using Visual Basic 6 with an app with the following code. Set NewEmail = CreateObject("CDONTS.newmail") The error msg .."Activex Component Cant Create Object" gets trapped I have "CDONTS for 1.2" and ADO 2.7 library checked in References. Any...
  2. jfield817

    Foreign Key Constraint Problem

    An SQL Server 2000 Foreign Key Constraint Anomaly is occuring. The following tables exist in my database: Person Table Orders Table Pers_id on Orders is a Foreign Key referencing Pers_id on Person Table The following statements are executed in the following order: Delete from Orders where...
  3. jfield817

    Custom Control Question

    I want to upgrade a VB 4 16 bit app to 32 bit VB 4(for starters) But there are a couple in-house written 16 VBX bit custom controls that the app uses. I have the C source code of these controls .. How does one upgrade them to 32 bit OCX .. Is that even possible ... Is all I need 32 bit...
  4. jfield817

    MDAC 2.6 and SQL 6.5

    I will be upgrading SQL 6.5 to SQL 2000 .... and concerned there may problems when the latest MDAC (2.6 ?) is applied to the database Server .... There are currently two VB4 apps using SQL 6.5 and one Web app using SQL 7.0 .....The SQL 7 server will also be upgraded to SQL 2000 and the new...
  5. jfield817

    Report was not exported

    Getting "Report was not exported" using Crystal 7 on a Web system ....when trying to export to RTF ....Exporting to Word doesnt work either.. Excel exporting works ..... Crystal 7 had been installed on several environements and export also fails .... Any ideas would be appreciated...
  6. jfield817

    DBLIB-C

    Is Microsoft's DBLIB-C library compatible with SQL-2000.....is it a valid low-level interface for SQL 2000 as in SQL 6.5 and SWL 7.0 Any feedback is welcome ... Thanks John
  7. jfield817

    Query using quotes and variables ...

    Using Sql Server 7 ... Unable to get this code fragment to work ... @z is Null when I display it ...Ive tried different approaches to "set @fcount = 1" with no success .... declare @z char(300) declare @list char(30) declare @fcount char(1) set @list = "(10,99999,999999)&quot...
  8. jfield817

    Where are Dlls available in MS WORD

    I know there's an MS Word 2000 option for displaying current dlls in memory .. I cannot remember how to access it .... Does anyone have any ideas .. Thanks John
  9. jfield817

    Blinker 1.5 question

    Sorry .......but I need to do a Blinker 1.5 link on a Clipper 5.0 application I inherited ... (All we have is Blinker 1.5 and there's no chance of upgrading ) Can anyone please point me to some old Blinker Documentaion would contain the input parameter definitions etc ..... Thanks John
  10. jfield817

    Disabling a Trigger

    Using SQL 7.0 How can one tell if a trigger on a table is disabled ... I disabled a trigger but I can't find a system stored procedure that provides info as to whether the trigger is enabled or disabled. Thanks John
  11. jfield817

    <b> Foreign Keys Using Enterprise Manager </b>

    Using SQL 7 ... Where on Enterprise Manager can I see the Foreign Keys on a Table .... "All Tasks" shows indexes and triggers but not Foreign Keys I know how to do it using system stored procs, however .... Thanks John
  12. jfield817

    String Field Printing only 255 chars

    Using Crystal reports with Sql Server 7 in a Web Environment ..... A String field is printing only 255 chars when in fact the same field in the Table and Stored procedure behind the report was modified to a length of 500 ... Cant figure out why the entire 500 chars in the field arent being...
  13. jfield817

    ADO Data Control Not working ...

    Everyone, I placed an ADO control on the form and text box on the form, however I keep getting "Data Source name not found and no default driver specified" when I run the following in VB 6 .... I ran it with the DSN and without... I am trying a simple connection to the Pubs database...
  14. jfield817

    Apex TrueGrid (TG_VB4.VBX)

    Hi all, What is the 32 bit version of Apex's 16 Bit TrueGrid TG_VB4.VBX ... Is it TrueDBGrid32.ocx and its associated files And I am hoping that the 32 bit version supports the methods and properties of the 16 bit version .... I am in the process of upgrading a VB from 16 to 32 bit...
  15. jfield817

    Export Recordset to Foxpro Question

    Hi Is there a quick way to dynamically and programatically Export/Convert a VB 5/6 recordset to a Foxpro table from within VB ......without using a thir party tool The recordsets will have varying structures ... possibly 90 different types of recordsets .... Thanks John
  16. jfield817

    16 to 32 Bit True Grid Conversion

    What is the 32 bit version of Apex's 16 Bit TrueGrid TG_VB4.VBX ... I'm assuming that its DBGRID32.OCX by Microsoft .... I might be wrong on this ... And I am hoping that the 32 bit version supports the methods and properties of the 16 bit version .... I am in the process of upgrading a VB...
  17. jfield817

    Crystal 5 and Crystal 4.6.5.1

    I currently have Crystal 4.6.5.1 installed on my Windows 2000 development machine since some VB apps use it .... If I upgrade to Crystal5 will Crystal 4.6.5.1 be supported and the old apps run I need to upgrade since I am upgrading some of the apps to 32 bit .... Thanks ... John
  18. jfield817

    VB and Stored Procedure call

    Can a SQL Server 7 Stored Procedure be executed Inside of a "Where" clause from VB 6 .... The proc would be called as such "Myproc" The pseudocode would be something like ... Select * from Table where Table.x = 5 and Table.y IN a string returned by Myproc ... How could...
  19. jfield817

    Visual Basic 6 and Stored Procedure Call

    Can a SQL Server 7 Stored Procedure be executed Inside of a "Where" clause from VB 6 .... The proc would be called as such "Myproc" The pseudocode would be something like ... Select * from Table where Table.x = 5 and Table.y IN a string returned by Myproc ... How could...
  20. jfield817

    SQL Server 7 and Windows 2000

    Can SQL Server be installed on a system with Windows 2000 Professional OS .... or would Windows 2000 Professional work .... Thanks John Field

Part and Inventory Search

Back
Top