= doc.FAQ.HowDoITroubleshootAFailedJDBC-ODBCBridgeConnection

%TOC%

   
*Ensure that the ODBC Data Source Name connects to the target database.  
*Ensure that Windows-based ODBC Data Sources are System Data Sources.  
*Ensure that [[OpenLink]]  's Single-Tier driver is installed on the machine that contains the ODBC Data Source Name.  
*Ensure that you pass the exact name of the ODBC Data Source in the JDBC connection URL.  
*Ensure that your Single-Tier JDBC connection URL uses the following syntax: 
{{{
jdbc:openlink://ODBC[/DSN][/UID][/PWD][/READONLY] 
}}}
 
For example: 

{{{
jdbc:openlink://ODBC/DSN=Local Oracle ODBC/UID=scott/PWD=tiger 
}}}

 [[http://support.openlinksw.com/support/worksheets.vsp?ws=st_install|Single-Tier Installation or Connection Problem]] 

 [[http://support.openlinksw.com/support/worksheets.vsp?ws=mt_install|Multi-Tier Installation or Connection Problem]] 


----