Search results matching tag 'PostgreSql'

Get Access to Many Database Servers with One ADO.NET Data Provider

Devart Software — Wed, 09 Dec 2009 05:00:00 GMT

Devart presents the new version of dotConnect Universal (formerly known as UniDirect.NET), data provider that offers universal access to data of Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird databases for the Microsoft .NET Framework.

dotConnect Universal 3.00 offers support for new Devart dotConnect data providers, that is especially important for the users who upgraded their data providers earlier and want to use dotConnect Universal with them as well. The new version also offers bundled providers with advanced connectivity options, such as http tunneling, ssl and more.

dotConnect Universal introduces SQLite provider for working with SQLite - a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

dotConnect Universal compatibility was extended by adding support for Visual Studio 2008 and Visual Studio 2010 Beta.

Mobile edition of dotConnect Universal no longer needs dotConnect providers installed.

Among other improvements, dotConnect Universal Server Explorer integration was enhanced.

Pricing and Availability

The Single license starts from as little as $99.95, and you can always choose the edition that matches your needs best. To learn more, download trial edition, or order a license please visit Devart site:
www.devart.com/dotconnect/universal/.

Please, feel free to download, try and write any comments and suggestions about our products!

About Devart

Devart is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users.

We specialize in providing native connectivity solutions as well as comprehensive development and management tools for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.

For additional information about Devart, visit www.devart.com/company/.

Improved ORM Model Designer and New Monitoring Capabilities for the New Version of ADO.NET Data Providers

Devart Software — Thu, 26 Nov 2009 05:00:00 GMT

Devart has recently announced the release of dotConnect products for Oracle, MySQL, PostgreSQL, and SQLite ADO.NET providers that offer Entity Framework support, LINQ to SQL support, and contain an ORM model designer for developing LINQ to SQL and EF models based on different database engines.

Entity Developer 2.50, a designer for modeling and code generation for ADO.NET Entity Framework and LINQ to SQL, included in Professional Edition of every dotConnect, was greatly improved. Now Entity Developer allows to view and edit data of tables, views, and model entities, create and execute Entity SQL, LINQ to Entities, and LINQ to SQL queries against the model, eliminating the need for additional applications and reducing time for accessing these operations.

Code generation for models was completely redesigned. New T4 like template language allows you to use the full power of C# or Visual Basic in the templates, allowing virtually anything you may want for code generation. Template editor now provides syntax highlighting, code completion, and parameter information features. Syntax highlighting allows you to easily distinguish text and code blocks.

The model got two new properties, affecting code generation: File Per Class and View Generation. The File Per Class property allows placing each model class to a separate file, and View Generation adds code for pre-generating views for Entity Framework models.

In LINQ to SQL, dotConnect providers offer better performance and new DbLinqDataSource class.

To ease the database application development, integration with improved Devart dbMonitor was added, allowing you to monitor interaction with database remotely.

Please, feel free to download, try and write any comments and suggestions about our products!

Pricing and Availability

We offer a free Express edition for each product from the dotConnect product line.

The Single licenses start from as little as $99.95, and you can always choose the edition that matches your needs best. To learn more, download trial and free editions, or order a license please visit Devart site:
www.devart.com/dotconnect/.

About Devart

Devart is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users.

For additional information about Devart, visit www.devart.com/company/.

Aspose.Total for .NET Q3 2009 Released

aspose_seo — Mon, 05 Oct 2009 04:00:00 GMT

What’s new in Aspose.Total for .NET Q3 2009?

This Q3 2009 release of Aspose.Total for .NET includes a detailed quarterly summary about major feature enhancements and a large number of newly supported features by Aspose .NET components. Let me list down some of these important features for your review.

Aspose.Words for .NET adds support for LINQ and allows rendering shapes as images when exporting to HTML, MHTML and EPUB. It also supports picture cropping in renderer and in PDF export.
Aspose.Grid suite has now been merged into Aspose.Cells for .NET. It supports multiple print areas in worksheet to image (Worksheet2Image) feature and also adds formula calculation support for some new MS Excel built-in functions. With optimized performance of formula calculation engine, it also provides support for setting image options in chart to image (Chart2Image) and worksheet to image (Worksheet2Image) features.
Aspose.Pdf for .NET supports text opacity and page gutter.
Aspose.Slides for .NET supports automatic cloning of master slides and slide notes together with slides. It improves algorithms for embedding true type fonts to a PDF file and provides a workaround for cloning slides with wrong VML which is created sometimes after converting old PPT presentation to PPTX in PowerPoint 2007.
Aspose.Pdf.Kit for .NET supports vertical-aligned-text in XfaForm, allows getting the format information of text in a field, determining currently selected and valid radio group values with full support for 64-bit OS.
Aspose.Tasks for .NET Improves detection of empty resources stored in MPP project files.
Aspose.Network for .NET supports listing, deleting and fetching email messages from Inbox and other folders using Exchange Web Services. It also allows connecting Exchange Web Services to Microsoft Exchange Server and managing emails. This feature can be used with Microsoft Exchange Server 2007, 2007 SP1, 2010.
Aspose.Workflow for .NET now include a new Web-based XPDL designer and also supports MySQL and PostgreSQL.
Aspose.Form for .NET supports File attachment control, rule set actions and allows getting a control by InfoPath ID using API.
Aspose.Flash for .NET supports Flash v10, encoding FLV video and converting from SWF to FLV format.
Aspose.Report for .NET supports displaying images in place of markers in the LegendBox with ability to change the transparence of a DataPoint in a Point chart.

More about Aspose.Total for .NET

Aspose.Total is a suite of 13 powerful and widely used .NET components that enables you to programmatically manage your business applications like: Word, Excel, PowerPoint, PDF, Project, InfoPath & Flash. Aspose.Total also contains components for Barcode creation, Networking protocols, Email, Workflow, Charting and Ad hoc query generation. It is compiled on daily basis to contain all existing and potential components released by Aspose.

What’s new in Aspose.Total for .NET Q3 2009?
Homepage of Aspose.Total for .NET.
Download Aspose.Total for .NET.
Online documentation of Aspose.Total for .NET.
Demos of Aspose.Total for .NET.
Post your technical questions/queries to Aspose.Total for .NET Forum.
Receive notifications about latest news and supported features by subscribing to Aspose.Total for .NET blog.

Contact Information
Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Australia
Aspose - The .NET and Java component publisher
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.94651

Re: Add PDF to MySQL BLOB field

alanaxford — Wed, 07 Jan 2009 05:00:00 GMT

may try Navicat, http://www.navicat.com. I've been using it for 3 yrs and it's the best mysql gui I ever used.

Re: Sorting by column header click doesn't work

jacekskowron — Mon, 15 Dec 2008 05:00:00 GMT

Does anyone know what can cause my problem? Maybe it's not provider error if sorting works fine when used without dynamic data?

Re: Sorting by column header click doesn't work

sjnaughton — Thu, 11 Dec 2008 05:00:00 GMT

Hi Jacekskowron, So what you are saying it that only in the List.aspx PageTemplate does sort fail for postgreSQL?

If that's thae case hopefully one the team will have alook at this and may be point you in the right direction.

Re: Sorting by column header click doesn't work

sjnaughton — Thu, 11 Dec 2008 05:00:00 GMT

Hi Jacekskowron, I think your issue is with the postgreSQL ADO.Net Editites provider I'd have a go creating a command line app with one table and do a comparison again SQL Server and then if you are able to isolate the issue to say the Linq orderby statment then post you results to the Entity Framework forum here: ADO.NET Entity Framework and LINQ to Entities (Pre-release) - MSDN ...

Hope this helps

File .CSV Error :System.Data.Odbc.OdbcErrorCollection Help!!!!!!!!!!!

luisbragagnolo@hotmail.com — Tue, 02 Dec 2008 05:00:00 GMT

Hi There, I Have this error when I Uploaded the page in my Host, but in my computer work excellent. (Error :System.Data.Odbc.OdbcErrorCollection)

What I do is Copy the data from a .csv file to a database in MS SQL , in Godaddy.com

This is the Code:

protected void Cargar_Click(object sender, EventArgs e)
    {

        if (Uploader.PostedFile.FileName == "")
        {
            lblInfo.Text = "No file specified.";
        }
        else
        {
            #region cargar datos
            string NomArchivo = "Dsn=" + Uploader.FileName +";";

            string DBQ = "dbq=" + Path.GetDirectoryName(Uploader.FileName) + ";";
            string defaultdir = "dafaultdir=" + Path.GetDirectoryName(Uploader.FileName);
            string camino = NomArchivo + DBQ + defaultdir + ";driverid=27;fil=text;maxbuffersize=2048;pagetimeout=5";
            OdbcConnection DbConnection = new OdbcConnection(camino);
            string LeerOdbc = "SELECT StoreID, OrderID, CustomerFirst, CustomerLast, OrderDate, SubTotal, ItemNumber FROM ["+ Uploader.FileName +"]";
            OdbcCommand Odbccmd = new OdbcCommand(LeerOdbc, DbConnection);
            OdbcDataReader reader;
            SqlConnection con = new SqlConnection(connectionString);
            commisionrate = Int32.Parse(txtComision.Text);
            try
            {
                DbConnection.Open();
                reader = Odbccmd.ExecuteReader();
                while (reader.Read())
                {
                    string insertSQL;
                    insertSQL = "INSERT INTO DataVendedor(";
                    insertSQL += "StoreID, OrderID, CustomerFirst, CustomerLast, OrderDate, SubTotal, ItemNumber, ";
                    insertSQL += "CommisionRate) VALUES (";
                    insertSQL += "@StoreID, @OrderID, @CustomerFirst, @CustomerLast, @OrderDate, @SubTotal, @ItemNumber, ";
                    insertSQL += "@CommisionRate)";
                    SqlCommand cmd = new SqlCommand(insertSQL, con);
                    cmd.Parameters.AddWithValue("@StoreID", reader["StoreID"].ToString());
                    cmd.Parameters.AddWithValue("@OrderID", reader["OrderID"].ToString());
                    cmd.Parameters.AddWithValue("@CustomerFirst", reader["CustomerFirst"].ToString());
                    cmd.Parameters.AddWithValue("@CustomerLast", reader["CustomerLast"].ToString());
                    cmd.Parameters.AddWithValue("@OrderDate", reader["OrderDate"].ToString());
                    cmd.Parameters.AddWithValue("@SubTotal", reader["SubTotal"].ToString());
                    cmd.Parameters.AddWithValue("@ItemNumber", reader["ItemNumber"].ToString());
                    cmd.Parameters.AddWithValue("@CommisionRate", commisionrate);

                    try
                    {
                        con.Open();
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception err)
                    {

                        lblInfo.Text += "Error inserting record. " + err.Message;

                    }
                    finally
                    {
                        con.Close();
                    }
                }
            }
            catch (OdbcException ex)
            {
                lblInfo.Text += "Error :" + ex.Errors;
                lblInfo.Text += "<br />" + camino;

            }
            finally
            {
                DbConnection.Close();
                Response.Redirect("~/Default.aspx");
                lblInfo.Text = " Database Update ";
            }
            #endregion
        }

    }

I tried everything, always is working good in my computer, but not when I Publish the Web Site.

Even I tried to fix the file in one specific place, still nothing!!!!!!!!!!!!

Help!!!!!!!!!!!!!!!!!!!!!!!!!!

Can anyone recommend good hosting that support ASP.net 2.0 and PostgreSQL?

pauix — Sat, 16 Aug 2008 04:00:00 GMT

I'm currently building this ASP.net 2.0 website with PostgreSQL. The problem is I'm having a difficult time looking for a hosting provider that support both ASP.net 2.0 and PostsgreSQL. Is this a rare combination?

Can anyone recommend a good hosting provider for this combo?

Thanks!

Squilbo SQL tool needs BETA testers!

tobinharris — Wed, 14 May 2008 04:00:00 GMT

Hi folks,

We're looking for developers to help test Squilbo, starting within the next few weeks.

Squilbo lets you work with databases from your web browser. It's a simple tool designed for the SQL-savvy developer. It supports long running queries, multiple queries at once, batches, keyboard shortcuts, editable result sets, schema browsing and saving of queries. Deployment should be straight forward - just upload to your ASP.NET hosting or company intranet.

Version 1.0 will support MySQL and Microsoft SQL Server 2005. Sql Server 2000, Postgres, Oracle and Sqlite are in the pipeline too.

Get to play with squilbo early and sign up for Squilbo beta testing (starting soon).

Thanks for reading :-)

The Squilbo team