Hi Venkat, The reason there is no "suitable driver", is because you still have an error in your connection command. Actually Marco gave you the correct answer.
Please compare the following: Connection con = DriverManager.getConnection "jdbc:sapdb//localhost/TST","TEST","TEST"); Connection con = DriverManager.getConnection "jdbc:sapdb://localhost/TST","TEST","TEST"); The second one is the correct one. Notice the (:)colon after sapdb. Brian. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Venkat Sent: Tuesday, February 04, 2003 10:08 PM To: SAP Subject: Unable to connect ot sapdb7.4 using jdbc 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
