VBA-Excel function to connect to SQL Database server, in addition to DB_Disconnect to disconnect from database.
I can not believe I did not add this one here before.
Returns 1 if connection to db was successful, 0 if not.
This is a simpler version of the big guy DB_Connect_AndOr_Fix that will be added too soon.
Edit 2020-03-26: Looks like drivers are not installed by default on all machines, If you are seeing error about Provider not installed, try any of the commented ConnString lines instead.
In all cases, installing the driver would fix it, get SQL Native Client driver from https://www.microsoft.com/en-us/download/details.aspx?id=50402
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
Views 1,688
Downloads 455
