|
 |
asp_databases thread: Connecting to oracle
Message #1 by arshad siddiqui <ash_arshad@y...> on Tue, 28 Jan 2003 05:23:29 -0800 (PST)
|
|
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
Message #2 by Greg Griffiths <greg2@s...> on Tue, 28 Jan 2003 19:58:47 +0000
|
|
You'll need to install an Oracle Client on the server you are running the
ASP on, this will then allow you to create an ODBC connection, Oracle also
provide a cool ODBC Test tool as well.
At 05:23 28/01/03 -0800, 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
>
Message #3 by Nikos <pappas@c...> on Tue, 28 Jan 2003 23:34:20 +0200
|
|
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
>
Message #4 by avishkar meshram <avishkarm@y...> on Wed, 29 Jan 2003 04:51:54 -0800 (PST)
|
|
Try this
'Using DSN connection
connection ="DSN=DSNName;Provider=MSDASQL;UID=username ;PWD=password;"
'With an ODBC connection,Connecting to database
set conn=Server.CreateObject("ADODB.Connection") conn.Open(connection)
'Creating ADO recordset set rs=Server.CreateObject("ADODB.recordset")
rs.Open sqlstring,conn
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Message #5 by arshad siddiqui <ash_arshad@y...> on Wed, 29 Jan 2003 05:35:17 -0800 (PST)
|
|
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
Message #6 by arshad siddiqui <ash_arshad@y...> on Wed, 29 Jan 2003 05:36:52 -0800 (PST)
|
|
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.
Please can you give me some example for this.
I made a DSN also but no use
Thank you
Best regards
--Arshad--
--- Greg Griffiths <greg2@s...> wrote:
> You'll need to install an Oracle Client on the
> server you are running the
> ASP on, this will then allow you to create an ODBC
> connection, Oracle also
> provide a cool ODBC Test tool as well.
>
> At 05:23 28/01/03 -0800, 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
Message #7 by Nikos <pappas@c...> on Thu, 30 Jan 2003 01:36:46 +0200
|
|
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
>
|
|
|
View Cart
