How to create Data source in visual admin ? All steps Pls....

[Former Member]

Hi All

I was not able to create Data sources in Visual admin

Can any one guide me on that step by step ?

(Thing is in place all JDBC connections we want to use data sources)

-

---

Awaiting for response

adv...thanx and points

--- Rakesh

[Former Member]

Hi Rakesh,,

Hope this will be useful

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/7f/d84b25d49846819d08e1c8ba03a9cd/frameset.htm">Creating Datasource</a>

Browse for using visual admin

cheers

Swathi

Do offer pts nd ncourage:-)

[Former Member]

Hi Swathi

Can you refer me any document which cantains all steps with screen shots ?

because i am very new to this and which connection to used ?

DTD ? data-sources.xml file required ? many questions

--- We developed the application with hard coded the driver rather we want to

go with data sources(Replace all the connections with data sources)

Regards

-

---

Rakesh

[ankur_garg5]

Hi Rakesh,

Dont know whether you were able to solve your problem or not?

Nevertheless, I am giving the links of some docs which can help you understand what has to be done in Visual Administrator.

<a href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a09424">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a09424</a>

The above doc will tell you how to configure the JDBC driver at the back end. See pages 5, 6, and 7. On page 6, the JDBC driver JARs (there are 3 JAR files needed for MS SQL Server 2000) that it talks about in point 7 have to be downloaded from the internet, and the drivers which need to be downloaded can be had from the following link:

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/VC/JDBC%2bConnection%2bSetup">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/VC/JDBC%2bConnection%2bSetup</a>

Next step is creating a data source. Have a look at the following doc. Go to page 6 and 7.

<a href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea04182875f">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea04182875f</a>

This doc will just give you a view as to how data source is created. For actual steps, have a look at this post:

<a href="https://www.sdn.sap.com/irj/sdn/thread?threadID=67404">https://www.sdn.sap.com/irj/sdn/thread?threadID=67404</a>

See what ashish mittal has written, you have to follow the exact same steps what he has done in the first case ie. you have to choose JDBC version 1.x

The Driver class and the Database Url can be had from the same Wiki link given above (giving it again):

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/VC/JDBC%2bConnection%2bSetup">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/VC/JDBC%2bConnection%2bSetup</a>

Hope it solves your problem.

Please do reward points for helpful answers!!

Bye

Ankur