Re: connection string to DB

For the microsoft oleDB provider I use the following connection string, Provider=MSDAORA.1; Password=[Password]; User ID=[User ID];Data Source=[Database];Persist Security Info=True

For the microsoft oLE provider for ODBC
Provider=MSDASQL.1;Persist security Info=False;User Id=[User id];Data Source=[Database];Extended Properties="DSN=[DSN];UID=[User ID];server=[Server];"

hope this helps ..

X




------------------------
 "Oracle" <[email protected]> wrote:
------------------------
	
>HI THERE,
>does any body know how to write the connection string to an oracle data base on another pc
>through the Microsoft OLE provider for ODBC drivers or
>oracle provider for OLE DB
>i tried this one 
>Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=maximo;Password=maximo;Data Source=maxdemo;but an ora error null password login is denied
>so if anyone know about this send me plz
>thanks
>lamiaMSN 8 helps eliminate e-mail viruses.  Get 2 months FREE*. 
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or 
>to unsubscribe send a blank email to %%email.unsub%%.
>



---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].