Hi all,
I downloaded the sapdbc.jar and pointed classpath to the jar file
I am able to compile the java file but unable to run it.


When i try to connect sapdb using java
I am geting execption java.sql.Exception : no suitable driver

I tried these options
Class.forName("com.sap.dbtech.jdbc.DriverSapDB");

Connection
con=DriverManager.getConnection("jdbc:sapdb//localhost/TST","TEST","TEST");

Connection con=DriverManager.getConnection("jdbc:sapdb//localhost/TST");

insted of localhost i gave the ip

But no luck.

I checked the helloSapdb.java
Here the connection part.

          user = options.getProperty ("user");
        password = options.getProperty ("password");
        String url = "jdbc:sapdb://" + host + "/" + dbname;
        /*
         * load driver and connect
         */
        Class.forName ("com.sap.dbtech.jdbc.DriverSapDB");
        Connection connection = DriverManager.getConnection (url, user,
password);

Can some one help me where i went wrong.

Thanks in advance
regards
venkat

-----Original Message-----
From: Paskamp, Marco [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 5:55 PM
To: 'Venkat'; SAP
Subject: RE: New Bie--Unable to install


Hello,
your connect URL is wrong. The general layout is:
jdbc:sapdb://<host>/<database_name>. So, you should use the following URL:
"jdbc:sapdb://localhost/TST"
Details about the connect URL, connect options and a simple hello-JDBC-world
programm can you find at:
http://www.sapdb.org/7.4/jdbcSapdbcEng.html

Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Venkat [mailto:[EMAIL PROTECTED]]
> Sent: Dienstag, 4. Februar 2003 13:15
> To: SAP
> Subject: RE: New Bie--Unable to install
>
>
> Hi all,
> I installed the sapdb and able to configure all the services.
> The problem is i have to login as administrator.
>
> I am able to run all the services.
> I created a table login under TST database and  now i want to
> connect using
> java.
> I downloaded the sapdbc.jar and pointed classpath to the jar file
> I am able to compile the java file but unable to run it.
>
> it is throwing exception : no suitable driver
>
> Here my connection
>
> Class.forName("com.sap.dbtech.jdbc.DriverSapDB");
> Connection
> con=DriverManager.getConnection("jdbc:sapdb//localhost:85/TST"
> ,"TEST","TEST"
> );
>
>
> Do i need to download some driver for jdbc bridge?
> I created a dsn but no luck.
>
> Can some one help me the parameter to pass into
> DriverManager.getConnection();
>
> Thanks in advance.
>
> regards
> venkat
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Venkat
> Sent: Tuesday, February 04, 2003 3:26 PM
> To: SAP
> Subject: New Bie--Unable to install
>
>
> Hi all,
>
> I am new to sapdb and trying to install sapdb 7.4
> (sapdb-all-win-32bit-i386-7_4_3_7).
>
> When i give the option profile id: 5 and giving all defalut values it
> started installing and after some time window is closed.
>
> My environment is win 2000 with sp2.
>
> Can some one tell me what is happening?
>
> Thanks in advance
>
> regards
> venkat
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to