vb 6 odbc sql
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: vb 6 odbc sql

Threaded View

  1. #1
    Join Date
    Jul 2012
    Posts
    1

    vb 6 odbc sql

    Code:
    Dim Ssql
    Dim dbstatus 
    Dim rs
    
    
    Ssql = " Select * from User_Access A Where A.User_pwd ='1234' "
    set rs = Server.CreateObject("ADODB.RecordSet")
    rs = DB.execute(Ssql,dbstatus) 
    Response.Write(dbstatus)
    If dbstatus <> 0 Then
    'Error code here
    Else
    'code here 
    END IF
    The code is working ok . On successful execution of sql statement the dbstatus value is giving -1 . But according to the code it should return 0 for further execution . For other than 0 it will give Error .

    I'm executing this on sql server 2005 and in windows 7.

    ***But the same code On successful execution of sql statement the dbstatus value is giving 0 on some other enviornment where ODBC version and sql server version is different .

    Can anyone help me out .
    Thanks in advance
    Last edited by WizBang; July 24th, 2012 at 09:46 AM. Reason: Added [code] tags

Tags for this 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
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center