Convert Db connection for use on web

[raycafc]

I've developed my site with all testing done on my PC. Now I want to upload the
entire site to the web, but what do I change my DB Connection string to?
Currently it is:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connNJB_STRING
MM_connNJB_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\NJB\Database\books.mdb;"
%>
But what would it be if I'm using, for example "www.njb.co.uk" please?

[CarlGrint]

YOu can use an ASP file to find the 'location' of your live site path.

I have a copy you can download, once unzipped, upload it to your website, next
to your home page, then browse to it, note the path it gives you.

Normally your database will go in a DB folder next to the www or htdocs
folder, so you just adjust the path given to accomodate this.

URL = [url]www.cgw3.co.uk/uploads/location.zip[/url]


Originally posted by: raycafc
I've developed my site with all testing done on my PC. Now I want to upload
the entire site to the web, but what do I change my DB Connection string to?
Currently it is:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connNJB_STRING
MM_connNJB_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\NJB\Database\books.mdb;"
%>
But what would it be if I'm using, for example "www.njb.co.uk" please?

[raycafc]

Thanks for your help. However I still have a problem...
Your program gave me a string of:
C:\Inetpub\vhosts\notjustbooks.co.uk\httpdocs\njb\ YourDB.mdb and I've tried
various permutations of this, such as:
httpdocs\njb\books.mdb, but I get errors returned, such as:
'c:\httpdocs\njb\books.mdb' is not a valid path. Make sure that the path name
is spelled correctly and that you are connected to the server on which the file
resides. So it still seems to think I'm using a local server rather than the
web itself. So I'd be grateful for any further help.

Thanks again

[CarlGrint]

Depending on the folder name of the db try

C:\Inetpub\vhosts\notjustbooks.co.uk\db\books.mdb

Originally posted by: raycafc
Thanks for your help. However I still have a problem...
Your program gave me a string of:
C:\Inetpub\vhosts\notjustbooks.co.uk\httpdocs\njb\ YourDB.mdb and I've tried
various permutations of this, such as:
httpdocs\njb\books.mdb, but I get errors returned, such as:
'c:\httpdocs\njb\books.mdb' is not a valid path. Make sure that the path name
is spelled correctly and that you are connected to the server on which the file
resides. So it still seems to think I'm using a local server rather than the
web itself. So I'd be grateful for any further help.

Thanks again

[raycafc]

I haven't tried it yet, but if you're specifying C: doesn't that mean that you're testing on your PC?

[CarlGrint]

I was just copying the string you pasted from the page I gave you...so that is
why C is there, but don't forget the hosting server is a PC to, it has C, D, E
drives just like your home pc, so it has to be one or the other.


Originally posted by: raycafc
I haven't tried it yet, but if you're specifying C: doesn't that mean that
you're testing on your PC?

[Alexandro Colorado]

Can't it be a relative link instead of a root link taking place form your
home folder like:
notjustbooks.co.uk\db\books.mdb

or even
db\books.mdb

On Sun, 6 Mar 2005 15:37:39 +0000 (UTC), CarlGrint
<webforumsuser@macromedia.com> wrote:

> I was just copying the string you pasted from the page I gave you...so
> that is
> why C is there, but don't forget the hosting server is a PC to, it has
> C, D, E
> drives just like your home pc, so it has to be one or the other.
>
>
> Originally posted by: raycafc
> I haven't tried it yet, but if you're specifying C: doesn't that mean
> that
> you're testing on your PC?
>
>
>

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

[raycafc]

I find this connection thing so confusing, but I've sorted it anyway. Thanks to
those who helped, maybe I didn't ask the right question, but eventually I
managed to sort it with the following:
MM_connNJB_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" &
Server.MapPath("Database\books.mdb")