homepage Welcome to WebmasterWorld Guest from 54.226.10.234
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
database usage
how to connect
Blelisa

10+ Year Member



 
Msg#: 2790 posted 5:44 pm on Jun 9, 2005 (gmt 0)

Hello everyone,
I am about to pull my hair out.
I have a database, I have a register.asp and a login.asp page. They work fine on my old site which is hosted at me regular hoster.
Now I took over a new site. I mimic'd the database and site and such for this new site (except for the database and table names) and I cannot connect to database. When I ftp up to the site the first thing I see are three folders one is db, one is etc and the last is www. I figured the database goes into db than I use the following code to connect:
'Open a database connection
Set connection = Server.CreateObject("ADODB.Connection")
connection.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_
server.MapPath("db/sys.mdb")
connection.Open

However this is not working. Anyone have any ideas what I could be missing? I called the new hosting company and they tell me my asp is wrong and that the server info is

MySQL Information
UserName: syner008
Password: (hidden) Show Password

MySQL Host: mysql.synergyearthsys.com or mysql.omnis.com
Database Name: syner008
MySQL Version: 4.0.22

Can anyone help me? I've already shed some tears in frustration over this!

 

defanjos

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 2790 posted 7:30 pm on Jun 9, 2005 (gmt 0)

If you create a folder called "db" under "www" and place the database in there, it should work.
Make sure to request "write" permissions to www/db, otherwise you won't be able to write to the db.

I believe the problem you have is, the existing db folder is outside of your root (www).
I am not sure how you can connect to it from within the root of the site. Maybe you can use a DSN connection (the hosting company has to set this up for you).

The code the hosting company gave you was for a mySQL database and not Access like you are using.

TheDave

10+ Year Member



 
Msg#: 2790 posted 5:38 am on Jun 10, 2005 (gmt 0)

Load up your database in Access, use the Database Upsizing Wizard and convert to SQL, then use the SQL info they gave you.

Blelisa

10+ Year Member



 
Msg#: 2790 posted 3:42 pm on Jun 10, 2005 (gmt 0)

Thanks for the help!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved