Having Trouble Getting Openschema To Work To Report Table/columns Names
dbpath = "D:Pure-Flo IntranetdatabaseEngDB.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") & "<br />"
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.
View Replies
ADVERTISEMENT
I want to create a report with 4 fields( employe ID, emp name, DOB,age).
out of this 4 , record for 1st three flds i m getting from table in my data base, and the 4th fld that is age ....i m calculataing that in my code behind.
View Replies
View Related
I want to be able to connect to the database (the name is known) and then have it report back the tables in the database and the columns available in the tables. Is there a way to do this?
View Replies
View Related
What I want to do is list all of the columns in a table from a MYSQL database.. How would i go about this? I already know about select *, what I want to do is write them all down.
View Replies
View Related
I am having much difficulty having a form write to a DB... I am an ASP newbie and am noticing the errors are pointing to this script... currently this script is producing no error messages but when a user selects one of the chk options in the "Nominator code" section of my code, it won't write to tblNomCommVotes. Code:
View Replies
View Related
I'm sure it sounds kinda nutty to display 200 columns and
500,000 rows of data. But I have been pulling data from a
Lotus Notes database into Sql Server for a while now, but
Lotus Notes is starting to crack, columns getting
corrupted. Can't handle the volume of data and number of
columns. Sql Server has no problem. But displaying the
data is the big deal. The end users want to be able to
scroll acros a page to the colum of their choice, or be
able to scroll up or down.
I was thinking of breaking up
the table into section, but this would reqire additional
clicking to get to the next section of the table. Would
it be feasable to have a 200 column table in asp? or
should I stick with the section idea? I have to tell my
dept something. They started out with Lotus Notes but
couldn't query the data. I have been suggesting to
migrate the project entirely to Sql Server/IIS. Notes can
at least display all the columns.
View Replies
View Related
I have a Table with 10 columns and would like to sort this based on columns 2, 7, 5, respectively. I thought my code :
objRS.Open "SELECT * FROM MyTable ORDER BY col2, col7 col5", MyDB, , , adCmdText
should work, but didn't. How do I do that?
View Replies
View Related
ive got a small problem, i dont know if this is possible but its bound to be. What im trying to do is request a cookie which contains a database table name and put that inside an sql query...sort of like this
id = request.cookies("tablename")
mySQL = "SELECT * FROM &'id'&"
i know that doesnt work, ive tried every other combination .
View Replies
View Related
I am planning my next move on my current website and am looking at doing the following. I am adding a feature where as a database can be viewed on the web page as this has been requested for me to do.
I am pretty sure i can do this without a problem except for getting all of the table names. Is there an SQLQ command where you can say
SELECT (ALL TABLE NAMES) FROM DATABASE.
Antoher way to look at it is to have a seperate table in each of the databases to hold all of the table names.
View Replies
View Related
i want to make a drop down menu with the names of the tables in the mdb. how do i get this right? do i use a sql statement? i cannot find a sql statement with the command for this.
View Replies
View Related
I have been looking everywhere, and can't find a complete function to create tables and columns in access .mdb from ASP, while adding columns that are missing in tables that already exist, can anyone post a link or the code to such function?
View Replies
View Related
i am just trying to build a table that will put content into 2 columns. Ideally, if there were 20 hits, 1-10 would be in column 1 and then 11-20 would appear in column 2...i just can't seem to figure it out. I had started by getting a recordcount, and dividing it by 2, but things got a little fuzzy after that.
View Replies
View Related
I would like to be able to generate table reports listing all the TABLE NAMES, FIELDS and their datatypes in a neatly formatted table.
Additionally I am building up a frightening amount of queries.I would also like to cycle through this and neatly associate notes with them to remind me of their specific purpose.The naming of the query can only go so far.
I find that upon returning to my asp and access application after a month or two I struggle to contextualize where to begin query additions and table alterations
and hope a catalog method will make me more effective and save time.
View Replies
View Related
Is there any way of using ASP to read the names of all the tables within my database?
View Replies
View Related
Anyone have any advice on getting a recordset of all tablenames in a database? I have an access database that I am constantly adding tables to.
I want to have code that will lookup all tables and populate a selectbox with the tablenames so that I can click to look at each table individually.
View Replies
View Related
Ive got an accces database with a couple of table in it at the moment but this will grow to 5 tables pretty soon then maybe more after that.
I would like to be able to populate a drop down menu with all the table names in the database any ideas how to do this or if its even possible.
View Replies
View Related
Environment: Windows XP Pro, IIS 5, SQL Server 2000
oConnectionString = 'driver={SQL
Server};server=(local);uid=sa;pwd=;database=mydata base;'
Relationships are setup on all the tables.
EOF is returned for the recordset when using:
oRecordSet = oConnection.OpenSchema( adSchemaForeignKeys )
This works when using an Access2000 database, but not for SQL Server 2000.
What's wrong?
View Replies
View Related
I am using MSAccess 2003 as my DB, ASP page my front end. My access file is
in the temp folder which ahs IUSR_Machine permissions. My asp page works
fine, connects to DB and retrieves what I want. Now, when I open my db file
in Microsoft Access in Exclusive mode my ASP page doest establish a
connection which is correct as exclusive open locks the files and prevents
further connections. Upto here no problem.
Now when I close that opened Microsoft Access instance, my web page resumes
working. If I refresh it, it works. The third time I refresh the page I get
"Unspecified Error". Again if I refresh it works and again if I refresh I
get "Unspecified error" when I debugged it fails at connection open. Code:
View Replies
View Related
I was wondering If there is any way to grab just the viewable text of a webpage
using xml. Not the html, just what the user can see.
View Replies
View Related
I am having trouble with installing IIS, I tried to do it in my control panel, but it wants the disk, I don't have the disk because my computer came with Windows XP Pro 2002 Service pack 2.
so I went to the microsoft website and downloaded the free download of IIS6. Then when I go to my control panel and Administrative tools it is in there and when I click on it, there is no computer name available.
View Replies
View Related
I want to display the results from my database in 2 columns.any easy tutorials or article out there? havent found any easy so far
View Replies
View Related
How do I find out how many columns exist in a SQL Server DB table before displaying the records of that table?
Also how do I get all the column names as an array so that I can seperate each column using the Split function?
View Replies
View Related
I have a small doubt, my access database has been moved to SQL Server. Now I had some columns say [Where NoP] and similar many such columns. Are these columns going to work, since some of my queries are returning error. When i change the column name to say WhereNoP, it works fine, but in that case, I have to check around 300 forms where the column name is mentioned. So any clues to make such column types work.
View Replies
View Related
I have a sign-in box that is an IFrame, with a form target of "_top", and
the current (parent) page URL as a hidden field.
If sign-in in successful, there is a response.redirect to the page URL,
having set the session variable LoggedInOK=true.
However, if the sign in is not OK, I want the IFrame to be the target, (i.e.
_self, not _top) to display the error.
Is there a way for ASP to control whether it redirects to _top or _self, as
setting the form target in the Login page requires "pre-knowledge" of
whether it will be successful.
View Replies
View Related
I am moving a ASP website to a new Window 2003 server with
IIS 6, but an error occur for the metadata declaration in
my global.asa
<!--METADATA TYPE="TypeLib" NAME="Microsoft Scripting
Runtime" UUID="{420B2830-E718-11CF-893D-00A0C9054228}"
VERSION="1.0"-->
the error message is
Active Server Pages error 'ASP 0223'
TypeLib Not Found
/LM/W3SVC/1/Root/myweb/global.asa, line 4
METADATA tag contains a Type Library specification that
does not match any Registry entry.
View Replies
View Related
I'm writing an Online registration system for my friends new business.
I'm trying to incorporate checkboxes so when a person checks on 3 or 4 checkboxes and hits the Submit button I can
pass the information of what they checked_on to a new page.
When I get to the new page I would like to update a database, based on what they checked_on on the previous page.
I'm not sure how to do this.
I'm not sure how to pass the information.
View Replies
View Related
Ive got a script here that searches using info from querystrings. it's just a snippet from the other lot. Code:
View Replies
View Related
using PWS on test machine (NT4 workstation SP6) and everything was fine but cpshost.dll was used in the website we're maintaining, so I idiotically installed it from a Visual J++ disc. now the website works fine but when i navigate to 127.0.0.1 nothings happens. I've checked directory browsing is enabled but still nothing happens!
I'm aware that cpshost.dll was never meant to be used on NT workstations but as I said before the upload functionality works fine, it just seems to have screwed the directory browsing up - and also the code document.referrer equals nothing.
View Replies
View Related
I am primarily a front-end designer and not familiar with ASP beyond
breaking up pages into include files. Recently, one of my freelance
clients wanted to display an RSS feed from his blog on his site. I did
some research and found the rss2html.asp script. I chose this over a
javascript solution because those scripts apparently don't affect
search engine rankings.
I implemented the script and it was running fine until about a month
ago, when the site and sometimes the server running it started to
crash. The ISP and the blog company the RSS feed originates from blame
the script. Bytescout, who wrote the script, says that it's probably
the feed that's causing the problem. The RDF version of the feed
validates as RSS, but the ATOM one has specs that are too new for the
validator to parse correctly. Code:
View Replies
View Related
I keep having trouble connecting to my database I am running windows xp pro and Access 2000
Error Type:
Provider (0x80004005)
Unspecified error
/test.asp, line 60
It keeps bringing up the above error message sometimes it works fine then other times it dosen't has anyone had any similar problems.
View Replies
View Related
i'm working on access db the problem is when i enter date in d/m/y format it wrote db m/d/y format but this happens only with small numbers i.e if date 04/09/2002 it become 09/04/2002 in db but if it is 24/09/2002 there is no problem.
View Replies
View Related
I've narrowed down my error to one particular function. It looks as if the function may not be receiving the variable that is passed to it.
The error message is:
error '80020009'
results.asp, line 21
Line 21 is: Code:
View Replies
View Related
I'm having some trouble parsing an XML document I'm getting from my company's bank in response to a XML document I'm sending. Both docs are transferring fine, and in fact if the transaction in the document I send is accepted (valid credit card), everything parses perfectly.
The prob is when the transaction is not accepted by the bank server (invalid credit card), and the document that's returned to me has different tags. Code:
View Replies
View Related