I have written a program in VB.NET and one of the things this program does is insert records into a Microsoft Access database. The backend of my program that access the database is written as an interchangeable layer. If I "swap" this layer out with a layer that used a Microsoft SQL Server database, my program flies. If I use MS Access, ...
I am beginner in java and I don't know how can I use database and MySQL??and how can I write a code with data base:(( ...
Hi, I have a database in MySQL and another database that runs on MS SQL. The MySQL is the backend database for my website running on Joomla. I have an ERP running my store. This ERP is made by a 3rd party in .Net A table called the orders gets updated whenever a user places an order in my website. The order details must get flushed to ...
My current set up is a single dedicated server with Java, hibernate app running on tomcat, apache http server, MYSQL. I need to get a second server to share the load, but using the same database from the first server. The backend processing(excluding db transaction) is time consuming, hence the second server for backend processing)....
Which providers are there and your experience using them I would like to know about all possible native .net Framework Entity Framework providers that are out there as well as their limitations compared to the default Linq2Entities (from MS for MS SQL). If there are more for the same database even better. Tell me and I'll be updating th...
I have faced a very strange situation here. I am accessing database (MDB) through JET. I use DBGrid and DBNavigator to allow user access it. Dataset is created using TADOQuery component, with the following query: SELECT *, (DateDiff ('y',[Birth Date], Now())) AS [Age] FROM TableName It works fine. But whenever I press Refresh button ...
If I have some config for web admin to set e.g. number of post per page, some enum showing choice. How should I keep this settings in db ? Should I serialize it and save as blob. Thanks, I using rails and I want it to dynamically change this setting through web interface, so I think environment.rb would not fit this situation. So I s...
i need to generate my sql server 2005 database for testing a multithreaded application. it must be morre than 3 gb at least, what should i do ...
I tried to record the code to update a pivot sourcedata which gave me this: ActiveSheet.PivotTableWizard SourceType:=xlExternal, _ SourceData:=QueryArry1, _ Connection:=Array( _ Array("ODBC;DSN=MS Access Database;DBQ=" & DBDir & "\" & DBName & ";"), _ Array("DefaultDir=" & DBDir & ";DriverId=25;FIL=MS Access;MaxB...
I have a query that goes something like the following: select <field list> from <table list> where <join conditions> and <condition list> and PrimaryKey in (select PrimaryKey from <table list> where <join list> and <condition list>) and PrimaryKey not in (select PrimaryKey from <table list> where <join list> and <condi...
Let's say an application has really specific data which belongs to a user, and nobody is supposed to see it except the owner. I use MySQL database with DataMapper ORM mapper. The application is written in Ruby on Sinatra. Application behavior: User signs up for an account. Creates username and password. Logs into his dashboard. Some ...
I'm not sure if this is technically a web service or not but I have a Flash file that periodically needs to make a round trip to a DB. As it stands, AS3 uses the URLLoader class to exchange XML with an ASP.NET/VB file on the server. The aspx code then goes to the DB and returns whatever information is requested back to the Flash file. ...
I have a project which is composed of a board with 2 CPUs that have access to 2 different memories (FLASH and DDR), and the 2 CPUs can communicate by ethernet among themselves. one CPU is running XML hierarchical DB files handled by "tail-f" and the other is running SQLite DB and also a CLI which is exposed to the user through which he...
Is there any way that I can make sure that a stored procedure completely finishes before another instance of it is started? I have to do 3 things in the procedure and if two instances are running at the same time it will mess up a boundary case. Example: Count rows, if < X insert a row, return calculated Y if multiple instances of ...
We have a CRM solution where all metadata stored in Oracle table (don't ask me why). I am issuing an update statement but when get the data from database I see on front end '\n' as part of the text and not new line (like HTML's <br/>). I was trying to put directly in description but it shows as br/ on front end. What escape charact...
Imaging the following 3 relationships in a data model Entity > Path > Link Both relationships are 1 to many. So Entity has multiple paths and a path has multiple links. Should I do this as 3 tables with relationships between the tables Or create a table that stores that path information as XML. This table (lets call it Paths), will...
What are the differences in database terminology between MsSQL and MySQL? Can a mysql instance have more than one database? It appears that it can only create different schemas.. However the sql command is "create database". In MsSQL you can create multiple databases.. each have a default schema of dbo?.. but multiple schemas in a data...
conn = MySQLdb.connect(host='db1', user='user', passwd='pass', db='db', port=3306) cursor = conn.cursor() count = int(sys.argv[1]) x = 0 while x < count: x += 1 cursor.execute("INSERT INTO auth_group(name) VALUES(%s)", (str(x))) #if I change %s to 'kkkk', it doesn't work either. print str(x) + ' / ' + str(count) print '...
I had a auto-increment duplication issue for master-master replication. Then, I set: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 99999; This skips 9999 queries. Then I did: SHOW SLAVE STATUS\G Slave_IO_Running: Yes Slave_SQL_Running: Yes And it seems to be running OK. But, of course, since I skipped 99999 statements...if I make a change...
I have found that if I modify table X via SQLplus and don't commit the change, then if my web appliation (which runs as a PHP script under Apache in ModPHP mode) attempts to commit a change to table X it will block indefinitely until I commit my changes via SQLplus. This behavior is correct, but what I want is a clean/reliable/simple wa...