none
microsoft odbc driver manager data source name not found and no default driver specified in vb.net RRS feed

  • Question

  • Hi,

    I have written a connection string for sql server in vb.net

    Below is my connection string code.I am getting this error after 3rd line which is highlighted below.

       

    conn = New ADODB.Connection
       strConnection = "SQLOLEDB;Data Source=Data source name;Initial Catalog=;User Id=ID;Password=Password;"
    conn.Open(strConnection)

    i have DSN created with the name of SQLOLEDB for my data source.Can you please help me to resolve this error.

    Wednesday, June 20, 2018 10:31 AM

All replies