SQL Server Instance Help

[bedirhanmanim]

How can i connection sql server instance can you provide dsn?

[iTanken]

https://github.com/go-gorm/sqlserver

https://github.com/go-gorm/sqlserver/blob/b8d91cbd0b9b9d9a3538cf0d9f7f01ac2fcf006d/README.md?plain=1#L6-L13

[BEDIRHANSAMSA]

Hello, this is not working when using instance. Instance Name Example: WIN-NNN/SQLPRO

[iTanken]

https://github.com/microsoft/go-mssqldb#connection-parameters-and-dsn

// dbConfig is the database connection configuration information struct
if strings.Contains(dbConfig.Host, `\`) {
	// Compatibility Backslash Instance Path
	dbConfig.Host = strings.ReplaceAll(dbConfig.Host, `\`, `/`)
}

query := url.Values{}
query.Add("database", dbConfig.Database)
query.Add("app name", dbConfig.AppName)
query.Add("encrypt", "disable")
query.Add("connection timeout", "90")
query.Add("dial timeout", "30")
query.Add("keepalive", "30")

sqlserverUrl := &url.URL{
	Scheme:   `sqlserver`,
	User:     url.UserPassword(dbConfig.Username, dbConfid.Password),
	RawQuery: query.Encode(), // Connection parameters
}

if dbConfig.Port < 1 || strings.Contains(dbConfig.Host, `/`) {
	// Ignore the port if the port is not configured or the service address contains the instance name
	splitSize := 2
	paths := strings.SplitN(dbConfig.Host, `/`, splitSize)
	if len(paths) > 0 {
		sqlserverUrl.Host = paths[0]
		if len(paths) > 1 {
			sqlserverUrl.Path = paths[1]
		}
	}
} else {
	sqlserverUrl.Host = fmt.Sprintf("%s:%d", dbConfig.Host, dbConfig.Port)
}
dsn = sqlserverUrl.String()

[bedirhanmanim]

Thank you @iTanken