Connection Error 800a0cb3
Unanswered Topics Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases ADODB.Recordset error '800a0cb3' User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) July 16th, 2003, 01:25 PM jmss66 Friend of Wrox Points: 1,035, Level: 12 Activity: 0% Join Date: Jun 2003 Location: , , USA. Posts: 196 Thanks: 0 Thanked 0 Times in 0 Posts ADODB.Recordset error '800a0cb3' Can someone please help me on figuring out adding/updating new records on an ACCESS Database please? Below is my code and the error message: Error Message ADODB.Recordset error '800a0cb3' Object or provider is not capable of performing requested operation. Program Code !--#include file="Connection.asp"--> <% Dim rsUsers Set rsUsers = Server.CreateObject("ADODB.Recordset") sqlString= "SELECT * FROM Member WHERE SSN =" & Request.Form("SSN") & ";" rsUsers.Open sqlString, objConn If rsUsers.EOF Then rsUsers.AddNew Else rsUsers.Update End If %> Include File Connection.asp <
trouble getting openschema to work to report table/columns names The SitePoint Forums have moved. You can now find them here. This forum is now closed to new posts, but you can browse existing content. You can find out more information about the move and how to open a new account (if necessary) here. If you get stuck you can get support by emailing forums@sitepoint.com If this is your first visit, be sure to check out the FAQ http://p2p.wrox.com/classic-asp-databases/1735-adodb-recordset-error-800a0cb3.html by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. SitePoint Sponsor User Tag List Results 1 to 2 of 2 Thread: having trouble getting openschema to work to report http://www.sitepoint.com/forums/showthread.php?68647-having-trouble-getting-openschema-to-work-to-report-table-columns-names table/columns names Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jul 18, 2002,08:34 #1 lucas View Profile View Forum Posts Procrastinator Extraordinaire Join Date Oct 2000 Location Springfield, Missouri, U.S.A. Posts 320 Mentioned 0 Post(s) Tagged 0 Thread(s) having trouble getting openschema to work to report table/columns names Code: dbpath = "D:\Pure-Flo Intranet\database\EngDB.mdb" set objConn=Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & dbpath objConn.Open Set rsSchema = objConn.OpenSchema(adSchemaTables) Do Until rsSchema.EOF If rsSchema.Fields("TABLE_TYPE") = "TABLE" Then Response.Write rsSchema.Fields("TABLE_NAME") & "
" End If rsSchema.MoveNext Loop rsSchema.Close set rsSchema = Nothing just a simple example of what i'm trying to do. its supposed to list the names of all the tables in the database, but instead its returning the following error: ADODB.Connection error '800a0cb3' Object or provider is not capable of performing requested operation. anyone have a clue? www.extremesanity.com Jul 18, 2002,09:49 #2 lucas View Profile View Forum Posts Procrastinator Extraordinaire Join Date Oct 2000 Location Springfield, Missouri, U.S.A. Posts 320 Men
visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the http://www.dbforums.com/showthread.php?984110-ADODB-Command-error-800a0cb3 forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: ADODB.Command error '800a0cb3' Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-19-04,08:26 #1 richprice View Profile View Forum Posts Registered User Join Date Feb 2004 Location Sussex Posts 5 Unanswered: ADODB.Command error '800a0cb3' I have posted connection error various questions on the microsoft ng trying to identify the cause of this error. ADODB.Command error '800a0cb3' Object or provider is not capable of performing requested operation. I have MDAC 2.8 installed locally on my machine. Via IIS I created a virtual directory via IIS that points to my ASP files on c: Via the SQL Server IIS for XML configuration utility I created a virtual directory with a different connection error 800a0cb3 names that points to the same directory as that created via IIS. The SQL database is on a different machine and I connect via the OLEDB DSNless connection string. I used a ADODB.Stream to transform the XML against the XSL but I couldnt get it to work. To simplify things and work towards a solution I inserted the code into my ASP from the MS KB article Q272266 (see below). I amended the ms code to change the connection code and call a stored procedure that exists on the database. The ms code gives the same error as my original code. I tried changing the CursorLocation to server and client but the results were the same. I put a SQL trace on the DB to determine if the stored procedure gets ran, it does not. If I run the following in the URL it works: If I run http://localhost/p2/?sql=SELECT+*+FR...StatusDesc.xsl it works. If I run the xml template it works: http://localhost/p2/xml/test.xml The two lines above run. My IIS server uses a virtual directory called dev, so when I run the ASP I type http://localhost/DEV/secure/aframes.asp the IIS virtual directory creted by sql server is called p2 but has the same source code directory. Here is the MS code amended as described above