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.