Connection String

[WStoreyII]

I am making a asp page that will run on my computer by iis. But the problem
is the database in on a web server. I can not seem to get the connection to
work for it though here his the connection and the error. Any help please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

[Scott M.]

When using Access, it must reside on the same machine as the code that is
accessing it and the path in the connection string must be a local physical
path. Access is not made for sharing database data across networks. You
may wish to upgrade to the free MSDE (MS Data Engine), which is a single
user licensed version of SQL Server.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

I am making a asp page that will run on my computer by iis. But the
problem
is the database in on a web server. I can not seem to get the connection
to
work for it though here his the connection and the error. Any help
please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

[VB Programmer]

Try using the local path such as "Source=c:\database\PIMP.mdb"

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

I am making a asp page that will run on my computer by iis. But the
problem
is the database in on a web server. I can not seem to get the connection
to
work for it though here his the connection and the error. Any help
please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

[Ken Cox [Microsoft MVP]]

If you are trying to get data from an Access database across sites (on
different machines), you'll want to investigate calling a Web service on the
remote site.

The Web service will fetch the data from Access and return it to your page.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

I am making a asp page that will run on my computer by iis. But the
problem
is the database in on a web server. I can not seem to get the connection
to
work for it though here his the connection and the error. Any help
please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

[WStoreyII]

Ken,

The problem is that i have a free webpage that comes with asp classic
capabilliteis and access database only. so i guess my question is can i use
webservices with asp classic?

"Ken Cox [Microsoft MVP]" wrote:

If you are trying to get data from an Access database across sites (on
different machines), you'll want to investigate calling a Web service on the
remote site.

The Web service will fetch the data from Access and return it to your page.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

I am making a asp page that will run on my computer by iis. But the
problem
is the database in on a web server. I can not seem to get the connection
to
work for it though here his the connection and the error. Any help
please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

[Ken Cox [Microsoft MVP]]

It isn't as easy as with ASP.NET but you can certainly do it:

Creating Web Services with ASP

http://www.4guysfromrolla.com/webtech/070401-1.shtml

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...

Ken,

The problem is that i have a free webpage that comes with asp classic
capabilliteis and access database only. so i guess my question is can i
use
webservices with asp classic?

"Ken Cox [Microsoft MVP]" wrote:

If you are trying to get data from an Access database across sites (on
different machines), you'll want to investigate calling a Web service on
the
remote site.

The Web service will fetch the data from Access and return it to your
page.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

>I am making a asp page that will run on my computer by iis. But the
>problem
> is the database in on a web server. I can not seem to get the
> connection
> to
> work for it though here his the connection and the error. Any help
> please.
>
> Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"
>
> Error: Microsoft JET Database Engine (0x80004005)
> Not a valid file name.
> /Default.asp, line 40
>
> Thanks,
>
> WStoreyII

[Ken Cox [Microsoft MVP]]

And this..

How to Build a Low-Budget Web Service with Classic ASP

http://www.4guysfromrolla.com/webtech/120501-1.shtml

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...

Ken,

The problem is that i have a free webpage that comes with asp classic
capabilliteis and access database only. so i guess my question is can i
use
webservices with asp classic?

"Ken Cox [Microsoft MVP]" wrote:

If you are trying to get data from an Access database across sites (on
different machines), you'll want to investigate calling a Web service on
the
remote site.

The Web service will fetch the data from Access and return it to your
page.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

>I am making a asp page that will run on my computer by iis. But the
>problem
> is the database in on a web server. I can not seem to get the
> connection
> to
> work for it though here his the connection and the error. Any help
> please.
>
> Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"
>
> Error: Microsoft JET Database Engine (0x80004005)
> Not a valid file name.
> /Default.asp, line 40
>
> Thanks,
>
> WStoreyII

[Kevin Spencer]

The DataSource must be a file path, not a URL.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

I am making a asp page that will run on my computer by iis. But the problem is the database in on a web server. I can not seem to get the connection to work for it though here his the connection and the error. Any help please.
Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

