p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   database problem (http://p2p.wrox.com/showthread.php?t=16620)

prasadp August 9th, 2004 12:30 PM

database problem

I am trying to give a connection string to get the records from the oracle9i database. I have put my database in useraccount scott. When i try to retrieve record through this code it is troubling me. Can anybody help? Thanks in advance.

Public con As adodb.connection
Public Sub connection()
Set con = New adodb.connection
con.Open = "Provider=MSDAORA.1;User ID=scott; Persist Security Info=False"
End Sub

gokul_blr September 10th, 2004 02:07 AM

 OLE DB, OleDbConnection (.NET)

 Standard security:

"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
 Standard Security:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"

 Trusted Connection:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"

All times are GMT -4. The time now is 08:55 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.