Excel vba connection question RRS feed

  • Question

  • Hi All,

    I have a excel vba file which has two connection to the same sql server database as below.

    A. A is oledbconnection(created using MS query) created using Data Sources -> From MS Query and executes a Stored procedure.
    B. B is ADODB Connection which uses connection string through sql server native client and fetches information from the table to load into combobox.

    Can i use the connection from A for connection in B instead of creating a new connection again.  so that i can have only one
    connection to the Database.  

    Thanks in Advance,
    Thursday, December 11, 2014 9:42 AM