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 |
|
MyronCope
Starting Member
46 Posts |
 Posted - 2010-11-05 : 10:50:31
|
| For a crystal report I need to create one stored procedure that will pull data from 2 different kinds of odbcs.1 is a SQL Server 2005 database1 is a PLB database (which is actually files)I am able to pull data separately from each odbc/db however I need to figure out how to create One stored proc that will join on fields located in both databases and wondering if anyone knows how to do that?Both databases are located on separate servers toothanksMC |
|
|
shebert
Yak Posting Veteran
85 Posts |
Posted - 2010-11-05 : 10:58:46
|
| You should try to add a linked server linking to the DBT file.If you get it linked you can then query it as if it was a second database on your server.IF YOU CAN'T LINK THE FILEYou could import the data from the DBT files into a table on the sql server.this gets tricky however because you need to import the data into an empty table just before the procedure is run to get the latest data from the DBT file. |
 |
|
|
MyronCope
Starting Member
46 Posts |
Posted - 2010-11-05 : 11:22:20
|
| you know what I think the import would be the best thing to do. Import all the data once each night, make a scheduled task on the server to do this. |
|
|
|
shebert
Yak Posting Veteran
85 Posts |
Posted - 2010-11-05 : 12:04:30
|
| Good Luck |
|
|
|
|
|
|
Create stored procedure with 2 odbcs