473,320 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Move away from a database, into dll

Hi

I am dealing with an existing application that has a large set of static
data in a SQL database. It is actually a set of code that has been ported
into different languages and into different applications many times. We
would like to consolodate this so that there is only one set of code to
update and so that it is runnable without network access.

My idea is to move away from the database and compile the code and the data
into a dll that can then be accessed by any application we desire. But I
don't really have any idea where to start in moving away from a database and
bringing the data into a dll.

We would like the dll to be able to be used by web applications and desktop
applicaitons on Windows XP, 2000, and CE.

Any ideas?
--
Denis Crotty
Application Developer

--------------------------------------------
Maltais Geomatics Inc.
17011 - 105 Avenue, Edmonton, Alberta, Canada T5S 1M5
Sep 23 '05 #1
2 1333
Denis,

In my opinion will this only go by creating an extra tier (service) in all
your applications, and than having all trouble and benefit from that service
that is running (how that would communicate with CE does not even come in my
mind).

Starting with old code to make a desing is in my opinion never a good start
to make a new architecture.

Be than aware that this than will only work with Net application if you
create this in managed code (VBNet, C#, J# or C++ managed).

Just my thought,

Cor

If you don't get your answer there than it will probably be a hard way with
"Denis Crotty" <De*********@discussions.microsoft.com> schreef in bericht
news:39**********************************@microsof t.com...
Hi

I am dealing with an existing application that has a large set of static
data in a SQL database. It is actually a set of code that has been ported
into different languages and into different applications many times. We
would like to consolodate this so that there is only one set of code to
update and so that it is runnable without network access.

My idea is to move away from the database and compile the code and the
data
into a dll that can then be accessed by any application we desire. But I
don't really have any idea where to start in moving away from a database
and
bringing the data into a dll.

We would like the dll to be able to be used by web applications and
desktop
applicaitons on Windows XP, 2000, and CE.

Any ideas?
--
Denis Crotty
Application Developer

--------------------------------------------
Maltais Geomatics Inc.
17011 - 105 Avenue, Edmonton, Alberta, Canada T5S 1M5

Sep 23 '05 #2
Thanks for the Reply!

I absolutely agree with you. We are not trying to base new architecture on
old code and are well aware that once this is complete we will be redesigning
our existing applications.

It does not necessarily need to be done with managed code, but as it will be
running on Windows machines exclusively I do not see the harm.

My biggest dilema is getting the data into the dll and accessing it at
comparable speeds to the SQL database. I am sure there must be a way to move
this data into some sort of binary format with custom access functions but I
don't know where to start. Can anyone point me in the right direction?

--
Denis Crotty
Application Developer

--------------------------------------------
Maltais Geomatics Inc.
17011 - 105 Avenue, Edmonton, Alberta, Canada T5S 1M5
"Cor Ligthert [MVP]" wrote:
Denis,

In my opinion will this only go by creating an extra tier (service) in all
your applications, and than having all trouble and benefit from that service
that is running (how that would communicate with CE does not even come in my
mind).

Starting with old code to make a desing is in my opinion never a good start
to make a new architecture.

Be than aware that this than will only work with Net application if you
create this in managed code (VBNet, C#, J# or C++ managed).

Just my thought,

Cor

If you don't get your answer there than it will probably be a hard way with
"Denis Crotty" <De*********@discussions.microsoft.com> schreef in bericht
news:39**********************************@microsof t.com...
Hi

I am dealing with an existing application that has a large set of static
data in a SQL database. It is actually a set of code that has been ported
into different languages and into different applications many times. We
would like to consolodate this so that there is only one set of code to
update and so that it is runnable without network access.

My idea is to move away from the database and compile the code and the
data
into a dll that can then be accessed by any application we desire. But I
don't really have any idea where to start in moving away from a database
and
bringing the data into a dll.

We would like the dll to be able to be used by web applications and
desktop
applicaitons on Windows XP, 2000, and CE.

Any ideas?
--
Denis Crotty
Application Developer

--------------------------------------------
Maltais Geomatics Inc.
17011 - 105 Avenue, Edmonton, Alberta, Canada T5S 1M5


Sep 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: CPNZ | last post by:
I have a database i am m oving to another server, during the process I am moving the data and log files to another drive.(Which I have done countless times before with no problems) The problem I...
2
by: Edward Mitchell | last post by:
I have Web Form (.aspx file) with a fair number of textboxes (<asp:textbox .... />) that I need to fill from a database and then save back to the database when I'm done. This presumably must be a...
2
by: Denis Crotty | last post by:
Hi I am dealing with an existing application that has a large set of static data in a SQL database. It is actually a set of code that has been ported into different languages and into different...
3
by: Eric | last post by:
When i run my query it transfer last 4 digits of account number from one table to another and its wrong. There are two tables one i use for parsing. Second thru query i use to move data from temp...
1
by: Charles MacLean | last post by:
I need to move our production database to a brand new machine on our LAN. Both machines are running SQL2K. I'd like to place the production database in a directory on the destination machine with...
4
by: sara | last post by:
I have an A2K database that has links to 3 of my other databases (external links) to run some reports. The coding in any of the 4 is pretty simple. Recently when we make a new .mde for the...
5
by: Sabbaath | last post by:
First off, I've pretty much convinced myself that the issue is that there are onmouseover events inside the div that contains an onmouseover event on it... I wrote the message below first. This was...
11
by: Robert Dufour | last post by:
As a simple example starting with a memory pointer location I need to do 10 operations, (like copying 10 values to an array for instance), then when that's done, move the pointer to the eleventh...
4
by: pgcn | last post by:
Hi Using A2003 My db has main form with stakeholderID & other main details. When there are a number of detail subform records it often requires two clicks of the next/previous nav buttons...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.