Login | Register

Interactive SQL Tool (using ADO)

Posted by George Poulose on January 30th, 2000
Environment: VC++ 6.0 (SP3), MDAC 2.1, NT 4.0 (SP4)

Interactive SQL (using ADO) is a query tool that allows you to query OLE DB data sources, author SQL scripts and queries, return query results to a grid or text, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, retrieve multiple query result sets (depends on the data source), etc.

Downloads

Download Application - 547 KB
Download Source - 98 KB

IT Offers

Comments

  • More concessions with herveleger, more dish past!

    Posted by comewlvac on 04/29/2013 08:41pm

    wenchcatbe in will-power withpurloinobedientguide in

    Reply

  • Excellent free utility!

    Posted by Legacy on 01/26/2003 12:00am

    Originally posted by: James Sicolo

    This appears to be just what I need. Entering SQL directly into Access is such a pain since you need to save your query first. Also, I am using Access 97 which keeps your cpu pegged at 100%, so I am glad I can use this program instead. Thanks!

    Reply

  • Expired virus scan

    Posted by Legacy on 01/16/2003 12:00am

    Originally posted by: sameeya raoof

    The source code and application have an expired virus scan license. Kindly upgrade it so that the file can be downloaded. Thanx

    Reply

  • How to make ADO processing fast

    Posted by Legacy on 10/18/2002 12:00am

    Originally posted by: NIDHI SHRIVASTAVA

    Dear Sir
    I want to discuss one thing That I am developeing one application in(VB6.0) in which........
    I have to insert more than 5500000 records on SQL server
    using ADO.
    But this process is taking more than 6 hours.
    even when I have I am using Batch Update in ADO.
    How can I make this process fast????????????
    Pls tell me if u have any good solution to make it fast

    Reply

  • How to make ADO processing fast

    Posted by Legacy on 10/18/2002 12:00am

    Originally posted by: NIDHI SHRIVASTAVA

    Dear Sir
    I want to discuss one thing That I am developeing one application in(VB6.0) in which........
    I have to insert more than 5500000 records on SQL server
    using ADO.
    But this process is taking more than 6 hours.
    even when I have I am using Batch Update in ADO.
    How can I make this process fast????????????
    Pls tell me if u have any good solution to make it fast

    Reply

  • Why GetItem() function of RecordSet interface does not work with numeric indexes?

    Posted by Legacy on 07/29/2002 12:00am

    Originally posted by: Erhan Kaluc 

    my explanation is not good enough so here comes part of my code:


    _variant_t vtEmpty;

    				

    myRecordSet.CreateInstance ( __uuidof( Recordset) );

    	myRecordSet = myConnection->Execute( bstrQuery, 

            &vtEmpty, adCmdUnknown);


    _bstr_t tmp, tmp1;


    //This part creates a run time COM error and make me crazy

    tmp = myRecordSet->GetFields()->GetItem[0].Value;

    tmp1 = myRecordSet->GetFields()->GetItem[0].Name;


    //This similar part works nice

    tmp = myRecordSet->GetFields()->GetItem["Field1"].Value;

    tmp1 = myRecordSet->GetFields()->GetItem["Field1"].Name;

    //********************************************************


    

    I'll be very pleased if anyone can tell me why I can't use numeric index values with "GetItem" function.


    I really need to take field names depending to field count.


    Many Thanks

    Reply

  • Where can I get the help of ADO method?

    Posted by Legacy on 04/30/2002 12:00am

    Originally posted by: szhuzi 

    Where can I get the help of ADO method? such as the help of the methods of ADODB::_RecordSetPtr? How to use these methods?

    Reply

  • why my Query error ? ---for Informix 9

    Posted by Legacy on 01/26/2002 12:00am

    Originally posted by: TC_COM 

    i Use Ado  _RecordSet Execute SQL ,

    but Retrive Data Error


    database Table Data :

    field1 : 1234560

    field2 : 123000


    Code:


    _Connect. m_Connection;

    _Recordsetptr  rs;

    CString m_StrValue;

    int     m_IntValue;


    ....


    rs=m_Connection->Execute  (m_bstrSQL,&m_lVrecsAffected,adOptionUnspecified);

    ...

    while(!m_pRecordSet->GetadoEOF())

    {

    m_StrValue.Format("%s",(const char*)_bstr_t(rs->GetCollect(0L)));


    m_intValue=long(rs->GetCollect(1L));

    		    

    	m_pRecordSet->MoveNext();

    }

    		m_pRecordSet->Close();


    Result:

         m_StrValue:123456

         m_intValue:123

    Reply

  • Cannot access DB2 server tables from client machine

    Posted by Legacy on 07/17/2001 12:00am

    Originally posted by: Ravi Reddy

    First of all, this is an excellent application, and I found it works beautifully when used on a stand-alone PC or even when used on the server machine itself.

    But looks like OpenSchema throws an error "Object or Provider is not capable of performing requested operation",
    when trying to get table/column names in a server database from a client PC.

    The database I tested this application on is DB2 Universal Version 6.1, and ADO version is 2.5. And I have tried this on both NT 4.0 and Windows 2000.

    Wonder whether anybody else has experienced similar problems and if so how they have fixed them. Would appreciate it if anyone can throw some light on it.

    Thanks

    Ravi Reddy

    Reply

  • Help me plz to get Tables's schema with ADO

    Posted by Legacy on 05/19/2001 12:00am

    Originally posted by: dashinghawk

    hello
    i want you to plz assist me as to how i can get all user defined databses through ADO. i have go through OpenSchema() method, but will u plz mention me, is there any flag need to be set to get this information.
    seconldy i want to get Table schema of all tables of a database. will u plz mention me the way
    i will be gr8 ful of urz assistance
    best regards
    DashinHhawk

    Reply

  • Loading, Please Wait ...

Leave a Comment
  • Your email address will not be published. All fields are required.

Go Deeper

Most Popular Programming Stories

More for Developers

Latest Developer Headlines

RSS Feeds