Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Using DSN connection in VB6.0

oobabuoobabu Posts: 17Member
Pls can anyone tell me how to use DSN connection in VB6.0

Comments

  • number7number7 Posts: 11Member

    public Cn As New Connection
    Public CnString As String

    With Cn
    CnString = "UID=USERNAME;PWD=PASSWORD;DSN=DSNNAME"
    .Open CnString
    .CursorLocation = adUseClient
    End With



    Create a DSN using ODBC and provide the username, password and DSN Name in the above code.

    Cheerz
    Number7
Sign In or Register to comment.