Error calling SQLDriverConnect with DSN name in curly braces

Printable View

Information

Title	Error calling SQLDriverConnect with DSN name in curly braces

URL Name	error-calling-sqldriverconnect-with-dsn-name-in-curly-braces

Article Number	000129156

Environment	Product: Progress DataDirect for ODBC Version: 8.0 Product: Connect/Connect64 for ODBC Version: 7.1 OS: All supported platforms Database: All supported databases Application: All supported applications

Question/Problem Description

It is allowed/recommended to use curly brackets to enclose values in a connection string. This works for any connection attribute except for DSN.

This connection string fails:
DSN={mydsn};UID={test};PWD={secret}
This succeeds:
DSN=mydsn;UID={test};PWD={secret}

Steps to Reproduce

Clarifying Information

Error Message	Data source name not found and no default driver specified

Defect Number	Defects XDBC-15573, XDBC-16822

Enhancement Number

Cause

The Driver Manager was treating the curly braces as part of the DSN name.

Resolution

Fixed in hot fix 07.16.0368 (U0335) and 08.02.0408 (U0365).
Refer to article Connect and Connect64 for ODBC hot fix download and install instructions for instructions on how to download and install the hot fix.

Workaround

Leave the curly braces off of the DSN value.
DSN=mydsn;UID={test};PWD={secret}

When using a data source name (DSN) that requires curly braces, use SQLConnect instead of SQLDriverConnect.

Notes

References to other documentation:
ODBC API Reference for SQLDriverConnect
https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqldriverconnect-function?view=sql-server-2017#comments

Last Modified Date	11/20/2020 6:58 AM

Files

Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Sitefinity

NativeChat

Kendo UI

Telerik

Test Studio

Fiddler Everywhere

Chef

MOVEitNew Release

WS_FTP

OpenEdge

Kinvey

WhatsUp Gold

DataDirect

Corticon

Kemp

Flowmon

Error calling SQLDriverConnect with DSN name in curly braces

Information

MOVEit
New Release