my dog learned polymorphism*
The moose likes JDBC and the fly likes Mircrosoft Driver Manager Invalid String or Buffer Length JDBC ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mircrosoft Driver Manager Invalid String or Buffer Length JDBC ODBC" Watch "Mircrosoft Driver Manager Invalid String or Buffer Length JDBC ODBC" New topic
Author

Mircrosoft Driver Manager Invalid String or Buffer Length JDBC ODBC

Xenon Surves
Greenhorn

Joined: Apr 14, 2010
Posts: 4
Hello,

Im really frustrated finding this probs solution. here the code


Im using this in a servlet to connect to a database on local server thats my pc.
Problem Im facing is Im getting a Invalid String or Buffer Length error of Microsoft Driver Manager.

Im confused a bit with this issue since this code worked for me smoothly in Windows XP SP3 32 bit and since
I have upgraded my system to 7 64 bit its not working and I think there lies the problem.

Im using netbeans 6.8 as my IDE, Sql Server 2008 Express as my provider and windows 7 64 bit as my OS

Now, here what I have tried since 2 weeks to correct this issue:


Can anyone please solve the problem. Its urgent.

Thank You!
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2510
    
  10

Can you download 32-bit jdk, and try with that.
(assuming that you are trying to connect to Access database, and I might stand corrected, but) At this moment there is no solution to operate jdbc odbc bridge to Access from 64 bit java.

http://support.microsoft.com/kb/957570


OCUP UML fundamental and ITIL foundation
youtube channel
Xenon Surves
Greenhorn

Joined: Apr 14, 2010
Posts: 4
No I cant
32 bit jdk wont allow me install netbeans.
I read somewhere that shifting from java to javaw would do the trick.
You know whats that ? or how to do it ?

Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2510
    
  10

I don't know how to do that.

There are, however, commercial pure Java MS Access JDBC drivers.
You could download a trial version and check if that works with your 64 bit setup.
Xenon Surves
Greenhorn

Joined: Apr 14, 2010
Posts: 4
This 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 driver manager of windows 7 64-bit,and theres no
way I was able to fix it.

I recommend all users to use a mysql server if your craeting a web application.
Download a server called WAMP 2.0
its working now for me.

heres a tutorial I found:
http://www.youtube.com/watch?v=Q6VZIyYUyQg

i hope this will help the needy.

I would like to ask administrator to consider this post resolved.

Thankx!
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2510
    
  10

Xenon Surves wrote:
....
I would like to ask administrator to consider this post resolved.
...

I am going to mark it as unresolvable. The original issue (MSAccess on 64 bit) is not resolved.

Good luck with your project, and with MySQL!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mircrosoft Driver Manager Invalid String or Buffer Length JDBC ODBC