|
Since this code is written for ASP, I don't pretend it does anything under ASP.NET. Wether you run the rest of your web site under ASP.NET is up to you. ASP and ASP.NET runs fine together you know (or at least you should know  ).
All ASP articles here at CodeProject is under the ASP.NET hierarchy. Does that mean you think all ASP articles here is useless and obsolete? 
|
|
|
|
|
Great app. I guess it will only run on IIS as I could not get it working in PWS.
I noticed that it does not support binary field in the table or column create. I've not cracked open the code to see if I can do it myself but I thought this might be a simple mod for you.
Cheers and thanks for the great app.
bill
|
|
|
|
|
What database are you running against? I have no problems creating tables with either bit or binary (not sure which type you meant) fields on a MS-SQL database. I didn't test right now on Access, but it should support any datatype the db supports. I check available datatypes through the ProviderType schema.
|
|
|
|
|
Disregard. I was not seeing the 'bit' type in the column create dropdown list. I was looking for 'boolian'
bill
|
|
|
|
|
Hi !
I'm getting an 'access denied' error when trying to access a Microsoft Access database on my hosted website. I uploaded all the files and updated the config.asp file.
Anyone any suggestions  ?
Thx,
Tom
|
|
|
|
|
You need to have write access to the .mdb file.
|
|
|
|
|
Bjornar,
I'm pretty sure that I have write access as my 'normal' ASP pages are able to update the database...
Another suggestion maybe ?
Thx,
Tom
|
|
|
|
|
Hi !
It seems to be related to the fact that I'm using anonymous access - when I'm authenticated there's no problem (probably some security setting by my hosting provider). Now I wonder how I can get authenticated even when anonymous access is allowed. Anyone any suggestions ?
Thx,
Tom
|
|
|
|
|
Bjorn,
This is really great stuf  !
I however ran into some errors  (which seem to be related to missing ADOX constants - which indeed are not in your adojavas.inc) :
When clicking 'indexes' :
Error Type: Microsoft JScript runtime (0x800A1391) 'adIndexNullsAllow' is undefined /netdb/b.func.asp, line 28
When clicking 'keys' :
Error Type: Microsoft JScript runtime (0x800A1391) 'adKeyPrimary' is undefined /netdb/keys.asp, line 29
I hope you can help me out !
Best regards,
Tom
|
|
|
|
|
Modify the file common.asp to look like this in the top:
<br />
<!--#include file=config.asp--><br />
<!--#include file=adojavas.inc--><br />
<br />
<%<br />
var adIndexNullsAllow = 0x00000000;<br />
var adIndexNullsDisallow = 0x00000001;<br />
var adIndexNullsIgnore = 0x00000002;<br />
var adIndexNullsIgnoreAny = 0x00000004<br />
<br />
var adKeyPrimary = 0x00000001;<br />
var adKeyForeign = 0x00000002;<br />
var adKeyUnique = 0x00000003;<br />
<br />
var adRICascade = 0x00000001;<br />
var adRINone = 0x00000000;<br />
var adRISetDefault = 0x00000003;<br />
var adRISetNull = 0x00000002;<br />
%><br />
<br />
...<br />
|
|
|
|
|
OK so maybe i am being silly but is their any instruction on how to config the config.asp?
I want to us it to admin a SQL DB so what info would i need and what lines should i // out?
I cant wait to us this maodule.
Willa
|
|
|
|
|
These two lines are needed to connect to MS-SQL:
<br />
case 'connstr': return 'Provider=SQLOLEDB.1;User ID=sa; Password=;Initial Catalog=mydb;Data Source=(local)';<br />
case 'database': return 'mydb';<br />
where mydb is the name of your database, and (local) is the name of the server where MS-SQL is running. You might need to change User ID and Password also.
|
|
|
|
|
The look up does not work. The combo box shows the Foreign Key but when I select and try to go to the next page I get this error.
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/HAL/HAL_MAINTENANCE/data.asp, line 88
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705)
Any help would be appreciated. Using SQL 2000 on Windows 2000.
|
|
|
|
|
The foreign key must be only one field and that field must be integer. Could this be the problem?
|
|
|
|
|
Yes that is the problem. Thanks
|
|
|
|
|
These schemas are not showing up:
Asserts
CharacterSets
Collations
ColumnsDomainUsage
ConstraintColumnUsage
ConstraintTableUsage
Cubes
Dimensions
Hierarchies
KeyColumnUsage
Levels
Measures
Members
ProcedureColumns
Properties
ProviderSpecific
ReferentialConstraints
SQLLanguages
Translations
Trustees
UsagePrivileges
ViewColumnUsage
Views
ViewTableUsage
Maybe it has to do with Provider. I reference database with:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Trusted_Connection=Yes;Data Source=SERVERNAME;Initial Catalog=DATABASENAME;
Is there a better provider for referencing MS SQL Server 7 and 2000
Thanks.
|
|
|
|
|
There are no better providers that I know. Guess you could try to go via ODBC, but I doubt that would help
Doesn't have to be the provider either, since all databases might not support all shcemas defined in ADO.
|
|
|
|
|
A really nicely developed app - well done!
I have found two errors, both of which have been mentioned in the forum - Missbean and Annonymus on the 12/12/2002 and 17/12/2002.
Are there any fixes available?
Nellie
|
|
|
|
|
The link to table_info.asp shouldn't be there.
The error message from Annonymus I have no fix for.
|
|
|
|
|
Thank you for your response, any idea what is causing the error, when trying to save an edited record?
Nellie
|
|
|
|
|
I had changed the database file in config file as told to do so.Also the mdb file is the one from one of the code project source code.iam using winnt and IIS 4.0.Wat should i do , most codes from here i am getting an error
error is :
Response object error 'ASP 0156 : 80004005'
Header Error
/trial/tabeditor/common.asp, line 25
The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.
PLZZZZZZZZZZ HELP ME , IAM INTO A PROJECT AND NEED THIS
Amit Upadhyay
|
|
|
|
|
I encounter the following error.
ADODB.Connection (0x800A0CB3)
Object or provider is not capable of performing requested operation.
/admin/Default.asp, line 25
I'm trying to connect using DSN since the database is on another server. Any help would be greatly appreciated.
|
|
|
|
|
Only Access and MS SQL are supported, and only through OleDb. Sounds to me like you are using ODBC, or a different database.
|
|
|
|
|
The only problem that I'm getting is that none of the ado constants are defined. I'm running this on a WinXP system on which I primarily do ASP maint. Is there some config setting which makes the ado constants available to the scripts. I usually need to include adovbs.inc if I want these values available for VB Scripts.
|
|
|
|
|
Answered my own question.
Forgot to move the METADATA stuff to the active global.asa.
Also needed to update for ADO2.7
Here's some info on METADATA if your so interested: http://www.atgconsulting.com/adotypelibs.asp
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
