locked
ODBC on Windows 7 x64 RRS feed

  • Question

  • Hello everybody. 

    I'm having a huge problem with ODBC on Windows 7x64. I've been experiencing this for a few weeks and still find no solution at all. I want to connect to SQL Database from Netbean (6.9.1) but whenever I do that, the notification appears and my program just doesn't work. I'm having MSQL 2008 devx64 and netbean 6.9.1 installed, I'm sure none of them are 32bit version. I searched every where on Internet and it still remains unresolved. In need of a help indeed.

    The error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

    Thanks in advance.

    Friday, February 11, 2011 4:05 PM

Answers

All replies

  • does a 64Bit ODBC driver exist for SQL Server?



    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    Friday, February 11, 2011 5:06 PM
  • As the processes tab in task manager shows, my ODBC is not a 32bit application (it's not marked with small star, afaik that means 64bit).

    Here is the code where to issue points to:

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

     

    Friday, February 11, 2011 5:12 PM
  • try this driver:

    http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=a737000d-68d0-4531-b65d-da0f2a735707


    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    • Marked as answer by Leo Huang Friday, February 18, 2011 9:03 AM
    Friday, February 11, 2011 5:17 PM
  • Exactly the same error exist when using ODBC to Access and Excel in Vista and 7, both x32 and x64

    I have posted this in different foras and no one at Microsoft seems to take this serious. Se for example

     "ODBC to MSAccess database in Windows 7 or Vista"  In this thread I have put the ODBC tracking file
    so the problem can be seen. 

    We are because of Microsofts lack of response now skipping the use of Microsoft databases in our next
    software versions.

    This link http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

    goes to a download that makes ODBC work in Vista and 7 x32 and x64, atleast with Excel and Access but instead
    applications that works fine in XP or earlier crashes on application shut down in Vista and 7.

    My guess is that Microsoft knows that there are an error in the ODBC drivers that come with Vista and 7 but does
    not care.

    /Mikael

     

     


    sTf_paPs
    Monday, March 7, 2011 1:55 PM