Skip to main content

[archive] AcuXDBC and SQL server linked servers

  • December 17, 2009
  • 15 replies
  • 0 views

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?

15 replies

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Yes, I have successfully created a Microsoft SQL Server linked server with an AcuXDBC DSN. After installing AcuXDBC and ensuring the environment is set correctly (GENESIS_HOME and PATH) the MS SQL Server must be restarted so it will pick up the new settings. Then create the linked server and you're off and running.

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Our setup is SQL on windows and the vision data is on AIX. Is this what you have as well?

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Our setup is SQL on windows and the vision data is on AIX. Is this what you have as well?

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Our setup is SQL on windows and the vision data is on AIX. Is this what you have as well?

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Hi Mike,

Yes, I've configured and run a MSSQL Linked Server with the data and AcuXDBC Server on a separate server (although I think I used a Linux box).

Most of the work is on the server. You'll install AcuXDBC Server, configure it, build the system catalog (or copy one if you already have it), and then start the AcuXDBC server.

After that you'll set up an AcuXDBC client DSN on the Windows Server where MSSQL is running. Do that by checking the "Network Driver" item and specifying the server name (or IP address), the port number, the name of the configuration file on the server, and the Username and Password.

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
I'm having problems trying to link I got the following error:

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ACUXDBC"
OLE DB provider "MSDASQL" for linked server "ACUXDBC" returned message "[Miscrosoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "ACUXDBC" returned message "[TOD][ODBC Driver]DLLLOAD:acuxbdc03, The specified could not be found.
".(Microsoft SQL Server, Error:7303)

When I created the linked server my parameters were:

Linked Server: AcuXDBC
Other data source
Provider: Microsoft OLE DB Provider for ODBC Drivers
Product Name: AcuXDBC
Data Source: AcuXDBC
Provider string: blank
Location: blank
Catalog: blank


The ODBC was created as a system DNS it works great with excel or Crystal Reports as AcuXDBC.

Please help me.

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Your Linked Server setup looks correct.

The real issue is identified in this error:

[TOD][ODBC Driver]DLLLOAD:acuxbdc03, The specified module could not be found.

The acuxdbc03.dll is the client piece so I assume the DSN has been set up as a network connection and AcuxDBC Server is running on a separate server.

Your Excel and Crystal Reports connections to the same DSN work so it is set up correctly.

However, in this case with the Linked server the acuxdbc03.dll cannot be found or the security settings are preventing it from being loaded.

I think to resolve this you need to look at two things.

Has MSSQL Server been restarted since installing AcuXDBC?

Does the user account that is logging in to the MSSQL Management Console have sufficient privilege to access the acuxdbc03.dll?

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Your Linked Server setup looks correct.

The real issue is identified in this error:

[TOD][ODBC Driver]DLLLOAD:acuxbdc03, The specified module could not be found.

The acuxdbc03.dll is the client piece so I assume the DSN has been set up as a network connection and AcuxDBC Server is running on a separate server.

Your Excel and Crystal Reports connections to the same DSN work so it is set up correctly.

However, in this case with the Linked server the acuxdbc03.dll cannot be found or the security settings are preventing it from being loaded.

I think to resolve this you need to look at two things.

Has MSSQL Server been restarted since installing AcuXDBC?

Does the user account that is logging in to the MSSQL Management Console have sufficient privilege to access the acuxdbc03.dll?

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Your Linked Server setup looks correct.

The real issue is identified in this error:

[TOD][ODBC Driver]DLLLOAD:acuxbdc03, The specified module could not be found.

The acuxdbc03.dll is the client piece so I assume the DSN has been set up as a network connection and AcuxDBC Server is running on a separate server.

Your Excel and Crystal Reports connections to the same DSN work so it is set up correctly.

However, in this case with the Linked server the acuxdbc03.dll cannot be found or the security settings are preventing it from being loaded.

I think to resolve this you need to look at two things.

Has MSSQL Server been restarted since installing AcuXDBC?

Does the user account that is logging in to the MSSQL Management Console have sufficient privilege to access the acuxdbc03.dll?

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Thank you for your reply.

After I restarted SQL Server I was able to link the server.

Now I can see the tables, but how I can make a query?

When I made a right click in my table --> Script Table as --> Select to --> New Query Editor Window

I got the following message:

-- [ACUXDBC]..[PUBLIC].[CUS10010] contains no columns that can be selected or the current user does not have permissions on that object.
GO

Thank you again for your help.

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Paul, it's great that you've got the linked server set up successfully. Now, to get to your data use the openquery method. A simple select will look something like:

select * from openquery(LinkedServerName,'select * from tablename')

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
You have to use the OPENQUERY syntax:

select * from OPENQUERY (LINKED-SERVER-NAME, 'select * from TABLENAME')

One important note is that if you want to update or insert a new record the table you will need AcuXDBC 8.1.1 or later as there was an issue with versions older than that caused errors when trying to update a table when using AcuXDBC as a linked server.

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
You have to use the OPENQUERY syntax:

select * from OPENQUERY (LINKED-SERVER-NAME, 'select * from TABLENAME')

One important note is that if you want to update or insert a new record the table you will need AcuXDBC 8.1.1 or later as there was an issue with versions older than that caused errors when trying to update a table when using AcuXDBC as a linked server.

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
You have to use the OPENQUERY syntax:

select * from OPENQUERY (LINKED-SERVER-NAME, 'select * from TABLENAME')

One important note is that if you want to update or insert a new record the table you will need AcuXDBC 8.1.1 or later as there was an issue with versions older than that caused errors when trying to update a table when using AcuXDBC as a linked server.

[Migrated content. Thread originally posted on 11 December 2009]

Has anyone ever created linked server (MSSQL Server) using XDBC?
Thank you very much for your help.

It works.

I was able to use the following syntax too:

select * from [ACUXDBC]..[PUBLIC].

Regards