Hello:



I am trying link Oracle database with ASP page I am creating.  The code I

have written is as follows.



set myconn = Server.createobject("ADODB.connection")

		myconn.open "provider=msdaora;" &_

		"driver = {Microsfot ODBC for Oracle};" &_

		"server = case_dev;" &_

		"user_id=freelance;password=freelance;"



I tried several variation like "data source = case_dev"  instead of

"server = case_dev"



Everytime I get the following error message.



I am using Oracle version 7.3.4.3.0 and the instance name = case_dev.



Microsoft OLE DB Provider for Oracle error '80004005' 

ORA-03121: no interface driver connected - function not performed 



I checked the Oracle documentation for ORA-03121 which is as follows -



Cause

ORA-03121 no interface driver connected - function not performed

This message occurs usually because the SQL*Net driver is not loaded into

memory or there is a mismatch of the version of the driver. A user program

linked with an obsolete library may also cause this message. Only programs

provided by Oracle Corporation should use this interface.



Action

If the message occurred during use of a program provided by Oracle

Corporation, contact customer support. If a user program caused the

message, relink the program with current versions of the Oracle libraries.





I would appreciate if any of you can me help me out.



Thanks.

Sastry

ConnectionString = "Provider=MSDAORA.1;Password=freelance;User

ID=freelance;Data Source=case_dev;Locale Identifier=2057;Persist Security

Info=True;OLE DB Services=-1"



I assume that your case_dev is correctly declared in your TNSNAMES.ORA file.



Best regards / Cordialement

 

Stephane Dattenny

Dell Computers - EMEA IT - VB and Web developer

Phone: +33 (0)4 99 75 49 88 



 





-----Original Message-----

From: L. N. Sastry [mailto:lnsastry@h...]

Sent: 29 November 2000 08:25

To: ASP Databases

Subject: [asp_databases] Unable to connect to Oracle database





Hello:



I am trying link Oracle database with ASP page I am creating.  The code I

have written is as follows.



set myconn = Server.createobject("ADODB.connection")

		myconn.open "provider=msdaora;" &_

		"driver = {Microsfot ODBC for Oracle};" &_

		"server = case_dev;" &_

		"user_id=freelance;password=freelance;"



I tried several variation like "data source = case_dev"  instead of

"server = case_dev"



Everytime I get the following error message.



I am using Oracle version 7.3.4.3.0 and the instance name = case_dev.



Microsoft OLE DB Provider for Oracle error '80004005' 

ORA-03121: no interface driver connected - function not performed 



I checked the Oracle documentation for ORA-03121 which is as follows -



Cause

ORA-03121 no interface driver connected - function not performed

This message occurs usually because the SQL*Net driver is not loaded into

memory or there is a mismatch of the version of the driver. A user program

linked with an obsolete library may also cause this message. Only programs

provided by Oracle Corporation should use this interface.



Action

If the message occurred during use of a program provided by Oracle

Corporation, contact customer support. If a user program caused the

message, relink the program with current versions of the Oracle libraries.





I would appreciate if any of you can me help me out.



Thanks.

Sastry