Re: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Manohar Kamath [MVP] (mkamath_at_TAKETHISOUTkamath.com)
Date: 02/14/04 

Date: Fri, 13 Feb 2004 22:56:28 -0600

Show us the INSERT statement, please. 

-- 
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Nico Leiska" <nadlo@pipari.net.invalid> wrote in message
news:evhiHRk8DHA.2416@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I am able to retrieve data from database and then the object name is fine,
> say SELECT * FROM problemdb, but when I try to use INSERT, I get the error
> in subject.
>
> The access rights are enough, as far as I can see, and the error only
comes
> from ASP page, not when I do it with windows scripting host (or cscript).
>
> I use the following command in ASP, is it ok?
> <%
> set Conn = CreateObject ("ADODB.connection")
> Conn.Open "driver={SQL
> Server};server=ip.ad.re.ss;uid=myself;pwd=mypasswd;database=mydatabase"
> %>
>
> So I explicitely connect to the database I want to.
>
> Could anyone say what's the problem? I think it might be the connection
I'm
> using... I've seen it done differently, but this works
>
> The SQL server is in the same server as the IIS where I run the pages.
>
> Thanks for the help.
>
>

Relevant Pages

  • Re: Are Frontpage passwords secure?
    ... These access a sql server ... > database which has credit cards. ... How does your asp get the credentials for presentation to SQL?? ... If you are using the DB for credit card info, ...
    (microsoft.public.security)
  • RE: ASP Help Needed
    ... Derive the difference, again, using datediff() ... dont touch the database (best practice - if you did a PORPER analisys ... > I need some help with the ASP. ... > I am using MS SQL server 2000 as database ...
    (microsoft.public.inetserver.asp.components)
  • Problem in Synchronization PocketPC with SQL Server
    ... my Pocket PC with a database in a PC. ... In my Pocket PC i have SQLCE 2.0. ... PC is running SQL SERVER 2000 and IIS. ... "..ASP ERROR " and the ...
    (microsoft.public.sqlserver.ce)
  • [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
    ... say SELECT * FROM problemdb, but when I try to use INSERT, I get the error ... I use the following command in ASP, ... So I explicitely connect to the database I want to. ... The SQL server is in the same server as the IIS where I run the pages. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Hope this is the correct forum... Question on connection issue
    ... I can say that if I reset SQL Server, I have to re-run everything in Query ... the ASP server quit using them. ... > Our database had been running great for over a year now... ...
    (microsoft.public.sqlserver.server)