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

Pls can anyone tell me how to use DSN connection in VB6.0

Comments

  • number7number7 Posts: 11

    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.