ASP Database Connectivity Problem
This problem is regarding the ASP Database connection, discussed in the book
Mastering VB6 by Evangelos Petrosus. on page 1222 (Allprods.asp) Code:
This problem is regarding the ASP Database connection, discussed in the book
Mastering VB6 by Evangelos Petrosus. on page 1222 (Allprods.asp) Code:
I somehow got my PWS installed and running after a few tuts online. But as they mentioned, I tried connecting to the database from an .asp page with a DSN connection, but it repeatedly gives me a blank page.
View Replies View RelatedI'm trying to add records from the ASP web page to the database using SQL Server..but i'm not able to do it..Can anyone send me the codes related to the database connectivity..
View Replies View RelatedI have written few line codes but puzzling me lot giving errors.
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "wedding"
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from Group"
rs.open sql, Conn ' Gives error this statement
Set rs = Nothing
Conn.close
Set Conn = Nothing
Connection is established successfully and recordset is also created without any problem
but when it executes rs.open line it gives me error tht
"SYNTAX ERROR NEAR FROM CLAUSE"
I have a problem with internal websites written in ASP that connect to
SQL Server. Occassionally while trying to access these sites, the following error
is generated:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
/Mvp/admin_login.asp, line 0
I've looked on MS site and the solutions seem to be for problems that
are consistant. Sometimes the sites can be accessed other times they
cannot. Does anyone have any ideas what could be causing the server to
time out?
When I fetch record from MS-access using ASP. It is allowing me to print record from ASP.
but when I try to INSERT NEW RECORD/DELETE NEW RECORD into database it is giving me error. I m getting error like..
Error Property Contents
Number 0
NativeError 249761507
SQLState 3811
Source Microsoft JET Database Engine
Description
Help Context 5003811
Help File
I check all the Persmissions. I dont know what is that error means? I have a problme with my code or its Connectivity problme?
i have created an ASP page and have to retrieve some values from oracle tables. Please help me with the connection syntax as weel as the code for retrieving some data from the tables .
View Replies View RelatedDoes ACCESS or a server behave like ACCESS on a local machine? - in particular are there the same query performance advantages in applying indexes to certain table fields?
View Replies View RelatedI have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies View RelatedProducts ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies View RelatedI have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.
This is probably a stupid question (I'm good at those)...
I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data.
I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose.
So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?
I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.
Example :
If they select for like that
Ist question - Yes
IInd question - No
IIIrd question - Yes
IVth question - Not applicable
The variable is coming like (Yes, No, Yes, Not applicable)
but i want to get with separate variables.
What is the best database to connect to, and why?
View Replies View RelatedI have a form that is inserting data to an access database i have it working, but when ever a user enters a name with a special character eg Tom O'Conor i get an error due to the ' character, is there anyway of over coming this problem.
View Replies View Relatedi have this code that is supposed to help me out in some databse retrieval issue. however i am not aware of the dsn-less code and stuff:
<%
var rs = Server.CreateObject("ADODB.Recordset");
rs.Open("select * from states","DSN=IST_SQL;UID=....;pwd=....");
var n=0;
while (!rs.EOF)
{
...
}
rs.Close();
%>
i think the following is also to be included in the above code, but i am not sure of the whole connection thing.
Well Im finally getting how to do asp but I cannot seem to find where I import ms sql .sql files? I know in phpmyadmin there is a place to upload them but not anywhere in ms sql admin. Anyone know how to do this?
View Replies View RelatedI just wanna know if I got a asp page in a location A and wanna connect to the SQL database in a server with IP address 144.214.87.11 through the Internet,then how can I configure in the SQL Server 2000?
View Replies View RelatedI made a script that'll add a lot of data to an access database. Something went wrong during the execution of it, and i was stuck with the mdb file and the idb file. I've tried deleting both, or either, but neither will delete. I've also tried using sql DELETE and DROP, but neither will do anythying. Any way i can delete these files?
View Replies View RelatedI made a database in MS Access and two ASP pages, one with a drop-down box with some options in it and the other one which then shows more data from the database about the chosen option. All of this worked perfectly on my pc but when I uploaded all of this to the server all I get on my website is an empty drop-down box. It seems that my page can't read the data from the database. I'm sure that the path to the database is correct. What could be the reason?
View Replies View RelatedI have copied a MS SQL database to my local machine and am testing it with ASP pages, locally, on IIS. I have a db connect page that keeps the current connections for the live database.My question is, as the local db is named 'local,' is there another name I need to give it and thus call from the connection page?Also, when copying a db, are the permissions (username and pass) copied over with it?
View Replies View Related