Prev: How use datcomimport
Next: Plotting Column Values Against Row Values
From: Hakon Haugnes on 30 Oct 2009 07:50
I am on Vista X64 with Matlab 2009a, on a trial license trying to prove that Matlab is a great product :) - however, I am having the exact same problem - I have set up a ODBC User DSN and system DSN, the database using Windows Authentication (tried with a password/username too) and still getting the annoying message:

Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
Message: '[Microsoft][ODBC Driver Manager] Invalid string or buffer length'
Handle: 0
TimeOut: []
AutoCommit: 'off'
Type: 'Database Object'


Mathworks - please sort this out? From this thread it looks like it is a bug in Matlab on x64 platforms..?
From: Luis Cantero on 30 Oct 2009 08:56
Please see the following:
Tip: Some Windows systems support both ODBC and JDBC drivers. On such systems, JDBC drivers generally provide better performance than ODBC drivers because the ODBC/JDBC bridge is not used to access databases.

Source:
http://www.mathworks.com/access/helpdesk/help/toolbox/database/gs/braiey2-1.html#bre040n-1

Useful information and troubleshooting help can be found here:
How can I access a SQL Server database with a JDBC driver if I have Windows Authentication using Database Toolbox 3.5 (R2008b)? - 1-9SHNAT
http://www.mathworks.com/support/solutions/en/data/1-9SHNAT/?solution=1-9SHNAT
From: Oleg Komarov on 11 Nov 2009 04:27
Well you could also try my new release (that is going to be published soon with the windows authentication feature) on:
http://www.mathworks.com/matlabcentral/fileexchange/25577-ms-sql-jdbc-connection
 | 
Pages: 1
Prev: How use datcomimport
Next: Plotting Column Values Against Row Values