Results 1 to 13 of 13
  1. #1
    Join Date
    Mar 2004
    Location
    Philippines
    Posts
    3

    Unanswered: TIPS On how to access ms sql server from vb6 faster

    please post your idea, experiences what is fastest way to maniulate ms sql server using vb6 .

    thanks...

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Easy one...

    By Using SQL Server Stored Procedures...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Yup, no direct table access!

  4. #4
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Is there any way to enforce that other than just saying so?
    What I mean is, if you want my data, you can ONLY get it via MY stored procedures (and SQL Server will enforce it?)

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Sure, do not grant ANY permissions to tables! And, BTW, we're not just saying it, we're doing it.

  6. #6
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    But the VB programmer needs to have a UserID and Pwd to set up the connection for the command object to execute the SP. Doesn't this then also allow him to just do a normal ADO connection and issue select statements?

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    If your DBA just grants you EXECUTE permissions on procedures, - you're outaluck to get to the data regardless what data access method you use, - ADO, RDO, DAO, ODBC API's, dbLibrary, JDBC, or some other (are there any left?) method. All you can do is execute an SP. Isn't it wonderful?!!!

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    And, BTW, we're not just saying it, we're doing it.
    Yup!

    Can't you feel the power?

    Are you going to use connection pooling...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Can I presume then that the SP will execute with sa rights even if it is located in the chosen database rather than in Master?

  10. #10
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Stored procedures access objects with the permissions of the creator (man, I love it, talking about the power!!! May God be with you! Walk with the prophets! etc. )

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Literal translation: Till we meet again

    OK, Sheiner Bock time!!! Do Svidanya!

  13. #13
    Join Date
    Mar 2004
    Location
    Philippines
    Posts
    3
    any other way than stored procedure??..

Posting Permissions

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