Hi all,
Thanks for the help.
Now itz working.
Connection con =
DriverManager.getConnection("jdbc:sapdb://localhost/TST","TEST","TEST");
or
Connection con =
DriverManager.getConnection("jdbc:sapdb://localhost/TST?user=TEST&password=T
EST");Sorry for a stupid thing i game wrong ip insted of local host. Thanks for the help Again sory for the stupid thing as my ip was changed i didn't noticed that. Thank you all venkat -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Venkat Sent: Wednesday, February 05, 2003 11:58 AM To: SAP; Brian C. Woodcox Subject: RE: Unable to connect ot sapdb7.4 using jdbc Hi Brain, Thanks for the correction.But i still facing the problem Connection con = DriverManager.getConnection("jdbc:sapdb://localhost/TST"); I tried even Connection con = DriverManager.getConnection("jdbc:sapdb://localhost/TST?user=TEST&password=T EST"); Connection con = DriverManager.getConnection("jdbc:sapdb://localhost/TST?user=DBM&password=DB M"); Connection con = DriverManager.getConnection("jdbc:sapdb://localhost/TST?user=TEST&password=T EST&sqlmode=INTERNAL"); But no luck. I check with sqlstudio and it is connection to TST. and all the services are running. Now error is com.sap.dbtech.jdbc.exception.JDBCDriverException: SAP DBTech JDBC: Cannot connecto to jdbc:sapdb://192.168.1.64/TST [Cannot connect to host 192.168.1.64 [connection refused: connect], [2].]. Where i went wrong. Thanks in advance venkat -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian C. Woodcox Sent: Wednesday, February 05, 2003 11:26 AM To: SAP Subject: RE: Unable to connect ot sapdb7.4 using jdbc 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 _______________________________________________ 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
