remote connection string

[sdforsb]

I am pretty new to this. I am trying to put together a vba adodb connection string to a remote server. It is the first time I am using adodb in this context. I can get msysobj.connect but how do I format that information into a connection object connection string?

 

[DavidAtWork]

what kind of server are you trying to connect to?
maybe this link will help:
http://msdn.microsoft.com/en-us/library/office/ff821690.aspx

David

 

[sdforsb]

David - Thanks for the help.

This is what worked for me:

Public Function GetStrConnection() As String
GetStrConnection = "Provider=SQLOLEDB;Data Source=MyServer;" & _
"Initial Catalog=MyDataBase;UID=SA;PWD=Password"
End Function

 

[CJ_London]

this link is useful as well

http://www.connectionstrings.com/