You must Sign In to post a response.
  • Category: ASP.NET

    Declare of recordset in the vb using

    hi team,

    how do i call tables in the vb script using where data is stored or will be stored?

    Thanks $ Regard

  • #652203
    You need to open a connection first..In below code i am using DSN

    Set objConnection = CreateObject("ADODB.Connection")
    Set objRecordset = CreateObject("ADODB.Recordset")
    objConnection.Open "DSN=Test123;"
    objRecordset.CursorLocation = adUseClient
    objRecordset.Open "SELECT * FROM Table12" , objConnection, _
    adOpenStatic, adLockOptimistic

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.