using OleDbConnection can we connect to both sqlserver and mdb

• sampathmeka

  SSC Enthusiast

  Points: 192

  More actions

  April 27, 2020 at 5:31 am

  #3746503

  Hi All,

  In administrative Tools ODBC Data Sources (64-bit) configuration ,Please find the attached screenshot where i have a datasource configured.

  Example:

  Standarad Part Library  32/64 -bit     Server

  Standarad Part Library0904  32/64 -bit   Microsoft Access Driver (*.mdb)

  How to  establish connection for both SQL Server and Microsoft Access Driver in VB .net or C#

  Please help me.

  Thanks & Regards,

  Sampath

   

  Provider=Microsoft.ACE.OLEDB.12.0;

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 28, 2020 at 6:10 am

  #3746890

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.