Rank: 1676 based on 35 downloads (last 30 days) and 2 files submitted
photo

Martin Furlan

E-mail

Personal Profile:
Professional Interests:
vibrations, noise, signal processing, FEM, BEM

 

Watch this Author's files

 

Files Posted by Martin View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
29 Jan 2007 diskfree Queries the free space of a volume Author: Martin Furlan path, directories, files, disk, disk usage, free space 1 5
  • 3.0
3.0 | 2 ratings
10 Jan 2007 ADO OLE Database Connection Queries datasource and insers data into datasource. Author: Martin Furlan database, sql, oracle, insert, query, data import 34 12
  • 4.66667
4.7 | 12 ratings
Comments and Ratings on Martin's Files View all
Updated File Comment by Comments Rating
12 Jan 2012 ADO OLE Database Connection Queries datasource and insers data into datasource. Author: Martin Furlan Daly, Robert

This is a great tool, I have been using it for a while with out a hitch. Just recently it started to go wrong and gave the error:
"No public field CursorLocation exists for class COM.ADODB_Connection"
I found if I commented out the folowing line from adodb_connect
ado_connection.CursorLocation = 'adUseClient'; % Uses a client-side cursor supplied by a local cursor library
this error went away.
After this it had a problem with the line from adodb_query...
if (ado_recordset.State && ado_recordset.RecordCount>0)

I found if I delete this (and the corresponding end) it works fine for my purposes. I'm not exactly sure what this did (anybody?) and what errors will crop up now that it isn't there.
I wonder if there has been an update to the ADODB set up and now some of the methods and classes have changed since this code was written.

20 Sep 2011 ADO OLE Database Connection Queries datasource and insers data into datasource. Author: Martin Furlan Brian

I'm getting this error on Win7 64 box:

Make sure adotest.mdb is in the current directory
??? Invoke Error, Dispatch Exception:
Source: ADODB.Connection
Description: Provider cannot be found. It may not be properly installed.
Help File: C:\Windows\HELP\ADO270.CHM
Help Context ID: 12ee4f

Error in ==> adodbcn at 29
invoke(cn,'Open', cnstr);

Error in ==> adodb_demo at 30
cn=adodbcn(s);

13 Jan 2011 ADO OLE Database Connection Queries datasource and insers data into datasource. Author: Martin Furlan Kevin

does somebody have an example of running this with Oracle i keep getting an error.
  ??? Invoke Error, Dispatch Exception:
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Oracle][ODBC][Ora]ORA-12154: TNS:could
not resolve the connect identifier specified

23 Nov 2010 ADO OLE Database Connection Queries datasource and insers data into datasource. Author: Martin Furlan Fredrik
09 May 2010 ADO OLE Database Connection Queries datasource and insers data into datasource. Author: Martin Furlan Karanth, Vinod

Very effective. Thanks heaps.

Top Tags Applied by Martin
access, data export, data import, database, datasource
Files Tagged by Martin View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
29 Jan 2007 diskfree Queries the free space of a volume Author: Martin Furlan path, directories, files, disk, disk usage, free space 1 5
  • 3.0
3.0 | 2 ratings
10 Jan 2007 ADO OLE Database Connection Queries datasource and insers data into datasource. Author: Martin Furlan database, sql, oracle, insert, query, data import 34 12
  • 4.66667
4.7 | 12 ratings

Contact us at files@mathworks.com