|
 |
asp_databases thread: trying to make this connection DSN-LESS
Message #1 by "Phil Perks" <philp@w...> on Fri, 5 May 2000 10:21:13
|
|
-----Original Message-----
From: Michael Ravnsbæk Pedersen [mailto:slot-ravnsbaek@p...]
Sent: 04 May 2000 16:56
To: support@w...
Subject: 2726 - Beginning ASP Databases
On page 350-351, a connection to the dtb is established via DSN.
"Set objConn = Server......
Now I have been trying to make this connection DSN-LESS for almost two
days.
I know the path to my dtb.
Apparently, I do not know how to do this, and therefore I am asking you
whom
ever you are, if you would be so kind to give me the solution.
If you should like to explain what you have done too, I would be truely
greatfull.
TX A LOT
Michael
Denmark
Message #2 by "Ruud Voigt" <RuudVoigt@w...> on Fri, 5 May 2000 11:48:41 +0200
|
|
The easies way to do this is to create the script using a file DSN.
(instead of a system dsn)
When you get it to work that way you go to the microsoft common folder
that contains the file dsn. Open it, Copy the contents and past them over
your DSN script in the code. DSN does't really do much beside provide
a central location to store the connection details of a datasource.
-----Original Message-----
From: Phil Perks [mailto:philp@w...]
Sent: vrijdag 5 mei 2000 10:21
To: ASP Databases
Subject: [asp_databases] trying to make this connection DSN-LESS
-----Original Message-----
From: Michael Ravnsbæk Pedersen [mailto:slot-ravnsbaek@p...]
Sent: 04 May 2000 16:56
To: support@w...
Subject: 2726 - Beginning ASP Databases
On page 350-351, a connection to the dtb is established via DSN.
"Set objConn = Server......
Now I have been trying to make this connection DSN-LESS for almost two
days.
I know the path to my dtb.
Apparently, I do not know how to do this, and therefore I am asking you
whom
ever you are, if you would be so kind to give me the solution.
If you should like to explain what you have done too, I would be truely
greatfull.
TX A LOT
Michael
Denmark
---
You are currently subscribed to asp_databases
Message #3 by Mark Everest <Mark.Everest@t...> on Fri, 5 May 2000 11:50:54 +0100
|
|
Another way is if you have a copy of VB, create a connection in a
dataenvironment. You can the copy the connectstring from there into
the
adoConnection's connect string.
-----Original Message-----
From: Ruud Voigt
Sent: 05 May 2000 10:49
To: ASP Databases
Subject: [asp_databases] RE: trying to make this connection DSN-LESS
The easies way to do this is to create the script using a file DSN.
(instead of a system dsn)
When you get it to work that way you go to the microsoft common folder
that contains the file dsn. Open it, Copy the contents and past them
over
your DSN script in the code. DSN does't really do much beside provide
a central location to store the connection details of a datasource.
-----Original Message-----
From: Phil Perks [mailto:philp@w...]
Sent: vrijdag 5 mei 2000 10:21
To: ASP Databases
Subject: [asp_databases] trying to make this connection DSN-LESS
-----Original Message-----
From: Michael Ravnsb=E6k Pedersen [mailto:slot-ravnsbaek@p...]
Sent: 04 May 2000 16:56
To: support@w...
Subject: 2726 - Beginning ASP Databases
On page 350-351, a connection to the dtb is established via DSN.
"Set objConn =3D Server......
Now I have been trying to make this connection DSN-LESS for almost two
days.
I know the path to my dtb.
Apparently, I do not know how to do this, and therefore I am asking you
whom
ever you are, if you would be so kind to give me the solution.
If you should like to explain what you have done too, I would be truely
greatfull.
TX A LOT
Michael
Denmark
---
You are currently subscribed to asp_databases
$subst('Email.Unsub')
---
You are currently subscribed to asp_databases
$subst('Email.Unsub')
Message #4 by "Ken Schaefer" <ken.s@a...> on Sun, 7 May 2000 17:58:18 +1000
|
|
> -----Original Message-----
> From: Michael Ravnsbæk Pedersen
> Sent: 04 May 2000 16:56
> To: support@w...
> Subject: 2726 - Beginning ASP Databases
>
>
> Now I have been trying to make this connection DSN-LESS for almost two
> days. I know the path to my dtb.
>
> Apparently, I do not know how to do this, and therefore I am asking you
> who ever you are, if you would be so kind to give me the solution.
>
> If you should like to explain what you have done too, I would be truely
> greatfull.
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;User
ID=Admin;Password=;"
(all that to go on one line, there is a space between "User" and "ID" and
the above would work for an Access database which was called db1.mdb located
on c:\ - amend for your database location)
HTH
Cheers
Ken
Message #5 by "Kenneth Carlsson" <dp100kennethc@l...> on Mon, 8 May 2000 14:51:53 +0200
|
|
Hi there Ken
you could always try this method out...
Set objConn= server.createobject("adodb.connection")
DSN="DRIVER={Microsoft Access Driver (*.mdb)};UserID=Admin;Password=;
DBQ=" & server.mappath("db1.mdb")
objConn.Open DSN
Ken
----- Original Message -----
From: "Ken Schaefer"
To: "ASP Databases" <asp_databases@p...>
Sent: Sunday, May 07, 2000 9:58 AM
Subject: [asp_databases] Re: trying to make this connection DSN-LESS
> > -----Original Message-----
> > From: Michael Ravnsbæk Pedersen
> > Sent: 04 May 2000 16:56
> > To: support@w...
> > Subject: 2726 - Beginning ASP Databases
> >
> >
> > Now I have been trying to make this connection DSN-LESS for almost two
> > days. I know the path to my dtb.
> >
> > Apparently, I do not know how to do this, and therefore I am asking you
> > who ever you are, if you would be so kind to give me the solution.
> >
> > If you should like to explain what you have done too, I would be truely
> > greatfull.
>
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;User
> ID=Admin;Password=;"
>
> (all that to go on one line, there is a space between "User" and "ID" and
> the above would work for an Access database which was called db1.mdb
located
> on c:\ - amend for your database location)
>
> HTH
>
> Cheers
> Ken
|
|
|
View Cart
