× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Loyd,

Are you accessing the ADO type library with the appropriate meta tag:

<!-- METADATA TYPE="typelib" UUID="00000200-0000-0010-8000-
00AA006D2EA4" NAME="ADO Type Library" -->



> From: Goodbar, Loyd (ETS - Water Valley)
> [mailto:LGoodbar@xxxxxxxxxxxxxx]
> Sent: Tuesday, August 19, 2003 9:26 AM
> To: 'midrange-l@xxxxxxxxxxxx'
> Subject: Difficulty with ASP and Client Access ODBC driver
> 
> 
> Here's the scenario: I have some ASP (classic/3.0) pages that access AS/400
> data. Everything works correctly on my machine, running a local installation
> of IIS. I can access remote SQL server data or AS/400 data.
> 
> However, when I run the ASP pages on our application server, the ASP page
> always "hangs" on the "open connection" line when retrieving AS/400 data. I
> have Client Access installed on the application server.
> The server can access the SQL server database, but not the AS/400 database.
> The web page doesn't time out, but sits there for a very long time (I
> stopped timing it after 5 minutes).
> 
> The script hangs no matter which type of AS/400 connection I try to use:
> DSN: "DSN=mydsn;Uid=uid;Pwd=pwd"
> DSN-less: "driver={Client Access ODBC Driver
> (32-bit)};system=system;uid=uid;pwd=pwd"
> 
> I set up a standalone server running a default install of IIS and Client
> Access, and have the same problem. It would appear to me to be a
> configuration issue, but I'm not sure what to check.
> I'm pretty new to ASP, I think I missed a configuration setting or piece of
> client access installation somewhere on the server. All of our servers are
> in the same network subnet.
> 
> If I need to provide more information, let me know.
> Any help appreciated, thanks!
> 
> Loyd
> 
> 
> 


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.