ASP & ACCESS/SQL Server
This might be more of a database question than ASP. But when you create a database and then create relationships with the database, once you open an asp page say to create a new record; once the record is saved, shouldn't it also update the relationship with the table involved?
Unless I am doing something wrong, it is not updating the second table; for example:
rs.AddNew
rs("username") = Request.Form("txtUserName")
rs("password") = Request.Form("txtPassword")
rs("firstname") = Request.Form("txtFirstName")
rs("lastname") = Request.Form("txtLastName")
rs("email") = Request.Form("txtEmail")
rs.Update
Response.Write("Record has been added!")
Say the information is entered, because of the UserID field is "autonumber", that would be my primary key: so "1" would be related with the second table where I have:
upload.id (PK)
userID
Upload1
date1
Upload2
date2
Upload3
date3
If on the other table I have number of uploads to generate, whenever it adds a document, it would have the relationship of the username, and the upload:
But when I do that, even adding the code, it does not update the code. So what am I doing wrong? Do I have to do another Add.New at the same time for the second table?
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Server Vs. Access
I have an Access DB connected to an IIS via ODBC, and use ASP pages to get info to/from the DB. My guys in IT now want to migrate the Access DB to SQL Server. Can anybody tell me what this implies in terms of : a) syntax of my ASP pages b) syntax of my SQL statements c) other problems I may not have thought of. I am told it is really easy, however, I just cannot get is to work. BTW, I have activated the "SQL Syntax" option in Access, in case that helps any.
View Replies !
Access MS SQL Server
I ask this here because as ASP Developers I figure you have more experience with windows Webhosts. I know Phpmyadmin is usually provided on Apache platforms to manipulate MySQL databases. What interface is usually provided by webhost to access and manipulate your Microsoft SQL databases?
View Replies !
From PHP/MySQL To ASP/SQL Server Or Access
I have always used PHP and MySQL to do anything database related on the web, however I find myself in a new situation. I've been handed the daunting task of creating a (relatively) simple, partially database driven website for my company's intranet. The one problem I have is that all of our servers are Windows 2000 based because all of the in-house software we have works off of SQL Server... and I've never touched a windows based server, SQL Server, or ASP in my life. Searching through the forums, I've been able to find a few ASP tutorial sites, but everything I've found seems to be either all technical info and no basics or a basic tutorial written for people who are already familiar with Visual Basic, C, or another type of windows programming 'thing'.
View Replies !
Export Access To SQL Server
I have a database in MS Access and have one table in it (tblcontest) which has 30 fields in it, I want to export all the fields into Sql Server 2000, any idea how to? PS: I dnt wanna create all the fields manually one by one in SQL Server.
View Replies !
FSO Remote Server Access
Wish I'd found the thread yesterday before spending half the day fighting the same battle and finding a workaround. But at least it explains why my final approach worked.I set the remote folder as a virtual folder on the webserver, assigned web rights to a domain user and used fso.copyfile(server.mappath) to copy a file created locally.I'm not thrilled that access to the remote location can't be controlled at the user level this way but at least access to the calling script can. Strange though, the problem showed up during a migration. Server A had been hosting this asp page and connecting to server B sucessfully. I was moving the application to server C when I ran into the problem. All three machines are W2K, same service pack, same domain, same users, same access rights/method configuration. Go figure.
View Replies !
Remote Access To SQL Server
I was given the following by my host: Database name: asdfafasf IP/Host: 11.111.11.111 Server: asfafaf Username: afafdadaf Password: adfadf Every program I use (excluding Enterprise Manager - I don't have it) to connect is unsuccessful. Access Projects for example, when I try to establish a connection, it doesn't ask for IP/Host.
View Replies !
Access Remote Server
I have admin privileges on a remote server and would like to use a web interface (asp) to manipulate various files. It seems that when I access the remote web pages I only have IWAP and IWAM privileges. Is there a way to automatically send my admin username and password via the asp pages so I will have admin privilages?
View Replies !
Access, SQL Server Or MySQL?
I've been using URL asp shopping cart (free version) for a while with an access database and it worked perfectly. My store is very popular now (more than 200 simultaneous users) and I need to migrate to a professional database. Comersus is compatible with SQL Server and mySQL. Which one do you recommend? My idea was to use mySQL since in that case I can purchase Power Pack Medium ($239) instead of Premium (.$370)
View Replies !
Moving From Access To SQL Server
Im changing from Access to SQL Server and had a few questions: What is the Equivalent in SQL: Access: Memo Field Also, for my Autonumber field, which is Identity in SQL Server, why can I only go up to (int) 4 in Length for SQL Server?
View Replies !
Can't Connect To SQL Server 2005 Db With Asp But Access 2k3 Is Ok.
I am about to migrate my asp web pages from a previous well functioning connection with Access 2003 to SQL Server 2005 Express Edition instead. I have created a database in SQL Server called "test_db". As far as I know I have not set any particular user id or password for the database. In this microscopic database I have onnly a single table called "name" and in this table I have two columns called "fname" and "lname". I have two records stored in the name table. What I want to achieve is simply to display these two records in my asp-page. How can I achieve this and what am I missing here?
View Replies !
Access A Method In Another Server Using Xmlhttp
Shown below is ASP Code sample that tries to access a method,CreateUser in the server called, "http://smallbutsmart.basis.com.au" using the protocol,XMLHTTP. Can you explain to me why this Code does not work and showing the correct Code Sample?
View Replies !
SQL Server Does Not Exist Or Access Denied.
I have an ASP page which has commands to access a SQL Server 2000 database. Ex: rsDatabase.ConnectionString = "Provider=SQLOLEDB;Data Source=xx.xxx.xx.xxx,yyyy;Initial Catalog=ABCDEF;uid=john;pwd=smith" This line returns the following error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. 1. There is not much load on both the web and sql server and this is the only connection which I'm trying to open with the database. 2. I have tried connecting to the database using the System DSN, but it won't connect 3. On some days and at some times, the page works perfectly with no complaints.
View Replies !
SQL Server Does Not Exist Or Access Denied.
I have a web form to publish data to a ms sql database. Everything works great on my local machine which I use for development. When I uploaded the form and connection file to our web server, I receive the following: Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /psc/Connections/psc_lms_db.asp, line 5 Here is the connection string I am using: Code:
View Replies !
Server.CreateObject Access Error
i am using persists mail component for sending emails. all my pages were working fine 2 days ago, but suddenly it started giving me error as below: Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /contest/thankpage.asp, line 183 The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
View Replies !
Access Variables From Asp Server To Client?
isit possible to access variables (code) from ASP server script to ASP client page?? take for example the code supplied below: 'server script <%@ Language=VBScript %> <% dim svalue svalue="access me" %> 'client code <HTML> <BODY> <SCRIPT LANGUAGE="VBScript"> dim x x = svalue 'svalue isfrom server script response.write x </SCRIPT> </BODY> </HTML>
View Replies !
Asp/access Sql Page Works In Xp But Not In Server 2000?
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2 The SQL statement is as follows: Code:
View Replies !
Changing Access Code Page On Web Server
When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
View Replies !
Question About Access Database From The Server Through Asp Website?
I've published my asp file to the website. I've uploaded all the asp files including access database and it works fine. But the record is not updated until i upload the latest database. Actually the updated database stored in the my local server. Is it possible to access the database on my local server? It means, user can access all the updated directly.
View Replies !
Server.CreateObject("Access.Application")
i have an asp file with the following source code.... ****** Set r_ = Server.CreateObject ("Access.Application.10") s1 = "DoAnything()" with r_ .visible = false .OpenCurrentDatabase "D:SP5DataSPIS_LUPK_Vers.mdb" sApp = .Eval(s1) .CloseCurrentDataBase .Quit acQuitSaveNone End With ****** my problem is, that the createobject on my iis 15sec. goes....that is not normally, or ???? what is the problem ? IIS settings ? DComCnfg ?? ASP Problem ??? Wrong Settings ?
View Replies !
Access 2000 Or SQL Server 2000
I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads but very very few writes (just from me). Now the question is should I use: 1) The combination of Access 2000 (accessible through ASP or ASP.NET) using OLEDB Jet or 2) SQL Server 2000 ? Of course I know that the SQL Server option is a better one, especially since it's said that an Access DB can have about 9 users or so accessing it at the same time. But is that a general rule or is it about many people writing to the DB? In other words, if an Access DB has hardly any writes and 99.9% reads can it be used as efficiently as it would be used on SQL Server 2000?
View Replies !
ASP Attempting To Access MS Access 2000 On File Share
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB. The error is similar to: The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data. I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me. Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
View Replies !
Access A MS Access Database Using ASP But On A Linux Box
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>
View Replies !
MS Access - Table Access Problem
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table". If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's. How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
View Replies !
Access Remote Access Database From ASP
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.
View Replies !
How Many People Can Access The Same Access Database
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?
View Replies !
Query Works In Access But Not In Asp->access
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId FROM (tblArtists INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId) LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId ORDER BY surName ASC, firstName ASC Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
View Replies !
Access An Access Link Table
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table. This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
View Replies !
[Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL Server Does Not Exist Or There Is No Permission
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _ "Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission. I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
View Replies !
Server Object Error 'ASP 0177 : 800401f3' Server.CreateObject Failed
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
View Replies !
How To Read An SQL Server Into A ASP Page And Then Change, Add, Delete And Write It Back To SQL Server
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back. The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality. Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
View Replies !
Server.CreateObject Error: Server Object, ASP 0177 (0x800401F3), Invalid Class String
What do I need to do to enable CDONTS om my macine to make it working I'm testing the code: Dim objCDO Set objCDO = Server.CreateObject("CDONTS.NewMail") objCDO.To = "xyz@xxxxx.com" objCDO.From = "zyx@zzzzz.com" objCDO.Subject = "TESST CDONTS MAIL" objCDO.Body = "SOME TEXT TO SEND OVER" objCDO.Send Set objCDO = Nothing It gives me an error after Set objCDO = Server.CreateObject("CDONTS.NewMail") Server object, ASP 0177 (0x800401F3) Invalid class string
View Replies !
Server.execute/response.redirect/server.transfer
Real quick, please refresh my memory which one of the following preserves the information that was posted from a form? server.execute server.transfer response.redirect I need to have a page execute if an error occurs while processing a page that a form was submitted to and have the data preserved.
View Replies !
Combining Index Server And SQL Server Search Results
I'm just about to start a project that needs to combine the results of a SQL Server query with the results of an Index Server query. The basic idea is that the user enters/selects a bunch of search criteria on a form. Most of the criteria selected by the user will be used to select records from the database - standard WHERE clause stuff - but the user can also enter free-text that should be searched for in associated uploaded documents. The documents are sitting in the file-system with file-name pointers only stored in the database (not the document). Only records where the associated free-text is found in the documents should be returned. I'm new to Index Server and am wondering how is this done. Any good references/tutes?
View Replies !
External Server Pull Files From Internal Server
I have an application that needs to pull files from an internal server. This is the setup. The web server is external facing, meaning exposed to the internet. I then have a file server that sits inside our domain. I created a COM object that can impersonate a user to retrieve files from that server. However, I cannot get the application to pull files from the internal server. I first tried a domain account that could reach both servers. This did not work. I then had the network team create the same account on both machines. This is not working either. I can impersonate the user (I am able to get the user/users authenticated), but the script keeps coming back with and access denied. Code:
View Replies !
Getting HTML Content From One Server And Saving It On Another Server
I'm incharge of updating the stats on a chl hockey teams Web Site. I would like to know if there is a way to be able to save the content of the CHL Statistics WebPage on our Server and using it to update our Microsoft Access 2000 database. If it possible, then I would take the content of that page. Execute some code that will take this information an place it in our database on our server. By doing this, our Team WebSite would be update automaticaly at a time that I specify on our server. At this time, I have to open the CHL Statistics WebPage. Then Save the HTML page as a txt file, upload it on our server via FTP, then execute my my code that places it in our database. Could you send your suggestions to Join Bytes!?
View Replies !
Server Not Serving ASP To Some Clients? Including Server Itself!
I have a server that we installed a Web Application (ASP) and It works with a few clients that we tested, IE 5.5, and it does not work on the server machine itself. So we've tested a few thing. Created a simple file with the contents of <html> <body> Hello World </body> </html> Made one with .HTM extension and one with .ASP. I can see the HTM file from all machines. I can only see the .ASP file on the machine running IE 5.5 The server itself cannot see the .ASP page. We places the files in the root of the server web and in the Application folder with the same results.
View Replies !
Error Server.Transfer / Server.Execute ()
Any one has Idea, How to use Server.Transfer and Server.Execute, When I tried to use these methods I got an eror: Server object error 'ASP 0230 : 80004005' Server.Transfer Error /SISWeb/portal_logon.asp, line 40 The call to Server.Transfer failed while loading the page. anybody is there who can respond to this problem. Do I need to change any setting at IIS?
View Replies !
Server.createobject On Shared Win2003 Server
I've recently uploaded a site to a new ISP, which is on a Win2003 platform. I've had a problem in that the existing ASP scripts handling email form submissions all experience the following error: Microsoft VBScript runtime error '800a0046' Permission denied From what I can gather this is due to moving from Win2000 to Win2003, and specifically the problem lies in this line of code: ....
View Replies !
Index Server & Site Server + PDFs
I fire the following code on Index Server (different obj) and it returns a PDFs no problem, but when I change the object to use the MSSearch for Site Server I don't get any PDFs. Anything in the code that would cause this? I can see the PDFs getting crawled in Site Server, but when I try and search I don't get any pdfs .....
View Replies !
User Registration From One Server To Another Server
Previously I have canvassed a few way to get a registration code from one server to another - checking the results of the search and returning a function in a string tro be executed at the end. Well that worked until one of my beta testers decided that he would fiffle and get around the syste mmm...
View Replies !
|
TRACKER
