Unfortunately that didn't help. Like I said, the confusing aspect is that my VB apps using OLE DB connecting to the AS/400 are working fine. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "George Kinney" <GKinney@nextransport.com> To: <firstname.lastname@example.org> Sent: Tuesday, December 18, 2001 4:16 PM Subject: RE: AS/400 and Crystal Reports > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > -- > [ Picked text/plain from multipart/alternative ] > A real common reason for this not working is that the Host Servers aren't > running. > try: STRHOSTSVR *ALL at a command prompt, and then try the ODBC connect > again. > > If you are connecting via tcp/ip, fire up the DDM server for better > performance. > (STRTCPSVR SERVER(*DDM)) > > Anyways, good luck. > > >Using the ODBC driver that came with CA Express, I can get it to display > the > >tables in a library and then the table to show its fields, but it will not > >display dat in the preview window. > > >Using OLE DB that came with CA Express, I can not even get the connection > >configured. I go to make a new conenction and type in the system name and > >my username and password. Test conenction comes back successful, but when > I > >hit OK ut has a blank pop up box that says Database Error. > > >I know the OLE DB connection does work because I have written several > Visual > >Basic apps that use the OLE DB provider on my computer. > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-Lemail@example.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > >
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.