What do you think of Postgres and Firebird Databases?

Firebird-Fyracle supports the major
Oracle-based ERP/CRM application
“Compiere” — with virtually no change
to the Compiere code base. Fyracle has
supported Compiere since version
2.4.2b, which contained over 20,000 lines of PL/SQL. The current release,
2.5.3c, has moved most PL/SQL into stored procedures written in Java,
which is also supported by
Firebird-Fyracle.

the best way to connect sql server (Windows authentication vs SQL Server authentication) for asp.net app

I have a database and a site having forms authentication. It is working fine with VS2008. This time, I am using “Trusted_connection =True”. But when it is opened from outside or directly from browser then I am getting error “Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’.”

How many is too many databases on SQL Server?

I am working with an application where we store our client data in separate SQL databases for each client. So far this has worked great, there was even a case where some bad code selected the wrong customer ids from the database and since the only data in the database belonged to that client, the damage was not as bad as it could have been. My concerns are about the number of databases you realistically have on an SQL Server.

How to create asp.net web application using sqlite

I want to develop small application in asp.net using sqlite, actually I don’t know how to use sqlite in application. Can anybody provide a link for step by step process to create a application in asp.net code behind c#. Answers: Thank you for visiting the Q&A section on Magenaut. Please note that all the answers … Read more

Ordering SQL Server results by IN clause

I have a stored procedure which uses the IN clause. In my ASP.NET application, I have a multiline textbox that supplies values to the stored procedure. I want to be able to order by the values as they were entered in the textbox. I found out how to do this easily in mySQL (using FIELD function), but not a SQL Server equivalent.