DAO Connection throws ISAM Error

Asked May 07 '15 at 00:43

Active May 07 '15 at 01:01

Viewed 330 times

I can connect to an access database via ADO w/o issue, but if I attempt to connect using a DAO connection it throws the error of Could not find installable ISAM I am using VS2013 and it is communicating with Access 2000. This is the syntax I am using (DAO) to connect to my database. This syntax works with VS2010...

DAO.Database dd;
DAO.DBEngine db = new DAO.DBEngine()
DAO.TableDef tdf1;
string sourceTable = "dbo.Master";
string linkedTable = "Master";
string database = "C:\\Test.mdb;"
string sqlconnection = "ODBC;DRIVER=SQL SERVER; SERVER=TinyOne;Database=InterWebDB;Trusted_Connection=Yes";

dd.OpenDatabase(database);
tdf1.dd.CreateTableDef(linkedTable);
tdf1.Connect = sqlconnection;
tdf1.SourceTableName = sourcetable;
//The below line produces the ISAM error
dd.TableDefs.Append(tdf1);

edited May 07 '15 at 01:01

asked May 07 '15 at 00:43

MasterOfStupidQuestions

Have you created a link with those same properties inside an Access session? – HansUp May 07 '15 at 01:32
@HansUp - yes, I have. – MasterOfStupidQuestions May 07 '15 at 02:25

DAO Connection throws ISAM Error

0 Answers0