General MySQL Oracle SQL Server

1 2 3 4 5 6 … > >>   ∑:509  Sort:Rank

Differences of DECIMAL and FLOAT in SQL Server
What Are the Differences between DECIMAL and FLOAT in SQL Server Transact-SQL? DECIMAL and FLOAT are both used to store numerical values. But they have the following main differences: DECIMAL(p,s) stores values with the decimal point fixed at the position of s (scale) digits from the right. The tota... 2026-02-12, 3642🔥, 1💬

SQL Server Connection Protocols
What connection protocols are supported by SQL Server? SQL Server supports the following connection protocols: 1. TCP/IP (Transmission Control Protocol/Internet Protocol) - This is the most commonly used protocols to connect to SQL Server databases. It allow client tools or application programs on a... 2024-08-14, 3385🔥, 0💬

SQL Server TCP/IP Connection Info
What information is needed for a client tool or application to connect to a SQL Server database using the TCP/IP protocol? In order to connect to a SQL Server database using the TCP/IP protocol, you need to know the following information: 1. Host Name - The name of the hosting computer where the SQL... 2024-08-14, 3266🔥, 0💬

Configuring ODBC Connection and DSN for SQL Servers
A collection of 13 FAQs on connecting SQL Server via an ODBC DSN setting. Clear explanations and tutorial exercises are provided on creating new DSN with the SQL Server ODBC driver; starting SQL Server Browser Service; enabling TCP/IP protocol on SQL Server; verifying TCP/IP port numbers; testing OD... 2024-08-14, 3246🔥, 0💬

What Is ODBC (Open Database Communication)?
What Is Open Database Communication (ODBC)? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management servers. If you want to access a database server through an ODBC driver from an applic... 2024-08-14, 3101🔥, 0💬

SQL Server Connection Concepts
Where to find answers to frequently asked questions on SQL Server Connection Concepts? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Server Connectivity Concepts. SQL Server Connection Protocols SQL Server TCP/IP Connection Info   ⇒ SQL Serv... 2024-08-14, 2770🔥, 0💬

Adding a New DSN with the ODBC Driver for SQL Server
How To Add a New DSN with the ODBC Driver for SQL Server? Assuming that the ODBC driver for SQL Server has been installed as part of the Windows system, the next step of setting up ODBC connection to SQL Server is to create a new DSN (Data Source Name) with the ODBC Data Source Administrator: Go to ... 2024-08-06, 3031🔥, 0💬

Defining the Name and Server for a new DSN
How To Define the Name and Server for a new DSN? Continuing from the previous tutorial, on the first screen of the "Create a New Data Source to SQL Server" wizard, you should enter 3 fields: Name, Description, and Server as suggested below: Name: FYI_SQL_SERVER Description: FYIcenter.com SQL Server ... 2024-08-06, 2897🔥, 0💬

Getting "Connection failed" Error on ODBC DSN Creation
Why Am I Getting Errors When Creating a New ODBC DSN? Continue from the previous tutorial. After clicking Next on the SQL login information screen, ODBC manager will try to connect to the SQL Server with the login information you provided. After a period of waiting time, you may get error message bo... 2024-08-06, 2771🔥, 0💬

Requirements on SQL Server Network Connections
What Are the Requirements on SQL Server Network Connections? By default, SQL Server 2005 Express Edition is installed only one connection protocol enabled: Shared Memory - SQL Server connection protocol for applications that are running on the same machine where the SQL Server is running. For exampl... 2024-08-06, 2665🔥, 0💬

Providing Login Information for a New ODBC DSN
How To Provide Login Information for a New ODBC DSN? Continue from the previous tutorial. After clicking Next on the first screen of the "Create a New Data Source to SQL Server" wizard, you should see the second screen asking you to select SQL Server login type, login name and password. Select the r... 2024-08-06, 2642🔥, 0💬

Configuring ODBC DSN with Different Port Numbers
How To Configure ODBC DSN with Different Port Numbers? If your SQL Server is not using the default port number, like 1269, you need to set the port number to the correct value during the ODBC DSN creation process, as show in this tutorial: 1. Start ODBC Data Source Administrator and click System DSN... 2024-07-25, 3311🔥, 0💬

