Hi,
I am developing an ACCESS 2007 application that must query a remote SharePoint list over the internet. I am using ADO to connect and trying to follow VBA code from Litwin, Getz, and Gilbert that looks like:
Dim cnn as ADODB.connection
Set cnn = New ADODB.connection
With cnn
.Provider = “SQLOLEDB”
.Properties(“Data Source”) = “Gorilla”
.Properties(“Initial Catalog”) = “ADH2KSQL”
.Properties(“User Id”) = “Suzanne”
.Properties(“Password”) = “mud”
.open
End with
My questions are:
1) Does this seem like the right way to do this?
2) Instead of "Gorilla" (Data Source) would I use the IP address of the server, like "www.remote.server", and do I need to specify a port number?
3) How would I look for the needed parameters within the SharePoint configuration.
Please forgive my ignorance, the SharePoint administrator just quit, and though I can get access to the configuration, I know very little about SharePoint.
My 0verall objective is to use ACCESS to post files to the SharePoint list, retrieve the document URL from the SharePoint List , and then update additional SharePoint document attributes from the Access database. So far I have been unable to guess the parameters needed for a successful connection.
Thanks. Any comments or suggestions will be appreciated.