|
 |
asp_databases thread: Re: [beginning_asp] Re: ODBC and Access
Message #1 by "Stanley Cheung" <stanley@j...> on Wed, 13 Sep 2000 18:56:00 +0800
|
|
Hi Ken,
Can you provide some example for connection string of DBQ. thx!
Stanley
----- Original Message -----
From: Ken Schaefer <ken@a...>
To: Beginning ASP <beginning_asp@p...>
Sent: Wednesday, September 13, 2000 1:40 PM
Subject: [beginning_asp] Re: ODBC and Access
> > Actually, i want to setup the database with ASP.
> > I will perfer access data sheet, but i haven't ODBC connection on my web
> > hosting...
> > do i need the odbc when using access...?
> > pls advise. thx!!
>
> You need either ODBC, or (preferably) OLEDB
>
> http://www.adOpenStatic.com/faq/whyOLEDB.asp explain why you should use
> OLEDB
>
> http://www.adOpenStatic.com/faq/OLEDBconnection.asp explains how to setup
an
> OLEDB connection (I might add some more on Server.Mappath("/") sometime)
>
> If you really want to use ODBC, but don't have a DSN setup, you can use
DBQ
> = and specify a path to your d/base.
>
> Cheers
> Ken
>
>
Message #2 by =?iso-8859-1?Q?Gonzalo_Ruiz_de_Villa_Su=E1rez?= <gonzalo.ruizdevilla@a...> on Wed, 13 Sep 2000 13:42:47 +0200
|
|
Set oConn = Server.CreateObject("ADODB.Connection")
strSource = "Driver={Microsoft Access Driver (*.mdb); DBq=C:\My
Documents\mydatabase.mdb"
oConn.ConnectionString = strSource
oConn.Open
Regards,
Gonzalo
-----Mensaje original-----
De: Stanley Cheung [mailto:stanley@j...]
Enviado el: miércoles, 13 de septiembre de 2000 21:24
Para: ASP Databases
Asunto: [asp_databases] Re: [beginning_asp] Re: ODBC and Access
Hi Ken,
Can you provide some example for connection string of DBQ. thx!
Stanley
----- Original Message -----
From: Ken Schaefer <ken@a...>
To: Beginning ASP <beginning_asp@p...>
Sent: Wednesday, September 13, 2000 1:40 PM
Subject: [beginning_asp] Re: ODBC and Access
> > Actually, i want to setup the database with ASP.
> > I will perfer access data sheet, but i haven't ODBC connection on my web
> > hosting...
> > do i need the odbc when using access...?
> > pls advise. thx!!
>
> You need either ODBC, or (preferably) OLEDB
>
> http://www.adOpenStatic.com/faq/whyOLEDB.asp explain why you should use
> OLEDB
>
> http://www.adOpenStatic.com/faq/OLEDBconnection.asp explains how to setup
an
> OLEDB connection (I might add some more on Server.Mappath("/") sometime)
>
> If you really want to use ODBC, but don't have a DSN setup, you can use
DBQ
> = and specify a path to your d/base.
>
> Cheers
> Ken
>
>
|
|
|
View Cart
