1. ODBC to JDBC datatypes mapping stackoverflow.comWhere can I find description of how to map ODBC datatypes to JDBC? Or maybe anybody knows where source code of a jdbc-odbc bridge driver can be downloaded? |
2. Consistent method of inserting TEXT column to Informix database using JDBC and ODBC stackoverflow.comI have problem when I try insert some data to Informix TEXT column via JDBC. In ODBC I can simply run SQL like this:
but this do not ... |
3. Java can't find right ODBC-Datasource stackoverflow.comI created a BIRT report and deployed it to tomcat. It runs fine on localhost, but not on the server. The app doesn't find the right ODBC datasource. But the datasource ... |
4. RETURN_GENERATED_KEYS doesn't work using JDBC ODBC stackoverflow.comI'm trying to get insert ID while after inserting some data in my database.
But I got ... |
5. Detect Database Currently in Use with Java stackoverflow.comIs there a way to detect the ODBC database currently being connected to with Java? For example, I would like to know whether an application is currently connected to Oracle 10g or ... |
6. how to create a dsn for oracleinxe? stackoverflow.comi have oracle 10g express edition installed and i want to know how to create a system dsn for it.so that i can connect database to my java programs |
7. JAVA - insert into DB problem stackoverflow.comI've got a problem where I'm inserting data into a database. It's returning that 1 row is being inserted, but when I actually check the database, nothing new has actually been ... |
8. Java: cannot update Excel using JDBC ODBC stackoverflow.comI can read rows/columns just fine, but I can't update, insert or delete.
|
9. ODBC Error: Invalid String or Buffer Length--Microsoft Server 2008 32bit vs 2008 R2 64bit stackoverflow.comAttempting to connect from Java 6 console app to Microsoft SQL Server 2008 R2 on an Microsoft Windows Server 2008 R2 64bit system via an ODBC System DSN using SQL Server ... |
10. JDBC and ODBC backend information stackoverflow.comIf I am given the JDBC and ODBC from a site and they aren't giving me what database in the backend they're using (MySQL, PostgreSQL, SQLServer). Is there a way to ... |
11. jdbc odbc connectivity stackoverflow.comam a newbie to java. I want to create a table in MYSQL and insert images into it.I have to write code in java to insert the images. can anyone tell ... |
12. Error while executing Java code in RFT stackoverflow.comI am using RFT(Rational Functional Tester) 8.2 for my automation. I am getting error when I am doing the following steps
|
13. ODBC vs JDBC vs ADO.NET stackoverflow.comWhat exactly are ODBC, JDBC and ADO.NET? What are the links between them? |
14. Get table names from lotus notes database stackoverflow.comI'm trying to write a program that would dump a whole lotus notes database to a file via NotesSQL driver. I'm connecting via jdbc:odbc and have I can execute selects and ... |
15. How do I install an ODBC library in Jython stackoverflow.comIn python is possible to install pyodbc fairly easy, but in jython you are supposed either to install django, and to instal jdbc and then I do not know what else. ... |
16. Is there a standard for REST database connectivity? stackoverflow.comIs there a standard for REST database connectivity, or anyone hearing any whiffs of a plan? A standard similar to JDBC or ODBC for REST? I am not asking about some people ... |
17. "[Microsoft][ODBC Driver Manager] Invalid string or buffer length" error stackoverflow.comWhen I run in eclipse it runs fine. But, through the command prompt, it throws the exception |
18. "Solved" Query Excel date fields using ODBC return null stackoverflow.comI use the following configuration to run a java program to extract data from a excel file. Some of these columns have data with time-stamp context.
|
19. jdbc to odbc bytes.com@r035198x That is not what the OP attempted to use it for; the first column of that table is an auto-increment column and the OP was trying to express ? as ... |
20. JDBC ODBC in Netbeans 6.1 forums.netbeans.orgI connect to database via JDBC-ODBC bridge. My program does a lot of searching queries and I feel stored procedures can reduce the time. But My program gives the runtime exception ... |
21. JDBC ODBC in Netbeans 6.1 forums.netbeans.orgI connect to database via JDBC-ODBC bridge. My program does a lot of searching queries and I feel stored procedures can reduce the time. But My program gives the runtime exception ... |
22. I tried to drag&drop table + Ctrl from jdbc:odbc forums.netbeans.orgI tried to drag&drop table + Ctrl from jdbc:odbc connection and everything hungs up. Also I tried it in netbeans 6.8 causes same result. How can I use this function? ... |
23. ODBC and xBase coderanch.com |
24. JDBC:ODBC: DRIVINGMECRAZY coderanch.comEverything I read assumes I already know a bit about JDBC the fact is I don't.. I have Java 2 installed and it says that JDBC is included however when I run a JDBCtester I found on the net it states that class sun.jdbc.odbc.SunJdbcOdbcDriver could not be found... registerDriver().. failed Do I need to download something separate in order for JDBC ... |
25. ODBC Driver Manager Function sequence error coderanch.com |
26. JDBC ODBC error coderanch.com |
27. ODBC error: COUNT field incorrect coderanch.comHi. I am using VAJ 3.5 and am trying to update and insert a row into a table. I can run a select statement just fine, but on both the update and insert commands, I keep getting the following error: A database manager error occurred. SQL State: 07001 [Microsoft][ODBC SQL Server Driver]COUNT field incorrect Any ideas? I have a very limited ... |
28. JDBC /ODBC connectivity coderanch.comIf you are using Sun's JDBC-ODBC bridge driver, you will have to set up an ODBC DSN to your Oracle database, which will require that you have a driver present on your local machine. You would have that driver if you had the Oracle client installed. If you are saying that your machine is both the client and the server, then ... |
29. ODBC, DNS, JDBC coderanch.com |
30. JDBC ODBC Concetivity coderanch.com |
31. JDBC ODBC host string coderanch.com |
32. Odbc coderanch.com |
33. jdbc:odbc issue under JRun coderanch.comI just wanted to post this here to see if someone else had run across this, or to help someone who is going to. Here's what I'm doing on a .jsp page in JRun (windows 2000 install) < %@ page import="javax.naming.*, javax.rmi.PortableRemoteObject, java.sql.*, javax.sql.*, java.io.*, javax.servlet.*, javax.servlet.http.*" % > < % |
34. JDBC to ODBC to ODBC? coderanch.comThis is an odd one.... I've got a Linux machine and I need to connect to a remote SQL Server database. From what I can tell, I'll have to use some type of ODBC bridge to contact the SQL Server, then use the JDBC->ODBC bridge on the Linux machine to talk to the ODBC bridge. That's far too many bridges to ... |
35. Odbc problem help me coderanch.comhai all i am new to this section ,i have a problem with connecting to oracle by using odbc driver. First on windows 95 i installed oracle 7.3 and tryed to connect to it using odbc(Microsoft odbc driver for oracle) driver ,when i run my java application an window appears on the screen saying oracle client and network components where not ... |
36. jdbc:odbc coderanch.com |
37. ODBC coderanch.com |
38. Help needed with JDBC ODBC coderanch.comHi friends, I have created a servlet which connect with Access db and get data. When I run my servlet it throws me an error which says SQL exception: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedMy code is... url = "jdbc dbc:EmpDetails"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); conn = DriverManager.getConnection(url,"",""); stmt = conn.createStatement(); rs = ... |
39. ODBC DNS setting coderanch.com |
40. ODBC coderanch.com |
41. Setting up the ODBC settings coderanch.com |
42. ODBC authentication problem coderanch.comBy using sessions u can handle this problem e.g. u create html file for login. There is 2 text boxes in it one is for user name and other for password,there names are id and p. In jsp file in scriplets tag <% id = request.getParameter("id"); pass=request.getParameter("p"); if((id.equals("salman"))&&(pass.equals("salman12"))) {session.putvalue("usr",id); In this way u can solve ur problem |
43. How to Find what ODBC DSNs a computer have coderanch.com |
44. jdbc:odbc Help coderanch.com |
45. executeUpdate ODBC Too few parameters coderanch.comClass.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); java.sql.Connection con = null; java.sql.Statement stmt = null; java.sql.ResultSet rs = null; con = java.sql.DriverManager.getConnection("jdbc :-o dbc:Car","",""); stmt = con.createStatement(); // \" will put the quote into the string. String str = "INSERT INTO tblCars (Make,Name,Color,Price)"; str += " VALUES (\"" + carX.getMake() +" \",\" "+ carX.getName(); str += " \",\" "+ carX.getColor() +" \", "+carX.getPrice()+ ")"; int result = ... |
46. jdbc:odbc problem coderanch.com |
47. jdbc:odbc insert error fails with code -3502 coderanch.comI am calling a preparedstatement that performs inserts on a single table in an access database. However, the insert fails and I can't figure out why - any help is most appreciated. I also tried this as a batch, and that didn't work either. // code that inserts in to the database: PreparedStatement addFee = cnxn.prepareStatement("INSERT INTO RegistrationFee(meetingID,feeType,regularFee,earlyFee,description,order) VALUES("+meetingID+",?,?,?,?,?)"); // regFees ... |
48. ODBC and JDBC!!! coderanch.comhi folks, i saw that i can connect to a database with ODBC(ie manking DSN) and also with JDBC.but what i can't see is that what circumstance requires to choose one over the other. could you please educate me with this? thanks. [ August 30, 2003: Message edited by: Namaste Sathi ] |
49. updateDate using jdbc : odbc coderanch.comHi I am trying to update a field of type Datetime on SQL Server using jdbc: odbc bridge and I am not able to do that. I get different errors like [Microsoft][ODBC SQL Server Driver]Invalid date format and sometimes I get just 'null' this is the code I am using... import java.sql.*; public class jdbc1{ public static void main(String[] args) { ... |
50. JDBC or ODBC and Excel coderanch.comJoe, I looked at the article, but am confused about something: The name of the Excel file is qa.xls, but it often refers to qa-list. Why does it add the -list on the end? I am actually not working with Java code, but a tool instead that connects to a database and retreives it's structure. 1)It asks for a DB Connection ... |
51. Problem with Like statement Using JDBC:ODBC coderanch.comHi ranchers! I have a problem. I'm using JDBC DBC to connect to a MS ACCESS 2000 database. When I run the query in MS ACCESS I get correct results. When I run it in the javacode I get an empty resultset. I Dont have any problem with select , update , delete statements that doesn't use "LIKE". Here is an ... |
52. Setup ODBC? coderanch.com |
53. jdbc:odbc password definition coderanch.comHi I have a java application connecting to a MS SQL Server database. I set up an ODBC connection in "Windows ODBC Data Source Administrator" using its SQL Server driver. I have no problems connecting and all SQL executes fine. I use the following driverManager: "sun.jdbc.odbc.JdbcOdbcDriver" and connectionString: "jdbc dbc atasourcename" However, it only seems to work if I define the ... |
54. ODBC call fail coderanch.comI have an Access database with a ms sql backend. This morning I was making some changes on the design of a table from the sql server.Then I linked the table on access to the one on the server. But when I try to open that table , all the fields are marked #Name? and I am havign the error odbc ... |
55. ODBC DSN Programmically coderanch.com |
56. ODBC - too few parameters ?? coderanch.com |
57. Applet JDBC.ODBC coderanch.com |
58. JDBC:ODBC Native Code errors,please help! coderanch.comHi,im writing a system using tomcat. I connect to an ingres database using an ODBC bridge. Lately Tomcat has been crashing and generating the error report below.I think it says that the native odbc driver is crashing and causing tomcat to crash.It crashes outside the java VM so theres seems to be little i can do.Would anyone know how to fix ... |
59. odbc coderanch.com |
60. JDBC vs ODBC coderanch.com |
61. difference between JDBC and ODBC coderanch.com |
62. odbc question coderanch.com |
63. " jdbc : odbc : " + something. what is this something? coderanch.com |
64. jdbc_odbc equivalent in linux? coderanch.com |
65. C/ODBC and ODBC for Navision coderanch.comDear all, I am trying to connect to Microsoft Navision database. I am having C/ODBC driver for Navision and I have created a DSN(using C/ODBC driver) in the system and tried to connect to database(Navision). I am not getting connected. But when I am trying to connect to other ODBC DSNs in the system, I am getting connected. Can anybody tell ... |
66. configuring ODBC coderanch.com |
67. ODBC configuration.help coderanch.comhi, i have tried configuring my ODBC, but bcos their are so many option(user DSN, System DSN, File DSN, etc) and so many things in the ADD button, i am really confused as per which to use and each time i try any option my program gives an error. i dont know if this is the best forum for me to ... |
68. problem in enterin data through jdbc:odbc coderanch.com |
69. I can't seem to get my ODBC url right coderanch.com |
70. configure an ODBC datasource----help coderanch.com |
71. Dynamically create ODBC source coderanch.comI am having difficulty finding the right Google query, so hopefully someone can steer me in the right direction. I am using a database to populate an excel file. Using JDBC:ODBC I am able to read and write from the excel file (and boy did it feel good to get that figured out), I can also create a workbook of n ... |
72. Error in JDBC ODBC coderanch.com<%@ page language="java" session="true" errorPage="error.jsp" import="java.io.*,java.sql.*" %> <% Connection con = null; Statement st = null; ResultSet rs = null; String username = request.getParameter("id"); String password = request.getParameter("passwd"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:forum"); st = con.createStatement(); rs = st.executeQuery("select id,uname,password from users"); while(rs.next()) { if(username.equals(rs.getString(2)) && password.equals(rs.getString(3))) { session.setAttribute("uid",username); session.setAttribute("id",rs.getString("id")); response.sendRedirect("/examples/jsp/forum.jsp"); } } response.sendRedirect("login.html"); } catch(Exception e) { out.println(e); } ... |
73. JDBC ODBC coderanch.comOkay, I'm a little confused as to why you want an ODBC driver for DB2, when DB2 ships with two very sexy drivers, the .net driver and the .app driver. Both of these drivers are in the db2java.zip file, and if you have db2java.zip on your Java classpath, you can connect very easily to db2. Using the JDBC-ODBC bridge with DB2 ... |
74. Jdbc Odbc and bank transaction related question coderanch.com1. What is the difference between jdbc and odbc? 2. Please explain the 4 levels of jdbc drivers? 3. Consider the bank situation where the husband and wife are holding the joint account and there is a balance amount of 1000/-. Now the husband logs in through ATM also simultaneousl wife logs in through ATM. Both of them see the amount ... |
75. Error messages using ODBC coderanch.comHi , I'm having a problem with this code. I'm trying to connect to a locally stored access databank. I am running the Java application from within Eclipse.... can someone help me here? thank you! import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; public class test2 extends Frame { // GUI-Variable Label status = new Label("bereit ...", Label.LEFT); Panel panel = ... |
76. What is ODBC coderanch.comWhen you are communicating with MSSql directly in an all-windows environment, ODBC may be faster. JDBC can't talk directly to ODBC and therefore needs a bridge, so then you have Java app -> JDBC -> JDBC-ODBC Bridge -> ODBC -> MSSql You don't need to talk via the bridge, and the JDBC-ODBC Bridge is not great - it was never meant ... |
77. ODBC error coderanch.comHi, I am using Oracle 10g, in Windows XP, ODBC database administrator list contains oracle in OraDb10g_home2 instance, version 10.02.00.01. When I try to add this an error is being thrown saying "ODBC driver could not be loaded due to system error 998". May I know how to solve this problm as soon as possible. thanks and regards, Rahul. |
78. JDBC &ODBC coderanch.com |
79. JDBC:ODBC, Remote DSN and FoxPro (I am confused...) coderanch.comI am just in a design phase. I want to access dbase FoxPro free tables from jsp's pages. I found an application in my library which can serve the purpose properly after minor changes. But its been developed considering windows environment (VFP ODBC DSN connection). Now problem is currently I have only Linux server with apache tomcat 5 on it. I ... |
80. JDBC or ODBC coderanch.com |
81. Mircrosoft Driver Manager Invalid String or Buffer Length JDBC ODBC coderanch.comThis is for all those who have stuck on the same issue: Guys sincerely im really upset about the fact that I wasnt able to get any solution for this. Theres no update/ fix available for this issue. I have tried installed Visual Studio 2008/2010 all the sql servers since 2005 But i assume that problem exists in the Microsoft ODBC ... |
82. ODBC names coderanch.com |
83. JDBC (ODBC) Concurrency confusion coderanch.comHi Everyone. I'm a Computing Student and I'm working on some test code that will hopefully help in the construction of a new System for a friend of mine for some much needed cash over the summer. I'm fairly confident with most aspects of the requirements, but the one that has me stumped is safe concurrent access to a Database via ... |
84. where can I download and instal ODBC for excel coderanch.com |
85. Java application crashes because of ODBC coderanch.comHi all, I wrote a short java program that is suppose to print the column names of a certain table ("PrintHistory) in an Access database. This is the code: public class JdbcWithJre6 { /** * @param args */ public static void main(String[] args) { final String url = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=j://magic//WD_DEV3//lastprintout28102008.mdb"; Connection c = null; ResultSet rs = null; try ... |
87. Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch coderanch.compublic Customer getCustomerInfoFromDB(String nameId) { Customer cust = new Customer(); String url = "jdbc:odbc:CustomersDB"; String sqlQuery = "SELECT FirstName, LastName, Address, City, State, Zip FROM Customer where LastName =" + "\'"+ nameId + "\'"; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = DriverManager.getConnection(url, "lexx", "java"); stmt = conn.createStatement(); rs = stmt.executeQuery(sqlQuery); // ... |
88. Java: calling jdbc.odbc from browser dbforums.comI would like to have the browser call a java program which, among other things, executes database record retrievals. I have the following java code working correctly: import java.sql.*; public class db { public static void main (String[] args) { Connection conn; ResultSet res; Statement stat; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = DriverManager.getConnection("jdbcdbc:test"); stat = conn.createStatement(); res = stat.executeQuery("Select field1 from table1"); ... |
89. Looking for JDBC:ODBC and MDAC replacement dbforums.comI'm developing a java application which has to read and write a lot of different db file formats. All file handling is currently done through JDBC:ODBC and MDAC ODBC drivers. Our application supports: txt/csv (Comma Seperated Values), xls (MS Excel), mdb (MS Access) and dbf (MS FoxPro, dBase). However, we are not satisfied with the speed, stability of those drivers and ... |
90. without ODBC java-forums.org |
91. jdbc and odbc forums.oracle.comHi I am new to Java prog. What is the difference between OBDC and JDBC ? I am asking it as I encountered something like this in book The code fragment below illustrates creation of a connection for the JBDC driver for ODBC: import java.util.Properties; // ... String driverName = ?sun.jdbc.odbc.JdbcOdbcDriver?; String sourceURL = ?jdbc.odbc:technical_library?; try { Class.forName (driverName); Properties prop ... |
92. JDBC odbc performance issue... forums.oracle.comNow, if i run this in a loop, in other words if this get calls multiple times, my cpu go crazy... almost 99% with 50 calls to this stored procedure if ran ||. I checked about caching it. I did cached it but still my cpu consumption is same. Any help is great. My connections are hopfully being closed or being ... |
93. creating an executable - Also setting up DB and ODBC with it forums.oracle.com |
94. JDBC & ODBC forums.oracle.comWhy are you using ODBC, when there is a very good JDBC driver for MS SQL Server? As you have the problem on Windows 64 bit, make sure that either 1) You are using 64 bit Java, 2) the 64 bit MS SQL ODBC driver and 3) the 64 bit odbcad32.exe (in C:\windows\system32(!)) to setup the DSN or 1) You are ... |