Oracle Database Discussions

Hi all,

I am working on 02 servers, Information on the servers are:

Server 1
- Operating system => Oracle Linux
- Database => Oracle 10g R2
- Database name => ORCL
- Server IP => 192.168.100.223



Server 2
- Operating System => Windows 2003
- Database => SQLserver 2008
- Database name => Northwind
- Server IP => 192.168.100.152

I have done successful configuration to possess hetrogeneous connectivity from Oracle to SQL server during which Oracle was installed on Windows XP machine as configuring ODBC was simple.

Now when I tried to do a testing where I have my Oracle installed on a Linux platform, I'm facing some problems.

I did the following configruation so far:
=> downloaded the ODBC driver for Linux and confgiured it.
=> Free TSD driver and confgured.


The following are my odbc configuration.

##### /etc/odbc.ini ######

[Northwind]
Description = MSSQL TEST
Driver = TDS
SERVER = 192.168.100.152
PORT = 1433
DATABASE = Northwind


##### /etc/odbcinst.ini #####
[Northwind]
Description = FreeTDS driver
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/local/lib/libtdsodbc.so
Trace = Yes
TraceFile = /tmp/freetds.log
FileUsage = 1


When I tried to connect to the sqlserver from the linux box I get the follwoing error message:

[root@lab01 etc]# isql -v Northwindsa
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect


Any help with the regard to the above problem, will be greatly appreciated...

Thanks in advance!!!
Best Regards,
Asif Muhammad