DB2 remote connection string on vb 2005

[FelmenM]

Hi,

I would like to know what's the right connection string on vb 2005. I would like to connect to a database from a db2 server(version 9).

I can connect to a db2 server using a db2 client application. However I cannot connect to it from my vb 2005 application coz i don't know the connection string that i will use..

Can you give some sample codes.

Any help will be deeply appreciated


Thanks,

[MindBender77]

Hi,
I would like to know what's the right connection string on vb 2005.

Make sure you: Import system.data.ole db.oledbconnect ions
Try this connection string:

Dim con as ADODB.Connection
 
Public Sub db2_connection()
   Try
        con = New ADODB.Connection
        con.ConnectionString = "DSN = yourDSN; UID = yourUserID; PWD =               
               yourPassword"
        con.Provider = "IBMDADB2"
        con.CursorLocation = ADODB.CursorLocationEnum.adUseClient
        con.Open()
 
   Catch ex As Exception
        Msgbox(ex.message)
        con.close()
        me.close()
   End Try
End Sub