Help Establishing ODBC

[rmscho02]

Hey everyone, I don't have any experience with Nortel ACD but I just took over someone's role and now I have to figure out how to report from ACD. I've been using article 1263747 on this site to configure the ODBC connection but it's not working for me. I'm hoping someone can provide some insight. Here's what I've got so far:

I'm trying to connect from a remote server (call it SAM) to the ACD database. I can successfully ping the IP address (call it MAC). Sybase was installed on SAM and I used dsedit to create a new entry, but I can't get the test connection to be successful. I asked our server guy to send me the sql.ini files on MAC and he said there wasn't any C:\...Nortel folder. He did find the following:

D:\sybase\ini\sql.ini
D:\sybase\OCS-12_5\sample\xa-dtm\tuxedo\rentapp\sql.ini.

He sent me the first file, which looks like the one I want, but it doesn't have any ICCM_PREVIEW entries in it. Is that my problem? Everything in the article I referenced above talks as if the ICCM_PREVIEW should already exist as needed, but I can't find it.

Let me know what else you may need to know, and thanks a bunch for any help!

 

[mdixon2]

Not sure about the ODBC configuration, however if you have a MS Sql Server database available [call it MSS], you should be able to set up a linked server from MSS to SAM using the OLEDB driver.

(**Note, however that you might need to contact Sybase or Microsoft for an OLEDB driver compatible with your Sybase DB version. The install for this should include a program to create a "link file" with configuration information to connect to your SAM.)

Then you would be able to use your MSS as the "report source" to query the corresponding Sybase tables.

In Sql Server 2000 [yes, it's been awhile], connect using Enterprise Manager, expand the Security node, then right-click the Linked Servers node and select New Linked Server.

Enter the name to use for this link --ex: SYBASELINK.
**In the provider drop-down select the Sybase-OLEBD provider.
Enter the link file created above as the Data Source.

On the security tab, select "Be made using this security context" and enter a valid username and password with rights to access the data you need to report on.

From MSS you would write your selects using...

Select this, that from SYBASELINK.databasename.dbo.tablename

 

[effort1584]

In DSEdit can you ping the MAC server? Remember in sybase ODBC they use port 5000. So where you have the ip address for MAC it should be IP,5000 (ex. 192.168.1.12,5000).

You only have ICCM_Preview if the full client is installed (old process). Don't worry about that.

DSEdit and ODBC Datasoure (Windows in Administrative tools) are the only pieces you need.