----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: venkat_kl Message 2 in Discussion hi, If you have used ODBC DSN, then go and create DSN for Oracle. Before this you better install MDAC in all your Machines Using an ODBC DSN (Data Source Name) is a two step process. 1) You must first create the DSN via the "ODBC Data Source Administrator" program found in your computer's Control Panel (or Administrative Tools menu in Windows 2000). Make sure to create a SYSTEM DSN (not a USER DSN) when using ASP. You can also create the DSN via Visual Basic code. 2) Then use the following connection string - with your own DSN name of course. DSN oConn.Open "DSN=mySystemDSN;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" File DSN oConn.Open "FILEDSN=c:\somepath\mydb.dsn;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" Download MDAC from here http://www.microsoft.com/downloads/details.aspx?familyid=6A7D785F-C2E0-471D-A33B-82AD1D514737&displaylang=en Also see this http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconAboutODBCDataSources.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/achowStartODBCManager.asp bye venkat_kl ----------------------------------------------------------- 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]
