|
|
You're in the
inetserver asp general
group:Error 800a01a8 object required
inetserver asp general:
[quoted text, click to view] "Raj" <raj@track-mate.net> wrote in message news:ePO6j8$tHHA.4800@TK2MSFTNGP05.phx.gbl... >I have developed a component create database, sql login,pwd, create tables etc., > > The component is working fine with VB > > But the same is not working with ASP as I get this error: Error 800a01a8 > > For creating database, sql login,pwd I am using sa with a valid password. > > Please advice. > > Thank you, > > Regards, > > Raj. >
I have developed a component create database, sql login,pwd, create tables
etc., The component is working fine with VB But the same is not working with ASP as I get this error: Error 800a01a8 For creating database, sql login,pwd I am using sa with a valid password. Please advice. Thank you, Regards, Raj.
Thanx indeed Job, but I have checked the link already.
Here's what I am trying exactly. I have an application server running Windows 2003 Server with IIS 6.0 and have a separate database server running Windows 2003 Server with MS SQL Server 2000. I am trying to create database, SQL login, tables from my application server through ASP onto the database server. Before creating the objects (database, sqllogin, tables etc.,) I check for whether these objects exists already or not. The database is created successfully, but SQLLogin and tables creation was never successful. I tried the same through VB it was successful. I tried to create all objects on my application server itself it was successful. I am able to connect to the database server through SQL Query Analyzer. For all database creation and SQL Login creation I am using sa login. Please advice Thank you, Regards, Raj. [quoted text, click to view] "Jon Paal [MSMD]" <Jon nospam Paal @ everywhere dot com> wrote in message news:13829gjbshcribe@corp.supernews.com... > http://classicasp.aspfaq.com/general/why-do-i-get-the-error-object-required.html > > > "Raj" <raj@track-mate.net> wrote in message > news:ePO6j8$tHHA.4800@TK2MSFTNGP05.phx.gbl... >>I have developed a component create database, sql login,pwd, create tables >>etc., >> >> The component is working fine with VB >> >> But the same is not working with ASP as I get this error: Error 800a01a8 >> >> For creating database, sql login,pwd I am using sa with a valid password. >> >> Please advice. >> >> Thank you, >> >> Regards, >> >> Raj. >> > >
Thanx for all your advice.
When I try to execute those commands (these commands I have used in the component) directly in ASP page it works fine. I need to know, whether I can use script encoder to encode .inc file which I will include it in my ASP page which will do all? The .inc file will be in location where it cannot be url downloaded Regards, Raj [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:O1n6aSAuHHA.4800@TK2MSFTNGP05.phx.gbl... > Raj wrote: >> Thanx indeed Job, but I have checked the link already. >> >> Here's what I am trying exactly. >> >> I have an application server running Windows 2003 Server with IIS 6.0 >> and have a separate database server running Windows 2003 Server with >> MS SQL Server 2000. >> >> I am trying to create database, SQL login, tables from my application >> server through ASP onto the database server. >> >> Before creating the objects (database, sqllogin, tables etc.,) I >> check for whether these objects exists already or not. >> >> The database is created successfully, but SQLLogin and tables >> creation was never successful. >> >> I tried the same through VB it was successful. I tried to create all >> objects on my application server itself it was successful. >> >> I am able to connect to the database server through SQL Query >> Analyzer. >> >> For all database creation and SQL Login creation I am using sa login. >> >> Please advice >> > Sorry, but with the information we've been given, it is impossible for > anyone to solve your problem. Someone will need to be able to run and > debug your code to do that. > > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >
[quoted text, click to view]
Bob Barrows [MVP] wrote: > Never use the sa account in your applications. Never. Not even if you remove the [sysadmin] role? It's clearly better to state that the web application should never use credentials granted the [sysadmin] role. There is nothing special about sa in this case. -- Dave Anderson Unsolicited commercial email will be read at a cost of $500 per message. Use of this email address implies consent to these terms.
[quoted text, click to view]
Raj wrote: Jon tackled your subject problem, but I could not let this pass:> For creating database, sql login,pwd I am using sa with a valid > password. > Never use the sa account in your applications. Never. The sa is account is for System Administration. Period. The sa password should NEVER appear in application code. It should be guarded as if your database, server, network and job depended upon it ... it probably does. Best practice is to create a limited-rights sql account (login) for use in your applications. That account should have permissions for only the tasks needed by the application. Since it appears your component is creating a database, the account you create should be put in the dbcreator server role. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
[quoted text, click to view]
Raj wrote: Sorry, but with the information we've been given, it is impossible for> Thanx indeed Job, but I have checked the link already. > > Here's what I am trying exactly. > > I have an application server running Windows 2003 Server with IIS 6.0 > and have a separate database server running Windows 2003 Server with > MS SQL Server 2000. > > I am trying to create database, SQL login, tables from my application > server through ASP onto the database server. > > Before creating the objects (database, sqllogin, tables etc.,) I > check for whether these objects exists already or not. > > The database is created successfully, but SQLLogin and tables > creation was never successful. > > I tried the same through VB it was successful. I tried to create all > objects on my application server itself it was successful. > > I am able to connect to the database server through SQL Query > Analyzer. > > For all database creation and SQL Login creation I am using sa login. > > Please advice > anyone to solve your problem. Someone will need to be able to run and debug your code to do that. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
[quoted text, click to view]
Raj wrote: Again. I haven't the slightest idea what you are talking about. What> Thanx for all your advice. > > When I try to execute those commands (these commands I have used in > the component) directly in ASP page it works fine. > > I need to know, whether I can use script encoder to encode .inc file > which I will include it in my ASP page which will do all? > > The .inc file will be in location where it cannot be url downloaded > does script encoding have to do with your problem? -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |