I.T. Discussion Community!
andreazc [Unspecified] -Collapse +Expand
-Collapse +Expand
andreazc
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (3)

Search andreazc:

Advanced
Personal Account . . .
andreazc
London, UK



Real Name:  andreazc [Unspecified]
Primary Role:  Coder
Joined: Dec 2000 (21 years ago)
Visits: 6
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

3 posts.
More...

Thread 3 of 3
Thread Starter or a Reply (but not last)  Group

andreazc
sql query to MS Access from Java
Hi, I am trying to send SQL queries to MS Access 97 using Java but I only seem to get any response if I have a simple query of the form SELECT * FROM CUSTOMERS., , If I want to send something just slightly more complicated then it doesn't work, for example SELECT SURNAME FROM CUSTOMERS., , The code that I am using is:, Statement stmt = dbCon.createStatement ();, ResultSet rs = stmt.executeQuery (sqlStatement); //error occurs here, ResultSetMetaData rsmd = rs.getMetaData();, , Is there a particular format that Access needs when sending a query or is this a problem with it?, , Thanks, Andrea
Posted to MB Topic: DB Other & Misc. « DBA Board
21 years ago

andreazc
Thank you for the suggestion, the problem is now resolved., , For your information (and anyone else who reads this) the actual problem was caused by a corrupt ODBC driver as discovered when I reinstalled Office and the problem disappeared!!!, , Cheers
20 years ago
Nothing New Since Your Last Visit
2963
Hits

DBA, Databases, & Data

Thread 2 of 3
Thread Starter or a Reply (but not last)  Group

andreazc
Re: sql query to MS Access from Java
Thank you for the suggestion, the problem is now resolved., , For your information (and anyone else who reads this) the actual problem was caused by a corrupt ODBC driver as discovered when I reinstalled Office and the problem disappeared!!!, , Cheers
Posted to MB Topic: DB Other & Misc. « DBA Board
20 years ago
Nothing New Since Your Last Visit
2
Hits

DBA, Databases, & Data

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech