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 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?
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
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
I just started learning ASP.NET and i need to learn to use the database for SQL Server 2000 quickly. First, (forgive me for my ignorance) what is a database? Do you guys know any good sites that teach you how to access the database for SQL Server 2000? and have tutorials, and sample code?
I really like this forum as I can usually find the answer to all my questions by searching, but I haven't been able to find a way to resolve this problem. This is my setup. We have 2 local servers. One running WinNT that handles all our internal databases in dbf formats. The other server is WinServer 2k3 and it handles all webstuff. The Win2k3 Server logs onto the WinNT Server and can see and open all the files. If I copy a file from the NT Server to the 2k3 server, I can utilize the database using the connect string:
but, I cannot connect to it directly on the other server. I believe it is a permissions issue, but if I change the Annonomus Access user to one that can access the other server, it asks for a password. I have even tried a virtual server but cannot find a connection string that will allow me to access it.
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+ application) fails.
It throws common error Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running application on Windows 2000 advance Server.
I ALWAYS forget this cause we ALWAYS turn our db connections into COM components. That said... I need one for this project . Here's my base Access one:
DBPath ="C:datastoresmediacd.mdb" Set Con = Server.CreateObject( "ADODB.Connection" ) Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath
I just don't quite remember the SQL Server variation.
Wondered if anyone could help me out with some simple connection string problems I'm having.
Ive got this on the page so far and it works: ---------------------------------------------- Dim strConnString set strConnString = server.createobject("adodb.connection") strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=c:Inetpubwwwrootdlnforumforumadminwwforum.mdb" strConnString.open ----------------------------------------------- But I want to change it to a Server.MapPath method, so I tried the following: ------------------------------------------------ Dim strConnString set strConnString = server.createobject("adodb.connection") strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & Server.MapPath("forum/admin/wwforum.mdb") strConnString.open --------------------------------------------------- But now I get the following error: ------------------------------------------- Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E) Operation was canceled.
I'm trying to get asp to conect to a MySQL database, I've tried copying a few examples online that I found [there doesn't seem to be many!!] and I always get a 500 error with the code below. what am i doing wrong? any examples of a working connection string anyone could show me would be fantastic.
I am passing 3 hidden fields to another page using the method="post" Here is the next page - <% Dim fmMemberID, fmUsername, fmPassword fmMemberID = request.Form("memberID") fmUsername = request.Form("username") fmPassword = request.Form("password") %> <% Dim dbConn set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:inetpubcredencia.netfpdbmembers.mdb" dbConn.Open
Dim rsMember Set rsMember = Server.CreateObject("ADODB.Recordset") rsMember.Open "SELECT * FROM Members WHERE MemberID=179", dbConn, %>
Our hosting service migrated our web page from a Windows 2000 Server to Windows 2003. Our website is www.DisketteConnection.com.
I now intermittently receive error:
ADODB.Recordset error '800a0e7d' The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/shopcart/shopdisplaycategories.asp, line 36
I believe line 36 is "rs.Close". I can include additional code or the code opening the file if you need it. I utilize Microsoft 97 Access Database.
The hosting service indicated the problem lies in that the current code was written for Windows 2000 server. Our original programmer is no longer with the company and I'm at a loss to determine how to address the issue.
i run asp in my standalone pc, using access2003 as the database, like this:
i hv 3 pages, 1st page, i open the database, extract data from database for display(closing the connection using "recordset.close" and "conn.close").... then i have form input for users to input some information...and post to 2nd page
2nd page, this page may load N times depending on the user input in first page...for each time loading, i hv form input for users to input the detailed information. and for 2nd to Nth loading, i will get previous page's form input information(request.form("xxx")), then insert into database ("conn.execute")and close it("conn.close")...
last page, this page get Nth loading user input information for the 2nd page, then open database, insert into database("conn.execute") and close it("conn.close")...
now the problem is like this...database can not store data correctly: it did not insert N rows into database....maybe N+1 or N+M...randomly...because same data is insert more than once, so some rows are just duplicated...it seemes that the connection just can not be closed and do insertion more than once during each time the 2nd page is loading or during the last page is loading...
can anyone help me to find out the problem? any suggestion?
I have an .ASP page with a form on it, which I want the info input into the form to be submitted to a database. I am trying to create a Custom Connection String in Dreamweaver but I am having a hard time. I set the path correctly, etc.
Is it not working because I am trying to run this with an Access database and it's on a Linux server? I thought i'd start out simple before I post a million pages of details.
I am not able to connect to a MS Access Database..,, I am using a DSN Connection,
The Error that the asp page(having Database code) is showing everytime 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
i havent opened the database bfore, & no other app. is accessing it ..
I seem to be getting this error, and after Googling and searching this site, I still can't get a grip on it. I have a site on a server which is being developed for a national company who will offer this site to their members, hosting each on the national orgainzations servers. I have this string -
Which results in this error: The '..' characters are not allowed in the Path parameter for the MapPath method
Ok, the common solution seems to be a configuration on the server, which wouldn't be a problem IF the site was to remain where it is. BUT, seeing as I will give this site to the client, who will host it on their servers, could this configuration "fix" be a problem, perhaps for security issues.
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?
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.
Does anyone know of a simple (and I stress simple as I'm a beginner with this asp stuff!!) script to allow for basic functionality of Add/Edit/Update/Delete ASP page which works with an Access 200 mdb. Something I may easily adapt for what I have?? I'm running Windows 2000 Professional with IIS 5.0.
I have created an Access database with an Autonumber field and set as promary Key. When I insert a record from my ASP web page it insists on making me add a value to this field. Is there anyway to set this as an IDENTITY field.
I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while .
I recently built an application using an Access database. The application works fine, but for some reason I am unable to FTP the database file back to my machine from the server... the operation simply times out halfway into the transfer.
Has anyone ever encountered this issue? I don't know if maybe some renegade connection wasn't closed, but I kinda doubt that's the case.
Is there even a way I can check what connections to the DB are open?
I have a database which inputs usernames, passwords, and email addresses into the database. I'm trying to create an asp page that lists the data for a specific user when they are logged in so that they can change details (password, email address etc) any ideas how i can retrieve the data and append the new data to the database???
Our graphic designer is developing our new company website. We have switched providers and currently she is working on the new website which currently ressides on the new providers server as they support the ASP development environment. Their server is a Win2K3 server.
She is writing an ASP module to connect to an MS Access 2000 database and is having problems connecting. In this database there is only one table.
She has tried many different connection strings all to no avail and then found from investigating that the best and fastest method is to use the OLE connection string. However, each time she runs the ASP code she gets the following error... Code: