asked on

ASP, Dreamweaver Ultradev and Brinkster

Hi there,

I know I'm an absolute beginner, but anyhow:

does anyone has experience using Dreamweaver Ultradev and publishing that site on brinkster.com ?

I always get an error regarding ODBC and more of that. I would really appreciate that someone could tell me how to configure my database in Dreamweaver ultradev so I can use it on brinkster.

I know this can be hard, that's why so many points are involved.

Sorry if this is a stupid question, but I'm learning...

;-)

tnx in advance,

fledermaus

ASKER CERTIFIED SOLUTION

thunderchicken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thunderchicken

Here's the db connection BTW: http://www.brinkster.com/PremiumDatabaseGuide.asp

hongjun

Change all connection strings to something like this

<%
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\member_name\db\your_db.mdb"))
%>

Format is as below and you would need to change member_name and your_db accordingly.
Server.MapPath("\member_name\db\your_db.mdb"))

Please note that your mdb file needs to be placed in the brinkster-created db folder.

hongjun

gnmaier

Fledermaus,

Hongjun above is quite right with his code. Below is a bit of an example of how to display the records in your Access database. I have used the normal OLEDB connection string instead of the ODBC string shown above. Both will work fine with Brinkster. For clarity you might want to delete the notes.

Graham
----------------------------------------------

<%Option Explicit%>
<html>
<head>
<title>Show Records</title>
</head>

<% 'Note: copy the file adovbs.inc into the same directory
'as the .asp file. You can find it in:
'C:\Program Files\Common Files\SYSTEM\ADO. on your local machine.
%>


<body>
<%

dim conn, rs, SQL, DSN
set conn = server.CreateObject("ADODB.Connection")
set rs = server.CreateObject("ADODB.Recordset")

'Notes:
' Replace MyAccount with your Brinkster account name
' Replace MyDB.mdb with your database name which must be uploaded
' to Brinkster's db directory
' Replace MyTable with your Access table or query name
' Replace Fieldname1, Fieldname2 etc with the field names in your
' Access table.

DSN = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;"
DSN = DSN & "DATA SOURCE = " & Server.Mappath("\MyAccount\db\MyDB.mdb")

conn.open DSN

SQL = "Select * From MyTable "

rs.Open SQL, conn, adOpenKeyset, adLockPessimistic

do until rs.eof 'keep going until the end of file

response.write rs("Fieldname1") & "<BR>")
response.write rs("Fieldname2") & "<BR>")
'and so on. . .

rs.movenext

loop

%>
</body>
</html>

thunderchicken

The link I provided above will show exactly. Don't propose an answer like that.

> Hongjun above is quite right with his code.

And you propose that as your answer?

hongjun

gnmaier,

You are here long enough to know EE policy. The policy here is to post everyhing in comments. Questionner will then have the option to accept a comment as an answer. Posting as a proposed answer will lock the question and thus restrict the exposure to more experts. We know you are new here and thus is forgiven. With the current version of EE, you do not have the option to convert your answer to a comment but this can be done by the questioner himself. I advise the questionner to reject his answer so that this question will be released to more experts. You can however accept his comment again if you find it is really helpful.

Thanks
hongjun

hongjun

The only area we need to keep note of is the connection part.

hongjun

gnmaier

Sorry hongjun,

I have only just read EE policy, never having posted an answer or comment before. Is there some way of undoing the proposed answer or changing it to a comment?

Graham

hongjun

gnmaier,
It's okay as long as you realise it. We can wait for fledermaus to deal with it.

hongjun.

gnmaier

Fledermaus

please reject my answer.

Graham

hongjun

fledermaus,
so how's your progress?

hongjun

fledermaus

ASKER

as requested I 'll reject this answer - I'll look into the onther comments today and let you know...

hongjun

:)

hongjun

Netminder

Netminder

Admin notified of user neglect. Force/accepted by

Netminder
Community Support Moderator
Experts Exchange