If you cant figure it out, post some sample of your code. Hi, im trying to connect to our new 9i database, i have the correct entry in tnsnames. Hi all, i try to get an oci connect to my oracle 9i db with my jclient application. I install phpbb forum and, when i try to connect to db i found this error. Cant connect to remote oracle db with rubyoci8, ora. This usually means that the command syntax is incorrect. As i wrote, i do not intend to install a oracle client on the pcs if i can avoid it. Invalid driver designator using sqlplus, my connection works fine. Please try this patch against trunk and let me know if it works for you. Apparently oracle 8 does not recognize this connect string. Desperate for guidance, i lurked at toras community forum looking for one.
Do you know what could be a reason of such behaviour. I am trying to deploy a ejb cmp and i am getting the following error when i use oci8 drivers. Cant connect to remote oracle db with rubyoci8, ora06401. The oracle instant client is installed and i tried both 32 and 64 bits versions. Workflow builder cannot connect to database, ora12154 workflow builder cannot connect to database, ora12154 doc id 435755. This prompted the computer to return an invalid version 1 error, ora06401. Im trying to get an oracle db with excel power query and im getting this error. Connecting using jdbc oci driver fails with ora06401 doc id 164541. The schema used will be the default schema for the user scott. There was no default host string specified in the configuration and the user did not specify any explicit connect string. Seeing the first character of m after the alias somehow made sqlnet think it had an invalid protocol selection for a version 1 connect string. Connecting using jdbc oci driver fails with ora06401.
This can be generated by the oracle database when running any oracle program. Discussion forums for open issues and questions concerning database tools, data access components and developer tools from devart. Windows interface for oracle was not installed on client machine. So, look carefully at your connect string, and figure out where you went wrong. Hi kartik, the following links may be able to provide some insight for this issue. In the administration console, go to the connections tab edit the connection and update the data access properties section connection string with a valid entry from the tnsnames. Oracle database 11gr2 error code ora06401 description netcmn.
Workflow builder cannot connect to database, ora12154. Use of the oci driver should simply involve a changing thin to oci in the url string. I dont get the error when i change the driver to thin. There is no problems connection to this database directly from toads connection window. There was no default host string specified in the configuration and the user didnt specify any explicit connect string. While fetching data using dblink, i am getting the error, ora 06401. Ora 06401 invalid driver designator stack overflow. Squirrel which is a java application using swing too. The login connect string contains an invalid driver designator. I found a number of questions from people who apparently have the same problem as mine. Maybe not a solution, but this turned up when i ran oerr. Here we define a datasource called myoracle using the thin driver to connect as user scott, password tiger to the sid called mysid.
Detailed error ora06401 cause information and suggestions for actions. Export terminated unsuccessfully yet if i do this command from a different server with the oracle 9i software installed the command works. Either reconfigure the system specifying a default connect string or use an explicit connect string. This feature is that all the available jdbc drivers that announce. Also for some reason, it only affected connection attempts using a database link.
1600 501 1251 799 1393 301 1542 1260 701 198 220 171 982 1528 1350 500 1630 988 245 390 478 168 875 83 278 1269 146 150 509 865 481