Sun Java System Active Server Pages - Unable to create ADODB object or connect to admin console
I have just installed SunONE 4.0.0.41 on Linux and everything seems to work apart from:
1) Creating an ADODB object produces the following error:
Error Type:
Server object, ASP 0177 (0x800401F3)
System message, messageid = 0x800401f3
/testinc/include.asp, line 23
Line 23 is:
Set thisConnection = Server.CreateObject("ADODB.Connection")
I have used casp/asp-server-3000/testadocon to test it and get the following error:
[root@cs4 asp-server-3000]# ./testadocon DSN="Driver={MySQL};SERVER=10.0.0.7;DATABASE=TestDB;UID=dbadmin;PWD=testpassword"
IM002 -- [DataDirect][ODBC lib] Data source name not found and no default driver specified
I would see what the admin console says but that brings me to my second issue:
2) The admin console is not available.
If I start it using the casp/admtool then it says it starts the Wen Server and ASP server but if I check the status the web server is being stopped but apache is running.
Administration Console Status
=============================
Web Server: Stopped
ASP Server: Running
URL: http://cs4.mydomain.net:5100
The last odd thing is that it looks like it is running the process on port 5102 for some reason (even though the status shows 5100):
ps aux
/data/casp/admin/bin/admeng -p:5102 -mt:1
Any help would be great.
Thanks.
