Connection String

[Guest]

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.

 

[VB Programmer]

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

 

[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.

 

[Guest]

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]]

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

 

[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

 

[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.

 

[Guest]

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

 

[Jonas Blunck]

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.

 

[Guest]

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

 

[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.MapPath("[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.

 

[Guest]

That did not work ?

WStoreyII

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.MapPath("[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.

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

 

[Guest]

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

That did not work ?

WStoreyII

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.MapPath("[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.

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

:

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.

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

:

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

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?

:

 

[Guest]

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?

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

That did not work ?

WStoreyII

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.MapPath("[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.

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

:

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.

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

:

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

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?

:

 

[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.MapPath("[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.

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?

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

That did not work ?

WStoreyII

:

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.MapPath("[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.

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

:

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.

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

:

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

message
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?

:

 

[Guest]

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

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.MapPath("[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.

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?

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

:

That did not work ?

WStoreyII

:

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.MapPath("[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.

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

:

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.

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

:

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

message
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?

:

 

[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.

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

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.MapPath("[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.

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?

:

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

:

That did not work ?

WStoreyII

:

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.MapPath("[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.

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

:

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.

message
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

:

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

message
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?

: