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 |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-09-08 : 14:38:38
|
| I'm curious if it's possible to link 2 different databases from different servers to be use together? I have a database from sqlbase and a database from sql server. Both have a field that can be use to join, because those fields acts as primary/foreign keys. The old report was programmed in Cyrstal reports where both tables reference each other and pull information from both tables into the report. I was wondering if this can be accomplish from Reporting Services. I know I can use 2 datasets one for each database, but how would I like the primary/foreign key from one dataset to the other? Probably subreports but anyone got a better solution? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-09-08 : 14:55:23
|
| How about doing the link from SQL Server to sqlbase and then just querying SQL Server from your report? SQL Server could handle the JOIN and return all the results in one data set.---------------------------EmeraldCityDomains.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-08 : 17:43:41
|
| Chris,In the other thread that you created, I said that you could use linked servers. That thread is probably about 2 weeks old. Have you not tried that?Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-09-09 : 07:23:14
|
| Tara and AjarnMark,I had tried setting the link servers with sqlbase and sqlserver in enterprise manager, but it will not work. It seems like it has something to do with my settings. Since I'm using Gupta SQLBase ODBC Driver, it asked for Provider, Data Source, and Provider String. I provided the Provider field with the datasource name, Data source with the database name, and provider string as "SQLBaseOLEDB". When I connect it says Authentication failed. So I go to the security tab and put in where it says Remote Login the database login and password. That still doesn't work. I tried searching for white papers online and forums to see if anyone post up any other questions relating to this, but no luck. I was hoping that someone is able to do this by using 2 data set and just linked them together in reporting services as a workaround.I would like to be able to use the Linked Server in Enterprise Manager so that I can create stored procedures and also easier for me to work in, but at the moment I'm out of ideas.Any ideas? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-09 : 13:23:01
|
| Shouldn't you be using the Centura SQLBase driver? The Gupta version would be very, very old as Centura has had the SQLBase product for quite some time now.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-09-13 : 07:13:52
|
| I thought that Centura merge with Gupta? If you try going to Centura website it just redirects you to the Gupta website. Also the Gupta ODBC Driver is the latest. It supports sqlbase 9. I was able to get the ODBC Driver from Gupta to work with SQLBase 7.1.5. The problem is just linking SQLBase to SQL Server. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-13 : 13:44:53
|
| Did they switch back to Gupta? My knowledge of that product is over 4 years now. Back then, Gupta was the old version and Centura was the new. I guess they reverted again.Tara |
|
|
|
|
|
|
|
|
Linked servers or database?