ASP and Client Access

[Guest.Visitor]

Hi all. I´ve installed Client Acces in a NT 4.0 with IIS 4, where I´ve put a web application based on Active Server Pages. Every time I try to do an OPEN database, just like this: Set CN = Server.CreateObject("ADODB.Connection") CN.Open "DSN=AS400;UID=PCUSER;PWD=PCUSER", "PCUSER", "PCUSER" the follow message appears: "IBMODBC Controler Client Access (32 bits) DB2/400 SQL Communication Link Failure COMM RC=0x5 asppage.asp, line x (where I make OPEN)" If I refresh the same page a lot of times, the follow message appears: "Microsoft OLEDB Provider for ODBC Drivers error '800004005' MicrosoftController ODBC Administrator The Server is not Available." The amazing story is that the same connection string I use in the ASP page works fine if I use it in a Visual Basic 6.0 program: it open the connection and allows me to launch recordsets. How is it possible? Anybody can help me? Thanks.

[Guest.Visitor]

IF possible use client access express as it handles asp much better. Otherwise, see my article in Client Access Expert, possibly it is available on the web, about running CA as a service. ASP runs as an NT service program, and needs to run CA as a service. CA 95/NT by default can not run as a service without a "tweak" that is overviewed in the article. http://www.midrangecomputing.com/ane/article.cfm?id=188&md=19994 is the link for the article. please let me know if this helps you. Howard Arner,