sql server

  1. C

    Linked Server to ODBC

    Hi all out there, I have read many posts (inside and outside this forum) that deals with the error 7303 when trying to setup a linked Server object in SQL Server to reach a Progress database though the use of an ODBC driver. My situation: SQL Server 2016 on a 64-bit OS server (virtual) A...
  2. R

    Question Odbc And Multi Tenancy

    I am looking at using OpenEdge Multi Tenancy database for a solution that requires connections via a) a SQL Server Linked server, and b) .Net ODBC connection. I am using Progress OpenEdge 11.6 Driver (actually 11.6.3). Using OpenEdge Explorer with Sports2000 database, I have: Enabled Multi...
  3. Jeff Winchell

    Linked Server Doesn't Work, Openrowset Does

    The simple ODBC test connection works. The simple linked server test connection works. I can get a list of tables using that linked server. Outside of SQL Server, I can write a powershell script that does a select * from sometable. I cannot get a Select * from [whateverlinkedtable] to work...
  4. H

    Limiting Connections To Progress Database

    Hello, I wonder if anyone can help? I've written a Microsoft SSIS package to export data from two Progress databases (10.2 and 11.3) that connects via an ODBC 11.3 driver to export data into SQL Server. However, the Progress administrator contacted me to let me know that on several occasions...
  5. H

    Limiting Connections To Progress Database

    Hello, I wonder if anyone can help? I've written a Microsoft SSIS package to export data from two Progress databases (10.2 and 11.3) that connects via an ODBC 11.3 driver to export data into SQL Server. However, the Progress administrator contacted me to let me know that on several occasions...
  6. J

    !!! Sx.e Job Opportunity !!! Houston, Tx

    I have a client in Houston that has an immediate need for someone with experience supporting Infor SX Enterprise and Progress databases. Any coding/customization experience is a plus but at this point I want to talk to anyone interested in a fulltime job focused on SX.e with a great company...
  7. J

    How Can A Progress 10.2a Database Be Replicated To Sql Server?

    The organization uses the ERP system Epicor 9 with a Progress 10.2a database and needs to replicate the ERP Progress data to a SQL Server (any version) database for reporting. We would like the replication to be as near to real-time as possible. What are some possible solutions to this...
Top