Search results for query: *

thread637-1405340 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...

Thank you Steve. I now have SQL Express installed and I am trying to make the Linked Server, it asks me for a Provider, Product Name, Data Source, Provider String, Location and Catalog. For the provider do I choose Microsoft OLE DB Provider for ODBC Driver? I am also unclear what is required...

I really only need read access to maybe 3 tables. The steps that I am taking are: On our SharePoint web server I have installed v.4.10.1001 ProvideX ODBC drivers. I then created a System DSN pointing to the MAS200 server. This tested OK I have SharePoint Designer installed on my desktop PC...

Thank you BigLouie, I just tried it and I get the same results. MAS200 is version 4.1, does this mater? What is the purpose of SERVER=NotTheServer? Should this be the name of the MAS200 server?

I am trying to use Microsoft’s SharePoint Designer to create a database connection to our MAS200 database. I seem to be having problems creating the correct connection string. The SharePoint web site is on a different server other than MAS200. On the SharePoint server I have an ODBC connection...