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 |
|
sparrow
Starting Member
20 Posts |
 Posted - 2008-05-07 : 18:00:28
|
| This is a bit of a long shot but I’m trying to connect through management studio to a Jade application.I can set up a connection through connection manager as a new connection then as an ODBC link. I then select the connection as a “system data source” Test the connection which is successful. (I also use this connection when connecting to the jade application through Access which works fine)In the control flow I select “data flow task” This is when I start to ruin into problems. I then select “Data reader source’ this then brings up the Advance editor which allows me to select the connection I made above as the connection manager. I click ok then get the following error “Error at data flow task [DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager”A couple of things to note about jade is that it is object orientated DB and doesn’t have any relational tables but has a load of views which we connect to, to build our tables from. We are able to connect to it through DTS in SQL2000 which is how we currently build our tables but we want to move to 2005 and rebuild the loads rather than just migrate the DTS packages.I have contacted the people who support our jade system and although they haven’t been a great help they did mention that there may be issues with connecting to JADE using SQL2005, and the problem may lie with JADE but have no idea if this is correct.Any help or ideas in making this connection work would be much appreciatedCheers |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 21:10:39
|
| Have to ensure that driver works with sql2k5. |
 |
|
|
|
|
|
Connecting to jade DB