|
 |
asp_databases thread: DSNless connection to Access
Message #1 by Dieter Lubbe <dieter@n...> on Wed, 07 Jun 2000 19:49
|
|
I'm trying to connect to an Acces DB on windows 2000 and get an
internal server error.
It works on my work p.c which is NT4.
Can anyone help me out here?
Here is my code..
set conntemp=server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=DSNtemp & "DBQ=" & server.mappath("/database/teeoff.mdb")
conntemp.Open DSNtemp
Thanx,
Dieter
----
NetActive Personal
Message #2 by "Ken Schaefer" <ken.s@a...> on Thu, 8 Jun 2000 18:26:23 +1000
|
|
How do you know that it is the code that you have below that is causing the
error?
Also, a suggestion, ditch the ODBC and use an OLEDB connection string
instead.
Cheers
Ken
----- Original Message -----
From: "Dieter Lubbe"
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, June 07, 2000 7:49 PM
Subject: [asp_databases] DSNless connection to Access
> I'm trying to connect to an Acces DB on windows 2000 and get an
> internal server error.
> It works on my work p.c which is NT4.
>
> Can anyone help me out here?
> Here is my code..
>
> set conntemp=server.createobject("adodb.connection")
> DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
> DSNtemp=DSNtemp & "DBQ=" & server.mappath("/database/teeoff.mdb")
> conntemp.Open DSNtemp
>
> Thanx,
>
> Dieter
Message #3 by "Mukul Jain" <jainmukul@h...> on Thu, 08 Jun 2000 16:05:04 IST
|
|
Is your database is in Access 2000 ??
check that u have updated OBDC Drivers on the web server or get the same by
installing latest version of MDAC
Mukul
From: Dieter Lubbe
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] DSNless connection to Access
Date: Wed, 07 Jun 2000 19:49
I'm trying to connect to an Acces DB on windows 2000 and get an
internal server error.
It works on my work p.c which is NT4.
Can anyone help me out here?
Here is my code..
set conntemp=server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=DSNtemp & "DBQ=" & server.mappath("/database/teeoff.mdb")
conntemp.Open DSNtemp
Thanx,
Dieter
----
NetActive Personal
Message #4 by "Dieter Lubbe" <dieterl@z...> on Thu, 8 Jun 2000 14:45:41 +0200
|
|
I did update the ODBC drivers...
i still don't know what could be wrong...
-----Original Message-----
From: Mukul Jain
Sent: Thursday, June 08, 2000 6:05 PM
To: ASP Databases
Subject: [asp_databases] Re: DSNless connection to Access
Is your database is in Access 2000 ??
check that u have updated OBDC Drivers on the web server or get the same by
installing latest version of MDAC
Mukul
From: Dieter Lubbe
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] DSNless connection to Access
Date: Wed, 07 Jun 2000 19:49
I'm trying to connect to an Acces DB on windows 2000 and get an
internal server error.
It works on my work p.c which is NT4.
Can anyone help me out here?
Here is my code..
set conntemp=server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=DSNtemp & "DBQ=" & server.mappath("/database/teeoff.mdb")
conntemp.Open DSNtemp
Thanx,
Dieter
----
NetActive Personal
Message #5 by "Mukul Jain" <jainmukul@h...> on Thu, 08 Jun 2000 22:20:13 IST
|
|
i faced the same problem, I have a work around. You save database in
Access97 format, u have option for that in Access 2000 and then check, as
for me it worked.. and there was no prbs
Mukul
From: "Dieter Lubbe"
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] Re: DSNless connection to Access
I did update the ODBC drivers...
i still don't know what could be wrong...
-----Original Message-----
From: Mukul Jain
Sent: Thursday, June 08, 2000 6:05 PM
To: ASP Databases
Subject: [asp_databases] Re: DSNless connection to Access
Is your database is in Access 2000 ??
check that u have updated OBDC Drivers on the web server or get the same by
installing latest version of MDAC
Mukul
From: Dieter Lubbe
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] DSNless connection to Access
Date: Wed, 07 Jun 2000 19:49
I'm trying to connect to an Acces DB on windows 2000 and get an
internal server error.
It works on my work p.c which is NT4.
Can anyone help me out here?
Here is my code..
set conntemp=server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=DSNtemp & "DBQ=" & server.mappath("/database/teeoff.mdb")
conntemp.Open DSNtemp
Thanx,
Dieter
----
NetActive Personal
|
|
|
View Cart
