BoxLang 🚀 A New JVM Dynamic Language Learn More...

BoxLang Microsoft SQL Server

v1.1.0+7 BoxLang Modules

⚡︎ BoxLang Module: Microsoft SQL Server JDBC Driver

|:------------------------------------------------------:  |
| ⚡︎ B o x L a n g ⚡︎
| Dynamic : Modular : Productive
|:------------------------------------------------------:  |
Copyright Since 2023 by Ortus Solutions, Corp
www.boxlang.io | www.ortussolutions.com

 

This module provides a BoxLang JDBC driver for Microsoft SQL Server. This module is part of the BoxLang project.

Examples

See BoxLang's Defining Datasources documentation for full examples on where and how to construct a datasource connection pool.

Here's an example of a BoxLang datasource definition using this Microsoft SQL Server driver:

this.datasources["mssqlDB"] = {
	driver: "mssql",
	host: "localhost",
	port: "1433",
	database: "myDB",
	username: "sa",
	password: "123456Password",
};

or you can use environment variable substitution to populate the datasource definition:

this.datasources["mssqlDB"] = {
	driver: "mssql",
	host: "${env.MSSQL_HOST:localhost}",
	port: "${env.MSSQL_PORT:1433}",
	database: "${env.MSSQL_DATABASE:myDB}",
	username: "${env.MSSQL_USERNAME:sa}",
	password: "123456Password",
};

Ortus Sponsors

BoxLang is a professional open-source project and it is completely funded by the community and Ortus Solutions, Corp. Ortus Patreons get many benefits like a cfcasts account, a FORGEBOX Pro account and so much more. If you are interested in becoming a sponsor, please visit our patronage page: https://patreon.com/ortussolutions

THE DAILY BREAD

"I am the way, and the truth, and the life; no one comes to the Father, but by me (JESUS)" Jn 14:1-12

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.


Unreleased

1.1.0 - 2024-11-25

Fixed

  • Added URI delimiter that was missing from URIs
  • Github Actions Consolidation

1.0.0 - 2024-06-13

===

  • First iteration of this module

$ box install bx-mssql

No collaborators yet.
     
  • {{ getFullDate("2024-05-14T22:38:36Z") }}
  • {{ getFullDate("2024-11-25T17:13:45Z") }}
  • 507
  • 558