CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Unable to establish connection to database

Print topic Send  topic

Author Message
Kåre Simensen
Posted: 09/08/2002, 3:33 PM

I get this error message when I try to Login to my access-database. My
database is on my web-pages!!

Unable to establish connection to database.
a.. Error information:
Microsoft JET Database Engine (0x80004005)
'C:\altahavn\Nyheter.mdb' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.

I don't now where to make the right path when I want to connect to my
homepage on the Web.
Is there anyone who can help ?

Regards

Kåre Simensen

Wayne & Carr
Posted: 09/08/2002, 9:16 PM

I am learning "CodeCharge" and do not have a clue what I am doing in it yet.
But the problem that you are having is:

Is your database in a folder within the same directory of your pages??
If it is, then you need to edit the page that contains the directory for the
database
and make it look like so:
either of the 2 will work............
MyDatabase-Folder/mydatabase.mdb
or
.../mydatabase.mdb (<-- notice that there are 2 periods before the forward
slash.

This should get rid of your error. As that some scripts (and server
configurations)
do not except (or) like the full directory path's like you have here.
So just try the above and everything should go to working, without anymore
issues with
the directory paths for your database.

p.s.
Do you know of a good place to learn how to use this software,
I bought the standard edition, and cannot find a tutorial on it, no where.

Thank you, and I have that the information that I have given to you
will help in your database issue.

Wayne


--
Wayne & Carr Barron
Carrz-Fox-Fire Promotions
http://www.carrz-fox-fire.com
{Fire Search} New Search Engine By: Carrz-Fox-Fire Promotions
http://www.carrz-fox-fire.com/Fox/
Delphi Security Resource Site
http://www.carrz-fox-fire.com/Delphi/Delphi_Fire_Security/
Western Wear & Tack (Live Store)
http://www.carrz-fox-fire.com/EStores/West/catalog/
"Kåre Simensen" <karesim@trollnet.no> wrote in message
news:algj6u$49a$1@news.codecharge.com...
> I get this error message when I try to Login to my access-database. My
> database is on my web-pages!!
>
> Unable to establish connection to database.
> a.. Error information:
> Microsoft JET Database Engine (0x80004005)
> 'C:\altahavn\Nyheter.mdb' is not a valid path. Make sure that the path
> name is spelled correctly and that you are connected to the server on
which
> the file resides.
>
> I don't now where to make the right path when I want to connect to my
> homepage on the Web.
> Is there anyone who can help ?
>
> Regards
>
> Kåre Simensen
>
>

Kåre Simensen
Posted: 09/09/2002, 1:42 PM

I still have the same problem ...., is there other who can help me ??????
I woold say thank's for all help so far - but I still have my problem.


"Kåre Simensen" <karesim@trollnet.no> wrote in message
news:algj6u$49a$1@news.codecharge.com...
> I get this error message when I try to Login to my access-database. My
> database is on my web-pages!!
>
> Unable to establish connection to database.
> a.. Error information:
> Microsoft JET Database Engine (0x80004005)
> 'C:\altahavn\Nyheter.mdb' is not a valid path. Make sure that the path
> name is spelled correctly and that you are connected to the server on
which
> the file resides.
>
> I don't now where to make the right path when I want to connect to my
> homepage on the Web.
> Is there anyone who can help ?
>
> Regards
>
> Kåre Simensen
>
>

Sixto Luis Santos
Posted: 09/09/2002, 5:37 PM

Hello,

You must select an option other than "Same as Design" for the connection
string type. If your database is in the same folder as the rest of your
pages then you may select 'Create Automatically' and, given that your db is
already there, make sure the 'Copy the Database' option remains unchecked.
If your DB resides in any other folder, then you must select 'Custom' as the
connection string type. Then type in the server's connection string textbox
the following line

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("dbfolder/dbname.mdb") & "

where dbname.mdb is the name of your database on the server and dbfolder is
the folder where that database is located.

....and nope, it's not a typo. The line must contain & " at the end.

One more thing. The folder where the database resides must be writtable by
IUSER_machinename. There are tricks to do this if you're using frontpage,
but you must ask your hosting admins to apply proper permissions to the
folder otherwise.

Regards,

Sixto


"Kåre Simensen" <karesim@trollnet.no> wrote in message
news:algj6u$49a$1@news.codecharge.com...
> I get this error message when I try to Login to my access-database. My
> database is on my web-pages!!
>
> Unable to establish connection to database.
> a.. Error information:
> Microsoft JET Database Engine (0x80004005)
> 'C:\altahavn\Nyheter.mdb' is not a valid path. Make sure that the path
> name is spelled correctly and that you are connected to the server on
which
> the file resides.
>
> I don't now where to make the right path when I want to connect to my
> homepage on the Web.
> Is there anyone who can help ?
>
> Regards
>
> Kåre Simensen
>
>

Kåre Simensen
Posted: 09/10/2002, 11:12 AM

I'm a happy man just now. With all your help my problem is solved. So
again - thank to you all.

regards
Kåre

"Sixto Luis Santos" <sixto@tecnoapoyo.com> wrote in message
news:aljet2$esu$1@news.codecharge.com...
> Hello,
>
> You must select an option other than "Same as Design" for the connection
> string type. If your database is in the same folder as the rest of your
> pages then you may select 'Create Automatically' and, given that your db
is
> already there, make sure the 'Copy the Database' option remains unchecked.
> If your DB resides in any other folder, then you must select 'Custom' as
the
> connection string type. Then type in the server's connection string
textbox
> the following line
>
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("dbfolder/dbname.mdb") & "
>
> where dbname.mdb is the name of your database on the server and dbfolder
is
> the folder where that database is located.
>
> ...and nope, it's not a typo. The line must contain & " at the end.
>
> One more thing. The folder where the database resides must be writtable by
> IUSER_machinename. There are tricks to do this if you're using frontpage,
> but you must ask your hosting admins to apply proper permissions to the
> folder otherwise.
>
> Regards,
>
> Sixto
>
>
> "Kåre Simensen" <karesim@trollnet.no> wrote in message
>news:algj6u$49a$1@news.codecharge.com...
> > I get this error message when I try to Login to my access-database. My
> > database is on my web-pages!!
> >
> > Unable to establish connection to database.
> > a.. Error information:
> > Microsoft JET Database Engine (0x80004005)
> > 'C:\altahavn\Nyheter.mdb' is not a valid path. Make sure that the path
> > name is spelled correctly and that you are connected to the server on
> which
> > the file resides.
> >
> > I don't now where to make the right path when I want to connect to my
> > homepage on the Web.
> > Is there anyone who can help ?
> >
> > Regards
> >
> > Kåre Simensen
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.