Using DAO in .Net to access a MSAccess 97 Database

Thanks for Unicorn and David's reponse.

Hi Sameer,

You can also check the following KBs for more information:

http://support.microsoft.com/default.aspx?scid=kb;en-us;155666

http://support.microsoft.com/default.aspx?scid=kb;en-us;90111

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: "Sameer Motwani" <smotwani.TakeThisOut@ac2.net>
| Subject: Using DAO in .Net to access a MSAccess 97 Database
| Date: Fri, 7 Nov 2003 11:56:06 -0600
| Lines: 30
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eo9gEeVpDHA.2868.TakeThisOut@TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.vb.database.dao
| NNTP-Posting-Host: rrcs-sw-24-242-146-230.biz.rr.com 24.242.146.230
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.vb.database.dao:34922
| X-Tomcat-NG: microsoft.public.vb.database.dao
|
| Hello,
|
| I am trying to write a application in C#.net to replicate a Access 97
| database. I am using DAO 3.6 to do the replication and
| so using the COM Interop I have imported the DAO Workspace in my project.
| But when I when I try to open the database the following exception is
thrown
| "Could not find installable ISAM"
|
| Here is the Code I am using to open the database
|
| try
| {
| DAO._DBEngine dbEng = new DAO.DBEngineClass();
| DAO.Workspace wrk =
|
dbEng.CreateWorkspace("Replication","admin","",DAO.WorkspaceTypeEnum.dbUseJe
| t);
| DAO.Database db =
| wrk.OpenDatabase("MyDatabase",false,false,"C:\\MyDatabase.mdb");
| }
| catch(System.Exception e)
| {
|
| }
|
| Can anyone tell how to rectify this problem.
| Any help would be apprecited
|
| Sameer
|
|
|
 >> Stay informed about: Using DAO in .Net to access a MSAccess 97 Database 

Like this:

wrk.OpenDatabase("C:\MyDatabase.mdb",false,false);

If you have Access 97, have a look at the A97 help file.
You can double click on ACVBA80.HLP and leave the help
file open, so that you don't have to try to use the
less than helpful 'help' files from other products.

 > "Could not find installable ISAM"
Is a generic error message that means Jet could not
understand the connection string. Jet has assumed
that "C:\\MyDatabase.mdb" was the name of an installable
ISAM.


(david)

"Sameer Motwani" <smotwani.RemoveThis@ac2.net> wrote in message
news:eo9gEeVpDHA.2868@TK2MSFTNGP09.phx.gbl...
 > Hello,
 >
 > I am trying to write a application in C#.net to replicate a Access 97
 > database. I am using DAO 3.6 to do the replication and
 > so using the COM Interop I have imported the DAO Workspace in my project.
 > But when I when I try to open the database the following exception is
thrown
 > "Could not find installable ISAM"
 >
 > Here is the Code I am using to open the database
 >
 > try
 > {
 > DAO._DBEngine dbEng = new DAO.DBEngineClass();
 > DAO.Workspace wrk =
 >
dbEng.CreateWorkspace("Replication","admin","",DAO.WorkspaceTypeEnum.dbUseJe
 > t);
 > DAO.Database db =
 > wrk.OpenDatabase("MyDatabase",false,false,"C:\\MyDatabase.mdb");
 > }
 > catch(System.Exception e)
 > {
 >
 > }
 >
 > Can anyone tell how to rectify this problem.
 > Any help would be apprecited
 >
 > Sameer
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using DAO in .Net to access a MSAccess 97 Database 

Hello,
The statement
wrk.OpenDatabase("C:\MyDatabase.mdb",false,false,"") worked.

Thank You,
Sameer

"Kevin Yu [MSFT]" <v-kevy.DeleteThis@online.microsoft.com> wrote in message
news:qouMSo1pDHA.2616@cpmsftngxa06.phx.gbl...
 > Thanks for Unicorn and David's reponse.
 >
 > Hi Sameer,
 >
 > You can also check the following KBs for more information:
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;155666</font" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;155666</font</a>>
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;90111</font" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;90111</font</a>>
 >
 > Kevin Yu
 > =======
 > "This posting is provided "AS IS" with no warranties, and confers no
 > rights."
 >
 > --------------------
 > | From: "Sameer Motwani" <smotwani.DeleteThis@ac2.net>
 > | Subject: Using DAO in .Net to access a MSAccess 97 Database
 > | Date: Fri, 7 Nov 2003 11:56:06 -0600
 > | Lines: 30
 > | X-Priority: 3
 > | X-MSMail-Priority: Normal
 > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
 > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
 > | Message-ID: <eo9gEeVpDHA.2868.DeleteThis@TK2MSFTNGP09.phx.gbl>
 > | Newsgroups: microsoft.public.vb.database.dao
 > | NNTP-Posting-Host: rrcs-sw-24-242-146-230.biz.rr.com 24.242.146.230
 > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
 > | Xref: cpmsftngxa06.phx.gbl microsoft.public.vb.database.dao:34922
 > | X-Tomcat-NG: microsoft.public.vb.database.dao
 > |
 > | Hello,
 > |
 > | I am trying to write a application in C#.net to replicate a Access 97
 > | database. I am using DAO 3.6 to do the replication and
 > | so using the COM Interop I have imported the DAO Workspace in my
project.
 > | But when I when I try to open the database the following exception is
 > thrown
 > | "Could not find installable ISAM"
 > |
 > | Here is the Code I am using to open the database
 > |
 > | try
 > | {
 > | DAO._DBEngine dbEng = new DAO.DBEngineClass();
 > | DAO.Workspace wrk =
 > |
 >
dbEng.CreateWorkspace("Replication","admin","",DAO.WorkspaceTypeEnum.dbUseJe
 > | t);
 > | DAO.Database db =
 > | wrk.OpenDatabase("MyDatabase",false,false,"C:\\MyDatabase.mdb");
 > | }
 > | catch(System.Exception e)
 > | {
 > |
 > | }
 > |
 > | Can anyone tell how to rectify this problem.
 > | Any help would be apprecited
 > |
 > | Sameer
 > |
 > |
 > |
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using DAO in .Net to access a MSAccess 97 Database