Hi Arul,
Websphere 3.X supports only DB2 and Oracle 8.0.5 and above
Regards
Bhabatosh Das
System Analyst
Sonata Software Ltd.
1/4 APS TRUST Building
Bull Temple Rd.
Bangalore-19
PH : 6610330- Extn- 3434
> ----------
> From: Arul[SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 08, 2000 7:01 PM
> To: [EMAIL PROTECTED]
> Subject: help needed from websphere xperts
>
> Hello
>
> I am now trying to connect Webpshere with Sql server .Ibm Book states that
> only BMP is possible..not CMP..
>
> I tried to connect CMP with SQL Server.
> everything went on fine..
>
> what i did was
> 1)As Websphere supports on jdk1.1.7 i downloaded a type IV driver which
> also
> supports jdk1.1.7
>
> 2)Create a JDBC Driver by providing the Implementation class and URL
> Prefix
> as given in the read me file of the driver
> 3)There was no prob in creating the driver
> 4)Then Create the datasource with this driver
> 5)Install the JDBC Driver in the toplogy of the default container and set
> the datasource of the container as the one which was installed now
> 6) Deploy the Increment CMP Bean in the default container
> 7)When the Container is started the following exception occured
>
> []Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL
> Server connection.java.sql.SQLException: []Login failed for user '(null)'.
> Reason: Not associated with a trusted SQL Server connection.
>
> this gave the hope to me that some thing is cheeking for the username of
> sql
> server.
> 8)So in the user id column i gave as "sa" and when i again started the
> default container the error was
>
> Incorrect syntax near the keyword 'count'.java.sql.SQLException:
> [ARULKUMAR]Incorrect syntax near the keyword 'count'.
>
> --------
> com.ibm.ejs.sm.client.command.ExecutionException: Command default.start
> Sub-command Error.
>
> at com.ibm.ejs.sm.client.command.AbstractCommand.handleAct(Compiled Code)
>
> at
> com.ibm.ejs.sm.client.command.StartCommand.execute(StartCommand.java:93)
>
> at
> com.ibm.ejs.sm.client.command.CommandManager$ExecutionThread.run(CommandMa
> na
> ger.java:282)
>
>
> I havent used anything like count in my program .So wheres the error
> from???
> I believe that the StartCommand of websphere contains the java program
> which
> has something called a count and thats creating the error.
>
> any body knows How can that be rectified???
>
> Arul
>
> ==========================================================================
> =
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
