RE: Difficulty with ASP and Client Access ODBC driver

["Chris Devous" <cdevous@xxxxxxxxxxx>]

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
> 
> 
>