Welcome Guest

Search | Active Topics | Members | Log In | Register

Mailyoulike Forum » Mailyoulike v3 .8 » Installation and Configuration » location of database

location of database

Options · View

Previous Topic · Next Topic

anthdoyle

Posted: Thursday, January 15, 2004 9:35:26 AM

Rank: Advanced Member
Groups: Member

Joined: 7/16/2004
Posts: 53
Points: 159

Hi I have just installed mail you like and I am impressed so far.

One thing I would like a bit of info on however is in regard to the location of the access database. I wish to move this database to a secure area on my hosts server. I have a db folder which is there for all my databases but if I move the myl database how can I change the program to reflect the new location?

Cheers
Anthony

admin

Posted: Thursday, January 15, 2004 10:08:24 AM

Rank: Administration
Groups: Administration

Joined: 7/1/2008
Posts: 256
Points: 574

You can change the name of the database to any thing you want, and also open config.asp file in notepad and change the name of database there as well both must be same.

Now if you want to move the database to secure location you must know the physical path of that folder when you know that (if you do not know that ask your host) then open the file

Suhailkaleem.asp under the connections folder and then you will see this

'----[>>]-------- DSN LESS connection string ( Server.Mappath ) ----------[<<]----------

if dbtype =1 then

Path = vfolder & "/db/"&db_name

constr = "DBQ=" & Server.Mappath(path) & ";Driver={Microsoft Access Driver (*.mdb)};"

end if

'----[^^]-------- DSN_LESS connection string ( Server.Mappath ) --------[^^]----------

Change this to

'----[>>]-------- DSN LESS connection string ( Server.Mappath ) ----------[<<]----------

if dbtype =1 then

Path = "your_databse_physical_path"

constr = "DBQ=" & path & ";Driver={Microsoft Access Driver (*.mdb)};"

end if

'----[^^]-------- DSN_LESS connection string ( Server.Mappath ) --------[^^]----------

Let me know if you have any other questions

Thanks
Suhail Kaleem
Mailyoulike.com

admin38001.4234606481

anthdoyle

Posted: Thursday, January 15, 2004 10:29:14 AM

Rank: Advanced Member
Groups: Member

Joined: 7/16/2004
Posts: 53
Points: 159

Thanks Suhail, your a genius.

Another quick query. I have a sub domain setup at my site as in email.domain.com

This subdomain uses a folder called email that is inside my wwwroot folder. I have installed 'mail you like' in the email directory that is mapped to the subdomain. I have also put the bin directory inside the wwwroot folder. The database is now located outside of the wwwroot folder in a db secure folder (thanks to your brilliant help).

My problem is that I can access the login page from the subdomain email.domain.com but when I click login after entering login info i get the following:

Microsoft VBScript runtime error '800a004c'

Path not found

/my_check.asp, line 23

Now i think it may be something to do with the virtual folder that i have specified in the config.asp file. I have it set at /email at the moment as this is the only way I could seem to get it to work.

I can access the program and login fine if i enter the full actual path into the browser ie http//www.domain.com/email

Any ideas? Cheers Anthony

admin

Posted: Thursday, January 15, 2004 11:00:18 AM

Rank: Administration
Groups: Administration

Joined: 7/1/2008
Posts: 256
Points: 574

Hi !

open config.asp and set the variable vfolder to "" like this
vfolder= ""
this should slove your problem

'---------------- a little more info -----------------------'

if you have a subdomian and you install mailyoulike on your subdomain then you will be able to send and recive email by username@subdomian.domianname.com

if you want the user to type http://email.mydomian.com and redirect to http://mydomian.com/email/ then follow these steps

1) open notepad and copy paste the below text in it and save it with the name default.asp

<%
response.redirect "http://yourdomian.com/email/"
%>

2) create a subdomian and copy the default.asp file under the root directroy .

Let me know if you have any other question

Thanks
Suhail kaleem
mailyoulike.com

ps: Please start a new post for a new question

anthdoyle

Posted: Thursday, January 15, 2004 11:05:47 AM

Rank: Advanced Member
Groups: Member

Joined: 7/16/2004
Posts: 53
Points: 159

Hi thanks for the reply,

I tried this already but get the following error when clicking the login button:

Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30002: Type 'mma_net1' is not defined.

Source Error:

Line 50: 
Line 51: 
Line 52: Dim s1 As New mma_net1
Line 53: s1.login(trim(s),trim(u),trim(p1),
server.mappath("/" & request.querystring("bpath")) , 
server.mappath("/" & request.querystring("upath") ))
Line 54:

Source File: D:\webspace\golidays.com\wwwroot\email\g_m.aspx Line: 52

I also tried the install from subdomain but it generated the subdomain.domain addresses as you said which i do not want.

I can't really use the redirect default.asp solluction as the mail you like install is already sitting in the root of my subdomain. This would replace the myl default.asp

Any other ideas.

admin38001.4764699074

anthdoyle

Posted: Thursday, January 15, 2004 11:11:29 AM

Rank: Advanced Member
Groups: Member

Joined: 7/16/2004
Posts: 53
Points: 159

Hi I noticed this error was documented in an earlier post sorry. I moved the bin directory to the root of my subdomian ie domian/email folder and it now works fine. Are there any other mods i should make to stop potential problem with it running via a subdomain?

Thanks for all your help and well done on a great wep app.

Anthony

admin

Posted: Thursday, January 15, 2004 11:11:38 AM

Rank: Administration
Groups: Administration

Joined: 7/1/2008
Posts: 256
Points: 574

Hi !
Copy the bin folder under the root of subdomain and also under the domain root dir

Thanks
Suhail kaleem
mailyoulike.com

anthdoyle

Posted: Thursday, January 15, 2004 11:13:52 AM

Rank: Advanced Member
Groups: Member

Joined: 7/16/2004
Posts: 53
Points: 159

Cheers great support. Top quality service.

Anthony

Users browsing this topic

Guest

Mailyoulike Forum » Mailyoulike v3 .8 » Installation and Configuration » location of database

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.