Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_beginners thread: how to connect to oracle?


Message #1 by "Li, Xing" <xli@l...> on Tue, 30 Jul 2002 17:07:09 -0700
Anyone can show me the connectionString to Oracle database in asp.net
page?
I do not have any problem to connect to Oracle database in ASP page
using ADO and the connection string I used is the following:
"Provider=3DMSDAORA; Data Source=3DdsName; User ID=3Dscott; 
Password=3Dtiger"
However, when use the same connection string in ASP.NET page. It does
not work. Help! Please!

XingLi



Message #2 by "bclegg" <bclegg@a...> on Wed, 31 Jul 2002 13:29:51 +1200
Hi,
try
Provider=MSDASQL.1;Password=password;Persist Security Info=True;User
ID=YourUser;Data Source=yourDSN
regards
Bob


-----Original Message-----
From: Li, Xing [mailto:xli@l...]
Sent: Wednesday, 31 July 2002 12:07 p.m.
To: aspx_beginners
Subject: [aspx_beginners] how to connect to oracle?


Anyone can show me the connectionString to Oracle database in asp.net
page?
I do not have any problem to connect to Oracle database in ASP page
using ADO and the connection string I used is the following:
"Provider=MSDAORA; Data Source=dsName; User ID=scott; Password=tiger"
However, when use the same connection string in ASP.NET page. It does
not work. Help! Please!

XingLi





Message #3 by Simon Hargreaves <Simon.Hargreaves@c...> on Wed, 31 Jul 2002 09:23:58 +0100
Are you creating a dataset and then binding your controls/page to it ?

this is rather different to a recordset in ADO (Classic)

If you aren't, reply to me and I'll send you some code.

Sam

-----Original Message-----
From: Li, Xing [mailto:xli@l...]
Sent: 31 July 2002 01:07
To: aspx_beginners
Subject: [aspx_beginners] how to connect to oracle?


Anyone can show me the connectionString to Oracle database in asp.net
page? 
I do not have any problem to connect to Oracle database in ASP page
using ADO and the connection string I used is the following:
"Provider=MSDAORA; Data Source=dsName; User ID=scott; Password=tiger" 
However, when use the same connection string in ASP.NET page. It does
not work. Help! Please!

XingLi




Message #4 by "Li, Xing" <xli@l...> on Wed, 31 Jul 2002 09:16:32 -0700
Sam,

Thanks for all the people trying to help me.
Yes, I am creating a dataset and then bind it to the server control.

Thanks!

XingLi


-----Original Message-----
From: Simon Hargreaves [mailto:Simon.Hargreaves@c...]
Sent: Wednesday, July 31, 2002 1:24 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: how to connect to oracle?

Are you creating a dataset and then binding your controls/page to it ?

this is rather different to a recordset in ADO (Classic)

If you aren't, reply to me and I'll send you some code.

Sam

-----Original Message-----
From: Li, Xing [mailto:xli@l...]
Sent: 31 July 2002 01:07
To: aspx_beginners
Subject: [aspx_beginners] how to connect to oracle?


Anyone can show me the connectionString to Oracle database in asp.net
page?
I do not have any problem to connect to Oracle database in ASP page
using ADO and the connection string I used is the following:
"Provider=3DMSDAORA; Data Source=3DdsName; User ID=3Dscott; 
Password=3Dtiger"
However, when use the same connection string in ASP.NET page. It does
not work. Help! Please!

XingLi








  Return to Index