database trying to open localy instead of off server.

[Lash]

I have placed my database onto my webserver and opened the data access pages
in my browser
but all the pages are trying to open the database on my local computer.
How can I tell this connection string to look on my webserver for the
database.

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;
Data source=d:\webs\dbtest\fpdb\database.mdb

thankyou

Lash
(e-mail address removed)

 

[Pat Hartman]

"d:\webs\dbtest\fpdb\database.mdb" needs to be the address of the db on the
web server. I think you probably have to use UNC notation rather than a
drive letter.

 

[Lash]

Thank you Pat for your help,

The shown address is an absolute address on the web server

However the page looks for a local D: drive instead of using

The D: drive on the server.

I can see that Front Page will insert database components

with a connection to the DSN name of the database but access

builds the connection string shown.

Can I tell the page to use the DSN connection?

 

[Pat Hartman]

Change the reference to:
\\yourservername\webs\dbtest\fpdb\database.mdb

 

[Lash]

thank you Pat,
however it still does not work.
the server is not on my local area network
the only connection I can make to the server
is via http://www.lash.com.au or ftp://www.lash.com.au
and bot of these fail if I use them in the connection string.
the physical address I have in my connection string is correct
and points to the database in my frontpage web however when the asp page is
loaded
into a browser it will not look on the server where the page came from, it
will look
only on the local computer where the browser is running.

I created the .asp page using access and it works perfectly so long as I
have the database.mdb file in the appropriate directory of my computer.

here is the beginning of the code perhaps you can see something that can be
changed
that will cause access/asp to look on the website for the database.

<OBJECT id=MSODSC tabIndex=-1 User
classid=CLSID:0002E553-0000-0000-C000-000000000046>
<PARAM NAME="XMLData" VALUE="<xml
xmlns:a=&quot;urn:schemas-microsoft-comffice:access&quot;>

<aataSourceControl>;

<a:OWCVersion>10.0.0.2621 </a:OWCVersion>

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=d:\webspace\lash.com.au\www\lash\fpdb\lash_computing.mdb;
Mode=Share Deny None;Extended Properties=&amp;quot;&amp;quot;;
Persist Security Info=False;
Jet OLEDB:System database=&amp;quot;&amp;quot;;
Jet OLEDB:Registry Path=&amp;quot;&amp;quot;;
Jet OLEDBatabase Password=&amp;quot;&amp;quot;;
Jet OLEDB:Engine Type=0;
Jet OLEDBatabase Locking Mode=1;
Jet OLEDB:Global Partial Bulk Ops=2;
Jet OLEDB:Global Bulk Transactions=1;
Jet OLEDB:New Database Password=&amp;quot;&amp;quot;;
Jet OLEDB:Create System Database=False;
Jet OLEDB:Encrypt Database=False;
Jet OLEDBon't Copy Locale on Compact=False;
Jet OLEDB:Compact Without Replica Repair=False;
Jet OLEDB:SFP=False</a:ConnectionString>


thankyou for your help.

Lash
lashatlashdotcomdotau

 

[Pat Hartman]

When I have trouble getting connection strings right, I manually link to a
table on the server and then open the MSysObjects table and copy the
connection string from there. Try it. Use the network places object to
navigate to the server.