activex_data_objects thread: Help connecting to local database via ADO
Message #1 by "Greg Pearson" <jagged30net@n...> on Tue, 5 Mar 2002 20:02:13
|
|
I can not seem to find a code example to connect to a local database - on
my hard drive - via ADO. I do not want to set up an ODBC data source for
this particular app.
Message #2 by "Pete Davis" <pdavis@q...> on Tue, 5 Mar 2002 14:59:19 -0500
|
|
What kind of database do you want to connect to? The connect string is
dependent on the database, as different databases have different parameters.
The following sample connect string will connect to an MS-SQL Server
database:
Provider=MSDASQL;Driver={SQL
Server};UID=sa;PWD=MyPassword;Server=MyServer;Database=MyDatabase
Pete
----- Original Message -----
From: "Greg Pearson" <jagged30net@n...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Tuesday, March 05, 2002 8:02 PM
Subject: [activex_data_objects] Help connecting to local database via ADO
> I can not seem to find a code example to connect to a local database - on
> my hard drive - via ADO. I do not want to set up an ODBC data source for
> this particular app.
$subst('Email.Unsub').
Message #3 by venkat kl <venkat_kl@y...> on Tue, 5 Mar 2002 21:01:11 -0800 (PST)
|
|
Hi,
Tell me about yourself, place,job, etc & also your
problem of not able to get the code to connect to the
database. I will help u out
bye
venkat..
--- Greg Pearson <jagged30net@n...> wrote:
> I can not seem to find a code example to connect to
> a local database - on
> my hard drive - via ADO. I do not want to set up an
> ODBC data source for
> this particular app.
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
Message #4 by darrell.r.pitzer@e... on Wed, 6 Mar 2002 15:13:17
|
|
> I can not seem to find a code example to connect to a local database - on
> my hard drive - via ADO. I do not want to set up an ODBC data source for
> this particular app.
Try this web site for connection examples ... it is the most comprehensive
that I've seen:
http://www.able-consulting.com/ADO_Conn.htm
Cheers!
-- Darrell Pitzer
Message #5 by "Keith Lee" <kitleeky@m...> on Thu, 7 Mar 2002 01:54:26 +0800
|
|
Hi greg, try this url
http://www.asp101.com/articles/john/connstring/default.asp
good luck
"Greg Pearson" <jagged30net@n...> wrote in message
news:153401@a..._data_objects...
>
> I can not seem to find a code example to connect to a local database - on
> my hard drive - via ADO. I do not want to set up an ODBC data source for
> this particular app.
>
>
Message #6 by "Srinivasan Prasanna" <Sri_Core@m...> on Wed, 6 Mar 2002 13:10:56 -0500
|
|
------=_NextPart_001_0003_01C1C510.5A5011B0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Greg,
Like what Keith said asp101.com is a great site. This URl cleared all my
doubts http://www.able-consulting.com/ADO_Conn.htm
Good Luck
Thanks
Sri
----- Original Message -----
From: Keith Lee
Sent: Wednesday, March 06, 2002 1:00 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] Re: Help connecting to local database via
ADO
Hi greg, try this url
http://www.asp101.com/articles/john/connstring/default.asp
good luck
"Greg Pearson" <jagged30net@n...> wrote in message
news:153401@a..._data_objects...
>
> I can not seem to find a code example to connect to a local database -
on
> my hard drive - via ADO. I do not want to set up an ODBC data source fo
r
> this particular app.
>
>
to unsubscribe send a blank email to leave-activex_data_objects-823531U@p...
2p.wrox.com.Get more from the Web. FREE MSN Explorer download : http://e
xplorer.msn.com
|
View Cart
