What does this connection string mean? With NA parameter?

Hi there,

I came across an Excel file that is sourcing data from an outside server. I'd like to understand how the connection string works so I can recreate it elsewhere.

The connection string is in following format:

DSN=DeTec;UID=id0027;SRVR=dbdgaex;NA=172.17.99.63,4100

The connection string seems to be enough to establish the connection with the server; however, after playing with a number of different options in Excel, I'm unable to establish a connection.

My question is, based on this connection string, what "source" type do I need to use in Excel, to make this work?

Additionally, the "NA" parameter--this looks like a server IP, is that what it "NA" is? based on the information from this website, this does not seem to be a common parameter.

0 answers