[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?
[archive] AcuXDBC and SQL server linked servers
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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.
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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.
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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?
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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?
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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?
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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.
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?select * from openquery(LinkedServerName,'select * from tablename')
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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.
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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.
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?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.
- Rocketeer
[Migrated content. Thread originally posted on 11 December 2009]
Has anyone ever created linked server (MSSQL Server) using XDBC?It works.
I was able to use the following syntax too:
select * from [ACUXDBC]..[PUBLIC].
Recent badge winners
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
