Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 496
  • Last Modified:

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
0
fledermaus
Asked:
fledermaus
  • 6
  • 3
  • 3
  • +2
1 Solution
 
thunderchickenCommented:
Are you using Access or MS-SQL server?

If using Access, you have to have a common string set up to point to your access database.  Check the FAQ on Brinkster to set this up located at

http://www.brinkster.com/Forums/

or

http://www.brinkster.com/FAQ.asp
0
 
thunderchickenCommented:
0
 
hongjunCommented:
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
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
gnmaierCommented:
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.
%>

<!--#INCLUDE FILE="adovbs.inc"-->
<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>
0
 
thunderchickenCommented:
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?
0
 
hongjunCommented:
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
0
 
hongjunCommented:
The only area we need to keep note of is the connection part.

hongjun
0
 
gnmaierCommented:
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
 
0
 
hongjunCommented:
gnmaier,
It's okay as long as you realise it. We can wait for fledermaus to deal with it.

hongjun.
0
 
gnmaierCommented:
Fledermaus

please reject my answer.

Graham
0
 
hongjunCommented:
fledermaus,
so how's your progress?

hongjun
0
 
fledermausAuthor Commented:
as requested I 'll reject this answer - I'll look into the onther comments today and let you know...
0
 
hongjunCommented:
:)

hongjun
0
 
NetminderCommented:
fledermaus,

These questions are still open and our records indicate you logged in as recently as yesterday. Please resolve them appropriately as soon as possible. Continued disregard of your open questions will result in the force/acceptance of a comment as an answer; other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.

http://www.experts-exchange.com/jsp/qShow.jsp?qid=20119026
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20122329
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20159145
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20178879
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20182931
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20182979
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20195426
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20208486
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20235488
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20240167
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20240518
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20244663
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20241307
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20215489
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20182954
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20260609
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20262610

EXPERTS: Please leave your thoughts on this question here.

Thanks,

Netminder
Community Support Moderator
Experts Exchange
0
 
NetminderCommented:
Admin notified of user neglect. Force/accepted by

Netminder
Community Support Moderator
Experts Exchange
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 6
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now