SQL Express Linked Server to Kerridge

Post Reply
d1unc
Posts: 2
Joined: Thu Feb 25, 2010 6:04 pm

SQL Express Linked Server to Kerridge

Post by d1unc » Thu Feb 25, 2010 6:10 pm

Hi,

I am trying to create a Linked Server within SQL Express via an ODBC connection using the KISAM driver so that I can then query a table within a Kerridge Database.

I can create the Linked Server no problem but when I try a "SELECT * FROM <LINKEDSERVERNAME>.<TABLENAME>" I get an error saying the either the table does not exist or I don't have permission to view the table.

I know that the table does exist and I cannot see what permissions I would need?

If I try the exact same approach but in MS Access by creating a Linked Table, again via the same ODBC connection using the same KISAM driver, it works perfectly.

Any suggestions or ideas would be gratefully received!

Thanks in advance
Duncan

rafeemca
Posts: 1
Joined: Wed Aug 04, 2010 6:20 am

Re: SQL Express Linked Server to Kerridge

Post by rafeemca » Wed Aug 04, 2010 6:29 am

The query should be like below:

Syntax:
Select * from OPENQUERY(<Linked Server Name>,'Select * from <Kerridge Table Name>')

Example:-
Select * from OPENQUERY(KERRIDGE,'Select * from MA_10_BudgetTypes')

d1unc
Posts: 2
Joined: Thu Feb 25, 2010 6:04 pm

Re: SQL Express Linked Server to Kerridge

Post by d1unc » Wed Aug 04, 2010 8:40 am

Hi rafeemca,

Thanks for taking the time to reply - greatly appreciated.

This solution works perfectly by the way. I did discover the solution a while back but did forgot to post the solution myself and so apologies for that!

Regards,
Dunc

dannyagk
Posts: 1
Joined: Thu Aug 19, 2010 7:19 pm

Re: SQL Express Linked Server to Kerridge

Post by dannyagk » Thu Aug 19, 2010 7:50 pm

Hi Duncan,

seems like a great way to extract and query the data in the kisam database.
This comes in very handy for what i am doing in the company,
could you share some more details on it, in means of setting up the connection ?
I would greatly appreciate it.

Thanks,

Danny.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest