We are using SQL Linked servers and are receiving the error [ProvideX][ODBC Driver][PVKIO]Invalid segment number in one company (JAN). We are getting this error when doing a Select * From GL_DetailPosting. (Other tables work without error.) We can get…
A Linked Server within MS SQL Server is type of 'alias' within the SQL server that points to an external data source rather than a SQL Server database. This external data source can be in another RDBMS like Oracle or almost any other data system that…
We have a client that is having a very strange issue with ODBC drivers when we try to setup a linked server in SQL. No matter what we try we get an error that seems to suggest that the login is failing but ONLY when we try to access it from SQL. Using…
I need to create a linked server from ms sql server to access my timberline data.
I managed to create one using the Pervasive ODBC Client interface driver. What I really need it to create it using the Timberline Driver.
Has anyone ever done this?…
Hi
I try to connect Sage 2013 to SQL Server 2012-64x
I have MAS 90 4.0 ODBC Driver 64x (Version 4.40.02.00, Date 9/28/2012)
The DSN works well, Linked Server is Successfull but when i try to select from linked server i get this error: ( Sage2013x64…
Hello,
I am new to the world of Sage ERP.
I have designed this query and it works fine in SQL:
SELECT o1.*, ( Select isnull(SUM(D002_DollarsRented)+SUM(DollarsSold),0) FROM openquery(TESTSWRMAS, 'select * from AR_CustomerSalesHistory') o2 WHERE…
