Forums

ASP

This topic is locked

DSN LESS

Posted 08 Apr 2003 05:54:11
1
has voted
08 Apr 2003 05:54:11 Mohd Khalil posted:
I did a business portal and it work well on my local server but could not load when uploaded to the real server.

I tried a lot of dsn less codes but it still didn't work. There is something wrong with my DSN Less code. Can you guys tell me what it is. I develop my my portal using Ultradev 4 and Access(Javascript technology). My host uploaded their test page and they say it work fine.
The site address is www.biz.com.my
and the test page is www.biz.com.my/test/testgrid.asp

My codes are <%
// FileName="Connection_ado_conn_string.htm"
// Type="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
var MM_biz_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=biz.com.my/db/business.mdb"
%>



Replies

Replied 08 Apr 2003 15:26:14
08 Apr 2003 15:26:14 Owen Eastwick replied:
The path should be a physical path, something like: D:/WebDirectory/DataBaseDirectory/Database.mdb

You can use Server.MapPatch to determine the physical directory structure of you web server, have a read, see if this helps: www.drdev.net/article09.htm

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/
Replied 16 Apr 2003 00:46:37
16 Apr 2003 00:46:37 Dan Berdusco replied:
There is a free dreamweaver extension that caninserted on a page and will find the database path for you using mappath. It is called Get Database Path and you can find it here:

www.basic-ultradev.com/extensions/index.asp

Reply to this topic