mdb

Allow MDB Downloads in IIS7

Currently if I am hosting an Access .MDB file to allow users to download, IIS7 is throwing a 404 error. I know the file is there and the permissions are fine. It appears to be a Handler issue, but I cannot figure out how to change the handler to allow downloading of MDB file. I assume I need to add something to the Handlers section of...

MDB Transaction Propagation

Hi Guys, I am very new to EJB 3.0 I have deployed a EAR in WebLogic 10.3 g which have two ejb modules called ServicesDump MessageDump In ServicesDump i have a session bean which doing the database updates, After i have deployed, When i called these remote session-bean from out side of container to test the functionalites it working...

Can we create multicolumn unique indexes on MS access databases?

We'd like to prevent record duplication in our MS access database using a multicolumn unique index. Because of how the data is sent (via network), duplicate data is sometimes received. The data source does not send a unique ID, so the simplest option is to prevent duplicate records being inserted. According to Unique Index Design Guidel...

XML vs Access DB

I have a lightweight app that will use some data. I am trying to decide if I should use XML based or just include a mdb file. ...

Speed up insert mdb

Is there a way to speed up inserts to a mdb? using (StreamReader sr = new StreamReader(_localDir + "\\" + _filename)) while ((line = sr.ReadLine()) != null) { //sanitize the data } This takes about 20sec for ~2mil records from a csv but when I add in the mdb insert I can barely get 10,000 records in 10min, so you can see it'll t...

Handling connection errors in a MDB

Is it possible to manage connection timeouts or errors in a MessageDrivenBean? You can make the factory to retry connecting a certain number of times but... is it possible to make some actions each time that a reconnection retrial is neccesary? Is it possible to register an ExceptionListener into the MessageDrivenBean's connection someh...

Is there any server config file to invoke MDB ?

I am having ejb-jar.xml and jboss.xml files in my application of JMS with MDB. I have configured the queue destination in destination-service.xml. But my MDB is not invoking. Are there any server files to be configured to invoke MDB? ...

C# How can I read an MDB database into memory and query it?

I want to be able to copy a database into a byte array and then query it. Is this possible? For example, with a text file I can use.. byte[] file = File.ReadAllBytes; ..and then read the byte array with.. StreamReader rdr = new StreamReader(new MemoryStream(file)); ...

How to learn advanced C debugger usage?

Hello, How to learn advanced debugging techniques? I am a C/Unix programmer, and as such rely on a good C debugger. I know Sun^WOracle mdb on Solaris, GNU gdb on Linux. I feel comfortable setting breakpoints, examining memory structures and such. Yet, I know that those tools are way more powerful than that. Macros, custom walkers and ...

Message Driven Bean with Java Message Queue down

I have the following problem deploying my application. It uses JMS and a remote openMQ for communication between servers. The problem is that the connection is not fully reliable so it can be up or down. For reconnecting I set the jms reconnect glassfish property so it reconnects if at some moment the connection gets lost. The problem ...

VBScript & Access MDB - 800A0E7A - "Provider cannot be found. It may not be properly installed"

Hey gang, I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority of resources out there are for ASP/IIS7. Quite simply, I can't get it to connect. I'm getting the following error: 800A0E7A - "Provider cannot be found. It may not be properly installed" My code is: Set conn ...

Synchonizing data between django orm and pyodbc data source

Hello. I have a database (in Access 95 format... don't ask) that contains data i'd like to use in Django. I can already successfully connect, issue queries, etc using pyodbc. For the most part this is a one way sync operation - that is, the data won't be modified in Django, but will be modifed in the Access 95 db via legacy applications...

using ResultSet.Previous method not working in Java using .mdb file OBDC

Hello, I'm currently having an issue with my open result set not working how I believe it should. The only function that is currently working is the next() method, nothing else will work. If the project is placed into a debug mode you can follow through actionperformed event on the button it hits the previous() method and jumps over the...

Junit test for message driven bean (using jboss application server)

Hi, I am facing the problem when run the junit test case for the MessageDrivenBean(here i am using jboss application server). That is "org.jboss.jms.exception.MessagingJmsException:Failed to invoke". How can overcome this. ...

Problems creating JMS Queue on Glassfish

i'm get the following error when deploying my application with a JMS producer and consumer com.sun.enterprise.connectors.ConnectorRuntimeException: JMS resource not created : QueueName I used the annotations below: Producer @Resource(name = "jms/EmailNotificationQueue", mappedName = "EmailNotificationQueue") private Destination dest...

How do I change a specific MDB max-pool-size at runtime on Glassfish

I'd like to be able to change the max-pool-size value at runtime. Currently I have to modify the xml and restart Glassfish. Any ideas? ...

one message driven bean, listen to dynamic topics ...

Can one MDB listen to 2 or more topics? if not how do i go about listening for so many topics, assuming, one geo location is one topic, and the number of geo location can and will grow from 2 to more ... I am using glassfishV3. ...

Injecting jms resource in servlet & best practice for MDB

using ejb 3.1, servlet 3.0 (glassfish server v3) Scenario: I have MDB that listen to jms messages and give processing to some other session bean (Stateless). Servelet injecting jms resource. Question 1: Why servlet can`t inject jms resources when they use static declaration ? @Resource(mappedName = "jms/Tarturus") private static Conne...

Why is there a "Conversion Errors" tables in an MDB?

Why would there be a "Conversion Errors" table in an MDB? Does this mean there was an attempt to convert the MDB to a different (newer) version of Access? ...

Convert a c# mdb solution to xml?

I have a system that uses an mdb database with an xsd descriptor written in c#. Now I want to use one or more xml files with the same data instead. I have generated a couple of adapters for the mdb, but now I don't know what is needed for using xml instead. Anyone have some tips? I have managed to save the mdb as a few xml files. ...