Wednesday, June 11, 2014
[Microsoft][ODBC Driver Manager] Invalid string or buffer length exception for 64 bit SQL Server
this is a java bug, upgrade to java 1.7.70 at least
Monday, June 9, 2014
java and access
to connect access form java, i get this error.
Error:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
To connect java 64 bit with access, it 's necesary install driver 64 bit download and install http://download.microsoft.com/download/0/B/8/0B8EFDD9-8CE5-405C-A28D-A108A63AE2FC/AccessDatabaseEngine_X64.exe
And if you want read all query and launch this query "SELECT [Name] FROM MSysObjects WHERE Name Like 'MSys*' ORDER BY [Name]"
you get this error:
error:
READ en 'MSysObjects'
You must execute a macro
http://stackoverflow.com/questions/19971082/no-read-permission-on-msysobjects
strDdl = "GRANT SELECT ON MSysObjects TO Admin;"
CurrentProject.Connection.Execute strDdl
If you get this error "ODBC Driver Manager 'invalid string or buffer length' error " , my solver is update java 1.7.70 at least.
Subscribe to:
Posts (Atom)