I have established a link using Netbeans and Paradox driver and can query the database. Can Paradox 4.5 (Borland) be set up on a server so that the database can be queried remotely? Please point me in the right direction. Thanks! ...
A medical office that I do work for uses MIS that does not have ODBC. There is an export function, however, and it seems to dump it into a "export.DB" file. In Windows, that is traditionally a Paradox database; however, in snooping around the directory architecture, it looks like there's a portable Sybase server. Is there any way to a...
I received a MySQL data dump and am trying to insert the data into a set of temporary tables. The creation statement for the first table is shown below. When I run this I receive the error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''temp_books'(...
I have a Silverlight application that communications with an ASP.NET backend through WCF. I have a set of DataContract objects that I defined that (for the most part) match my LINQ to SQL generated types that my ASP.NET backend works with. My WCF code generates instances of my DataContract objects from LINQ to SQL generator types when I ...
Hi, If I add a simple Sql Server table data connection to an Excel worksheet, can it lock that table if the connection is never closed? ...
So we're building a locally(at customers site) hosted, custom point of sale system, nothing too much out of the ordinary. Its all .NET, C# and SQL Server. One of the requirements is that the system allows orders to be taken over the internet as well. For various reasons(connection reliability/speed, backups, stability, maintainance, et...
When debugging everything appears good. The insert commits and there is no roll back, no exceptions. I sure hope some can help with this. Here is my call: using (ITransaction transaction = _session.BeginTransaction()) { _session.Save(calc); transaction.Commit(); } Real simple mapping: <hibernate...
I have a program that pulls a large dataset from Oracle 10g (10.2.0.3) using a fairly-straightforward query. You could almost call the query/logic an "export" of sorts in that it selects the columns from a table with a minimal where clause (i.e., it returns most of, if not all, the rows). The [Java] code is boilerplate that we have all...
I am working on a small practice project in .NET with Sql Server 2005. I want to learn PostgreSQL and implement my project in PostgreSQL in the final version. Please advise on all the things I need to do, to setup PostgreSQL with .NET and run it successfully. Sincere thanks fsck. ...
Can someone explain what is Connection and Statement Pooling and what is the benefit over unpooled DataSources? I am trying to understand when it is a good idea to use a technology like c3p0 or proxool in a project. I need first to understand what they do and when it interesting to use them. Thank you very much. ...
I'm writing simple database driven application, 80% of functionality is CRUD operations on about 15 tables. Coming from web development background I figured I can cover almost all of these CRUD cases with Rails scaffolding or say Django admins. So I started to look around for Rails/Django-like framework but for Windows Forms applications...
Is there a function for SAP DB to get the length of a string in SQL? ...
I'm working on a multi-tenant application that will be implementing service APIs. I don't want to expose the default auto increment key for security reasons and data migration/replication concerns so I'm looking at alternative keys. GUID/UUID is an obvious choice but they make the URL a bit long and while reading an article about them I ...
I can't display the first entry from my query that returns multiple answers. For example, a search with a result set of five will return the second to fifth and miss the first entry. If I search for something that has one entry as output it doesn't return anything but just hangs because it is the first and only entry in the database. ...
Hi all, I'm using the SQLAlchemy Python ORM in a Pylons project. I have a class "Project" which has a one to many relationship with another class "Entry". I want to do a query in SQLAlchemy that gives me all of the projects which have one or more entries associated with them. At the moment I'm doing: [project for project in Session.que...
I'm writing a little web app with webpy, and I'm wondering if anyone has any information on a little problem I'm having. I've written a little ORM system, and it seems to be working pretty well. Ideally I'd like to stitch it in with webpy, but it appears that just using it as is causes thread issues (DB connection is instantiated/access...
What is the most secure and easier way to send approx. 1000 different records into database that is not directly accessible - MySQL database on Web provider's server - using Windows application . Data will be stored into different tables. Edited: The application will be distributed to users who have no idea what is database or putty or...
The following query does what I'd like it to do, however, I have no idea if it's efficient. I went through the Django aggregation documentation, threw it together, looked at the query and tilted my head sideways like a confused dog. What the query actually does is get published Entry's "name" and "name_slug" that have one or more approv...
Hi, I'm wondering what kind of persistence solutions are there for C++ with a SQL database? In addition to doing things with custom SQL (and encapsulating the data access to DAOs or something similar), are there some other (more general) solutions? Like some general libraries or frameworks (something like Hibernate & co for Java and .N...
Hi, I have an application that needs to map relational database to XML. The issue is that the database structure is given (I cannot change it) and the XML Schema is given (comes from WSDL). I need to let the user of my application to tell the system that a given column in a table is mapped to a given element in the schema. Then my app...