as if I didn't know that much, your answer is far to vanilla. thanks anyway

whats the best way to upgrade my client?

not the taskpad. When I open the database & click on tables the right window is emty. By the way to be clear, I can see the SQL7 tables...

I already thought of using refresh but I wanted the best performance I could get.

Thanks for the input 😉

I got it to work!

I was using addatetime, it needs addate.

And the variable names do mater. This may be a Visual InterDev thing.

Again, I can't thank you enough for your...

This is the usp interface

CREATE PROCEDURE spAddBusinessDays @StartDate smalldatetime, @AddDays smallint, @NewDate smalldatetime OUTPUT

Looks like your almost right:

ADODB.Parameters error '800a0e7c'

Parameter object is improperly defined. Inconsistent or incomplete information was provided.

cmd.parameters.append cmd.CreateParameter("StartDate", addatetime, adparamInput, 8)

cmd.parameters.append cmd.CreateParameter("AddDays", adInteger, adparamInput, 4)

cmd.parameters.append cmd.CreateParameter("NewDate", addatetime, adparamReturnValue,...

It is loose, but I can't (AS) anything.

this works:

Dim DATABASE

Dim cmd

Dim params

but I still run into:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'parameters'

/DATA/reports/sumReport.asp, line...

so I commented the Dims out, heres the next error:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'parameters'

/DATA/reports/sumReport.asp, line 79

the asp doesn't get that far:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/DATA/reports/sumReport.asp, line 66

Dim DATABASE as ADODB.Connection

-----------^

Sorry man, none of this code is working in InterDev, I can't seem to find sample code anywhere.

Dim DATABASE as ADODB.Connection

Dim cmd as ADODB.Command

Dim params as ADODB.parameters

Set DATABASE = Server.CreateObject("ADODB.Connection")

DATABASE.Open...

Steve, I zeroed in on the gateway because he said he could connect but he reloaded the client and now he can't. Start with the simplest first.

archie

Hello Parasu,

By your last post it sounds like your client is missing the default gateway. Use ipconfig /all to see your network configuration.

archie