Connecting Forms 6i to MS SQL Server
393550Apr 30 2003 — edited Apr 30 2003Dear friends,
I am really struggling to solve this connection issue. I am working with forms 6i, oracle 8i, in Windows 2000 professional environment. Developing programs using oracle 8i tables is ok, but I want to connect to SQL Server 2000 and MS Access also, as I want my application to run on any of the back end databases. The things I have done are
- I have already tables in MS SQL Server database.
- I Installed ODBC for Microsoft and Oracle. I am able to connect to SQL Sever database using SQL Plus from Oracle ODBC, with the following string
USERNAME/PASSWORD@ODBC:<DSN NAME>:<DATABASE NAME>
- I also installed OCA for developer from the CD.
I have followed the instructions in Developer Help menu and I was able to connect through SQL Plus, although it gives some error message while connecting and also while disconnecting. But I am not able to connect the same through Forms 6i. While using the same connect string with Forms 6i, gives an unknown error 'I'. I will appreciate if anyone provide me some tips. Thanks in advance.
Best Regards
Amit Tamrakar