[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 648
  • Last Modified:

client access ODBC driver

Hi,
a simple question - I have IBM personal communication installed on my machine( No client access) . I'm trying to connect as/400 from excel(Vb editor) like this -
conn.Open "Provider=IBMDA400;Data Source=;User ID=User;Password=Password;"
I think IBMDA400 is client access OLEDB providor ..right ? If i dont' have client access then how shud i connect ?? Can i create ODBC DSN from pcomm ??
Pls reply soon..

Thanx
Raj
0
raj28
Asked:
raj28
1 Solution
 
raj28Author Commented:
I forget to write the error which i'm getting -
Data source name not found and no default driver specifies"

Raj
0
 
tliottaCommented:
Raj:

Without an ODBC driver that knows how to talk to DB2 under OS/400, you won't get very far.

IBM supplies drivers with iSeries Access. Other vendors also supply drivers; Google can probably show a number of them.

JDBC can be used as well; classes from the JTOpen toolkit provide the linkage. I suppose that could lead somewhere if it's all open source.

Tom
0
 
raj28Author Commented:
Hi tom,
I haven't seen any Iseries Driver in ODBC. How shud i create a DSN ?? Pls provide the connection string.

Thx
Raj
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
tliottaCommented:
Raj:

If you haven't installed an appropriate driver, then I don't know of any way to create a DSN that will work.

If you can't install the driver from iSeries Access, you'll need to obtain one from some other vendor.

Tom
0
 
JUSTICECommented:
You can get the JTOpen toolbox from this page:

http://www-1.ibm.com/servers/eserver/iseries/toolbox/downloads.htm

My connection looks something like this.  Granted its going to be a bit different, as I am using Coldfusion to connect, but maybe this will help:

JDBC URL: jdbc:as400://<SYSTEM IP ADDRESS>/<DSN NAME>;prompt=false;
Driver Class: com.ibm.as400.access.AS400JDBCDriver

Otherwise, simply install the ODBC option with client access (its included)
For the connection string, check out this site: http://www.connectionstrings.com/, they have all kinda of strings there, I am sure you will be all set from that!


Let me know if you need any more help!

Chris Peterson
0
 
tliottaCommented:
Raj:

Why not install ODBC/OLEDB from iSeries Access? There should be no license charge; only display/printer emulation and file transfer require licensing.

AFAIK, the first iSeries Access license is free with OS/400 anyway so that iSeries Navigator is available, along with other reasons.

Tom
0
 
ScottParkerCommented:
heres the VB code I use daily..
But it is useing the Client Access ODBC Driver.

If connObject.State <> adStateOpen Then
   connObject = New ADODB.Connection
   With connObject
      .CursorLocation = adUseServer
      .ConnectionString = "Driver={Client Access ODBC Driver (32-bit)};TRANSLATE=1;DBQ=<libname>;System=<systemip>;Uid=<username>;Pwd=<password>"
      .Open()
   End With
 End If
0
 
daveslaterCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept JUSTICE comment as answer

Please leave any comments here within the next four days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
daveslater
Page Editor
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now