Results 1 to 7 of 7

Thread: the best way of a connection query

  1. Dec 25th, 2008, 01:51 PM #1
    jason78944545
    jason78944545 is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2008
    Posts
    97

    the best way of a connection query

    hi,
    i working with a sql server 2000 and vb6 and i need a connection/string query to connect from some pc´s in network i have a query but i think that is not the best query because the app freeze for 2segunds when i save/load some data
    thanks for your help
    Reply With Quote Reply With Quote
  2. Dec 25th, 2008, 01:57 PM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: the best way of a connection query

    So, what is it that you don't know?
    - How to connect to your SQL Server database
    - or how to write some sql statement
    - or both?

    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  3. Dec 25th, 2008, 02:27 PM #3
    jason78944545
    jason78944545 is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2008
    Posts
    97

    Re: the best way of a connection query

    hi,
    i know both the app is already running by some time my question is if there is some best way to connect to the server for fast response/performance etc
    there is obdc etc etc and i have use some apps that work with a sql server bd and they are more faster than my app.
    so i think there is some best way and my question is that what ways you use to improve the operation?
    thanks
    Reply With Quote Reply With Quote
  4. Dec 25th, 2008, 03:22 PM #4
    Grimfort
    Grimfort is offline
    PowerPoster
    Join Date
    Mar 2002
    Location
    UK
    Posts
    4,780

    Re: the best way of a connection query

    There are about 50 answers to your question, most of them being more questions. I think you should start at the begining and tell us what you have already.

    The database you are connecting to is on a lan?
    How many records you are bringing back, and how (show the query).
    What are the tables setup like (do you have indexing?).
    >>>>> Search First!!! <<<<<
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft * - tg Copyright!
    Option Strict/Explicit
    >>>>> If you love it, rate it <<<<<
    Reply With Quote Reply With Quote
  6. Dec 25th, 2008, 04:15 PM #5
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: the best way of a connection query

    There are various things we could suggest to improve the performance but first we need to know what you currently have. It would help if you could post the code which you deem is running slow. And what provider are you using to access your database?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  7. Dec 25th, 2008, 04:56 PM #6
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: the best way of a connection query

    This thread should really be moved to db forum.
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  8. Dec 27th, 2008, 06:57 AM #7
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: the best way of a connection query

    Agreed, and now that I've spotted it, thread moved to Database Development forum
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width