Is it possible to create a database of any sort not only Access using nothing but code?
To this day I still create databases using Access on my hardrive then upgrade them and use code to modify them... would be very convinient if there was a way to just create with ASP code and edit from ASP as well...
I have a need to have an end user enter information into a database from the web and have them be able to produce a pdf document/application to be able to download in the pdf format.I need to know how to create the report in Access FROM the web.Is there any routine that can call an Access report from the web? and, create a pdf from that call?
View Replies View Relatedif its possible to create a database from an asp script? My task is to make user surveys where a user selects elements such as text boxes,drop down menues etc from a form, I then have to to make the corresponding table in Microsoft Access.
View Replies View RelatedCan anyone tell me the SQL statement for creating a Yes/No checkbox column in Access.
View Replies View Relatedi'm having trouble finding the syntax of the create database..can some give me a link or something??
View Replies View RelatedI want to create a database and its tables and populate it through a web page, using ASP. The database is MySQL on win32 (4.10.13-nt) and the driver is MyOLEDB 3.0.
One thing, to set up the ole-db connection, it seems I have to specify a data source, which is an already existing database.
The Connection works and I actually can create the database, but the code for the table creation generates a 500 server error. The SQL itself is taken straight out of MySQLcc query window, so I know it's all good, syntactically.
(Also, regarding the connection, I can connect to and read from an existing database. It's the table creation that seems to be the trouble.)
I did a response.write to the page to make sure that the code coming out is what went in and that is the case. So, I guess one question is, what could be different about creating tables in a db that would fail, when "create database test_links;" and "use test_links;" both complete successfully (and the newly-created database shows up, just no tables in it).
To test the sql, i made three strings of SQL and executed each of them sequentially. The first two work, the third (table generation) fails.
A second question is, is there a way to capture any error message that might be generated at the MySQL end, rather than having the page bomb out; and then display the error. I tried using a RecordSet object, that didn't work, the page still crashes.
i have to do a code in ASP that including this code:
set c=server.createobject("adodb.connection")
c.open "dsn=MyDSN;"
c.execute "create table first_tables(Name char, Tel char)"
and i am geting that error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Text Driver] Cannot modify the design of
table 'first_tables'. It is in a read-only database.
/1.asp, line 4
what can i do?
Does anyone know of a database system available in which users could establish a user name and password to register products, buy merchandise and access a message board? I have moderate asp skills, but have no idea how to write or where to purchase software to create this database.
View Replies View RelatedI need to create a chart/graph with the following data from my database:
Each record is opened and then closed at a later stage. I then calculate the time it took from when the record was entered to when it was closed.
Now i need a pie chart to display how many records was closed in certain times. for example 10 records was closed within the first 10 minutes, 2 in 20 minutes and so on.
this also is to happen for dates that the user entered. i.e a Weekly report and a monthly report.
Any advice and help will be appreciated. I found alot of examples of hardcoded graphs but none extracting data from database.
So first i need to count the records that fits each section of minutes and then use that data to draw my graph?
I am using a repeated field to bring in to my page repeated records, and I have been able to retrieve values that are entered into text boxes that are associated with these repeated fields. I would like to post these values into a database, but I'm not sure how to set up my table as I know that each employee's values as well as number of fields will be different.
I thought about setting up two tables. One that houses the dynamic question and the other to house the answers, but I'm not sure if that will work. I could really use help as to the syntax to write a loop statement that will insert my returned variables and create the field names dynamically into my database table. I believe this is what i need to do.
I want to create a breadcrumb trail on a site, but instead of being
generated by cookies or a directory structure, it needs to be database
driven. My website details hundreds of products, each belonging to a
category. Each category can belong to a parent category, and so on.
My site will feature master/detail pages, and both need to feature a
trail, e.g.
Books > Hobbies > Sport > Football
The master page will list all items within the current category, and the
trail will allow the user to click to any parent category for a wider
listing.
The detail page will show the item detail, along with a full trail to
the category/parent categories it belongs to.
The category structure will grow over time, and different branches will
have different number of levels so it needs to be maintainable.
I am tryin to create a database of users for my system,each user is given a username based on their own name(surname and first name), however if 2 users with the same or similar name enter their details they will be given the same username,for example john drew would return drewj as thier username, so would jack drew, when a new user is entering their details how do i check that the username generated for them does not already exist,i.e i need to compare the username generated for the new user with all usernames already held in the database,if the username does already exist i want to add a digit to the end of the username how is this done using asp?
View Replies View RelatedI have created a database connection function which I use to open my database connection and recordset and another to close it. Easy stuff I know. The problem is this.
I want to be able to create database conenctions and recordsets specifically when I call the function. For example Code:
I am using an Access database, and for a field called size the client entered some values such as 20" x 20" Unfortunately when I try to print that field to the page, the cursor stops typing at 20 because I'm assuming it considers the first " inside the 20" x 20" to be the end of the string.
I am simply trying to print the whole string <%=(rsProdsUpdate("size1"))%>
Is there a workaround this without having to change all the values in the database?
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
Does anyone know how to connect to an Access database using C# in ASP.NET?
View Replies View RelatedI have four input variables from a form (first name, Last name, registration number and pin number). I want to check if this variables conform to the data I have in a database (mind you the Pin number is initially not related to the registration number, first name and last name and it is a list of numbers in a separate table in the database;I want to have the flexibility to supply any Pin number, tie this number to the registration number, first name and last name for the purpose of accessing other data in the database for a specified number of times) . how can I do this in an asp environment ?
View Replies View RelatedI'm trying for the longest while to access a database and i keep saying error 3219 which states that the operation is not allowed in this context.
The error occurs when i add obj.AddNew. I have declared a variable called obj which handles the microsoft access database. i set it to obj.Open tablename, connection,0,3,2 and after assigning the values to the fields i then said obj.Update.
I'm creating a form for users to fill out and submit the form via email(outlook). But at the same time I want their names and phone numbers to be registered in an Access database(once submitted). I can't figure the ASP coding to do this.
View Replies View RelatedI have a whole database set up in MS Access with all the menus etc. It's a flight reservation database for a school project. Is there a way to import everything (including the interface) to a website using ASP or ANY other kind of software?
View Replies View Relatedhow can i access other pc database and send a signal to that computer based on the IP address.i can not find any component for it.
View Replies View Relatedi want to write a intranet webpage (can be in ASP / HTML) to connect our Access Database and to search in the Database.
We are using WinNT Server here, and php is not allow. And i have no permission to install anything to the server ...
I have experience with php and mySQL, but have no experience with asp ...
1. what is ODBC ? how to link db with ODBC in intranet ?
(coz' i only saw instructions to link db to local computer)
2. any sample codes of ASP with access database to follow?
Hope that i could find my solution here.i'm working on an asp page and i need to display data from 2 different databases one is in sql server and the other is in access
currently i have linked the sql tables into the access database but problems occur where i have to refresh the tables regulary
so what i need is to be able to select from the sql and access seperatly in one select statment How could i create the connections for both of them to be able to do so?
I have been trying forever to get info from an RSS news feed and send it to an Access database.
The structure is a basic news feed
channel/item
with childnodes: title, link, description
I can supply more info if needed
Anyone have any examples or know how to do this?
I want to have a sentence reading:
There are "x" numer of records in the database.
What code do I use? Bear in mind that each ACCESS record has an Auto-ID, but since some records may have been deleted, the number of records in the database does not equal the maximum ID number.
For a new project I just got,I am being asked to code a small web site but it has to be in ASP. The company doesnt have alot of money, and wants to use ASP and an Microsoft Access database.I had thought that ASP was only able to use MS SQL, but maybe that is wrong.
I am very adept in PHP and MySQL, and have programmed a little in ASP, but never with ASP+ and a database. Could someone please recommend a site or give some examples on using ASP with MySQL or with Access?
I am trying to get records from an Access database that can be viewed from a WAP enabled phone.I understand that I have to create a WML file, but dont know how to do this.
View Replies View Relatedi have a form that adds subjects to access Database.It works very well but the problem is when i request the fields by their Name and not by Id. If the subject have to 2 words or more between the 2 words, there is Space so it take Only the First Word and ignore the rest of the words.
View Replies View Relatedthey have a database which stores information about their properties.. as well as one image of the property from the outside and 3 or interior images of the property.they would like the 'property' section of the website to pull the images and descriptions from this database.
they would also like to edit the properties section on a daily basis using forms.. (deleting properties.. adding properties.. deleting images.. uploading new images.. )
does this sound viable in asp and also some tutorials on uploading files i think will benefit me.
I have a single table, with 8 fields. I want to allow users to filter their selections on 3 fields, specifically County, DistrictName, and Date. I would like users to be able to chose one a specific field from each of these 3 or default to all. Users will not be able to update the database, they will simply be returned data.
Add to this one of the fields is an amount field in which a user can see the sum of the data returned. In conjunction I will also need a flag for amounts which have not yet posted so that these do not report in the sum amount. I would be most grateful for any assistance or if i can be pointed to a product which will aid me in completing this task.
How can I secure an Access database that I use on my Web site? That is, I don't want users to be able to guess the URL of my Access .mdb file and download my database.
View Replies View Related