Adding password to data connection

[xool]

Hi can anyone tell me how to add a password to using this connection string
pls

<%
set conn = server.createobject ("ADODB.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("dat48372.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
rs.Open SQL, conn
showall=true
%>

Many thanks in advance




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003

[Bob Barrows]

xool wrote:

> Hi can anyone tell me how to add a password to using this connection
> string pls
>
> <%
> set conn = server.createobject ("ADODB.connection")
> conn.Provider="Microsoft.Jet.OLEDB.4.0"
> conn.Open(Server.Mappath("dat48372.mdb"))
> set rs = Server.CreateObject("ADODB.recordset")
> SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
> rs.Open SQL, conn
> showall=true
> %>
>
> Many thanks in advance
>

[url]www.able-consulting.com/data_conn.htm[/url]

[xool]

Thanks Bob but that link doesn't work...


"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:O1q$KTtcDHA.2416@TK2MSFTNGP09.phx.gbl...

> xool wrote:

> > Hi can anyone tell me how to add a password to using this connection
> > string pls
> >
> > <%
> > set conn = server.createobject ("ADODB.connection")
> > conn.Provider="Microsoft.Jet.OLEDB.4.0"
> > conn.Open(Server.Mappath("dat48372.mdb"))
> > set rs = Server.CreateObject("ADODB.recordset")
> > SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
> > rs.Open SQL, conn
> > showall=true
> > %>
> >
> > Many thanks in advance
> >

> [url]www.able-consulting.com/data_conn.htm[/url]
>
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003

[Bob Barrows]

xool wrote:

> Thanks Bob but that link doesn't work...
>

Aargh! That's because the link should have been this:
[url]http://www.able-consulting.com/ADO_Conn.htm[/url]

Sorry

[Bob Barrows]

Sorry, but you're going to have to modify what you've got. You need to put
the database argument into the connection string as shown in the example.
Here is the appropriate example from that page:

If MDB has a database password
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:Database Password=MyDbPassword", _
"myUsername", "myPassword"

IIRC, the last two arguments ("myUsername", "myPassword") are not necessary.

Just to forestall any further lengthening of this thread, here is how your
connection should be opened:
dim sDB
sDB=Server.Mappath("dat48372.mdb")
conn .Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sDB & ";" & _
"Jet OLEDB:Database Password=MyDbPassword"


xool wrote:

> Cheers Bob but I can't find a connection string that matches the
> syntax of mine, I just need to know how to append a password to my
> current syntax if poss...
>
> <%
> set conn = server.createobject ("ADODB.connection")
> conn.Provider="Microsoft.Jet.OLEDB.4.0"
> conn.Open(Server.Mappath("dat48372.mdb"))
> set rs = Server.CreateObject("ADODB.recordset")
> SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
> rs.Open SQL, conn
> %>
>
> Cheers
>
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:OcnPkjtcDHA.1748@TK2MSFTNGP12.phx.gbl...

>> xool wrote:

>>> Thanks Bob but that link doesn't work...
>>>

>> Aargh! That's because the link should have been this:
>> [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
>>
>> Sorry
>>
>>

>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003

[xool]

Cheers Bob, got it

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:eHW3eZucDHA.2432@TK2MSFTNGP10.phx.gbl...

> Sorry, but you're going to have to modify what you've got. You need to put
> the database argument into the connection string as shown in the example.
> Here is the appropriate example from that page:
>
> If MDB has a database password
> oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=c:\somepath\mydb.mdb;" & _
> "Jet OLEDB:Database Password=MyDbPassword", _
> "myUsername", "myPassword"
>
> IIRC, the last two arguments ("myUsername", "myPassword") are not

necessary.

>
> Just to forestall any further lengthening of this thread, here is how your
> connection should be opened:
> dim sDB
> sDB=Server.Mappath("dat48372.mdb")
> conn .Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=" & sDB & ";" & _
> "Jet OLEDB:Database Password=MyDbPassword"
>
>
> xool wrote:

> > Cheers Bob but I can't find a connection string that matches the
> > syntax of mine, I just need to know how to append a password to my
> > current syntax if poss...
> >
> > <%
> > set conn = server.createobject ("ADODB.connection")
> > conn.Provider="Microsoft.Jet.OLEDB.4.0"
> > conn.Open(Server.Mappath("dat48372.mdb"))
> > set rs = Server.CreateObject("ADODB.recordset")
> > SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
> > rs.Open SQL, conn
> > %>
> >
> > Cheers
> >
> >
> > "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> > news:OcnPkjtcDHA.1748@TK2MSFTNGP12.phx.gbl...

> >> xool wrote:
> >>> Thanks Bob but that link doesn't work...
> >>>
> >> Aargh! That's because the link should have been this:
> >> [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> >>
> >> Sorry
> >>
> >>

> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> > Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003

>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003

[Jim PKP]

Sorry if this is a thick question:

I was having problems with db connections using ASP/VBScript/IIS.
I had been using ODBC connections and then switched to OLEDB instead
following advice from people here, which seems to have sorted the problem.

My question is, basically what's the difference between OLEDB and ODBC,
and why would connections using ODBC stop working in IIS on Win2K or WinXP??

Thanks
--
---
| JIM | PKP |

[Bob Barrows]

Jim PKP wrote:

> Sorry if this is a thick question:
>
> I was having problems with db connections using ASP/VBScript/IIS.
> I had been using ODBC connections and then switched to OLEDB instead
> following advice from people here, which seems to have sorted the
> problem.
>
> My question is, basically what's the difference between OLEDB and
> ODBC,

ODBC is the older, now obsolete, database connectivity software, that was in
use before ADO was invented. While it did work, there were issues with it
that MS did not want to deal with anymore, so when they developed ADO, they
took another direction: all connectivity would be supplied via OLE DB
providers, which could be created by anyone who wanted to write one. They
supplied "native" providers for several database engines, including Jet and
SQL Server. These providers talk "directly" to the database engines (well,
no really, but close enough unless one really wants to peek under the hood).
They also provided a provider for ODBC, called MSDASQL, which is used to
talk to ODBC drivers. When using ODBC with ADO, you are essentially passing
through an extra layer of software to get to your database. This leads to
inefficiency in itself, in addition to losing functionality that may be
incorporated into the native OLE DB provider but not into the obsolete ODBC
driver.

> and why would connections using ODBC stop working in IIS on Win2K or
> WinXP??

I don't know - I've never seen this happen.

Bob Barrows

[Troy Stark]

I've been lazy and made a file named ... New Text Document.udl (he he he)
open the udl file select the datasource type, connection, type
username/password etc.. then once im done hit the test connection botton...
wow it said it works, open the file in notepad and copy the connection
string into the conn.Open statement.

You can also use the udl file as the connection as well.. i dont remember
how, because i just assume it was slower and not necessary..

"xool" <misc@me.net> wrote in message
news:OOqJ5YtcDHA.2932@tk2msftngp13.phx.gbl...

> Thanks Bob but that link doesn't work...
>
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:O1q$KTtcDHA.2416@TK2MSFTNGP09.phx.gbl...

> > xool wrote:

> > > Hi can anyone tell me how to add a password to using this connection
> > > string pls
> > >
> > > <%
> > > set conn = server.createobject ("ADODB.connection")
> > > conn.Provider="Microsoft.Jet.OLEDB.4.0"
> > > conn.Open(Server.Mappath("dat48372.mdb"))
> > > set rs = Server.CreateObject("ADODB.recordset")
> > > SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
> > > rs.Open SQL, conn
> > > showall=true
> > > %>
> > >
> > > Many thanks in advance
> > >

> > [url]www.able-consulting.com/data_conn.htm[/url]
> >
> >
> >

>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003
>
>