|
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
|
|
|
|
|
The install took < 60 seconds (made an application in IIS, changed provider string) and it was up & running!
I'm impressed.
Nice work.
|
|
|
|
|
All I have changed is the config to point to test.mdb (in the same dir). Getting this.
Response object error 'ASP 0156 : 80004005'
Header Error
/dbadmin/common.asp, line 25
The HTTP headers are already written to the client...
If I remove lines 25 and 26 I get:
Microsoft JScript runtime error '800a1391'
'adUseClient' is undefined
/dbadmin/common.asp, line 30
I have the properties in PWS set to Execute for this dir but I am not sure tht is the same as an IIS application.
bill
|
|
|
|
|
I Can't run Online DB Administration well, it cause some errors that in source file wrote.
So can you help me ?
|
|
|
|
|
Got it to work and bring up all my tables in the Database but why can I add, edit and delete from some tables and not from others? Is it a setting in the code or is it my database? Using SQL 2000 on Windows 2000 server. Thanks for any help.
Swanger
|
|
|
|
|
Please i got a table with two foreign key
on using data.asp?table=xxx
where xx is my table name on clicking the edit button
the edit screen pop up nicely but on clicking the save button
i received the following error message
Multiple-step operation generated errors. Check each status value.
|
|
|
|
|
menu of 'view/Overview' linked table_info.asp
but there is not in zip file.
|
|
|
|
|
The file shouldn't be there, and therefore the link shouldn't have been there either.
|
|
|
|
|
Please i changed the config.asp
as follows
case 'connstr': return 'DSN=xxxx';
i created a system data source pointing to a database on sql server 2000 on another server
I used but i got the error message microsoft ole db provider
with sql authentication using loginid i entered the sa and its corresponding password
but i got the following error message oledb provider for odbc driver error 80040e4d login failed for user null reason not associated with a trusted sql server connection
Help please
|
|
|
|
|
1 - Check that Sql2k permit Mixed Mode auth ( simply verify that you can connect by (sa , xxxx) using QueryAnalyser
2 - Check the authentication mode on your DSN system source
3 - Please post the connection string. I think that can be more useful using a DSN-LESS connection string, using OleDb provider. For example: try:
"DRIVER=SQL Server;SERVER=YOURSERVERNAME;UID=sa;PWD=xxxx;DATABASE=YOURCATALOGNAME"
Hope this can help you.
Giacomo
|
|
|
|
|
can it be used with dsn connecttion to sql on another server
what changes should be done
|
|
|
|
|
Take a look at config.asp, should be pretty obvious I think 
|
|
|
|
|
Please i changed the config.asp
as follows
case 'connstr': return 'DSN=xxxx';
i created a system data source pointing to a database on sql server 2000 on another server
I usedbut i got the error message microsoft ole db provider
with sql authentication using loginid i entered the sa and its corresponding password
but i got the following error message oledb provider for odbc driver error 80040e4d login failed for user null reason not associated with a trusted sql server connection
Help please
|
|
|
|
|
Is your sql server set up to use only windows authenticationand not sql server authentication? I believe this is the default for MSDE2000.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
