p2p.wrox.com: Archives - asp

asp_databases thread: Access 2000 Data Sources?

Message #1 by "Griffin Caprio" <gcaprio@r...> on Thu, 19 Jul 2001 09:34:32 -0500

Does any one know how to use a Access 2000 Data Source with an ASP page?

This is my source:



connection.open "Provider=MSDASQL.1;Data Source=PenAge"



Where PenAge is a defined DSN. This is the error:



[Microsoft][ODBC Driver Manager] Data source name not found and no default

driver specified



Any ideas?



Griffin Caprio

Message #2 by "Tomm Matthis" <matthis@b...> on Thu, 19 Jul 2001 10:53:39 -0400

Are you using InterDev by any chance?

And do you have the latest version of MDAC installed on the web server?



-- Tomm



> -----Original Message-----

> From: Griffin Caprio [mailto:griffin.caprio@b...]On Behalf Of 

Griffin

> Caprio

> Sent: Thursday, July 19, 2001 10:35 AM

> To: ASP Databases

> Subject: [asp_databases] Access 2000 Data Sources?

>

>

> Does any one know how to use a Access 2000 Data Source with an ASP 

page?

> This is my source:

>

> connection.open "Provider=3DMSDASQL.1;Data Source=3DPenAge"

>

> Where PenAge is a defined DSN. This is the error:

>

> [Microsoft][ODBC Driver Manager] Data source name not found and no 

default

> driver specified

>

> Any ideas?

>

> Griffin Caprio

>

>

Message #3 by "Fione Ho" <fione0212@h...> on Thu, 19 Jul 2001 07:58:00 -0700

connection.open "Provider=Microsoft.Jet.OLEDB.4.0 Data source=PenAge



Microsoft.Jet.OLEDB.4.0 provides access to access databases

MSDASQL provides access to data through an ODBC data source.



>From: "Griffin Caprio" <gcaprio@r...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] Access 2000 Data Sources?

>Date: Thu, 19 Jul 2001 09:34:32 -0500

>

>Does any one know how to use a Access 2000 Data Source with an ASP page?

>This is my source:

>

>connection.open "Provider=MSDASQL.1;Data Source=PenAge"

>

>Where PenAge is a defined DSN. This is the error:

>

>[Microsoft][ODBC Driver Manager] Data source name not found and no default

>driver specified

>

>Any ideas?

>

>Griffin Caprio

>

>

Message #4 by "Jeff Scott" <jeff@j...> on Thu, 19 Jul 2001 09:20:23 -0700

how about using a dsnless connection.



for example I have an include page named codebook.inc which I call this way:



<!--#include file="../include/codebook.inc"-->



<%

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

DatabaseConnection.Open CODEBOOK_STRING

%>





Here is the include file.

<%



MdbFilePath = Server.MapPath("../codebook.mdb")

CODEBOOK_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &

MdbFilePath & ";"





%>



hope this helps. I did this with both access 97 and 2000 and it works for

both.



jeff scott



-----Original Message-----

From: Griffin Caprio [mailto:griffin.caprio@b...]On Behalf Of Griffin

Caprio

Sent: Thursday, July 19, 2001 7:35 AM

To: ASP Databases

Subject: [asp_databases] Access 2000 Data Sources?





Does any one know how to use a Access 2000 Data Source with an ASP page?

This is my source:



connection.open "Provider=MSDASQL.1;Data Source=PenAge"



Where PenAge is a defined DSN. This is the error:



[Microsoft][ODBC Driver Manager] Data source name not found and no default

driver specified



Any ideas?



Griffin Caprio

Message #5 by "Ken Schaefer" <ken@a...> on Fri, 20 Jul 2001 18:22:28 +1000

http://www.adopenstatic.com/faq/whyOLEDB.asp

on why not to use the ODBC Driver



http://www.adopenstatic.com/faq/OLEDBConnection.asp

on setting up an OLEDB Connection string



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Jeff Scott" <jeff@j...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, July 20, 2001 2:20 AM

Subject: [asp_databases] RE: Access 2000 Data Sources?





: how about using a dsnless connection.

:

: for example I have an include page named codebook.inc which I call this

way:

:

: <!--#include file="../include/codebook.inc"-->

:

: <%

: Set DatabaseConnection = Server.CreateObject("ADODB.Connection")

: DatabaseConnection.Open CODEBOOK_STRING

: %>

:

:

: Here is the include file.

: <%

:

: MdbFilePath = Server.MapPath("../codebook.mdb")

: CODEBOOK_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &

: MdbFilePath & ";"

:

:

: %>

:

: hope this helps. I did this with both access 97 and 2000 and it works for

: both.

:

: jeff scott

:

: -----Original Message-----

: From: Griffin Caprio [mailto:griffin.caprio@b...]On Behalf Of Griffin

: Caprio

: Sent: Thursday, July 19, 2001 7:35 AM

: To: ASP Databases

: Subject: [asp_databases] Access 2000 Data Sources?

:

:

: Does any one know how to use a Access 2000 Data Source with an ASP page?

: This is my source:

:

: connection.open "Provider=MSDASQL.1;Data Source=PenAge"

:

: Where PenAge is a defined DSN. This is the error:

:

: [Microsoft][ODBC Driver Manager] Data source name not found and no default

: driver specified

:

: Any ideas?

:

: Griffin Caprio

Message #6 by =?iso-8859-1?q?Med-Ali=20Hassayoun?= <mhassayoun@y...> on Fri, 20 Jul 2001 09:45:10 +0200 (CEST)

Hello,



> MdbFilePath = Server.MapPath("../codebook.mdb")

> CODEBOOK_STRING = "Driver={Microsoft Access Driver

> (*.mdb)}; DBQ=" &

> MdbFilePath & ";"



in this solution, the programer could specify the path

of database("../codebook.mdb")?(yes/no)













 > how about using a dsnless connection.

> 

> for example I have an include page named

> codebook.inc which I call this way:

> 

> <!--#include file="../include/codebook.inc"-->

> 

> <%

> Set DatabaseConnection 

> Server.CreateObject("ADODB.Connection")

> DatabaseConnection.Open CODEBOOK_STRING

> %>

> 

> 

> Here is the include file.

> <%

> 

> MdbFilePath = Server.MapPath("../codebook.mdb")

> CODEBOOK_STRING = "Driver={Microsoft Access Driver

> (*.mdb)}; DBQ=" &

> MdbFilePath & ";"

> 

> 

> %>

> 

> hope this helps. I did this with both access 97 and

> 2000 and it works for

> both.

> 

> jeff scott

> 

> -----Original Message-----

> From: Griffin Caprio

> [mailto:griffin.caprio@b...]On Behalf Of Griffin

> Caprio

> Sent: Thursday, July 19, 2001 7:35 AM

> To: ASP Databases

> Subject: [asp_databases] Access 2000 Data Sources?

> 

> 

> Does any one know how to use a Access 2000 Data

> Source with an ASP page?

> This is my source:

> 

> connection.open "Provider=MSDASQL.1;Data

> Source=PenAge"

> 

> Where PenAge is a defined DSN. This is the error:

> 

> [Microsoft][ODBC Driver Manager] Data source name

> not found and no default

> driver specified

> 

> Any ideas?

> 

> Griffin Caprio

Return to Index

P2P Archives