Skip to main content

Search

Welcome to Tibero GTS!

SID in tbdsn.tbr Method ODBC Connection Results in Data Source Not Found Error

Document Type | Troubleshooting

Category | Interface/Integration

Applicable Product Versions | 7FS01, 7FS02, 7FS02PS

Document Number | TIITS003

 

Issue

When attempting to connect via ODBC using the SID in tbdsn.tbr method, the error โ€˜TBR-2048 Data Source Not foundโ€™ occurs and connection is not possible.

Note
tbdsn.tbr is a configuration file containing necessary information for the client to connect to the Tibero database. By default, the tbdsn.tbr file includes information such as SID, host, and port number. 
 

 

Cause

The โ€˜2048 error - Data Source Not foundโ€™ occurs when the SID being used to attempt connection cannot be found in the tbdsn.tbr file. This happens when trying to connect using a SID different from the one listed in tbdsn.tbr or when the tbdsn.tbr file cannot be properly located.
 
During ODBC connection attempts using the SID in tbdsn.tbr method, connection may fail if the TB_HOME PATH is not properly set or if the SID is not correctly specified.
 
 
 
 

Solutions

1. Verify that the listed SID matches

  • TB_SID registered in environment variables (echo %TB_SID% or Environment Variables tab)
  • SID listed in tbdsn.tbr
  • SID you want to connect to
If they do not match, reset the SID and try connecting again.
 
 

2. Check the tbdsn.tbr file path

  • Verify that %TB_HOME% is properly applied (echo %TB_HOME% or Environment Variables tab)
If the path is not set, specify the absolute path of the tbdsn.tbr file in the TB_DSN_FILE environment variable and then try connecting.
--Example

TB_HOME => C:\Users\test\tibero7

TB_DSN_FILE => C:\Users\test\tibero7\client\config\tbdsn.tbr
Caution
The tbdsn.tbr file exists in %TB_HOME%\client\config.
 
If %TB_HOME% is not properly set, the file path may be set to a different location or \client\config, causing the tbdsn.tbr file to not be found and resulting in the Data Source Not found issue.
 
 
 
 
 
 
 

Related to