Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wali
Starting Member
7 Posts |
 Posted - 2007-02-09 : 16:11:40
|
| Could someone tell me how to use a query with a "connection string" to connect to an ODBC driver and retrieve data from its tables. I am new at this and have been having a lot of trouble connecting from the SSIS manager. If someone has a tutorial on how to do this. I would really appreciate it. Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-09 : 16:15:55
|
http://www.connectionstrings.com/Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
wali
Starting Member
7 Posts |
Posted - 2007-02-09 : 16:39:23
|
| Thnx for the reply, I know how to create a connection string but how do i use it in the query. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-10 : 06:42:47
|
| you don't use it in a query.you construct a connetion object and you use it on a command.what's your dev language? c#?Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
connect to ODBC driver