Dexterity - Access SQL Table on Different SQL Server

(0) Share

Report

Posted on by DK128

100

I'm trying to use Dexterity to access a SQL table that resides on a different SQL server. I've tried the open table statement based on the example help:

The following example opens the table Inventory_Master in the INVENT database located on the SQL server named Server12.

open table Inventory_Master as DB_TYPE_SQL, ":Server12:INVENT/";

But it's still trying to find the database on the Local SQL server. How do you access a table on a different server?

*This post is locked for comments

All responses (2)

Answers (0)

Dave Dusek on at

Like (0)

Report

RE: Dexterity - Access SQL Table on Different SQL Server

You have to use ADO with COM, that is the only way you can access a table on a different server from Dex
Suggested answer

Bill Vassas 85 on at

Like (1)

Report

RE: Dexterity - Access SQL Table on Different SQL Server

Not sure what the Dexterity syntax is, but to query from one sql server to another you need to create a SYNONYM first in the database.