----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Ritesh_Kesharwani Message 4 in Discussion Hi See their is two type of connection string first use for Oracle connectivity and other for SQL Server connectivity.. for Oracle Data Source and Provider is require for connection but in SQL server insead of Provider you have to mention Initial Catalog and Data Source in connection string and Persist Security Info we can write in both string bcos if this is false then server can not Persist the use authentication information like user id and password it will return default userid and password insead of actual. "Value="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=da;Data Source=orcl;password=da;" "Value="User ID=XYZ_admin;password=appadm13;Initial Catalog=database_name;Data Source=SGNPSA02" Regard's Ritesh Kesharwani SQL Star Intlernational Ltd. [EMAIL PROTECTED] [EMAIL PROTECTED] www.Riteshk.blogspot.com Cell - 9849976150 ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
