VB ADO Connecting

[dinesh123]

Is there any body know to get the Connecting string of Sysbase and DB2 databases

[Hobbit K]

dinesh ...
Look here
http://www.connectionstrings.com/

or here, it looks like they have OLE DB Data provider connections for DB2/
http://www.able-consulting.com/ADO_Conn.htm

HTH
Michael

[Twodogs]

We didn't do a search here before asking this question...did we?

search on sybase + connection

First post that comes up has one there

conSybase1.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=" & _
                    Chr(34) & "DRIVER=" & gsDB_Driver & _
                    ";UID=" & gsUser & _
                    ";DB=" & gsDatabase & _
                    ";SRVR=" & gsServer & _
                    ";PWD=" & gsPassword & Chr(34)
conSybase1.Open

[dinesh123]

Thankx and
it is a nice site really