conjurer

Thanks John, its working perfect now :-)

Hi hrabia, I can use the same datasouce name to connect to the database from VB 6 using ADO so I guess the datasource name isn't the culprit. Any other suggestions. Thanks.

Hi, I need to connect to an Oracle 9i Database from ASP.NET. Although I can connect to the Oracle Database through SQL*Plus. I have downloaded and installed the latest Oracle ODBC drivers for 9.01 from Oracle's website and it didnt help. Also I installed Microsoft .NET Oracle Client and it produced the same results. I have included the following namespaces and am using the following connection string to connect to Oracle - <%@ Page Language="VB" Debug="true" Trace="true" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.OleDB" %> szConStr = "Provider=OraOLEDB.Oracle;Data Source=abc; User ID=xyz; Password=xyz123;" In ASP.NET however I get the following error - ORA-12154: TNS:could not resolve service name Stack Trace: [OleDbException (0x80004005): ORA-12154: TNS:could not resolve service name] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 ASP.G3_ASPX.Page_Load(Object Sender, EventArgs E) in D:\timesheet\ts04\g3.aspx:50 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +725 What could be wrong. Please suggest. Thanks.