Problem initial ConnectionPool in Bea with Microsoft JDBC Driver

[Joseph Weinstein]

Halim wrote:

> hi,
> i have a problem to initial a ConnectionPool in the Bea WLS with microsoft JDBC
> Driver.
> Enviroment: Bea WLS 6.1 SP3, DB SQL Server 2000, Microsoft SQl Server 2000 Driver
> for JDBC SP1 Version 2.2.0029 December 2002
>
> I make this in Bea WLS console/Services/JDBC/ConnectionPool:
> Name: BestandsPool
> URL: jdbc:microsoft:sqlserver
> Driver Classname: com.microsoft.jdbc.sqlserver.SQLServerDriver
> properties:
> db=Bestand
> user=XXX
> password=XXX
> server=XXX:1433
>
> i get this error Message in the Dos Console from the BEA:
> <15.09.2003 20:17:49 CEST> <Error> <HTTP> <Connection failure
> java.net.SocketException: ReadFile failed: Der angegebene Netzwerkname ist nicht
> mehr verfłgbar.
> (error 64, fd 2536)

Show me the section of the config file that defines the pool.
Also try deleting the server property, and instead changing the URL to

jdbc:microsoft:sqlserver:XXXX

where XXXX is the name of the DBMS machine. You don't need to specify 1433, that
is the default. Lastly, read MS's document for the driver to be sure if 'db' is the
correct property for the default database context.
Joe

>
> at weblogic.socket.NTSocketMuxer.initiateIO(Native Method)
> at weblogic.socket.NTSocketMuxer.read(NTSocketMuxer.java:419)
> at weblogic.servlet.internal.MuxableSocketHTTP.requeue(MuxableSocketHTTP.java:247)
> at weblogic.servlet.internal.ServletResponseImpl.send(ServletResponseImpl.java:1034)
> at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2265)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
> >
> <15.09.2003 20:17:50 CEST> <Error> <JDBC> <Cannot startup connection pool "BestandstagPool"
> String i
> ndex out of range: 0>
>
> i can make ping from Server Maschine to DB Maschine. The ping is O.K. I can connect
> with Bea JDBC Driver. But i will use the Microsoft driver for better Performance
> and RPC Call an DB.
>
> the File RequestError ist the error Info in Console.
>
> can you help me.
> thanks Halim
>
> ----------------------------------------------------------------------------------------------------
> Name: requestError.txt
> requestError.txt Type: Plain Text (text/plain)
> Encoding: base64

[Stephen Felts]

A config entry for SQL Server should look something like this (generated with the WLS 8.1
JDBC Assistant in the console):

<JDBCConnectionPool
DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
Name="ms-mssql" Password="PASSWORD"

Properties="user=USER;url=jdbc:microsoft:sqlserver://MACHINE:1433;selectMethod=cursor;dataSourceName=SQL2000JDBC;userName=lcqasql1
;databaseName=wls1;serv
erName=NAME"
Targets="myserver"
TestTableName="SQL SELECT COUNT(*) FROM sysobjects"
URL="jdbc:microsoft:sqlserver://MACHINE:1433"/>

"Halim" <Abdolhalim....@AWD.de> wrote in message news:3f660bcc$1...@newsgroups.bea.com...

>
> hi,
> i have a problem to initial a ConnectionPool in the Bea WLS with microsoft JDBC
> Driver.
> Enviroment: Bea WLS 6.1 SP3, DB SQL Server 2000, Microsoft SQl Server 2000 Driver
> for JDBC SP1 Version 2.2.0029 December 2002
>
> I make this in Bea WLS console/Services/JDBC/ConnectionPool:
> Name: BestandsPool
> URL: jdbc:microsoft:sqlserver
> Driver Classname: com.microsoft.jdbc.sqlserver.SQLServerDriver
> properties:
> db=Bestand
> user=XXX
> password=XXX
> server=XXX:1433
>
> i get this error Message in the Dos Console from the BEA:
> <15.09.2003 20:17:49 CEST> <Error> <HTTP> <Connection failure
> java.net.SocketException: ReadFile failed: Der angegebene Netzwerkname ist nicht
> mehr verfłgbar.
> (error 64, fd 2536)