Skip to main content

AcuXDBC with MS SQL Server Linked Server setup failing

  • March 21, 2021
  • 8 replies
  • 0 views
A
  • Anonymous

Could you please point me to the latest most detailed documentation on getting AcuXDBC 32 bit version 10.3.1 working with a 32 bit version of MS SQL Server Management Studio Linker Server

 

I am hoping/expecting that MS SQL server will overcome the restriction that I am encountering when using MS Access in that I can only read in 256 columns.

 

I have attached a word document showing my current setup in which I am employing a version 9.01 ACUXDBC .

 

It may be better simply to provide the info on exactly step by step it should be done rather than trying to work out what I have done wrong.

    8 replies

    Stephen Hjerpe
    • Stephen Hjerpe
    • Participating Frequently
    • March 22, 2021

    Could you please point me to the latest most detailed documentation on getting AcuXDBC 32 bit version 10.3.1 working with a 32 bit version of MS SQL Server Management Studio Linker Server

     

    I am hoping/expecting that MS SQL server will overcome the restriction that I am encountering when using MS Access in that I can only read in 256 columns.

     

    I have attached a word document showing my current setup in which I am employing a version 9.01 ACUXDBC .

     

    It may be better simply to provide the info on exactly step by step it should be done rather than trying to work out what I have done wrong.

    Does this help ... /cobol/acucobol/f/forumid-20/352947/archive-acuxdbc-and-sql-server-linked-servers   

    /cobol/acucobol/w/wikiid-122/9693/accessing-an-acuxdbc-database-from-mssql-server

     

     

    A
    • Anonymous
    • March 22, 2021

    Does this help ... /cobol/acucobol/f/forumid-20/352947/archive-acuxdbc-and-sql-server-linked-servers   

    /cobol/acucobol/w/wikiid-122/9693/accessing-an-acuxdbc-database-from-mssql-server

     

     

    Thanks I had seen those links.

    I am getting the error below

     
     
    TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    The linked server has been created but failed a connection test. Do you want to keep the linked server?
    ------------------------------
    ADDITIONAL INFORMATION:
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    ------------------------------
    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "JR".
    OLE DB provider "MSDASQL" for linked server "JR" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
    OLE DB provider "MSDASQL" for linked server "JR" returned message "[TOD][ODBC Driver]connect: errno: 10061". (Microsoft SQL Server, Error: 7303)
    ------------------------------
    BUTTONS:
    &Yes
    &No
    ------------------------------
    Stephen Hjerpe
    • Stephen Hjerpe
    • Participating Frequently
    • March 22, 2021

    Thanks I had seen those links.

    I am getting the error below

     
     
    TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    The linked server has been created but failed a connection test. Do you want to keep the linked server?
    ------------------------------
    ADDITIONAL INFORMATION:
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    ------------------------------
    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "JR".
    OLE DB provider "MSDASQL" for linked server "JR" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
    OLE DB provider "MSDASQL" for linked server "JR" returned message "[TOD][ODBC Driver]connect: errno: 10061". (Microsoft SQL Server, Error: 7303)
    ------------------------------
    BUTTONS:
    &Yes
    &No
    ------------------------------

    Your - The PATH environmental variable holds the path C:\\Program Files (x86)\\Micro Focus\\Acucbl901\\AcuGT\\bin

    The PATH also needs to access C:\\Program Files (x86)\\Micro Focus\\Acucbl901\\AcuGT\\lib

    D

    Thanks I had seen those links.

    I am getting the error below

     
     
    TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    The linked server has been created but failed a connection test. Do you want to keep the linked server?
    ------------------------------
    ADDITIONAL INFORMATION:
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    ------------------------------
    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "JR".
    OLE DB provider "MSDASQL" for linked server "JR" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
    OLE DB provider "MSDASQL" for linked server "JR" returned message "[TOD][ODBC Driver]connect: errno: 10061". (Microsoft SQL Server, Error: 7303)
    ------------------------------
    BUTTONS:
    &Yes
    &No
    ------------------------------

    Hello Jimmyboy,

    I have attached a PDF document that I once made for a customer , he needed to create a 64 Bit Linked Server as he was Using 64 Bit AcuXDBC.

    SO please adjust everything to 32 bit where you see 64 bit and also of course the paths that often go to "Program files"   which should then be "Program Files (x86)"    etc.   
    Up to page 6 it's all about setting up AcuXDBC correctly (GENESIS_HOME,  AcuXDBC.CFG , the DSN, testing if its set up OK so you can for example get data via the DSN/System Catalog into excel)  then it goes into setting up and configuring the Linked Server.

    Perhaps this will help as the error message you posted was one that I also got when I hadn't  everything setup correctly.

    Have fun,

    Piet

     

    1 Attachments
    A
    • Anonymous
    • March 24, 2021

    Hello Jimmyboy,

    I have attached a PDF document that I once made for a customer , he needed to create a 64 Bit Linked Server as he was Using 64 Bit AcuXDBC.

    SO please adjust everything to 32 bit where you see 64 bit and also of course the paths that often go to "Program files"   which should then be "Program Files (x86)"    etc.   
    Up to page 6 it's all about setting up AcuXDBC correctly (GENESIS_HOME,  AcuXDBC.CFG , the DSN, testing if its set up OK so you can for example get data via the DSN/System Catalog into excel)  then it goes into setting up and configuring the Linked Server.

    Perhaps this will help as the error message you posted was one that I also got when I hadn't  everything setup correctly.

    Have fun,

    Piet

     

    Thanks, I will try these tips and get back.

     

    Jim

    A
    • Anonymous
    • April 1, 2021

    Hello Jimmyboy,

    I have attached a PDF document that I once made for a customer , he needed to create a 64 Bit Linked Server as he was Using 64 Bit AcuXDBC.

    SO please adjust everything to 32 bit where you see 64 bit and also of course the paths that often go to "Program files"   which should then be "Program Files (x86)"    etc.   
    Up to page 6 it's all about setting up AcuXDBC correctly (GENESIS_HOME,  AcuXDBC.CFG , the DSN, testing if its set up OK so you can for example get data via the DSN/System Catalog into excel)  then it goes into setting up and configuring the Linked Server.

    Perhaps this will help as the error message you posted was one that I also got when I hadn't  everything setup correctly.

    Have fun,

    Piet

     

    Thanks Piet, I shall try this today and get back to you.

    D

    Thanks Piet, I shall try this today and get back to you.

    I hope you got it working,

    Piet

    A
    • Anonymous
    • April 12, 2021

    I hope you got it working,

    Piet

    Hi Piet

    Unfortunately, not as yet.

     

    I am trying to get a 32 bit license for 10.3 AcuXDBC as I have been messing about with old versions.

    The MS SQL Server Management Studio  I have is 32 bit.  Therefore I believe I need to use ODBC Data Sources (32-bit) when creating the DSN

    I am setting up on a term server where different people log on with their own profiles.  I have ensured that the Environmental variables for GENESIS_HOME is in place as well as the  bin & lib, folder in the PATH

    Have been waiting on 32 bit license for nearly 3 weeks

     

     

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement