database

Connect to a Postgresql database and select or edit data through R

I am a R user and want to connect to my postgresql database in order to select data for statistical calculations. Afterwards I would also safe the results into the database. Plain SQL statements would suffice. I am using R 2.12 and postgresql 9.1

Oracle connection error

When you have just installed a database or client Oracle on a computer and want to connect with the parameters that have defined, it generates the error message: ORA-12154: TNS: Could not resolve the connect identifier specified.

Application.LoadCusomUI + xml description

To implement a custom Ribbon element we have to describe it using an XML file defined by the Microsoft CustomUI schema and load it using the Application.LoadCustomUI() procedure.

The root element of the XML file is customUI. Inside of it there is the element ribbon containing all the tabs, buttons etc.

A code snippet for loading of the xml file:

Dim f As Long
Dim strText As String
Dim strOut As String

f = FreeFile
Open "\customUI.xml" For Input As f

Do While Not EOF(f)
Line Input #f, strText
strOut = strOut & strText
Loop

Application.LoadCustomUI "AppRibbon_1", strOut

Sample XML file:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab id="Tab1" label="Tab1">
<group id="Group" label="Group">
<button id="MyButton1" label="Button1" imageMso="_1"
onAction="doSomeAction"/>
<button id="MyButton2" label="Button2" imageMso="_2"
onAction="doSomeAction2"/>
</group>
<group id="Group2" label="Group2">
<button id="MyButton3" label="Button3" imageMso="_1"
onAction="doSomeAction3"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>

Taggings:

Add a custom Ribbon to a database in Access 2007

Ribbon was introduced in Microsoft Office 2007 as part of its "Fluent User Interface" and has became a well known and quite often used part of graphical user interface of applications (specifically on MS Windows). In MS Access prior the 2007 version the user interface of an database application was implemented by standard GUI elements such as forms, buttons, menus and context menus. The users of MS Office 2007 are used to work with Ribbon and are familiar with its advantages e.g. its shortcut system, we want to provide them with a custom Ribbon interface of Access 2007 database application.

Access Database 2010 Portability

There is a case with a very small company that has recently operated from a database in Access 2010 made in two layers (database programs and link to another database with the data.) They would be interested in its portability to the web. The question is: Given that the number of users are few, up to 5 or 6. Sharepoint, web services, MS Office Comunications Server 2007 ... What technology / platform would be well, to use logic layer (the program) and link the db on the server? (Customer has a Windows 2003 server and fixed IP).

Preventing SQL-Injection in a Java application

Sql-Injection is a technique to inject (or execute) SQL commands within an application (database). It is mainly used to gain access to a databases content for which one has no authorization. The method injects SQL commands by providing input to a SQL statement which contains SQL meta-characters. Example statement: <strong>select * from user where username='input'</strong> SQL injected input:<strong>user' OR '1'='1</strong> The final statement:<strong>select * from user where username='user' OR '1'='1'</strong> Since 1 always equals 1, this statement would return all the users in the database! Depending on the SQL command, an attacker could insert, modify, extract and delete data in the database.

Connect remotely located Java application and database using JBoss, EJB

The Java application which serves as client-side software should be implemented as form of JavaBeans which are serializable.  Server-side software should be adopted to EJB(Enterprise Java Bean) which uses JBoss application server to communicate with database and client-side software components.What is serialization:In computer science, in the context of data storage and transmission, serialization is the process of converting an object into a sequence of bits so that it can be persisted on a storage medium (such as a file, or a memory buffer) or transmitted across a network connection link to be "resurrected" later in the same or another computer environment.[1] When the resulting series of bits is reread according to the serialization format, it can be used to create a semantically identical clone of the original object. For many complex objects, such as those that make extensive use of references, this process is not straightforward.What is JBoss:JBoss Application Server (or JBoss AS) is a free software/open-source Java EE-based application server. Because it is Java-based, the JBoss application server operates cross-platform: usable on any operating system that Java supports. JBoss AS was developed by JBoss, now a division of Red Hat.

Taggings:

Speeding up project using Zend_Db

<p>An existing project realized with the Zend Framework should be optimized in terms of performance. The use of Zend_Db slows down the database access because of its automatic table-scanning and overhead. The SQL-queries as well as the table structures are already optimized and should not be changed. The configuration on the server environment:</p><ul><li>PHP 5.2.6</li><li>MySQL Server Version: 5.0.75</li><li>Zend Framework 1.5</li><li>Apache 2.6.28-16</li><li>Suhosin-Patch 0.9.6.2</li></ul><p>The update to a newer version of Zend Framework is right now not possible because of some migration problems. The changes in the code should be measurable and viewable with XDEBUG/kcachegrind.</p>

Connect remotely located Java applications and database

<p>A library has a management software implemented by Java. This software is going to be used as a server application which is located in Vienna. A database including all book informations of the same library is located in London. Find out an appropriate technology by which a client Java application located in Paris can search the book informations of the library remotely.</p>

BitTorrent tracker optimization

<p><span style="font-family: sans-serif; color: #000000; font-size: small;"><span style="font-size: 13px; line-height: 19px;"><span style="font-family: Verdana, sans-serif; font-size: 12px; color: #494949; white-space: pre-wrap;">A BitTorrent tracker is a server software based on BitTorrent protocol. Download clients are required to firstly communicate with the tracker to get other peers which have already begun downloading the same file that the clients want to get. During the download, tracker randomly and periodically provides clients newer peers which have joined the same download group. Optimize the tracker by using GeoTool so that the tracker can provide clients the nearest peers through geographical coordinates and therefore speed up the entire download time. </span></span></span></p><p><span style="line-height: 19px; white-space: pre-wrap;"><span style="line-height: 20px; white-space: normal;"><br /></span></span></p>

Pages

Subscribe to database