by Fletc » Mon, 11 Feb 2002 16:58:02
q2. How do i go about uploading it ? I have uploaded all the asp and the
database using an ftp program, and I can access all the files, but when i
put in
http://www.holidays.travelconnect.com.au/asp/testsite/fancydress/
index.html comes up, but the .asp files don't show up ??
I would really appreciate all help here :)
thanx
by Mary Chipma » Mon, 11 Feb 2002 23:54:38
-- Mary
MCW Technologies
http://www.mcwtech.com
>q2. How do i go about uploading it ? I have uploaded all the asp and the
>database using an ftp program, and I can access all the files, but when i
>put in
>http://www.holidays.travelconnect.com.au/asp/testsite/fancydress/
>index.html comes up, but the .asp files don't show up ??
>I would really appreciate all help here :)
>thanx
by Fletc » Tue, 12 Feb 2002 07:11:14
Unfortunately, I did not understand much of what you said, so perhaps I am
well out of my depth.
My friend has given me a website, consisting of index.html, several *.asp
files and a database.mdb. I thought all I would have to do is upload the
files to my server which supports mysql. Obviously not.
I have spent the weekend searching the web, but find it all a bit too much.
All I want to do is upload the site and get it working.
Is there any hope for me ??
cheers
darren
> -- Mary
> MCW Technologies
> http://www.mcwtech.com
> >q1. Can I upload an access database to an sql server, or do I need an
> >msaccess server ?
> >q2. How do i go about uploading it ? I have uploaded all the asp and the
> >database using an ftp program, and I can access all the files, but when i
> >put in
> >http://www.holidays.travelconnect.com.au/asp/testsite/fancydress/
> >index.html comes up, but the .asp files don't show up ??
> >I would really appreciate all help here :)
> >thanx
by Mary Chipma » Wed, 13 Feb 2002 09:39:46
You need to install MDAC or a copy of Access on the web server if you
want to run the mdb as an Access database. Or else you need to
import/convert the Access database to another rdbms format. IOW, you
need the right software installed that can read the database. You will
then need to alter the connection information in your asp files.
-- Mary
MCW Technologies
http://www.mcwtech.com
>Unfortunately, I did not understand much of what you said, so perhaps I am
>well out of my depth.
>My friend has given me a website, consisting of index.html, several *.asp
>files and a database.mdb. I thought all I would have to do is upload the
>files to my server which supports mysql. Obviously not.
>I have spent the weekend searching the web, but find it all a bit too much.
>All I want to do is upload the site and get it working.
>Is there any hope for me ??
>cheers
>darren
>> Yes, you can either link to a Jet database using linked servers (see
>> SQL BOL for details), or you can migrate it using either DTS or the
>> Access upsizing wizard. However, asp is used to access data and isn't
>> stored in SQL Server, so I have no idea what you're talking about when
>> you say "uploaded all the asp" and "the asp files don't show up".
>> -- Mary
>> MCW Technologies
>> http://www.mcwtech.com
>> >q1. Can I upload an access database to an sql server, or do I need an
>> >msaccess server ?
>> >q2. How do i go about uploading it ? I have uploaded all the asp and the
>> >database using an ftp program, and I can access all the files, but when i
>> >put in
>> >http://www.holidays.travelconnect.com.au/asp/testsite/fancydress/
>> >index.html comes up, but the .asp files don't show up ??
>> >I would really appreciate all help here :)
>> >thanx
by Richard Davie » Wed, 13 Feb 2002 17:16:22
You need to get your database and the related files into correct directorys
on your web server. Your web server needs to be able to server ASP files for
these pages to work properly.
Have a look at your hosts FAQ or helppage.
Richard
> Unfortunately, I did not understand much of what you said, so perhaps I am
> well out of my depth.
> My friend has given me a website, consisting of index.html, several *.asp
> files and a database.mdb. I thought all I would have to do is upload the
> files to my server which supports mysql. Obviously not.
> I have spent the weekend searching the web, but find it all a bit too
much.
> All I want to do is upload the site and get it working.
> Is there any hope for me ??
> cheers
> darren
> > Yes, you can either link to a Jet database using linked servers (see
> > SQL BOL for details), or you can migrate it using either DTS or the
> > Access upsizing wizard. However, asp is used to access data and isn't
> > stored in SQL Server, so I have no idea what you're talking about when
> > you say "uploaded all the asp" and "the asp files don't show up".
> > -- Mary
> > MCW Technologies
> > http://www.mcwtech.com
> > >q1. Can I upload an access database to an sql server, or do I need an
> > >msaccess server ?
> > >q2. How do i go about uploading it ? I have uploaded all the asp and
the
> > >database using an ftp program, and I can access all the files, but when
i
> > >put in
> > >http://www.holidays.travelconnect.com.au/asp/testsite/fancydress/
> > >index.html comes up, but the .asp files don't show up ??
> > >I would really appreciate all help here :)
> > >thanx
1. Extracting an Access (*.mdb) database from SQL Server.
Hi:
I am putting together a project wherein my client wants to extract SQL
Server data to databases which will reside on users' laptops. The users
will then navigate through the data (which was extracted based on their
allowed views on the 'parent' database) offline, using IE4 and Microsoft's
very cool JDC appplet.
So, my first impulse is to make these client databases Access databases
(*.mdb). Does anyone know of a SQL based utility that can extract data
(given parameters) from a SQL Server database and export/save it to Access
format AND allow synchronization of the client databases back into the SQL
Server 'parent'?
Please email as well as post your answer.
Thanks in advance for your help,
Todd Rimes
http://home.earthlink.net/~toddrimes
http://www.vrdecorator.com (under construction)
2. HELP: Error 913 after deleteing test databases!!
3. converting an access mdb to sql server database
5. Replication from SQL to Access MDB to MDB
7. Access 97 mdb could not be opened after a conversion to Access 2000 mdb
8. Replication
9. Simple Question - SQL Script and Access MDB Database Creation
10. Please help ...how to insert records from one .mdb database to another .mdb database
11. Simple Question - SQL Script to Access (MDB) Database Creation
12. Publishing to SQL Server to Access MDB