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 |
|
Antonio
Posting Yak Master
168 Posts |
 Posted - 2007-02-23 : 05:49:47
|
| Hi there,I am trying to configure an SSIS connection manager to recognise a SQL Server 6.5 database but I can't get it to work. Testing the connection works but I am unable to select a database from the drop down list.Which OLE DB provider should I use to access a SQL Server 6.5 database?!_________________________________________________________________________________________________________________________Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will. |
|
|
Antonio
Posting Yak Master
168 Posts |
Posted - 2007-02-27 : 04:54:09
|
quote:
Originally posted by Antonio
Hi there,I am trying to configure an SSIS connection manager to recognise a SQL Server 6.5 database but I can't get it to work. Testing the connection works but I am unable to select a database from the drop down list.Which OLE DB provider should I use to access a SQL Server 6.5 database?!_________________________________________________________________________________________________________________________Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will.
I have now solved this problem finally!The native ODBC data provider works well if you're wanting to use a SQL Query Task but as there is no ODBS data source component in SSIS, one has to use the ADO.Net ODBC data provider.This is done by creating new connection manager, selecting ADO.Net then choosing ODBC from the drop down list.Problem solved.  _________________________________________________________________________________________________________________________Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will. |
 |
|
|
|
|
|
Data providers for SQL Server 6.5