OleDB connection string

I need help resolving a small issue when i use a OleDb connection string.

I am trying to create a string that will connect to a SharePoint list.


The string works, however, one of my columns contains AD users. The column is returning these users as IDs (1, 4, 34 etc...)

I know there is a table used by SharePoint called UserInfo which contains the full name.

I need help connecting these two tables within the string above. I am not coding the connection, it's being entered into a reporting application, so my options are very limited.

Thanks in advance.

0 answers