Front Page - Help with database connection

Author

Help with database connection

Paul M

2004-11-09, 12:15 pm

Hi
How do I find out the dsn connection string for an access database stored in
the fpdb folder of a website
Thank
Paul M

MD Websunlimited

2004-11-09, 12:15 pm

If it was created using the DIW then you can look in the global.asa file.

--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 Released Special Pricing
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible

"Paul M" <P@doinghisbest> wrote in message news:%23LyBC2mxEHA.2316@TK2MSFTNGP15.phx.gbl...
> Hi
> How do I find out the dsn connection string for an access database stored in
> the fpdb folder of a website
> Thank
> Paul M
>
>

Paul M

2004-11-09, 12:15 pm

Thanks
I can't see anything that says dsn the connection code I am trying to
change is

'making connection to database
set objcon=server.createObject("aadodb.connection")
'opening database
objcon.open "dsn=dsnname"

Thanks
Paul M

"MD Websunlimited" <none@none.com> wrote in message
news:ewLwPInxEHA.824@TK2MSFTNGP11.phx.gbl...
> If it was created using the DIW then you can look in the global.asa file.
>
> --
> Mike -- FrontPage MVP '97-'02
> J-Bots 2004 Released Special Pricing
> http://www.websunlimited.com
> FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
>
> "Paul M" <P@doinghisbest> wrote in message
news:%23LyBC2mxEHA.2316@TK2MSFTNGP15.phx.gbl...
stored in[color=darkred]
>
>

Stefan B Rusynko

2004-11-10, 7:14 am

Use

Dim dsnname
dsnname = Application("XXXXX_ConnectionString")
set objcon = Server.CreateObject("ADODB.Connection")
objcon.Open dsnname

The value for XXXXX above is the value you see when you open the global.asa file (in your root)
Usually in the line
Application("XXXXX_ConnectionString") = "........;DRIVER={Microsoft Access Driver (*.mdb)}"

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________

"Paul M" <P@doinghisbest> wrote in message news:%23xcNzWnxEHA.1308@TK2MSFTNGP09.phx.gbl...
| Thanks
| I can't see anything that says dsn the connection code I am trying to
| change is
|
| 'making connection to database
| set objcon=server.createObject("aadodb.connection")
| 'opening database
| objcon.open "dsn=dsnname"
|
| Thanks
| Paul M
|
|
| "MD Websunlimited" <none@none.com> wrote in message
| news:ewLwPInxEHA.824@TK2MSFTNGP11.phx.gbl...
| > If it was created using the DIW then you can look in the global.asa file.
| >
| > --
| > Mike -- FrontPage MVP '97-'02
| > J-Bots 2004 Released Special Pricing
| > http://www.websunlimited.com
| > FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
| >
| > "Paul M" <P@doinghisbest> wrote in message
| news:%23LyBC2mxEHA.2316@TK2MSFTNGP15.phx.gbl...
| > > Hi
| > > How do I find out the dsn connection string for an access database
| stored in
| > > the fpdb folder of a website
| > > Thank
| > > Paul M
| > >
| > >
| >
| >
|
|

Dianne

2005-01-30, 7:16 pm

Apologize for tagging on -

I am getting this msg:

Provider error '80004005'

Unspecified error

/step1-DW.asp, line 85

The website has a series of .asp pages that should check for existing
records in the Access DB. If found, take user to page to ask if password is
forgotten. If not found, take user to registration page.

Line 85 of code is this:

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.open = CONNECTION_STRING

I checked the Connection.asp file to verify it is still pointing at the
correct Access DB. It is.

Why would it suddenly no longer be willing to open the connection? It
worked before. No new software installed. Properties and permissions still
show the DB is writable. Using Win2000 Server.

TIA,

"Stefan B Rusynko" wrote:

> Use
>
> Dim dsnname
> dsnname = Application("XXXXX_ConnectionString")
> set objcon = Server.CreateObject("ADODB.Connection")
> objcon.Open dsnname
>
> The value for XXXXX above is the value you see when you open the global.asa file (in your root)
> Usually in the line
> Application("XXXXX_ConnectionString") = "........;DRIVER={Microsoft Access Driver (*.mdb)}"
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "Paul M" <P@doinghisbest> wrote in message news:%23xcNzWnxEHA.1308@TK2MSFTNGP09.phx.gbl...
> | Thanks
> | I can't see anything that says dsn the connection code I am trying to
> | change is
> |
> | 'making connection to database
> | set objcon=server.createObject("aadodb.connection")
> | 'opening database
> | objcon.open "dsn=dsnname"
> |
> | Thanks
> | Paul M
> |
> |
> | "MD Websunlimited" <none@none.com> wrote in message
> | news:ewLwPInxEHA.824@TK2MSFTNGP11.phx.gbl...
> | > If it was created using the DIW then you can look in the global.asa file.
> | >
> | > --
> | > Mike -- FrontPage MVP '97-'02
> | > J-Bots 2004 Released Special Pricing
> | > http://www.websunlimited.com
> | > FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
> | >
> | > "Paul M" <P@doinghisbest> wrote in message
> | news:%23LyBC2mxEHA.2316@TK2MSFTNGP15.phx.gbl...
> | > > Hi
> | > > How do I find out the dsn connection string for an access database
> | stored in
> | > > the fpdb folder of a website
> | > > Thank
> | > > Paul M
> | > >
> | > >
> | >
> | >
> |
> |
>
>
>

Thomas A. Rowe

2005-01-30, 7:16 pm

Have you tried changing line 85, as per Stefan suggestion?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dianne" <Dianne@discussions.microsoft.com> wrote in message
news:FDEBAA03-B13B-4519-9D62-E6CDB884EAC2@microsoft.com...[color=darkred]
> Apologize for tagging on -
>
> I am getting this msg:
>
> Provider error '80004005'
>
> Unspecified error
>
> /step1-DW.asp, line 85
>
> The website has a series of .asp pages that should check for existing
> records in the Access DB. If found, take user to page to ask if password is
> forgotten. If not found, take user to registration page.
>
> Line 85 of code is this:
>
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.open = CONNECTION_STRING
>
> I checked the Connection.asp file to verify it is still pointing at the
> correct Access DB. It is.
>
> Why would it suddenly no longer be willing to open the connection? It
> worked before. No new software installed. Properties and permissions still
> show the DB is writable. Using Win2000 Server.
>
> TIA,
>
> "Stefan B Rusynko" wrote:
>

Dianne

2005-01-31, 7:24 pm

No, I had not. When I went to do this, I decided to check it to see if it
would work correctly first. And it did! It's an intermittent problem. Any
ideas as to why it's unstable? Would changing line 85 correct the
instability?

"Thomas A. Rowe" wrote:

> Have you tried changing line 85, as per Stefan suggestion?
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Dianne" <Dianne@discussions.microsoft.com> wrote in message
> news:FDEBAA03-B13B-4519-9D62-E6CDB884EAC2@microsoft.com...
>
>
>

Thomas A. Rowe

2005-01-31, 7:24 pm

It may.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dianne" <Dianne@discussions.microsoft.com> wrote in message
news:FFEBCE1B-EF97-4B5E-BE19-713B4109370C@microsoft.com...[color=darkred]
> No, I had not. When I went to do this, I decided to check it to see if it
> would work correctly first. And it did! It's an intermittent problem. Any
> ideas as to why it's unstable? Would changing line 85 correct the
> instability?
>
>
> "Thomas A. Rowe" wrote:
>