Troubleshooting Access Conn. In Dreamweaver
I have 3 db connections, 2 of which are dsnless connections to access db's. Any of my previous existing pages that have recordsets from these db's work fine. I can add a new recordset to them and it works fine as well.
If I create a new page and add the same recordset in the same directory, I get the error msg saying something like "unable to open registry key" which from my understanding, means the page cant find the db.
Now I am using Dreamweaver 2004, and using their way to create connections where it creates a file, and then just adds an include statement an asp page if you use that connection.
Any good way to test this connection on the page or any ideas on how to troubleshoot where the path its pointing to is incorrect...im pretty much stuck at this point.
View Replies
ADVERTISEMENT
I have a memo field that I'm using in Access via my development in Dreamweaver MX 2004.
In this field, rather than having it as a text field, I'm using it as a memo field to collect information
for our company. My question - is there a way for the text to do a hard return when I hit a hard return rather than
continuing to wrap.
Example, I would like the field to display as:
4+4=8
5+5=10
Rather than: 4+4=8 5+5=10, etc.
View Replies
View Related
Access database - fields Amount numeric
Opinion Yes/No
Dreamweaver form - when I use the insert record feature on my form - I can not get these fields to work.
I clarify the fields as numeric and checkbox Y,N
When I submit the form - I get Page can not be displayed error - if I make them text fields it works fine.
What do I need to do to correct this problem - I would prefer these fields to be numeric and Yes/No in the Access Database.
View Replies
View Related
I have the following connection string:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../_database/MOO_ACCESS.mdb") & ";"
Which tests successfully.
When I try to view the tables within Dreamweaver of the access database though, it shows none. There are definitely 2 tables built in the database.
anyone have any ideas?
View Replies
View Related
I am trying to establish a connection in Dreamweaver MX 2004 and an Access database for a log in ASP page, but keep getting an error. I am trying to establish "Custom Connection String" and here's what I type into the boxes that pop up:
1) CONNECTION NAME: ConnectToMyDB (I know, here I can put anything)
2) CONNECTION STING: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:Documents_and_SettingsJohn_SmithMy_Doc umentsJohnsSitedbJohnsWeb.mdb;
(tried with and without quotes around this)
3) Dreamweaver should connect: Using driver on Testing server
4) When I hit "TEST" I get an error "An unidentified error has occurred"
I am using Windows 2000. The database is in a db folder in the my defined site (moved it there). Is it the path I am typing in Dweaver or my Win2000 settings?
Hope someone can tell me what I am doing wrong. Is it my path to the database?
View Replies
View Related
Can anyone suggest a good way to check an ASP application for sloppy code,
unclosed data conections, etc? I have been given a large application with
many dozens of scripts. I would like to know if it is effecting server
perfomance.
There are no individual scripts that I can identify with
problems, but I am concerned that sloppy coding will cause problems when the
application starts to get more users.
View Replies
View Related
I am experiencing the following error from a particular XP workstation. The application has been in production for some time and the error only appears on one XP workstation. I have run Windows Update on this workstation. The error does not appear on a different XP workstation.
The error happens when I make a selection from the Category drop-down list. The subsequent drop-down list Subcategory should be automatically filtered. Code:
View Replies
View Related
I have a big application, about 800 asp pages.
Since we made a few changes, the processor usage on all 4 servers is constantly at 100%. iisreset cures this for a while.
Process Explorer reports that the main hog is the instance of dllhost.exe that manages the application in IIS to which we have made changes to common include files.
It is also racking up Page Faults of 3000 per second (not web page faults, memory faults).
How can I find out which piece of code is causing the processor to freak out so badly? Any tools out there?
View Replies
View Related
I have a some code:
Rs.Open "[TableName]", Conn, 1,3,2
RS.AddNew
RS.Fields("Account_Name").Value = request.Form("Account_Name")
my question is does conn, 1,3,2 only write to the database not making the data readable? if i change it to conn, 0,1 i get page can't be displayed. I'm using access DB, with conn 1,3,2 it inserts fine, but when i go to query it i get no records found, but i see the data in the database, anybody have any ideas?
View Replies
View Related
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open application("dtat_motor_connectionstring")
set rs = new adodb.recordset
'Set RS = Conn.Execute(' "exec spcn_update_transactions &
customer_number, customer_name, customer_address, customer_city,
customer_state, customer_zip, customer_phone, vin,
acct_number, tag, title_number, tag_type_number, branch_number,
institution_number, yr_make, state_from, type_number)
response.write rs
%>
I'm I connecting them correctly. Is there and easier way to execute a stored procedure. I'm trying to insert data into a SQL page. I have to have the customer number returned to me asap for the next page.
View Replies
View Related
I use this code all the time, but what does the ",,129" mean? Are there other parameters that one might use (I only do fairly simple SQL commands).
conn.execute strSQL,,129
View Replies
View Related
Is there any way to modify the locktype when updating a database via a connection object's execute method? I have a game which worked completely fine when only ten or so people were playing, but as it grew into the hundreds, many people started getting errors and I'm 99% sure that they occur when the database tries to update when it's locked, which means that my connection execute statements are defaulting to pessimistic locking, which I don't want them to. Does anyone know how I can fix this?
View Replies
View Related
what is the best way to protect the connection strings keeping an effective, low overheaded access to them ?
View Replies
View Related
I have a problem utilising my connection string to open more than one recordset in one ASP page.
The following code runs absolutley fine on a server running ASP 3, but falls over when run on a server running ASP 2 (the error says:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
The code I am trying to run is: Code:
View Replies
View Related
I searched the forum but I am still a little confused regarding the global.asa file. I created a global.asa file and it is in the root of the virdual directory. I then created a sub to initially connect to a datase such as: Code:
View Replies
View Related
What is the best way to control is a transaction? I've done a little test and both of the examples below seem to do the job, but I was wondering which is the better method, this:
If err.number <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
Or this:
If conn.Errors.Count <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
View Replies
View Related
I'm trying to access an access database by including the DB's password within the connection string. I try to connect to the DB, but I get and "Incorrect Password" error. What am I doing wrong?
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"; uid=admin; pwd="pass"
conn.Open(Server.Mappath("maindb.mdb"))
set rsUpdateEntry = Server.CreateObject("ADODB.recordset")
View Replies
View Related
I am currently working on a small asp application. Now I would like to store the complete database connection in the application object. Note I want to store the connection NOT the connectionstring. For that purpose I wrote a small asp include which connects to the dbase and stores the connection object to the application object. However when I use this include in my pages then it doesnt work. What I am doing wrong? Here is the code:
View Replies
View Related
I recently installed IIS lockdown, and ever since my ASP pages have been hell. One problem is that now after a user views my ASP page which reads my local Access DB, the temporary file, .ldb, stays in the folder forever!
This temp file is created when a user opens the file, so I checked out the .ldb file and it says the ADMINISTRATOR is opening the file! How can the internet user be using the ADMIN account?! This is not good news! I will share my code for my page; however I have a feeling the code isn't the problem, but a setting is. Code:
View Replies
View Related
Error info is as follows:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
Error Type:
error '8002801c'
Error accessing the OLE registry.
/iisHelp/common/500-100.asp, line 154
Is ADO a separate install? And from where?
View Replies
View Related
using dreamweaver mx,i created a 'jump menu' trying to do this below:
Code:
<option value="Settings/CT2004S1/setCT2004S1.asp?paper=Common Test 2004 Semester 1" selected>Common
but seem not possible..
<%response.write Request.QueryString("Paper")%>
View Replies
View Related
Dreamweaver MX has a behavior called Restrict Access To Page. It is not working for me. I have Access 2000 db set up and working. The registration and login pages work based on the database info. It is only this behavior I can not get to work. My db has a field AccessLevel. There I made sure I had admin entered to match to the Behavior condition. I still do not get access to the page even though the admin is the AccessLevel condition.
Here is the code.....
View Replies
View Related
I keep my church's website updated. Recently they got someone to do a new design. This guy used asp for all the pages and I know nothing about it. When I try to make updates I try to view the page with DreamweaverMX 2004, but it all comes out funky looking.
The footer is at the top of the page, the text is all on one side. Graphics are just wherever. Believe it or not I can update this, but I frequently have to do pages from scratch and I would like to know what it will look like before I download to the server. Is there some setting I can change on Dreamweaver to make things look right.
Our designer doesn't have a clue. He just says to learn to write code. I can learn the code if I have to but we have other volunteers who aren't as computer savvy.
View Replies
View Related
I'm just about to embark on building a custom cms with Dreamweaver MX with ASP. I've done something on a very mico level, but i'm gonna go bigger this time.
Something along the lines of Interactive Tools Page Publisher.
Can someone recomend some invaluable (and free) Dreaweaver extensions that can help in this process. Also, if there are any good DWMX tutorials and open source stuff that can help in this process.
View Replies
View Related
I'm using the out of the box Dreamweaver login script (I'm a super noob developer) and I'm interfacing with a database that uses MD5 to protect passwords. I need help modifying the DW code to work with this. Code:
View Replies
View Related
I've tried (during a trial period) Dreamweaver quite extensively for HTML coding. I thought it did a good job of that. I'm just dipping my toes into ASP, and I was wondering if people found it as good for ASP programming as they did for HTML.
I'm seriously thinking about purchasing either Dreamweaver or, may be Studio.
View Replies
View Related
I see that Dreamweaver MX has a pre-written ASP login script that you can just drop in, as well as a drop-in for every page to ensure users are logged in before they can view the page.
Can any security-types out there tell me if this is any good? We're setting up one site where the database is above root level, so I'm hoping that the DW system will provide adequate security (since its SOOO easy to use). Will it?
View Replies
View Related
Im using dream weaver to connect to my database. I hav e made my connection successfully,
added my recordset succesfully....however when i insert my dynamic text.....
I get this: Code:
View Replies
View Related
Can someone tell me , how to apply jscript in dreamweaver, as well as the example, because I am trying to run jscript script with an include file ....
View Replies
View Related
I've been doing ASP by hand-coding in either Homesite or Interdev for years. I have been using Dreamwever for static sites that I make on the side. I recently was asked to make a form which will store info in an Access database, and thought it would be a good chance to learn how to use Dreamweaver MX's ASP capabilities.
Haven't tried it yet, but reading up on it, it seems that it forces you to use Session variables. I'm not a big fan of session variables, and want to avoid them. Anyone here use DW MX for ASP?
View Replies
View Related
I know that this is not the most appropriate forum for this question, but after the excellent advice i have recieved from some members about various things I figured I would wrack your brains. The situation is this: The webserver in question is settled behind a firewall, and you can only get ftp access if your ip address is on a trusted list. A colleague of mine wants to access it from home but due to the fact that he has a dynamic ip address he is unable to be added to the trusted list.
I assumed that his access would be denied, and sure enough when i configured dreamweaver for the site it did indeed fail to connect. So far this makes sense, but then I discovered that if, when on the website in IE, if he clicks the edit with frontpage button frontpage will open and give him access to the site once he has logged in with the correct username/pass. He really needs to be able to access the site via dreamweaver so im wondering if anyone can explain how FrontPage is able to get access and if this information can be used to get dreamweaver connecting.
View Replies
View Related
i have a site where i am showing staff from an office using a repeater in dreamweaver (link : http://www.remaxfinance.com.au/managers.aspx).
i want to put a button that says more info under each staff, and i guess i need to make a page names managerprofile.aspx, but how do i add that link from the managers.aspx page to the managerprofile.aspx page and have the ?&id=something. how do i make this work?
View Replies
View Related
I am trying to create a form which emails the user with details of the
form.
My problem is that when i hover over the sumit button, it shows up as
test.asp and i want it to go to a specific email address.
I did have the action = test.asp but i then installed the FP extensions
and now it holds that value for some reason?! Code:
View Replies
View Related