Can you get Solution Explorers Connection string?

[Sorwen]

While I use ADO.Net for all other connections I've always had a problem using it for getting data from our AS400 machine. None of the connection strings I use work so I've had to keep using ADODB Connections. On this project I was hoping to finally totally get away from that, but still I cannot find the correct connection string. Server Explorer however will setup the connection with no problems. Both are using an ODBC Connections. So is there some way to get the full connection string it is using to connect? Before someone suggests I have tried connection string from

http://www.connectionstrings.com/

and

http://www.carlprothman.net/Default.aspx?tabid=81

with no luck.

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!

 

[RiverGuy]

I haven't worked much with AS400 in the past three years, but I never had problems connecting to it with ADO.Net before. Did you try the Client Access OLEDB provider or just the ODBC?

 

[Sorwen]

Yeah, I tried both when I couldn't get ODBC to work I tried using the OLEDB connection/connection strings I could find.

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!