c# - Create Access 97 database without dependency on Access -

-

For compatibility with legacy software, I need to create an .mdb database compatible with Access 97 or earlier versions. I can not use OLDB because I can not trust access to set up. I also do not want to install office connectivity components.

Are there any third party libraries that can do this?

Jet part of the Windows interface forever (as part of the MDAC component from Windows 2000) No need to access the .mdb file for

You only need to install ACE drivers if you plan to create new .accdb files (compatible with Access 2007 and above).

To create an empty .mdb database, you need to use the Microsoft ADO Ext 2. Datab and security for the 2.8 library Interop.ADOX. Dll .

You can call it your VS. There is no need to referencing directly in the project, you can use late binding to create the object that is available on the machine: 

  zero main () {var conStr = GetConnectionString (@ "C: \ Users \ user \ Desktop \ myDatabase.mdb", blank, zero); CreateDb (Construction); } //[System.Security.SecuritySafeCritical] Public Zero CreateDb (string connection string) {type adoxType = Type.GetTypeFromProgID ("ADOX.Catalog"); Object O = Activator Create Instances (Adox Type); O.GetType () InvokeMember ("Create", BindingFlag.Invokmath, Blank, O, New Object [] (connectionString)); Object connection = o.GetType (). InvokeMember ("ActiveConnection", BindingFlags.GetProperty, null, o, null); If (connection! = Zero) connection Gettype () InvokeMember ("Close", Binding Falgues, Invocomath, Blank, Connection, Blank); } Public static string GetConnectionString (string database, string user id, string password) {return string.format (" 1}; {3} Password = {2}; ", Database, UserAd, Password, String.IsNellOcty (password)? String:" Jet Olendi: Database "); }

You can use LINQpad to test the code, it works on my machine Note that if you try to create a database in folders, where you have If you do not have the rights to create files, then you will get an unrelated COM exception such as:

The Microsoft Jet database engine can not open the file 'C: \ myDatabase.mdb' This is already done by another user Has been opened, or you see its data Area requires permission.

To create tables and indexes etc., you can use these commands and execute them through OLEDB, such as command.execute nonquiries ("Create table staff CRAR, LastName CRAR) ");

Another, perhaps this simple solution that can be avoided all this code,

to open the database, you can only use OldDb as the old one .

To be careful about things: Make sure you target X86 for your app;

    • Li>
  • >

    • Comments

    Post a Comment

    Popular posts from this blog

    java - org.apache.http.ProtocolException: Target host is not specified -

    -
    I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
    Read more

    java - Gradle dependencies: compile project by relative path -

    -
    Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
    Read more

    ruby on rails - Object doesn't support #inspect when used with .include -

    -
    So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
    Read more