[WStoreyII]

Ken,

that tutorial that you sent me does not use Vs.Net, do you know of a way to
do it with vs.net becuase that is alls that i have.

Thanks Again

WStoreyII

"Ken Cox [Microsoft MVP]" wrote:

It isn't as easy as with ASP.NET but you can certainly do it:

Creating Web Services with ASP

http://www.4guysfromrolla.com/webtech/070401-1.shtml

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...

Ken,

The problem is that i have a free webpage that comes with asp classic
capabilliteis and access database only. so i guess my question is can i
use
webservices with asp classic?

"Ken Cox [Microsoft MVP]" wrote:

If you are trying to get data from an Access database across sites (on
different machines), you'll want to investigate calling a Web service on
the
remote site.

The Web service will fetch the data from Access and return it to your
page.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...
>I am making a asp page that will run on my computer by iis. But the
>problem
> is the database in on a web server. I can not seem to get the
> connection
> to
> work for it though here his the connection and the error. Any help
> please.
>
> Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"
>
> Error: Microsoft JET Database Engine (0x80004005)
> Not a valid file name.
> /Default.asp, line 40
>
> Thanks,
>
> WStoreyII

[Jonas Blunck]

WStoreyII wrote:

I am making a asp page that will run on my computer by iis. But the problem
is the database in on a web server. I can not seem to get the connection to
work for it though here his the connection and the error. Any help please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

ConnectionsStrings.com [1] is your friend if you have problems with your
connection string.

HTH,
Jonas

[1] http://www.connectionstrings.com/

[Ken Cox [Microsoft MVP]]

I must be missing something because you are talking about using ASP Classic
rather than ASP.NET.

In any event, you can edit either in VS.NET's editor.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:F4**********************************@microsof t.com...

Ken,

that tutorial that you sent me does not use Vs.Net, do you know of a way
to
do it with vs.net becuase that is alls that i have.

Thanks Again

WStoreyII

"Ken Cox [Microsoft MVP]" wrote:

It isn't as easy as with ASP.NET but you can certainly do it:

Creating Web Services with ASP

http://www.4guysfromrolla.com/webtech/070401-1.shtml

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...

> Ken,
>
> The problem is that i have a free webpage that comes with asp classic
> capabilliteis and access database only. so i guess my question is can
> i
> use
> webservices with asp classic?
>
> "Ken Cox [Microsoft MVP]" wrote:
>

[WStoreyII]

Ken,

Heres the situation. I am making a program for my wife and I, that will
allow us to view and edit information in a database on seperate computers so
i have put the database on a website that was free. Since this website only
use's classic asp and ms access database. I can not access the database from
my code. So i need a webservice or other means of accessing the database
from the server and downloading the informatin. But the tutorial that you
gave me to make a webservice in asp classic does not use .net and .net tools
are the only tools that i have so i was wondering if there was a way to make
it compatable with .net ?

Thanks

WStoreyII

"Ken Cox [Microsoft MVP]" wrote:

I must be missing something because you are talking about using ASP Classic
rather than ASP.NET.

In any event, you can edit either in VS.NET's editor.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:F4**********************************@microsof t.com...

Ken,

that tutorial that you sent me does not use Vs.Net, do you know of a way
to
do it with vs.net becuase that is alls that i have.

Thanks Again

WStoreyII

"Ken Cox [Microsoft MVP]" wrote:

It isn't as easy as with ASP.NET but you can certainly do it:

Creating Web Services with ASP

http://www.4guysfromrolla.com/webtech/070401-1.shtml

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...
> Ken,
>
> The problem is that i have a free webpage that comes with asp classic
> capabilliteis and access database only. so i guess my question is can
> i
> use
> webservices with asp classic?
>
> "Ken Cox [Microsoft MVP]" wrote:
>

[Scott M.]

After you upload your Access database to the free hosting server, run a
simple test asp page that has this in it:

