You can use MSDE, a SQL server compatible database engine that MS makes available for free. You can download and install MSDE from a whole variety of sources. Here is one source . MSDE also comes with Visual Studio .NET and the .NET Framework SDK. It... The data source component of your connection string should contain the port right after the IP address (or name). It should be separated from the IP by a comma. data source=192.168.123.1, port_number; Take a look at the connectionstrings.

Yes. You can use any relational database that is accessible by JDBC and satisfies the SPECjAppServer2004 Run and Reporting Rules.

Yes, but to do this, you should open the port where SQL Server works (1433 by default) on your firewall and on the firewall of the remote network.

SQL Server is Microsoft's flagship database system for enterprises. While it is extremely fast and reliable, it may be costly for small companies. Find out more at the SQL Server product page.

Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. The MySQL Server apply these modes individually to different clients. For more information, see Section 5.2.6, "SQL Modes".

You can set the default SQL mode (for mysqld startup) with the --sql-mode option. Using the statement SET [SESSION|GLOBAL] sql_mode='modes', you can change the settings from within a connection, either locally to the connection, or to take effect globally. You can retrieve the current mode by issuing a SELECT @@sql_mode statement.

If due to the security policy accepted in your corporate network or by your host provider you cannot connect to your PostgreSQL server directly through TCP/IP (for example a firewall prevents this), you can use SSH or HTTP tunneling feature of SQL Manager to fulfill your task.

Using our products you can work with the following SQL Server versions: SQL Server 7, SQL Server 2000, MSDE, SQL Server 2005, SQL Server Express.

Why am I being blocked by spid -1? I am not able to kill it and have to restart SQL Server to get around it. Why does the new 'TOP' command in SQL 7 not work? I get a syntax error. Also ALTER TABLE and other SQL 7 only commands.

By default, no special modes are enabled. See Section 5.2.6, "SQL Modes", for information about all available modes and MySQL's default behavior.

Yes. The database window works only with Access databases, but you can use any database that supports OLE DB and ODBC standards for e-mail merge. That includes SQL Server, Oracle, Excel, Text Files, Access, etc. In BaseNow, our database product, you can easily transform your SQL queries, tables and views between an Access database and any other database format. You will then be able to use other features in the program. For more information about BaseNow, visit this web page.

I'm getting an error message - "Cannot Load DLL 'SDI' Reason 126 ( The specified Module Cannot be found)" when doing a stored-procedure debug on SQL Server. Or breakpoints just don't fire.

I'm doing a transfer using the SQL EM transfer tool, and not only is it not transferring the objects.