-----------------------------------------------------------

New Message on MumbaiUserGroup

-----------------------------------------------------------
From: BusyWizy
Message 2 in Discussion


basically to access a database, u need a connection string which contains 
the relevant info. in case of a DSN, the relevent info is embedded in the 
DSN itself. if u don;t want to use a DSN, then simply create a 
connectionstring and assign it to your connection object.

eg: to pull data from a sql server database called northwind on a server 
called mySERVER, using a userid called sa whose password is also sa, i 
would form the following connection string

provided=SQLOLEDB.1;server=myserver;user id=sa;pwd=sa;initial catalog=northwind

hope that helps
nauzad kapadia [mvp]


>From: sachaa_premi
>Message 1 in Discussion
>
>Hi,
>I have to write an application using VC++, which pulls data from database
>without using DSN. I am required to use OLEDB to access db, of which i m
>unaware. Can anyone paste a code snippet showing how to open a connection
>and get data from one table. Please note that I m not using .Net.
>thanx,
>sanjeev




-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/mumbaiusergroup/_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]

Reply via email to