ca.portal.admin

Re:Re: IUA website - MySQL

Discussion created by ca.portal.admin on Sep 5, 2006
Yes, there is a ODBC driver that is installed from the MySQL website.
This was done, and the global.asa file is pointing to the proper
driver. That was one of the problems we resolved over the weekend.
Before we had the proper driver identified, we were getting a 'driver unkown
or unavailable' message. Once we got the driver properly installed and
defined, we started getting this properties message.

Laura

Neal Walters wrote:
Do you have to install a special ODBC driver for MySQL?

Neal Walters
http://Biztalk-Training.com
http://Sharepoint-Training.com
http://VBScript-Training.com
http://CMSTrainingVideos.com


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Tuesday, September 05, 2006 7:59 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: IUA website

Hi all,

The IUA's service provider moved our website over this past weekend from
a WIN2000 server with IIS5 to a WIN2003 server with IIS6. You would
think that it would be a simple move, and everything would continue
working as before. No such luck. After spending many hours this
weekend working with the service provider to fix the different problems,
I'm at dead end. We're getting the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/english/index.asp, line 77


Line 77 is the following Open statemSent:

Set objrst = Server.CreateObject(""ADODB.Recordset"")
' Get the welcome message
objrst.Open ""SELECT home_welcome_"" & langue & "" AS welcome FROM
TBL_home"",Application(""strconnect""),3,1


It's the first database call. We're using MySQL as the database.
The application code has not changed, we just changed a few values in
the global.asa file in order to connect properly to the database and
the application.

If anyone has any ideas or would like to help me debug this, the IUA
(and I) would appreciate very much!

Thank you,
Laura Rochon
IUA struggling webmaster


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/437 - Release Date: 9/4/2006


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/437 - Release Date: 9/4/2006
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: IDMS shutdown - two different ways to do it
"Mike,

The command should be 'DCMT SHUTDOWN IMMEDIATE (IMM)'. The IMMEDIATE
instructs the CV to cancel all active run-units and then shutdown the CV.
Without using IMMEDIATE, any active run-unit will finish; before, the CV is
shutdown. There may be times when the IMMEDIATE is not appropriate, but
this would be a judgment call and I always issued the command with
IMMEDIATE.

I am not familiar with this MVS command: ""P IDMSname"".

A REPLY may be issued as a console command and issue the SHUTDOWN or
SHUTDOWN IMM. This is how operators normally shutdown CVs. At startup a CV
will return a message like this: @010 REPLY WITH REQUEST TO IDMS V61. To
shut this CV down from the console, issue one of the following commands: R
10,SHUTDOWN IMM or R 10,SHUTDOWN.

I have only canceled CVs when absolutely necessary, i.e. when they will not
shutdown normally. I issue the cancel by placing a 'C' by the executing CV
job.

Good Luck,

John Collins
SAIC

Outcomes