Defining datasource in portal application

[Former Member]

Hi there,

I am doing portal application.

I have define my MSSQL driver on the server and i amworking currently in my local machine. I want to connect from my local machine to the server's datasource.

What codes should i put in the JSPDynPage

Thanks Loads

Quatre

[Former Member]

For creating systems based on connectors provided by SAP:

The application connector and its PAR file are installed to the Web application server and the PCD, respectively, and configured.

For creating systems NOT based on connectors provided by SAP:

You have edited an existing PAR file, or written your own, to contain a portalapp.xml file where you define a non-SAP system to which you want to connect, and you have deployed it.

steps to be followed

1. From top-level navigation, choose System Administration -> System Configuration -> System Landscape.

2. In the Portal Catalog, right-click a folder in which to store the new system and choose either New -> System (from template)or New ->System (from PAR).

3. Follow the instructions for each screen of the wizard,

Whether you create a new system from a PAR file or from a template, the SAP_ConnectionString is not supported for JCOClient.

The template SAP system using connection string is not supported for connections by means of JCOClient.

after following steps You might have created a system through which you can access a back-end application or an HTTP source, and retrieve its data. This system is now part of the portal system landscape and should appear in the System Landscape Overview iView.

*****please provide points if the information is helpful to you******************

Message was edited by:

Venkatesh HN

[Former Member]

hi...

chk out these links......

http://java.sun.com/products/jdbc/driverdesc.html

Regards,

Sudheer

Message was edited by:

Sudheer Reddy

[Former Member]

hi....

why dont u use the <b>type 4</b> drivers instead and ...for this u need to include the required jars like msbase, mssqlserver in the <b>PORTAL-INF/LIB</b> folder.

with this u dont need to define anything in the server.

Hope this helps,

Regards,

Sudheer

Message was edited by:

Sudheer Reddy

[Former Member]

hi there

wad is <b>type 4</b> ? Sorry i am new to EP/SAP.

Thanks loads

Quatre

[vijayakhanna_raman]

Hi,

I find same quesion is asked in different ways in 4 threads. Can u check these two posts? I think u would have located the log file and configured visual admin for log. If u need more infm, post in the same thread. If ur question is answered, provide points to people who have spent time in helping u and close it. Please don't leave the thread opened and reopen another with same question.

Regards,

Vijai

[praveenkumar_gudapati]

Hi,

You should define a DataSource in your Visual Administrator for your MS SQL server. Then define JDBC Driver for it. After that you can directly make a DB Connection and exectute JDBC statements.

JDBC Connector Service

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/frameset.htm

To connect to the Java persistence layer in the J2EE Engine, you use an instance of javax.sql.DataSource

http://help.sap.com/saphelp_nw2004s/helpdata/en/fe/9e362f3d954e8e8555007d8030df63/frameset.htm

Greetings,

Praveen Gudapati

[Points are always welcome for helpful answers]

[Former Member]

Hi,

See this thread it will help you

Regards,

Senthil K