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
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
------------------------------
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
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
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
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.
Thanks Piet, I shall try this today and get back to you.
I hope you got it working,
Piet
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
