How do I make a connect string for a iSeries Access ODBC?

[anoble1]

I am having trouble making a connecting string for a database I have.

Here is the code I have for it now.

Public Sub LinkTables2()
strConn = "Driver={iSeries Access ODBC Driver};System=PFW;Uid=anoble;Pwd=password"

I have no clue what I am doing with this.
When I pull up the ODBC Data Source Administrator I am using the "Name" of the Source which is PFW.

Any help? I am trying to make this run when the program opens so I don't have to enter in my username and password everytime.

[Rabbit]

How come you are using a third party driver rather than the native one that Microsoft provides?

[anoble1]

What do you recommend me using?

I tried using the SQL Server one, but when I put the IP address in it failed.

[Rabbit]

I'm confused, are you trying to access SQL server or Access? Your first post says Access but your second post you are talking about SQL server. They aren't the same thing.

[anoble1]

I am using MS Access to grab that data. I had my IT department set up the datasource connection a long time ago in the Windows Administrator. The driver it uses is called iSeries Access ODBC Driver. I honestly don't know anything about it. I am trying to write VBA in my MS Access database the automagically link the table and use my username and password so I don't have to enter it every time. I don't know how to string my username and password using that iSeries Access Driver. Maybe there is another way?

[Rabbit]

You are using Access to grab the data. But where is the source data sitting? Maybe you should ask your IT department to set up the connection again