Using DSN connection in VB6.0 - Programmers Heaven

Howdy, Stranger!

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

Categories

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.