|
 |
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
|
|
 |