<%
response.write("<P>The physical path to the database is:")
response.write(Request.ServerVariables(Server.MapP ath("[put relative path to
your database here]") & "<P>")
%>

And run the page. You will now know the exact physical path you need to
enter into your connection string.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...

Ken,

Heres the situation. I am making a program for my wife and I, that will
allow us to view and edit information in a database on seperate computers
so
i have put the database on a website that was free. Since this website
only
use's classic asp and ms access database. I can not access the database
from
my code. So i need a webservice or other means of accessing the database
from the server and downloading the informatin. But the tutorial that you
gave me to make a webservice in asp classic does not use .net and .net
tools
are the only tools that i have so i was wondering if there was a way to
make
it compatable with .net ?

Thanks

WStoreyII

"Ken Cox [Microsoft MVP]" wrote:

I must be missing something because you are talking about using ASP
Classic
rather than ASP.NET.

In any event, you can edit either in VS.NET's editor.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:F4**********************************@microsof t.com...

> Ken,
>
> that tutorial that you sent me does not use Vs.Net, do you know of a
> way
> to
> do it with vs.net becuase that is alls that i have.
>
> Thanks Again
>
> WStoreyII
>
> "Ken Cox [Microsoft MVP]" wrote:
>
>> It isn't as easy as with ASP.NET but you can certainly do it:
>>
>> Creating Web Services with ASP
>>
>> http://www.4guysfromrolla.com/webtech/070401-1.shtml
>>
>> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
>> news:D1**********************************@microsof t.com...
>> > Ken,
>> >
>> > The problem is that i have a free webpage that comes with asp
>> > classic
>> > capabilliteis and access database only. so i guess my question is
>> > can
>> > i
>> > use
>> > webservices with asp classic?
>> >
>> > "Ken Cox [Microsoft MVP]" wrote:
>> >

[WStoreyII]

That did not work ?

WStoreyII

"Scott M." wrote:

After you upload your Access database to the free hosting server, run a
simple test asp page that has this in it:

<%
response.write("<P>The physical path to the database is:")
response.write(Request.ServerVariables(Server.MapP ath("[put relative path to
your database here]") & "<P>")
%>

And run the page. You will now know the exact physical path you need to
enter into your connection string.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...

Ken,

Heres the situation. I am making a program for my wife and I, that will
allow us to view and edit information in a database on seperate computers
so
i have put the database on a website that was free. Since this website
only
use's classic asp and ms access database. I can not access the database
from
my code. So i need a webservice or other means of accessing the database
from the server and downloading the informatin. But the tutorial that you
gave me to make a webservice in asp classic does not use .net and .net
tools
are the only tools that i have so i was wondering if there was a way to
make
it compatable with .net ?

Thanks

WStoreyII

"Ken Cox [Microsoft MVP]" wrote:

I must be missing something because you are talking about using ASP
Classic
rather than ASP.NET.

In any event, you can edit either in VS.NET's editor.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:F4**********************************@microsof t.com...
> Ken,
>
> that tutorial that you sent me does not use Vs.Net, do you know of a
> way
> to
> do it with vs.net becuase that is alls that i have.
>
> Thanks Again
>
> WStoreyII
>
> "Ken Cox [Microsoft MVP]" wrote:
>
>> It isn't as easy as with ASP.NET but you can certainly do it:
>>
>> Creating Web Services with ASP
>>
>> http://www.4guysfromrolla.com/webtech/070401-1.shtml
>>
>> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
>> news:D1**********************************@microsof t.com...
>> > Ken,
>> >
>> > The problem is that i have a free webpage that comes with asp
>> > classic
>> > capabilliteis and access database only. so i guess my question is
>> > can
>> > i
>> > use
>> > webservices with asp classic?
>> >
>> > "Ken Cox [Microsoft MVP]" wrote:
>> >

[WStoreyII]

Alls i need to do is to be able to use the webservice on the server even
though it uses classic asp. but the only tools that i have to do this are
vs.net. I just need to use the server as a storage for the database and i
wish to be able to use the webservice to access and mutate it. i dont need
to be able to use it in asp or anything i just need to get the data and sent
them back to my computer from the infor mation on the server. Does anyone
know how to do this or is it not possible?

Thanks

WStoreyII

"WStoreyII" wrote:

That did not work ?

WStoreyII

"Scott M." wrote:

After you upload your Access database to the free hosting server, run a
simple test asp page that has this in it:

<%
response.write("<P>The physical path to the database is:")
response.write(Request.ServerVariables(Server.MapP ath("[put relative path to
your database here]") & "<P>")
%>

And run the page. You will now know the exact physical path you need to
enter into your connection string.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...

Ken,

Heres the situation. I am making a program for my wife and I, that will
allow us to view and edit information in a database on seperate computers
so
i have put the database on a website that was free. Since this website
only
use's classic asp and ms access database. I can not access the database
from
my code. So i need a webservice or other means of accessing the database
from the server and downloading the informatin. But the tutorial that you
gave me to make a webservice in asp classic does not use .net and .net
tools
are the only tools that i have so i was wondering if there was a way to
make
it compatable with .net ?

Thanks

WStoreyII

"Ken Cox [Microsoft MVP]" wrote:

> I must be missing something because you are talking about using ASP
> Classic
> rather than ASP.NET.
>
> In any event, you can edit either in VS.NET's editor.
>
> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
> news:F4**********************************@microsof t.com...
> > Ken,
> >
> > that tutorial that you sent me does not use Vs.Net, do you know of a
> > way
> > to
> > do it with vs.net becuase that is alls that i have.
> >
> > Thanks Again
> >
> > WStoreyII
> >
> > "Ken Cox [Microsoft MVP]" wrote:
> >
> >> It isn't as easy as with ASP.NET but you can certainly do it:
> >>
> >> Creating Web Services with ASP
> >>
> >> http://www.4guysfromrolla.com/webtech/070401-1.shtml
> >>
> >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
> >> news:D1**********************************@microsof t.com...
> >> > Ken,
> >> >
> >> > The problem is that i have a free webpage that comes with asp
> >> > classic
> >> > capabilliteis and access database only. so i guess my question is
> >> > can
> >> > i
> >> > use
> >> > webservices with asp classic?
> >> >
> >> > "Ken Cox [Microsoft MVP]" wrote:
> >> >
>
>

[rmunson8]

I have the same issue, but didn't see a resolution. From what I have read, a
physical path on a machine is needed for the Data Source property of the
connection string. How can this be specified if the file is located on a
remote server?

"WStoreyII" wrote:

Alls i need to do is to be able to use the webservice on the server even
though it uses classic asp. but the only tools that i have to do this are
vs.net. I just need to use the server as a storage for the database and i
wish to be able to use the webservice to access and mutate it. i dont need
to be able to use it in asp or anything i just need to get the data and sent
them back to my computer from the infor mation on the server. Does anyone
know how to do this or is it not possible?

Thanks

WStoreyII

"WStoreyII" wrote:

That did not work ?

WStoreyII

"Scott M." wrote:

After you upload your Access database to the free hosting server, run a
simple test asp page that has this in it:

<%
response.write("<P>The physical path to the database is:")
response.write(Request.ServerVariables(Server.MapP ath("[put relative path to
your database here]") & "<P>")
%>

And run the page. You will now know the exact physical path you need to
enter into your connection string.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...
> Ken,
>
> Heres the situation. I am making a program for my wife and I, that will
> allow us to view and edit information in a database on seperate computers
> so
> i have put the database on a website that was free. Since this website
> only
> use's classic asp and ms access database. I can not access the database
> from
> my code. So i need a webservice or other means of accessing the database
> from the server and downloading the informatin. But the tutorial that you
> gave me to make a webservice in asp classic does not use .net and .net
> tools
> are the only tools that i have so i was wondering if there was a way to
> make
> it compatable with .net ?
>
> Thanks
>
> WStoreyII
>
> "Ken Cox [Microsoft MVP]" wrote:
>
>> I must be missing something because you are talking about using ASP
>> Classic
>> rather than ASP.NET.
>>
>> In any event, you can edit either in VS.NET's editor.
>>
>> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
>> news:F4**********************************@microsof t.com...
>> > Ken,
>> >
>> > that tutorial that you sent me does not use Vs.Net, do you know of a
>> > way
>> > to
>> > do it with vs.net becuase that is alls that i have.
>> >
>> > Thanks Again
>> >
>> > WStoreyII
>> >
>> > "Ken Cox [Microsoft MVP]" wrote:
>> >
>> >> It isn't as easy as with ASP.NET but you can certainly do it:
>> >>
>> >> Creating Web Services with ASP
>> >>
>> >> http://www.4guysfromrolla.com/webtech/070401-1.shtml
>> >>
>> >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
>> >> news:D1**********************************@microsof t.com...
>> >> > Ken,
>> >> >
>> >> > The problem is that i have a free webpage that comes with asp
>> >> > classic
>> >> > capabilliteis and access database only. so i guess my question is
>> >> > can
>> >> > i
>> >> > use
>> >> > webservices with asp classic?
>> >> >
>> >> > "Ken Cox [Microsoft MVP]" wrote:
>> >> >
>>
>>

[Scott M.]

After you upload your Access database to the free hosting server, run a
simple test asp page that has this in it:

<%
response.write("<P>The physical path to the database is:")
response.write(Request.ServerVariables(Server.MapP ath("[put relative path to
your database here]") & "<P>")
%>

And run the page. You will now know the exact physical path you need to
enter into your connection string.

"rmunson8" <rm******@discussions.microsoft.com> wrote in message
news:0C**********************************@microsof t.com...

I have the same issue, but didn't see a resolution. From what I have read,
a
physical path on a machine is needed for the Data Source property of the
connection string. How can this be specified if the file is located on a
remote server?

"WStoreyII" wrote:

Alls i need to do is to be able to use the webservice on the server even
though it uses classic asp. but the only tools that i have to do this
are
vs.net. I just need to use the server as a storage for the database and
i
wish to be able to use the webservice to access and mutate it. i dont
need
to be able to use it in asp or anything i just need to get the data and
sent
them back to my computer from the infor mation on the server. Does
anyone
know how to do this or is it not possible?

Thanks

WStoreyII

"WStoreyII" wrote:

> That did not work ?
>
> WStoreyII
>
> "Scott M." wrote:
>
> > After you upload your Access database to the free hosting server, run
> > a
> > simple test asp page that has this in it:
> >
> > <%
> > response.write("<P>The physical path to the database is:")
> > response.write(Request.ServerVariables(Server.MapP ath("[put relative
> > path to
> > your database here]") & "<P>")
> > %>
> >
> > And run the page. You will now know the exact physical path you need
> > to
> > enter into your connection string.
> >
> > "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
> > news:C8**********************************@microsof t.com...
> > > Ken,
> > >
> > > Heres the situation. I am making a program for my wife and I, that
> > > will
> > > allow us to view and edit information in a database on seperate
> > > computers
> > > so
> > > i have put the database on a website that was free. Since this
> > > website
> > > only
> > > use's classic asp and ms access database. I can not access the
> > > database
> > > from
> > > my code. So i need a webservice or other means of accessing the
> > > database
> > > from the server and downloading the informatin. But the tutorial
> > > that you
> > > gave me to make a webservice in asp classic does not use .net and
> > > .net
> > > tools
> > > are the only tools that i have so i was wondering if there was a
> > > way to
> > > make
> > > it compatable with .net ?
> > >
> > > Thanks
> > >
> > > WStoreyII
> > >
> > > "Ken Cox [Microsoft MVP]" wrote:
> > >
> > >> I must be missing something because you are talking about using
> > >> ASP
> > >> Classic
> > >> rather than ASP.NET.
> > >>
> > >> In any event, you can edit either in VS.NET's editor.
> > >>
> > >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
> > >> news:F4**********************************@microsof t.com...
> > >> > Ken,
> > >> >
> > >> > that tutorial that you sent me does not use Vs.Net, do you know
> > >> > of a
> > >> > way
> > >> > to
> > >> > do it with vs.net becuase that is alls that i have.
> > >> >
> > >> > Thanks Again
> > >> >
> > >> > WStoreyII
> > >> >
> > >> > "Ken Cox [Microsoft MVP]" wrote:
> > >> >
> > >> >> It isn't as easy as with ASP.NET but you can certainly do it:
> > >> >>
> > >> >> Creating Web Services with ASP
> > >> >>
> > >> >> http://www.4guysfromrolla.com/webtech/070401-1.shtml
> > >> >>
> > >> >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in
> > >> >> message
> > >> >> news:D1**********************************@microsof t.com...
> > >> >> > Ken,
> > >> >> >
> > >> >> > The problem is that i have a free webpage that comes with asp
> > >> >> > classic
> > >> >> > capabilliteis and access database only. so i guess my
> > >> >> > question is
> > >> >> > can
> > >> >> > i
> > >> >> > use
> > >> >> > webservices with asp classic?
> > >> >> >
> > >> >> > "Ken Cox [Microsoft MVP]" wrote:
> > >> >> >
> > >>
> > >>
> >
> >
> >

[rmunson8]

Thanks Scott. I was able to get the server's absolute machine path, but
after using that in the connection string I received permission errors about
going across domains. I can work with my hosting provider to see about the
permission issue, but this seems like a solution that could be very unstable.
If my hosting provider changes the directory, this solution would break.
But I image of the Jet Provider doesn't allow for url paths, there isn't much
I can do.

Ryan

"Scott M." wrote:

After you upload your Access database to the free hosting server, run a
simple test asp page that has this in it:

<%
response.write("<P>The physical path to the database is:")
response.write(Request.ServerVariables(Server.MapP ath("[put relative path to
your database here]") & "<P>")
%>

And run the page. You will now know the exact physical path you need to
enter into your connection string.

"rmunson8" <rm******@discussions.microsoft.com> wrote in message
news:0C**********************************@microsof t.com...

I have the same issue, but didn't see a resolution. From what I have read,
a
physical path on a machine is needed for the Data Source property of the
connection string. How can this be specified if the file is located on a
remote server?

"WStoreyII" wrote:

Alls i need to do is to be able to use the webservice on the server even
though it uses classic asp. but the only tools that i have to do this
are
vs.net. I just need to use the server as a storage for the database and
i
wish to be able to use the webservice to access and mutate it. i dont
need
to be able to use it in asp or anything i just need to get the data and
sent
them back to my computer from the infor mation on the server. Does
anyone
know how to do this or is it not possible?

Thanks

WStoreyII

"WStoreyII" wrote:

> That did not work ?
>
> WStoreyII
>
> "Scott M." wrote:
>
> > After you upload your Access database to the free hosting server, run
> > a
> > simple test asp page that has this in it:
> >
> > <%
> > response.write("<P>The physical path to the database is:")
> > response.write(Request.ServerVariables(Server.MapP ath("[put relative
> > path to
> > your database here]") & "<P>")
> > %>
> >
> > And run the page. You will now know the exact physical path you need
> > to
> > enter into your connection string.
> >
> > "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
> > news:C8**********************************@microsof t.com...
> > > Ken,
> > >
> > > Heres the situation. I am making a program for my wife and I, that
> > > will
> > > allow us to view and edit information in a database on seperate
> > > computers
> > > so
> > > i have put the database on a website that was free. Since this
> > > website
> > > only
> > > use's classic asp and ms access database. I can not access the
> > > database
> > > from
> > > my code. So i need a webservice or other means of accessing the
> > > database
> > > from the server and downloading the informatin. But the tutorial
> > > that you
> > > gave me to make a webservice in asp classic does not use .net and
> > > .net
> > > tools
> > > are the only tools that i have so i was wondering if there was a
> > > way to
> > > make
> > > it compatable with .net ?
> > >
> > > Thanks
> > >
> > > WStoreyII
> > >
> > > "Ken Cox [Microsoft MVP]" wrote:
> > >
> > >> I must be missing something because you are talking about using
> > >> ASP
> > >> Classic
> > >> rather than ASP.NET.
> > >>
> > >> In any event, you can edit either in VS.NET's editor.
> > >>
> > >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
> > >> news:F4**********************************@microsof t.com...
> > >> > Ken,
> > >> >
> > >> > that tutorial that you sent me does not use Vs.Net, do you know
> > >> > of a
> > >> > way
> > >> > to
> > >> > do it with vs.net becuase that is alls that i have.
> > >> >
> > >> > Thanks Again
> > >> >
> > >> > WStoreyII
> > >> >
> > >> > "Ken Cox [Microsoft MVP]" wrote:
> > >> >
> > >> >> It isn't as easy as with ASP.NET but you can certainly do it:
> > >> >>
> > >> >> Creating Web Services with ASP
> > >> >>
> > >> >> http://www.4guysfromrolla.com/webtech/070401-1.shtml
> > >> >>
> > >> >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in
> > >> >> message
> > >> >> news:D1**********************************@microsof t.com...
> > >> >> > Ken,
> > >> >> >
> > >> >> > The problem is that i have a free webpage that comes with asp
> > >> >> > classic
> > >> >> > capabilliteis and access database only. so i guess my
> > >> >> > question is
> > >> >> > can
> > >> >> > i
> > >> >> > use
> > >> >> > webservices with asp classic?
> > >> >> >
> > >> >> > "Ken Cox [Microsoft MVP]" wrote:
> > >> >> >
> > >>
> > >>
> >
> >
> >

[Scott M.]

You don't have permission to the folders of your own site? You should just
upload the access database to a sub-folder within your own site. Since this
folder will be on the same machine and directory as the rest of the
files/folders in your site, the absolute physical path to your site root is
the same for all of your site content. It wouldn't be on a different domain
than everything else in your site.

And, no the JET provider must have a file path, not a URL in the connection
string.

"rmunson8" <rm******@discussions.microsoft.com> wrote in message
news:AB**********************************@microsof t.com...

Thanks Scott. I was able to get the server's absolute machine path, but
after using that in the connection string I received permission errors
about
going across domains. I can work with my hosting provider to see about
the
permission issue, but this seems like a solution that could be very
unstable.
If my hosting provider changes the directory, this solution would break.
But I image of the Jet Provider doesn't allow for url paths, there isn't
much
I can do.

Ryan

"Scott M." wrote:

After you upload your Access database to the free hosting server, run a
simple test asp page that has this in it:

<%
response.write("<P>The physical path to the database is:")
response.write(Request.ServerVariables(Server.MapP ath("[put relative path
to
your database here]") & "<P>")
%>

And run the page. You will now know the exact physical path you need to
enter into your connection string.

"rmunson8" <rm******@discussions.microsoft.com> wrote in message
news:0C**********************************@microsof t.com...

>I have the same issue, but didn't see a resolution. From what I have
>read,
>a
> physical path on a machine is needed for the Data Source property of
> the
> connection string. How can this be specified if the file is located on
> a
> remote server?
>
> "WStoreyII" wrote:
>
>> Alls i need to do is to be able to use the webservice on the server
>> even
>> though it uses classic asp. but the only tools that i have to do this
>> are
>> vs.net. I just need to use the server as a storage for the database
>> and
>> i
>> wish to be able to use the webservice to access and mutate it. i dont
>> need
>> to be able to use it in asp or anything i just need to get the data
>> and
>> sent
>> them back to my computer from the infor mation on the server. Does
>> anyone
>> know how to do this or is it not possible?
>>
>> Thanks
>>
>> WStoreyII
>>
>> "WStoreyII" wrote:
>>
>> > That did not work ?
>> >
>> > WStoreyII
>> >
>> > "Scott M." wrote:
>> >
>> > > After you upload your Access database to the free hosting server,
>> > > run
>> > > a
>> > > simple test asp page that has this in it:
>> > >
>> > > <%
>> > > response.write("<P>The physical path to the database is:")
>> > > response.write(Request.ServerVariables(Server.MapP ath("[put
>> > > relative
>> > > path to
>> > > your database here]") & "<P>")
>> > > %>
>> > >
>> > > And run the page. You will now know the exact physical path you
>> > > need
>> > > to
>> > > enter into your connection string.
>> > >
>> > > "WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
>> > > news:C8**********************************@microsof t.com...
>> > > > Ken,
>> > > >
>> > > > Heres the situation. I am making a program for my wife and I,
>> > > > that
>> > > > will
>> > > > allow us to view and edit information in a database on seperate
>> > > > computers
>> > > > so
>> > > > i have put the database on a website that was free. Since this
>> > > > website
>> > > > only
>> > > > use's classic asp and ms access database. I can not access the
>> > > > database
>> > > > from
>> > > > my code. So i need a webservice or other means of accessing the
>> > > > database
>> > > > from the server and downloading the informatin. But the
>> > > > tutorial
>> > > > that you
>> > > > gave me to make a webservice in asp classic does not use .net
>> > > > and
>> > > > .net
>> > > > tools
>> > > > are the only tools that i have so i was wondering if there was a
>> > > > way to
>> > > > make
>> > > > it compatable with .net ?
>> > > >
>> > > > Thanks
>> > > >
>> > > > WStoreyII
>> > > >
>> > > > "Ken Cox [Microsoft MVP]" wrote:
>> > > >
>> > > >> I must be missing something because you are talking about using
>> > > >> ASP
>> > > >> Classic
>> > > >> rather than ASP.NET.
>> > > >>
>> > > >> In any event, you can edit either in VS.NET's editor.
>> > > >>
>> > > >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in
>> > > >> message
>> > > >> news:F4**********************************@microsof t.com...
>> > > >> > Ken,
>> > > >> >
>> > > >> > that tutorial that you sent me does not use Vs.Net, do you
>> > > >> > know
>> > > >> > of a
>> > > >> > way
>> > > >> > to
>> > > >> > do it with vs.net becuase that is alls that i have.
>> > > >> >
>> > > >> > Thanks Again
>> > > >> >
>> > > >> > WStoreyII
>> > > >> >
>> > > >> > "Ken Cox [Microsoft MVP]" wrote:
>> > > >> >
>> > > >> >> It isn't as easy as with ASP.NET but you can certainly do
>> > > >> >> it:
>> > > >> >>
>> > > >> >> Creating Web Services with ASP
>> > > >> >>
>> > > >> >> http://www.4guysfromrolla.com/webtech/070401-1.shtml
>> > > >> >>
>> > > >> >> "WStoreyII" <WS*******@discussions.microsoft.com> wrote in
>> > > >> >> message
>> > > >> >> news:D1**********************************@microsof t.com...
>> > > >> >> > Ken,
>> > > >> >> >
>> > > >> >> > The problem is that i have a free webpage that comes with
>> > > >> >> > asp
>> > > >> >> > classic
>> > > >> >> > capabilliteis and access database only. so i guess my
>> > > >> >> > question is
>> > > >> >> > can
>> > > >> >> > i
>> > > >> >> > use
>> > > >> >> > webservices with asp classic?
>> > > >> >> >
>> > > >> >> > "Ken Cox [Microsoft MVP]" wrote:
>> > > >> >> >
>> > > >>
>> > > >>
>> > >
>> > >
>> > >