Hi
First I would like to give thanks to Simon Song for his quick response to my post. Simon, thanks a lot.
I installed IBM Http Server 3.9.1, WAS Advanced Single Node Server 4.0, DataDirect SequeLink Server 5.2 and MS SQL Server 2000 at my machine.
Now I can access the sample database(pubs) using a
servlet I developed at WAS ( Located at Default Server) through SqueLink Server. The problems I have are:
1 I can only access "pubs" using database login name "sa":
The code as followed:
public void service (HttpServletRequestrequest,HttpServletResponseresponse)
throws ServletException, IOException{
...blah blah blah ...............
try{
....blah blah blah .....
Class.forName("com.merant.sequelink.jdbc.SequeLinkDriver");
Connection conn = DriverManager.getConnection("jdbc:sequelink://myserver:19996;databaseName=pubs;HUser=sa;HPassword=","sa","");
...blah blah blah ........
}
...blah blah blah .....
}
But when I used another login name and password to access the same database, WAS told me "LOGON FAILURE usrid" eventhough the usrid has been created in my "pubs" database. I am stucked here. Is there somebody who met this problem before? Could I get some hint?
2 The second problem is that when I access the same database using "datasource",
public void service (HttpServletRequestrequest,HttpServletResponseresponse)
throws ServletException, IOException{
...blah blah blah ...............
try{
....blah blah blah .....
Hashtable parms = new Hashtable();
parms.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
InitialContext ctx = new InitialContext(parms);
ds = (DataSource) ctx.lookup("local:jdbc/Beta");
Connection conn = ds.getConnection("sa"," ");
...blah blah blah ........
}
...blah blah blah .....
}
The WAS responed me
"Login failed for user 'sa'".
If I type
Connection conn = ds.getConnection("sa","");
The WAS responed me
"Null password for user".
I noticed that: at the first connection, eventhough the password is NULL, WAS did not complain, but when executing the second connection, it did complain.
Does the complain arise beacuse of "DataSource" configuration? I noticed that during the conguration of my datasource "Beta", I was not able to leave the default password field blank. (WAS complains). Could somebody be kindly solve my puzzle?
3 The third question: The installation requirements of SqueLink Server include " SequLink Socket Server and SqueLink Legacy Server: ODBC Driver Manager". Since I do not use ODBC, do I need to install these two servers? If I need to do so, where can I download them? It seems to me that at the
http://www.datadirect-technologies.com/jdbc/sljava/ddpsl5_sqlserver.asp, there is nothing about these two servers.
4 As I mentioned in my previous post, I hope that I can install SqueLink Server at my WAS machine, and the MS SQL Server 2000 is at the other machine. Could I do this? And how? Why do all the docs say that the SqueLink Server should be at the same machine as SQL Server resides? Could they two be installed at different machines?
Thanks a lot.
Howard
I