We take growing businesses and organizations to new heights with our systems. As per shaneymc 4. The feedback you provide will help us show you more relevant content in the future. Sign Up at analytics. How do I convert access database.

Uploader: Mikagor
Date Added: 18 February 2009
File Size: 10.1 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 52134
Price: Free* [*Free Regsitration Required]

Get mentored online and become a business analyst. How do I copy a table ocbc one server database to another server database in a different location in SQL? Promoting, selling, recruiting, coursework and thesis posting is forbidden.

As per shaneymc 4. Avxya of our groups uses it to access the Informix tables directly. Then it will use whatever connection information provided in the linked server one sets up mapping to same Windows user for pass-through security or using a specific username and password, etc. One of the place i worked had a shadow reporting server where the reporting dept could work off, leaving the cms server alone D.

SO, with all that said: Close this window and log in.

CMS: ODBC connection failure with CMS

You dismissed this ad. One test using a query tool may indicate that one can connect, but then it fails from the linked server connection.

Related Drivers  SPVD 012 DRIVERS FOR WINDOWS 7

How do I convert access database. Reading the documentation it looks like they would need the appropriate DSN for our system which I don’t know what it would bea user name and password. I’ve read the Database Connectivity documents but I’m not completely clear as to how the tables are accessed. Red Flag This Post Please let us know here why this post is inappropriate. How do I determine the DSN?

I don’t know why, or where permissions would have to change. I also verified it’s running on our CMS.

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. I don’t understand how they access it though.

Students Click Here Join Us! Sorry for the oxbc post, but this is an area of CMS that I am really lost. Ask New Question Sign In.

Still have a question? The first issue is bit vs bit ODBC drivers, query tools, etc. How do I connect to another SQL server?

How to connect an SQL server to Avaya CMS Database – Quora

The feedback you provide will help us show you more relevant content in the future. I’ve been told it’s because it logs in differently and can be found in a different system log. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.


He has rights in CMS to view just about everything report and dictionary related. Where is this log and what are they logging into? I have another user who would like to access these tables, he can get logged in, but he’s denied the ability to look dobc the tables.

Thank you for helping keep Tek-Tips Forums free from inappropriate posts. Looking for a Cloud ERP solution for your business?

The installed broker is not multitiered so you only have the basic windows or Solaris odbc connection, i. If you have existing linked server connections on your MS SQL Server, you can look at them from this system stored procedure: What log would show users logging in and accessing the Informix tables?