I am not sure how I could create a connection of my code in excel 2003 to the sql server. In inherited this connection code from other people but now that we change the server name etc... the connection doesn't work. Basically, what I am trying to do is connecting the functions I have in my VBA code to this new server. The name of the server that I am trying to connect to is p3sql and the database is called abcd. Do I have to change anything in Provider= or security?
**************************************
Const sConnection = "Provider=sqloledb;Server=p3sql;database=abcd;Integrated Security=SSPI"
***************************************
Thank you