Using JET with EMF
Hi! I need to run JET templates on a EMF model metadata - i.e. the model itself (not data) is input to my JET template. More practically - I want generate non java code, based on EMF templates. How I do it? Thank you ...
jet
Microsoft JET SQL Query Logging or "How do I debug my customer's program?"
The problem: We use a program written by our biggest customer to receive orders, book tranports and do other order-related stuff. We have no other chance but to use the program and the customer is very unsupportive when it comes to problems with their program. We just have to live with the program. Now this program is most of the time ...
How do I create a Microsft Jet (Access) database without an interop assembly?
I need to create an access (mdb) database without using the ADOX interop assembly. How can this be done? ...
How do I create a Jet ODBC link to a SQL Server view with periods in the field names?
I need to create an ODBC link from an Access 2003 (Jet) database to a SQL Server hosted view which contains aliased field names containing periods such as: Seq.Group In the SQL source behind the view, the field names are encased in square brackets... SELECT Table._Group AS [Seq.Group] ...so SQL Server doesn't complain about creatin...
@@IDENTITY after INSERT statement always returns 0
I need a function which executes an INSERT statement on a database and returns the Auto_Increment primary key. I have the following C# code but, while the INSERT statement works fine (I can see the record in the database, the PK is generated correctly and rows == 1), the id value is always 0. Any ideas on what might be going wrong? ...
How to determine MS Access field size via OleDb
The existing application is in C#. During startup the application calls a virtual method to make changes to the database (for example a new revision may need to calculate a new field or something). An open OleDb connection is passed into the method. I need to change a field width. The ALTER TABLE statement is working fine. But I would ...
System.Data.OleDb.OleDbException: Invalid internet address. How do you connect to excel files located on a webserver using OleDb
I'm trying to create an OleDb connection to an Excel file that is located on a SharePoint server. The example code I'm playing with at the moment throws an OleDb exception "Invalid internet address": public static void ConnectToRemoteExcelFile() { string connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=...
Add columns to an Access (Jet) table from .NET
Our app (already deployed) is using an Access/Jet database. The upcoming version of our software requires some additional columns in one of the tables. I need to first check if these columns exist, and then add them if they don't. Can someone provide a quick code sample, link, or nudge in the right direction? (I'm using c#, but a VB.NE...
Jet(Access) DB and Expression based columns?
I occasionally work on an old project that uses classic asp as a front end and an access database as a backend. I'd like to create a new column in one of the tables that contains logic to calculate its value from the other columns in the row. I know how to do this in a more modern DBMS, but I don't think that access supports it. Keep i...
Add a field in ACCESS with a default value
I'd like to insert a new field with a Default value using Visual C++ Code. I have wrote this: CADODatabase pDB; String strConnessione = _T("Provider=Microsoft.Jet.OLEDB.4.0;""Data Source="); strConnessione = strConnessione + "MioDatabase.mdb"; pDB.SetConnectionString(strConnessione); pDB.Open(); query.Format("ALTER TABLE TBProva ADD Fa...
Querying Jet Databases/Excel files with C# under x64 OS
So I have learned that that the Microsoft.Jet.OLEDB.4.0 data provider for querying data sources like Microsoft Access MDB files and Excel spreadsheets does not work under a Windows 64-bit operating systems. What I am now supposed to use to query against these file types in .NET 3.5 (C#) applications in order to ensure compatibility in b...
Polling database for updates from C# application
I'm attempting to create my first "real" C# application - a small pet project to help schedule peer reviews at work. Due to the insane amount of process/bureaucracy involved in implementing anything new - as well as the fact that I'm doing this away from managements eyes, on my own time, for the time being - I'm going to be writing this...
Why is my Access database not up-to-date when I read it from another process?
In my application I do the follwing things: Open a Access database (.mdb) using Jet/ADO and VB6 Clear and re-fill a table with new data Close the database Start another process which does something with the new data. The problem is that sometimes the second process cannot find the new data. Sometimes the table is just empty, sometim...
Why should I use SQLite over a Jet database
Someone asked me this the other day, and I couldn't think of a good answer. Platform portability is completely irrelevant to the project. In fact, Jet has some features that SQLite does not, namely foreign keys. So can anyone think why SQLite should be used instead of a Jet database? ...
Select Top (all but 10) from ... in Microsoft Access
Say I've got a query SELECT TOP 10 ... FROM ... ORDER BY ... in Access (well, really Jet). The question is: how can I get all the other rows... everything except the top 10? ...
Having difficulty combining JET SQL queries
Warning: Here be beginner SQL! Be gentle... I have two queries that independently give me what I want from the relevant tables in a reasonably timely fashion, but when I try to combine the two in a (fugly) union, things quickly fall to bits and the query either gives me duplicate records, takes an inordinately long time to run, or refu...
How to get id of newly inserted record using Excel VBA?
Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't be done with ADO/VBA (I'll be glad to be shown wrong in this regard however). I currently insert my new record then run a select query using (I hope) enough fields to guarantee that only the newly inserted...
SQL: How to display records for only 30 days
I tried to use SELECT * from Results WHERE DATEDIFF(d,Date,getdate())<30 But it seem having error with this. For each record submitted will only display 30 days. May I know if my syntax is correct? Greatly Appreciated, Stan ...
What does 'native' mean in the context of two related technologies?
The scenario in question relates to the much-maligned Microsoft Jet database engine. The assertion was that the Data Access Objects (DAO) data access technology is 'native' to Jet, the implication being that creating an object via the DAO model is 'superior' to doing the same via SQL code executed from within in the Microsoft Access user...
What to use in creating a hand held database application
What program/programming language would be ideal for creating an Access like database on a Windows 5 CE hand held scanner? We have tried Visual CE but it is not really something we can work with. Ultimately we would love to build a system where we scan a bar code, select a user from a drop down list, select basic options of division, l...