I'm using asp.net and oracle 9i. so, after masukkan all the needed coding (connectionstring bla bla bla..) this is what I got when I try to launch my webpage:

"Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed."

what's wrong aaa...???!!



tq

Helo,

I think that there is a problem with your Oracle configuration or setup, because if you get that message, the ASP.net page has tried to connect to the Oracle DB meaning that ASP.net and the connection to the DB is working fine. But you can try double checking the connection string in the ASP.net page.


Using MSDAORA

--- Code Starts ---

"Provider=MSDAORA;Data Source=db.server.com;User ID=me; Password=pass";

--- Code Ends ---

Or

Using OraOLEDB.Oracle as a provider:

--- Code Starts ---

"Provider=OraOLEDB.Oracle;Data Source=db.server.com;User ID=me; Password=pass";

--- Code Ends ---

Make sure that you have entry for the data source in tnsnames.ora file and TNSListener service is running. For more information on OraOLEDB provider refer to Orcale9i documentation.

bandit,

selain daripada langkah yang kawan - kawan lain telah tunjukkan tadi, cuba ..

- dlm windows98/95 -

cuba cari fail autoexec.bat

di antara kandungan dlm autoexec.bat tu (sebagai contoh - tengok balik autoexec.bat. setiap pc kebanyakannya berbeza.)

PATH=%PATH%;D:\ORAWIN95\BIN;"d:\Mts";

tukarkan kepada :-

PATH=%PATH%;"d:\Mts";D:\ORAWIN95\BIN;

dan sebaliknya.

- dlm winxp -

kalau ada fail autoexec.bat yang macam kat atas tadi, ikut langkah tadi.

- dlm platform windows lain aku rasa tak de masalah -

nak tau berjaya atau tidak (cara mudah).

1. pergi ke odbc datasource administrator.
2. tambah datasource baru (pada user dsn boleh, pada system dsn boleh. mana - mana. ikut suka)
3. pilih jenis microsoft odbc for oracle. kalau keluar kotak untuk diisi datasource baru. bermakna cara tadi sudah dikira berjaya.

masalahnya saya guna oracle v7.3.4.1. bolehlah cuba cara yang diterangkan tadi.

semoga cara ini dapat membantu.