Beginner ASP Need Database Connection Help
May 1, 2007
Hi, I went to school over 4 years ago learning ASP but I forgot almost everything.
I am able to setup a connection to a an Ms Access file and get information using Windowx XP's IIS.
I need to change the code where the location of the Access file is on my computer to my webhost.
In other words, I have uploaded all the pages and the Access db file but now the pages can't find the Access db because the file was original on my computer in a certain folder. Now that it is uploaded, I need to change the location where it searches for the db from my computer to my webhost.
I have not dealt with ASP for almost 5 years ago.
Please give advice, or websites or 3rd party programs that can do this for me.
I am trying to build a webiste where you enter the username and login then be able to retrieve information or update, or add new or delete from the Access db.
This should be a simple problem for most you professionals out there.
View Replies
ADVERTISEMENT
Jan 11, 2007
I've searched and could not find what I was looking for.
I have NO database experience but need to learn quick
I have an html page with an iFrame (flash menu on left - iFrame on right)
When I click a product image on the left this is what I need to happen.
- Flash send a variable
- The iFrame to load an HTML page that will populate with an image, 2 text fields, and 3 hyperlinks dependant on what product is clicked in the flash.
I am using access since it is what i have at work, and i can just add all the products in a table pretty quickly and easitly. I set up a table in access with the image, hyperlinks, and text that needs to populate in the html page. The HTML page is set up in tables if that makes a difference...
I just don't know where to go from here to make my connections and how to set it up.
Any help would be appreciated.
Thanks in advance.
View 2 Replies
View Related
Sep 30, 2005
I have a combo box that is populated by a query. The problem is that the query pulls data from a different database than the rest of the form and it prompts the user for a password to access this database.
Is there any way of coding the password into the form so that the connection to the database is opened automatically without prompting the user?
Thanks.
View 4 Replies
View Related
Dec 25, 2004
I'm trying to use a banner ads .asp program called Admentor.
My problem is that this uses DNS less connection and I can't get this working on both the pages showing the ads and the admin panel.
I know it's the path to the database that causes this.
If I change this to suite the webpages showing ads, it work's, and if I modify it to suite the admin panel it work's.
But not both at the same time.
Should'nt this path be relative to the sites root ?
g_Admentor_strConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("../ads/admentor/ad97.mdb")
when using this string, the webpages showing banners is working, but when clicking on these, the site calles a redirect .asp page that also uses this database connection. Then it fails, since this page is located in another folder in the site and therefore also gets another path to the database.
How can I get this to be a relative path working on all pages not been worried about folders, subfolders and correct paths to the base ???
Best regards
Ketil Leinum
Norway
View 1 Replies
View Related
May 9, 2005
hi, below are the codings i input.
I just cannot get the connection to open. error is at "objConn.open"
I have also given the user full access right. folder attribute however, always reverts back to "read-only" whenever i try to turn "read-only" off.
Please help!
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.Recordset")
objConn.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source="& server.MapPath("db.mdb")
objConn.Open
sql = "Select * From tblReceipt"
objRs.CursorLocation = 3
objRs.CursorType = 3
objRs.ActiveConnection = objConn
objRs.source = sql
objRs.open
View 1 Replies
View Related
Jul 26, 2005
Hi,
I apologize first of all if this question is bounced up and down through out the forum all the time, and if there's already a topic on this, then it'd be perfect for me. But im not having any luck.
I do not know how to upload my database in a way that it will work when i try to use a page through microsoft frontpage to display results from it.
What are the accurate steps into creating a database connection? Thanks a bunch
View 3 Replies
View Related
Mar 9, 2007
Really don't know the answer to this question and I thought I'd come to the experts. I have created an Access database that I use to push & pull data from an SQL database through linked tables. I created an ODBC connection on my PC and set it so the links keep the username and password for the ODBC connection. All that works great...Now my question - Is it possible to somehow "store" the ODBC connection within the Access database so that I don't have to go to every PC that is going to be running this database and create an ODBC connection? The Access database and the SQL database both exist on our network and all those that will be using it have access to both. If someone has the answer I would really appreciate it.
Thanks
View 8 Replies
View Related
Nov 24, 2004
Hey,
Im doing a login page for my website, and i am having trouble connecting to the DB:
'Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein; DBQ=" & Server.MapPath(strAccessDB)
where strAccessDB = "cs334-45/Kosy/Kosy.mdb"
cs334-45 is my computer name in the virtual directory.
Im getting this error:
Server.MapPath(), ASP 0172 (0x80004005)
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
/Kosy/check_user.asp, line 21
I dont understand. I thought that the virtual directory was mapped to the physical directory
anyway? So why do I have to enter a virtual path?
View 1 Replies
View Related
Jul 6, 2015
Using Access 2013.
We have split a database and have about 6 users connected to a gigabit switch. There is a noticeable delay of about 5 to 15 seconds when we search by an account name. We are working with a split form, where it has the database records listed at the bottom half of the screen.
Is there a way to improve the performance? I tried a persistent connection, but it didn't seem to work and would occasionally get an error message.
View 9 Replies
View Related
Apr 9, 2006
hi guys,
this is my first thread on this forum...,, i am new out here..
i am not able to establish a connection with a MS Access database. I am using DSN Connection for it..
The error that i am getting is...//
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/airtickets/scripts/dbconn.asp, line 4
please help...??
View 2 Replies
View Related
Nov 18, 2012
I have a back end 2002 DB. I would like to disallow access to this through odbc connection. Is there some way this can be achieved? Thie directory where it is located is unfortnately cannot be restricted as the front end mde also resides there.
View 1 Replies
View Related
Jun 26, 2015
I am looking to automate the process of linking my Access DB with an ODBC connection to an SQL DB with VBA (unless there's an easier way to do it?) - some sample code - if this is possible at all?
View 2 Replies
View Related
Jan 10, 2013
we have Oracle 11g as main database and for viewing purpose, we have created an mdb (Access 2007) using Link tables via ODBC connection (system DSN).While querying, count queries are working fine with accurate record counts but, all select queries are not working fine. It filters and displays with wrong records. There is no issue in query building.how to get correct records through odbc connection to Oracle database.
View 3 Replies
View Related
Sep 26, 2005
Dear Guys,
How to Establish the connection between Ms-Access2000 & Oracle using DAO Connection through Code?.
I created one table in Oracle and I created User-DSN in ODBC.
I linked that oracle table into Ms-Access MDB using Link table option in ms-Access.
Now, Whenever I open that mdb, we need to establish the ODBC connectivity automatically through code (I mean, we need to refresh automatically).
I need to hardcode all the information in the Ms-Access code.
My User DSN Name: abcd
Oracle Database Name: abcd
Schema Name(User Name): abcd
password: abcd
View 1 Replies
View Related
Sep 4, 2014
I have MDB database linked to SQL SERVER through VPN connection.I created links to the sql server Links are dsnless..Everything works fine but when I lost VPN connection or sql connection has been broken I can't refresh links to the tables.I receive message 3146 sql connection failed..I must close database and start again...
I tried different methods like ado,dao, and vba docmd.transferdatabase,aclink... but no success, table cant be relinked.
Only way I can relink is to change ip adress in conn.string
E.g. 192.124.0.2 (1st ip- router server ip) and after connection failed i can use 192.124.0.32 (2nd ip - server local ip) and that's it if i lost connection for the 3rd time... i must restart application.
It seems that access database keep the previous connection..how to reset or drop database connection to the sql server and refresh links to the tables with vba code without closing access database...
View 12 Replies
View Related
Jan 9, 2005
Right Ok i hope i can get some help cause im absolutely stumped..
i cant get my login page to work since moving it from my PWS(iis on xp) DSN connection
to a 24/7 server on the net with DSNless connection
here is the code for the include file "conntopwd.asp"
http://www.pritchardwebdesign.pwp.blueyonder.co.uk/conntopwd.txt
the username and path has been changed slightly for security purposes,
and the code for the login page which attempts to access the database is here
http://www.pritchardwebdesign.pwp.blueyonder.co.uk/login.txt
the connection has been tested by one of the tech support guys at brinkster and he told me it was ok,
the problem was the way that the data is called from the data base is wrong ..
The tech support guy said that it was this line that was causing the problem..
MM_rsUser.ActiveConnection = MM_conntopwd_STRING
Any help would be much appreciated as im stuck for now..
View 2 Replies
View Related
Sep 7, 2005
I have created a new Access database and need a few additional things that I would like to add. I created a database for inventory within my company. Only a few people will have access to it so security will not be an issue. However, I have a couple questions. Is their a way to have a popup when you open the database to insert let's say the serial number of the computer (already in my forms) and then it will automatically bring up that information. Also, I do not want any of my forms edited. I want this done strictly through the tables. So this leads to my next question. Is their a way once you have a form up that you can enter a different serial number and the information will automatically populate. If not, can you add a search query or option or what needs to be done. Thanks in advance for your help.
View 4 Replies
View Related
May 4, 2006
Hi
I'm not sure if I have posted this in the right section, but i'm sure someone will tell me.
I have 2 questions, first is about concatenation.
I've looked endlessly & have tried a few scripts, but all to no avail.
eg db:
Name: Dpt:
Tom sales
John sales
Jerry mgm
Albert sales
Keith mgm
eg report that I want
Sales - Tom, John, Albert
MGM - Jerry, Keith
What is the best way to do that?
2nd Question.
In the same db, what i'm wanting to do is if I change the data in any record, it will track the changes.
eg
Albert has changed departments from sales to management (mgm as above), and so when you view albert's information, you can do something to pull up any & all changes made to that particular person. Any ideas there! Once again, i've searched the net and can't seem to find the best result.
Cheers in advance!
View 2 Replies
View Related
Jun 14, 2006
Hi,
I am just a new greenhore learning ms access and I am planning for a warehouse/inventory storage database.
My question :
1) I have 4 product division (Do you think it is good to have 4 tables):confused:
2) The calculation field. (How does the mechanism work when I take the the item out from the inventory, it will show as total storage -1 (eg, the storage have 5 units and I took 1. it show balance left 4).:confused:
About question 2, is it that I have a to do separate table again.
Temporary, I have these 2 problems and hope all access expert can help.
Regards,
Richard
View 1 Replies
View Related
Mar 14, 2008
I am fairly new to access and am trying to put together a project for work. I need to be able to create a list of all of the employees and which team they are in. So no problems with this.
I also need to be able to mark in their records where they can advertise and the quota they have. Each employee may be able to advertise in more than one location.
What I would like to create is a form for each team that displays the employees and where they can advertise. So far I have managed to get a subform to show this for each office but each employee has record for each job board. See Picture1.http://i112.photobucket.com/albums/n170/nharri/1-1.gif
Ideally I would like something like picture 2.
http://i112.photobucket.com/albums/n170/nharri/2-1.gif
Is this possible?
View 1 Replies
View Related
Feb 22, 2006
Hello!First of all I am new to these forums and I'm also a beginner with Access so have patience :) and I don't know if this thread is in the correct part of the forums so if a moderator feels like it's not feel free to move it.Me and a friend are interns at a company in US and the company assigned us to gather data from several excel sheets and build a completely new database. This database contains several tables.This isnt the correct names of the tables, it just to give you an idea how it looks at this moment.Customer information. (key: Customer ID)Resellers (Key: Reseller ID)Newsletter subscriptionsProducts (Key: Serial Number)Software (Key: Licence) Product2 (completely different product from the others) (key: Serial number)Invoices (Billing information, debit, credit, etc) (key: Invoice ID)OK, that explains how our tables looks like. And ofc in the tables we have different fields.Our problem at this moment is our form. Because we want to use a form to enter the data. We believe that it will be the fastest way and the easiest.I have a picture for you to show you our problem.It seems like the FORM is looking in the same table. But we want all the "fields" in the form to represent its own table. We tried to gather all tables into 1 Query and use the query when we created the form, the problem dissapears BUT a new one comes along. If we use a query in the form we can fill out all the fields but we can't create a new "record" with empty fields to enter more data hence leaving us with only one record of information. This is realy starting get on our nerves. Can someone help us?
View 1 Replies
View Related
Apr 3, 2006
Hi there, Heres my situation
I have a basic form for a customer shopwing all general details the top field is Customer ID in which I would like to enter a customer ID and for the rest of the data to appear for that customer in the remaining fields, I have a small amount of knowledge with access and believe I need to a Dlookup but I am unsure where and how to put this expression i'm thinking maybe in a query. Any help would be great, My field names are listed below to make any help a little clearer
Customer ID field = txtCustomerID
Linking to = tblCustomers
to find = txtSurname
txtForename
txtPostCode etc
Many Thanks
View 1 Replies
View Related
Jun 30, 2006
Hi this should be very simple, but it's not for me.
I am creating a database logging machine error's.
Each error has a recorded start and end time, which I enter.
I want the database to enter the elapsed time into a third field, 'ElapsedTime'.
I see how to do this in the builder, just subtracting the two fields. But I know not to make it a condition of my query, that doesnt make sense. Where do I put my expression so that my table updates itself with the new field?
Thanks!
View 3 Replies
View Related
Nov 6, 2004
I am creating a database concerning products sold.
I am a beginner of using Access Database and would like to know if this is possible...
At the designing stage of tables and relationships is it possible to link and construct, so that the stock quantity of each product is kept up to date. so, when an order is made of produc '123', product '123' updates it stock quantity be deducting the quantity ordered.
attached are the tables/fields/relationships.
Thank you very much.
View 1 Replies
View Related
Jul 27, 2007
I need to figure out how to program an expression that will reset a value on a form to zero if the product of it's calculation is less than zero.
I am figuring out sales commissions for listing Ebay items and there are some instances where the item doesn't sell, so it's a net loss because of the fees Ebay charges to list the item. I have programmed the form to take 10% of whatever the net gain is and use that as the salespersons commission. But in instances where the item doesn't sell, it actually takes money away since 10% of a negative number is a negative value.
In cases like this, I need the expression to just show a zero, if the number is negative.
If anyone could help, I would be greatly appreciative.
View 1 Replies
View Related
Nov 30, 2005
For a couple of years now I have been keeping a spreadsheet record of UK football match results and statistics - I use this as the basis for gambling on future matches. I now want to migrate this information into a database so that
1) It is much easier to enter the new data(via picklists)
2) I can generate reports on particular teams to help me on future betting decisions
Being almost completely new to Access I am struggling with the design. The information I'm capturing is:
Match Date
Competition(table including five)
Home team/away team(table including many depending on competition)
Home formation/away formation(table with standard list)
Home goals/away goals(numerical)
Home corners/away corners(numerical)
Home bookings/away bookings(Numerical)
Referee(from a standard list)
All the above is in a match results records table with relationships to each data element table.
For the form for data entry, I want pick lists for all non-numerical values - eg team, formation etc. I would like to get a little cleverer and for the team pick list to only contain teams that are in the competition I've selected(eg Uk or European).
I've created some tables and relationships, but when I create a simple form with combo-list boxes, the list itself comes up blank even though I've linked the field to a particular table of options(eg a competitions table).
Can anyone help on suggestions for the overall design(should I have separate match results tables and team tables for each competition?) and with this particular combo-box problem please?
View 3 Replies
View Related
