Hi,
Thanks for your help.Now I am able to connect to the
Oracle database.
I have one more question?
I want to give the username,password and TSN in a text
file and want the ASP page to read all these things
from the text file and then connect to the Oracle
database.If the username,password and TSN matches with
that of database then it should connect to database
otherwise it should give a message "Cannot connect to
database.After this test is done then only the ASP
should access the table and matches the username and
password i.e in the table.
The whole concept is that first it should check for
the username and password for the Oracle
database(which is in the text file) and after that it
should check for the username and password applied in
the text boxes(which is given in the table).

Thank you
Best Regards
--Arshad--





--- Nikos <pappas@c...> wrote:
> In the link I have send you will find many examples.
> This is from this site.
>
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
> 
>                ODBC Driver for Oracle (from
> Microsoft)
>              For the current Oracle ODBC Driver from
> Microsoft
> oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
>             "Server=OracleServer.world;" & _
>             "Uid=myUsername;" & _
>             "Pwd=myPassword"
> 
>              For the older Oracle ODBC Driver from
> Microsoft
> oConn.Open "Driver={Microsoft ODBC Driver for
> Oracle};" & _
>             "ConnectString=OracleServer.world;" & _
>             "Uid=myUsername;" & _
>             "Pwd=myPassword"
>              For more information, see:  Connection
> String Format and 
> Attributes
>              To view Microsoft KB articles related
> to Microsoft ODBC for 
> Oracle,
>              click here
> 
>                ODBC Driver for Oracle (from Oracle)
> oConn.Open "Driver={Oracle ODBC Driver};" & _
>             "Dbq=myDBName;" & _
>             "Uid=myUsername;" & _
>             "Pwd=myPassword"
>              Where:  The DBQ name must be defined in
> the tnsnames.ora file
>              For more information, see:  Oracle8
> ODBC Driver Help, Oracle ODBC
>              FAQs, [asporacle] listserv FAQs, and
> ASPDB Oracle
> 
>
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
> 
> At 15:35 29/01/2003, you wrote:
> >Hi,
> >
> >Thanks for your reply.
> >I know how to connect to connect to Access and sql
> >server databse but connecting to Oracle database is
> a
> >problem.I tried so many ways to connect to it but
> of
> >no use.
> >Its saying no data source name found.
> >Pleas can you give me some example for this.
> >I made a DSN also but no use
> >
> >Thank you
> >Best regards
> >--Arshad--
> >
> >--- Nikos <pappas@c...> wrote:
> > > http://www.able-consulting.com
> > >
> > >
> > > At 15:23 28/01/2003, you wrote:
> > > >Hi,
> > > >Can any one tell me how to connect to an oracle
> > > >database.The database is residing on a server.I
> am
> > > >trying it thourh DSN but always giving the
> > > following
> > > >error:
> > > >"Data source name not found and no default
> driver
> > > >specified"
> > > >I am using the following code:
> > > >
> > > >conCurrent.Open "DSN = metro; UID = test; PWD 
> > > test;"
> > > >
> > > >Please help
> > > >Regards
> > > >--Arshad--
> > > >
> > >
> >__________________________________________________
> > > >Do you Yahoo!?
> > > >Yahoo! Mail Plus - Powerful. Affordable. Sign
> up
> > > now.
> > > >http://mailplus.yahoo.com
> > > >
> > >
> > >
> > >
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> >http://mailplus.yahoo.com
> >
> 
> 
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

I guess others will be able to provide better help on that
I don't know if this is a good idea anyway.

You have to use file system object to get what you need from the file
but I can't suggest a good solution as I am not too experienced.
It just doesn't seems to be a safe solution.
If someone gains access to this text file?
What is the problem if you store the info in the database?

Any way I am happy the link was helpful
http://www.able-consulting.com was a great help for beginners like me.

best regards

Nikos


At 14:43 02/02/2003, you wrote:
>Hi,
>Thanks for your help.Now I am able to connect to the
>Oracle database.
>I have one more question?
>I want to give the username,password and TSN in a text
>file and want the ASP page to read all these things
>from the text file and then connect to the Oracle
>database.If the username,password and TSN matches with
>that of database then it should connect to database
>otherwise it should give a message "Cannot connect to
>database.After this test is done then only the ASP
>should access the table and matches the username and
>password i.e in the table.
>The whole concept is that first it should check for
>the username and password for the Oracle
>database(which is in the text file) and after that it
>should check for the username and password applied in
>the text boxes(which is given in the table).
>
>Thank you
>Best Regards
>--Arshad--
>
>
>
>
>
>--- Nikos <pappas@c...> wrote:
> > In the link I have send you will find many examples.
> > This is from this site.
> >
>"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
> >
> >                ODBC Driver for Oracle (from
> > Microsoft)
> >              For the current Oracle ODBC Driver from
> > Microsoft
> > oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
> >             "Server=OracleServer.world;" & _
> >             "Uid=myUsername;" & _
> >             "Pwd=myPassword"
> >
> >              For the older Oracle ODBC Driver from
> > Microsoft
> > oConn.Open "Driver={Microsoft ODBC Driver for
> > Oracle};" & _
> >             "ConnectString=OracleServer.world;" & _
> >             "Uid=myUsername;" & _
> >             "Pwd=myPassword"
> >              For more information, see:  Connection
> > String Format and
> > Attributes
> >              To view Microsoft KB articles related
> > to Microsoft ODBC for
> > Oracle,
> >              click here
> >
> >                ODBC Driver for Oracle (from Oracle)
> > oConn.Open "Driver={Oracle ODBC Driver};" & _
> >             "Dbq=myDBName;" & _
> >             "Uid=myUsername;" & _
> >             "Pwd=myPassword"
> >              Where:  The DBQ name must be defined in
> > the tnsnames.ora file
> >              For more information, see:  Oracle8
> > ODBC Driver Help, Oracle ODBC
> >              FAQs, [asporacle] listserv FAQs, and
> > ASPDB Oracle
> >
> >
>"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
> >
> > At 15:35 29/01/2003, you wrote:
> > >Hi,
> > >
> > >Thanks for your reply.
> > >I know how to connect to connect to Access and sql
> > >server databse but connecting to Oracle database is
> > a
> > >problem.I tried so many ways to connect to it but
> > of
> > >no use.
> > >Its saying no data source name found.
> > >Pleas can you give me some example for this.
> > >I made a DSN also but no use
> > >
> > >Thank you
> > >Best regards
> > >--Arshad--
> > >
> > >--- Nikos <pappas@c...> wrote:
> > > > http://www.able-consulting.com
> > > >
> > > >
> > > > At 15:23 28/01/2003, you wrote:
> > > > >Hi,
> > > > >Can any one tell me how to connect to an oracle
> > > > >database.The database is residing on a server.I
> > am
> > > > >trying it thourh DSN but always giving the
> > > > following
> > > > >error:
> > > > >"Data source name not found and no default
> > driver
> > > > >specified"
> > > > >I am using the following code:
> > > > >
> > > > >conCurrent.Open "DSN = metro; UID = test; PWD 
> > > > test;"
> > > > >
> > > > >Please help
> > > > >Regards
> > > > >--Arshad--
> > > > >
> > > >
> > >__________________________________________________
> > > > >Do you Yahoo!?
> > > > >Yahoo! Mail Plus - Powerful. Affordable. Sign
> > up
> > > > now.
> > > > >http://mailplus.yahoo.com
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >__________________________________________________
> > >Do you Yahoo!?
> > >Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > now.
> > >http://mailplus.yahoo.com
> > >
> >
> >
> >
>
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>