SQL Views to MAS 200 Database
SQL Views to MAS 200 Database
(OP)
thread637-1405340: MAS200 ODBC connection string to Sharepoint
I have created an SQL linked server to my MAS200 database, this all works fine. I then created a blank database with a view to AP_Vendor. The SQL syntax I used to create the view was:
CREATE VIEW Vendors AS
SELECT * from OPENQUERY(MASLINK, 'SELECT * FROM AP_Vendor')
My problem is when I try an access the data, I don't see the view. I'm wondering if it has something to do with a no primary key.
Does anyone have any idesas?
Thank you
Don Price
I have created an SQL linked server to my MAS200 database, this all works fine. I then created a blank database with a view to AP_Vendor. The SQL syntax I used to create the view was:
CREATE VIEW Vendors AS
SELECT * from OPENQUERY(MASLINK, 'SELECT * FROM AP_Vendor')
My problem is when I try an access the data, I don't see the view. I'm wondering if it has something to do with a no primary key.
Does anyone have any idesas?
Thank you
Don Price