Help needed please please

PhillipMorris · August 21st, 2003, 09:01 AM

I am trying to build a project that has access to a database stored in a web server. I uploaded my database in a free hosting site like websamba and i don't know how to access it from my app. I am sure that it could be done using asp code but i am getting mixed up with DSN or DSNless asp code.
Can someone help me please. I am desperate...

pgtips · August 21st, 2003, 09:41 AM

I just had a look at websamba and I see they offer "Free ODBC System DSN Setup". So it would seem the easiest way for you is to get a system DSN set up and use that to connect to your db like this:

Code:

Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=whateverNameItUses"
...

hth
Phil

PhillipMorris · September 10th, 2003, 01:00 AM

Well, the problem is that I cannot use the DSN setup. The websites don't allow that option...

Thanks anyway...

pgtips · September 10th, 2003, 03:15 AM

Well then you'll have to use DSN-less connection. You need to find out the relative path from your asp page to the database and build your connection string accordingly. You don't say what rdbms it is (Edited - oops just realised this is the Access forum so use the Jet OLEDB driver examples in that link page), but there are examples of them all here: http://www.able-consulting.com/ADO_Conn.htm

DaveGerard · September 23rd, 2003, 11:39 PM

Maybe this can help. Let me know if it does okay or at least comes close.

conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=path\whatever.mdb"
OR better yet
conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../whatever.mdb")

Then set and open your recordset...

set rs = server.createobject("adodb.recordset")
sql = "select * from table"
rs.open sql, conn, 3, 3

NOTE: 3, 3 is write mode for Access I think.