VB or VB.NET Database linking

senewimala1988

Well-known member
  • Dec 5, 2007
    7,709
    2,578
    113
    Kadawatha, Sri Lanka
    Machanla, mama XP waladi VB.NET program ekakata Access Database ekak link kale UDL file ekak (data link properties) create karala, eeta passe eke providers valin "Microsoft Jet 4.0 OLEDB data provider" select karala..But dan vista wala udl file eken karanna giyama ehema provider kenek ne..Ithin dan kohomada karanne???


    42098779.jpg
     

    senewimala1988

    Well-known member
  • Dec 5, 2007
    7,709
    2,578
    113
    Kadawatha, Sri Lanka
    Oya thiyenne lassanata ODBC drivers
    Ane mata ovva therenne ne....Mata kiyannako Access database ekak connect karana hati.

    Example:

    Public Function GetConnection()


    CON=New OleDbConnection("Provider=Microsoft.JetOLEDB.4.0;Data Source=<path>;Persist Security info=False")

    CON.Open()

    End Function




    Mata othana red coloured coding eka generate kara ganna vidiya kivvama athi UDL file eken...:(