can anyone Solve the JDBC adapter error :

[former_member185856]

Hi experts!!!

Whn I run File(FTP) to MSSQL Server ( JDBC), I m getting an error

<b>

Receiver Adapter v1027 for Party '', Service 'BS_JDBC_R2':

Configured at 12:16:42 2007-01-05

Last message processing started 12:17:09 2007-01-05, Error: Accessing database connection 'jdbc:Microsoft:sqlserver://sapep:1433;databaseName=tescra' failed: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Addtional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

Available JDBC drivers:

com.microsoft.jdbc.sqlserver.SQLServerDriver, 2.2 JDBC compliant</b>

Pls help me.... I have to clear it up.....

<b>If anyone solves this they gud gud points from me...trust me..really!!!!!</b>

Thanks in advance....

[Former Member]

Hi-

Check these blogs

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

[former_member185856]

Still not resolved !!!!!!!!!!!!!!

[MichalKrawczyk]

did you apply solution from my link?

Regards,

michal

[Former Member]

Hi Michal..

I checked..like osql.. svrnetcn.exe.. this commands.. everything was fine...see now in adapter framework..sometime it shows green for some fraction of seconds..and then its coems to red..what will be the problem..can you try for this

[bhavesh_kantilal]

In the receiver JDBC adapter try selecting the option,

Disconnect From Database after each message processing under Advanced Mode and give this a shot.

Regards

Bhavesh

[Former Member]

Hi kumar,

Does it affect your adapters configuration??

regards

krishna

[MichalKrawczyk]

hi,

have a look at this:

http://support.microsoft.com/kb/313178

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[VijayKonam]

You must have not specified you DB machine name/port name/database name correctly. Please remember.. everything is case sensitive in the world of JAVA.

Vijay