I am having a Windows NT server with Personal Oracle 8 running on it. On the same machine I have Visual Interdev and Crystal report installed.
The web server(IIS) also resides on the same NT machine.
1. My First problem is that I am unable to run Oracle Net8 EasyConfig. Whenever I starts the same, I get a Dr. Watson for Windows NT error and the application closes. I reinstalled Oracle, but the problem was not solved.
2.The second problem follows:
With Oracle 8 odbc driver if I create a DSN it works fine with the ODBC test.Since I am having Personal Oracle in the same machine, while creating the DSN I have kept the Service name blank.
But when I use that DSN to make a project on Visual Interdev and try to acces those pages(which initiates data connection ), I am getting an error" Microsoft OLE DB Provider for ODBC Drivers error'8004005'[Microsoft][ODBC Driver Manager]
Data Source name not found and no default driver specified".
Sometimes I get an error against that same '800045':"error, Unable to create file buffer".
I have found that Pesonal Oracle8 odbc does not support userid@connect_string format. Can that be a problem? Because most Microsoft products probably creates the connection string in that format, while connecting to databases.
Another astonising thing is that ,I am able to connect to the same database from remote machine using Oracle 7.3 odbc driver and Visual Interdev is working fine.
The similar problem I am facing when trying to run crystal report from the same machine and trying to connect the database.