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
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!
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.
Who is online
Users browsing this forum: No registered users and 0 guests