Also included are a query builder, tools for creating, editing, and executing stored procedures, triggers, and functions, a tool to compare table data and/or query results, and SQL history. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects tools for importing and exporting data a database browser for the viewing of database objects and structures and a robust programming editor with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and twelve other programming languages. RazorSQL ships with a built in relational database engine that is up and running out of the box and requires no end user administration. Any other JDBC or ODBC (Windows only) compliant database is also supported. View all methods and properties of the Connection object.RazorSQL is a SQL database query tool, SQL editor, database browser, and administration tool with support for over 40 databases and built in connection capabilities for Access, Cassandra, DB2, Derby, DynamoDB, Firebird, HSQLDB, H2, Informix, Microsoft SQL Server, MariaDB, MongoDB, MySQL, Oracle, Pervasive, PostgreSQL, Redshift, Salesforce, SimpleDB, SQL Anywhere, SQLite, Sybase, and Teradata. Source. Through this connection, you can access and manipulate a database. The ADO Connection object is used to create an open connection to a data Have physical access to that server, or ask your web The instructions above will work, but if your web site is located on a remote server, you have to
#RAZORSQL ODBC DRIVER#
The ODBC Driver is available to download from the Easysoft web site: Download the Windows ODBC Driver. The ODBC Driver enables you to work with data for in RazorSQL. Or Internet Information Server (IIS) on your own computer, RazorSQL can connect to databases by using either JDBC or ODBC. If you are running Personal Web Server (PWS) Note that this configuration has to be done on the computer where your web site In the Connection Wizard that appears, set the following properties: Driver Location: Set this property to the path to the lib subfolder in the installation directory.
#RAZORSQL ODBC HOW TO#
Here is how to create a connection to a MS Access Database: Your network, as long as an ODBC connection is available.Īn ODBC Connection to an MS Access Database With an ODBC connection, you can connect to any database, on any computer in
#RAZORSQL ODBC UPDATE#
WP Tutorial WebPages Intro WebPages Razor WebPages Layout WebPages Folders WebPages Global WebPages Forms WebPages Objects WebPages Files WebPages Databases WebPages Helpers WebPages WebGrid WebPages Charts WebPages Email WebPages Security WebPages Publish WebPages Examples WebPages ClassesĪSP.NET Razor Razor Intro Razor Syntax Razor C# Variables Razor C# Loops Razor C# Logic Razor VB Variables Razor VB Loops Razor VB LogicĪSP Classic ASP Intro ASP Syntax ASP Variables ASP Procedures ASP Conditionals ASP Looping ASP Forms ASP Cookies ASP Session ASP Application ASP #include ASP Global.asa ASP AJAX ASP e-mail ASP ExamplesĪSP Reference ASP VB Functions ASP VB Keywords ASP Response ASP Request ASP Application ASP Session ASP Server ASP Error ASP FileSystem ASP TextStream ASP Drive ASP File ASP Folder ASP Dictionary ASP AdRotator ASP BrowserCap ASP Content Linking ASP Content Rotator ASP Quick RefĪDO Tutorial ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed UpĪDO Objects ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes