|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Linked Servers |
| Author |
Message |
| Pete |
| |
| Group | : Members |
| Posts | : 17 |
| Joined | : 2007-01-06 |
|
| Profile |
|
| Posted : 2007-10-19 23:17:45 |
I am having trouble trying to get a simple query working. On my SQL 2005 server i have set up a linked Server, and on that SQL server i can use Enterprise Manager and run a query ( Select * From OPENQUERY( QODBC, 'Select * from Customer unoptimized') which returns the data from the quickbooks customer table, however, from another machine, i call Enterprise manager ( on that machine ) and log it on to the main SQL server ( one with the linked server ) and try to run the same query, Enterprise Manager just sits there stating it is Execuring Query. Can any one suggest where i may be going wrong
Thanks |
|
| |
i really do need help, this computer stuff is like double dutch
|
| | Top | |
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-20 08:45:47 |
| My understaning is that the QODBC linked server is only a local database on the linked server. It can't be called from anywhere else. That's why customers use DTS and SSIS to copy the QODBC tables to a native MS SQL Server Database so many users can access them. |
|
|
|
| Pete |
| |
| Group | : Members |
| Posts | : 17 |
| Joined | : 2007-01-06 |
|
| Profile |
|
| Posted : 2007-10-21 04:43:37 |
Thanks Tom,
I thought this was the case ,,,, though i was hoping for alittle more flexability ... oh well we can live in hope , SSIS is is |
|
| |
i really do need help, this computer stuff is like double dutch
|
| | Top | |
|
|
|