ok, i swear i entered this about 5 times... there must have been something wrong on the other end yesterday...the IP address worked this morning!

objmyconn.ConnectionString = "Provider=SQLOLEDB;Data Source=" & "00.123.456.78" & "\myDBname;User ID=SQL_user;Password=SQL_Password;"
sweet.