asptoday_discuss thread: Problem with access database, Undefinided error
Message #1 by "Antonio Garcia" <antonio_garcia@d...> on Mon, 8 Oct 2001 19:26:05
|
|
I have a intranet web con access databased. It work good but
any times have a error "Undefinided error" in the line for open
the database or in Execute sql string line. after any minutes back to
work good but any times i have to reset the server.
thanks
Message #2 by "R. Sanchez" <rodrigosp@g...> on Mon, 08 Oct 2001 17:14:29 -0700 (PDT)
|
|
You could verify the ODBC drivers that it's good, and could you made a system dsn.
Bye.
>
>I have a intranet web con access databased. It work good but
>any times have a error "Undefinided error" in the line for open
>the database or in Execute sql string line. after any minutes back to
>work good but any times i have to reset the server.
>
>thanks
>
Message #3 by "Antonio Garcia" <antonio_garcia@d...> on Tue, 9 Oct 2001 08:06:10
|
|
I have a conexion with system DSN. What is the better conexion method?
You have a good code sintasyx for conection by driver access 2000?
thanks
> You could verify the ODBC drivers that it's good, and could you made a
system dsn.
>
> Bye.
>
>
> >
> >I have a intranet web con access databased. It work good but
> >any times have a error "Undefinided error" in the line for open
> >the database or in Execute sql string line. after any minutes back to
> >work good but any times i have to reset the server.
> >
> >thanks
> >
Message #4 by david kuridza <david.kuridza@s...> on Tue, 9 Oct 2001 11:13:25 +0200
|
|
try something like this:
strconn = "Provider=Microsoft.Jet:OLEDB.4.0; Data
Source=c:\InetPub\wwwrooot\database.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strconn
i always use this ... and it never failed ... not even once ...
|
View Cart