Starting SQL Server Browser Service
How To Start SQL Server Browser Service? SQL Server Browser Service is installed as part of the SQL Server. But it is turned off by default to reduce the security risk. If you want start SQL Server Browser Service to allow the SQL Server to accept network connections, you need to follow the steps be... 2024-07-25, 2949🔥, 0💬

Enabling TCP/IP Protocol on a SQL Server
How To Enable TCP/IP Protocol on a SQL Server? By default, the TCP/IP protocol is turned off when a SQL Server is installed to reduce security risk. But if you want applications to connect and access the SQL Server, you need to enable the TCP/IP protocol on the server by following this tutorial: 1. ... 2024-07-25, 2885🔥, 0💬

Verifying the Port Number of the SQL Server
How To Verify the Port Number of the SQL Server? When applications use TCP/IP for network communication, you need to know the port number where the server is listening for connect request from the client. If you want to connect to the SQL Server through the TCP/IP, you must know on which port number... 2024-07-25, 2678🔥, 0💬

Configuring and Testing ODBC DSN Settings
How To Configure and Test ODBC DSN Settings? Continue from the previous tutorial. Click Next after you have finished changing the port number. The ODBC Data Source Administrator will try to connect to the SQL server through the specified port number and login information. If the connection is succes... 2024-07-25, 2616🔥, 0💬

Returning Result from Query with ODBC Connection
How To Receive Returning Result from a Query? When you execute a SQL SELECT statement with the odbc_exec() function, you can capture the returning result with a result set object with the following syntax: $result_set = odbc_exec($sql_statement); #- The returning value could be a Boolean value FALSE... 2024-07-17, 2624🔥, 1💬

odbc_tables() - Listing All Tables in the Database
How To List All Tables in the Database using odbc_tables()? If you want to get a list of all tables in the database, you can use the odbc_tables() function, which can actually be used to list all tables and views in the database. The syntax of odbc_tables() is: $result_set = odbc_tables($connection_... 2024-07-11, 2845🔥, 0💬

odbc_result() - Retrieve Field Values
How To Retrieve Field Values using odbc_result()? After calling odbc_fetch_row(), the field values of the fetched row are available in the result set object. You can use odbc_result() to retrieve the value of any given field with two syntax formats: $value = odbc_result($field_name); #- Retrieving v... 2024-07-11, 2571🔥, 0💬

Testing ODBC DSN Connection Settings
How To Test ODBC DSN Connection Settings? Assuming you have followed other FYIcenter.com tutorials and created an ODBC DSN called "FYI_SQL_SERVER", and planning to use it your PHP scripts, you should test this ODBC connection first as shown in this tutorial: 1. Go to Control Panel > Administr... 2024-07-11, 2553🔥, 0💬

odbc_data_source() - Listing All DSN Entries
How To List All DSN Entries on Your Local Machine using odbc_data_source()? If you are interested to know what DSN entries are available on your local machine, you can use odbc_data_source($con, SQL_FETCH_FIRST) and odbc_data_source($con, SQL_FETCH_NEXT) in a loop to list all DSN entries defined on ... 2024-07-11, 2546🔥, 0💬

odbc_connect() - Connecting to a SQL Server through an ODBC DSN
How To Connect to a SQL Server using odbc_connect()? If you have an ODBC DSN (Data Source Name) created linking to a SQL Server, you are ready to connect to the SQL Server through the DSN with ODBC functions. There is no changes needed in the php.ini configuration file. The tutorial script below sho... 2024-07-11, 2516🔥, 0💬

odbc_errormsg() - Retrieving ODBC Error Messages
How To Retrieve Error Messages using odbc_errormsg()? When you call odbc_exec() to execute a SQL statement, and the execution failed on the SQL Server, you can use odbc_error() and odbc_errormsg() to retrieve the error code and error messages. The tutorial script below shows you a good example: &... 2024-06-30, 3147🔥, 0💬

odbc_exec() - Executing SQL Statements
How To Execute a SQL Statement using odbc_exec()? Once you have created an ODBC connection object, you can use the odbc_exec() function to send a SQL statement to the SQL Server linked to the connection object for execution. Here is a simple PHP script that creates a new schema and a new table: &... 2024-06-30, 2953🔥, 0💬

1 2 3 4 5 6 … > >>   ∑:509  Sort:Rank

General MySQL Oracle SQL Server