Reference Citations - HerongYang.com - v2.91, by Dr. Herong Yang
Connection String - SQL Server 2005
'JDBC-ODBC - Creating DSN for SQL Server 2005' tutorial was cited in a forum post in 2009.
The JDBC-ODBC - Creating DSN for SQL Server 2005 tutorial was cited in a forum post in 2009.
Subject: Connection String - SQL Server 2005 Date: 9 Jul 09 Author: SchwabTerex Source: http://www.tek-tips.com/viewthread.cfm?qid=1558108&page=5 >I'm trying to connect to a SQL server 2005 database on another >server. This is my 1st attempt at using Crystal to connect with a SQL >db. I assume I need to set up an ODBC connection (the option I see is >OBDC (RDO)). I've been using the examples on connectionstrings.com to >create a connection string. I'm not sure which string format I ought >to use, or which values go where. >... I'm not 100% sure what you are looking at. If you would like a different way to look at setting up an ODBC connection try this site: http://www.herongyang.com/jdbc/JDBC-ODBC-DSN-for-SQL-Server.html I personally have never tried to use one of the strings they are talking about on connectionstrings.com. I always go throught the administrative tools to the Data Source (ODBC). Then it is just a matter of choosing a new system DSN and following the wizard. It's maybe not an option for you but I thought I'd mention it. Can't hurt right?
Table of Contents