Access 2010 to IBM iSeries DSN less (1 Viewer)

[MHutcheson]

Hello,

I am trying to create a DSN less connection from Access 2010 (32 bit) to an IBM iSeries. The below thread shows the coding:

http://www.connectionstrings.com/ibm-iseries-access-odbc-driver/

But I am a little stuck. How do I incorporate this into my database? Do I create a module and then pass the table names to it? If so I'm a little unsure how to do that - can anyone help?

Regards,

Michael

 

[Rx_]

http://www.access-programmers.co.uk/forums/showthread.php?t=234373
mdlueck is one of the top experts in my book. Suggest you check out this post about AS400


Sorry I can't be of more help:
Code segment for DSN-Less to SQL Server Native Client -
strConnectionString = "ODBC;DRIVER=SQL Server Native Client 11.0;" & _
"SERVER=dsql\regulator;DATABASE=" & DatabaseName & ";" & _
"UID=" & UID & ";" & _
"PWD=" & pwd & ";" & _
"Table=DBO." & sLocalName & ";Option=3;"