Posts by Leonardo • 21 points

• 2

  votes

  1

  answer

  112

  views

  A: ADO fails to connect

  Problem solved, in the server_name was using : to separate the connection port, but the correct one is to use ,.

  database sql-server vba excel-vba ado

  answered 5 years, 4 months ago Leonardo 21

• 0

  votes

  1

  answer

  112

  views

  Q: ADO fails to connect

  I have a project in Excel where I am trying to make a connection to SQL Server database. I am working on a virtual machine and the database is on another machine, however they are all on the…

  database sql-server vba excel-vba ado

  asked 5 years, 4 months ago Leonardo 21