Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    12

    Unanswered: VB 6 app connecting to SQL Server 2000

    Hi,
    The application connects to SQL Server 2000 db, fetches data through 2 selects, and puts it in a text file.

    The VB (.vbp) works alright for connecting to the sql server 2000 database, howver, once I make exe and try to run it, the exe doesnt do ANYTHING. not a single log, error message( captured in txt files) through error handling is written.

    In the code, I am using rdoconnection. I did not need to add any references for the code (vbp) to work
    Should I be adding any references so that the exe runs?

    Thanks
    Abhi
    (abhishek_toraskar@infosys.com)

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    References
    Microsoft Remote Data Objects 2.x
    Microsoft Remote Data Services 2.x Library

    Not sure which one though.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also run PROFILER to capture the activity during this process.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    May 2003
    Posts
    12

    Angry Running from command line only

    Actually what happened was I was reusng an earlier code, written to run only from command prompt (Command Line Argument enabled in Project--> Properties-->Make)

    I deleted that part and also the part in code where the command line inputs were referred to.
    the code is working fine now

    Thanks
    Abhi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •