Re: FN-FORUM ASP opportunity

date posted 29th September 2002 16:16

The problem appears to be that I am using a dnsless connection, I can do
this using a normal odbc set up but I really want to be able to do it
without!

It seems to me that it opens the connection ok but perhaps in read
rather than write mode, either that or I need to assign a name to the
connection so that I can then refer to it in the insert statement
seperately.

God this is driving me nuts!

John

Anthony Johnston . Antix wrote:

>commandtext is not on the connection object
>just put it in execute statement
>
>dmdTemp.Execute("INSERT blaaaa....")
>
>:) Ant.
>
>-----Original Message-----
>From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of john anslow
>Sent: 29 September 2002 12:48
>To: [EMAIL REMOVED]
>Subject: FN-FORUM ASP opportunity
>
>
>Hi guys,
>
>need a bit of help from the asp gurus amongst you.
>
>I'm using a direct connection to an access db which works fine for
>select statements but errors for inserts, here's the code I'm using and
>the error I'm getting.
>
>Can anyone cast any light on why it's not working?
>
>
> Set dmdTemp = Server.CreateObject("ADODB.Connection")
> dmdTemp.Provider = "Microsoft.Jet.OLEDB.4.0"
> dmdTemp.ConnectionString = "Data
>Source=d:websitessitenamefolderdatadtabase.mdb;"
> dmdTemp.Open
> dmdTemp.CommandText="INSERT INTO `homepage`
>(description,twso,price)VALUES('"+description+"','"+twso+"',''"+price+"')"
> dmdTemp.CommandType=1
> dmdTemp.Execute
>
>gives me the following error
>
>Microsoft VBScript runtime error '800a01be'
>
>Object doesn't support named arguments: 'CommandText'
>
>/cccomputing/scripts/addahp.asp , line 18
>
>TIA,
>
>John
>

--

Fatfriar Productions

"With you every step of the way"

Website Design and Production at a reasonable rate and with a level of
service second to none.

Web: http://www.Fatfriar.com E-mail: [EMAIL REMOVED]

Telephone: +44 (0)208 405 4151

Mobile telephone: +44 (0)7798 746 685

Go Beyond Your Limitations...


The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or
any action or omission taken by you in reliance on it, is prohibited and
may be unlawful. Please contact the sender immediately if you have
received this message in error. Thank you.