p2p.wrox.com: Archives - asp

asp_databases thread: ADODB.Connection-Fehler '800a0e7a' (ADO Connection Error)

Message #1 by "M. V�geli" <marco.voegeli@m...> on Mon, 24 Jul 2000 15:4:59

I have created an online-store with ms-97-access-databses (*.mdb)



On my server iis 4.0 it functions. I'm using de

microsoft.jet.oledb.4.0 to connect. But on my customer's

server it does not function. I get the error message:



ADODB.Connection-Fehler '800a0e7a' 



ADO konnte die angegebene Datenquelle nicht finden. 

(ado was not able to find the data-source)4



/cgi-bin/shop_diagramma/db.inc, Zeile 21



so I have tried to connect with an dsn-less odbc-driver. 

That functioned, but the field names of the access-database-table

were not right??? But they were. So my internet service provider

don't know much about iis. So could you tell me what can be

wrong on the server?



thanks for your help.



mailto:marco.voegeli@m...

switzerland

Message #2 by "Philip.Ware" <Philip.Ware@e...> on Mon, 24 Jul 2000 15:49:47 +0100

Your customers server is most likely using a different JET.OLEDB dll

version.



Ask them to update to version 4.0 - MDAC_TYP Version 2.5 will update

the jet dll's to version 4.0



Phil.



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

> From: M. V=F6geli 

> Sent: 24 July 2000 02:01

> To: ASP Databases

> Subject: [asp_databases] ADODB.Connection-Fehler '800a0e7a' (ADO

> Connection Error)

>

>

> I have created an online-store with ms-97-access-databses (*.mdb)

>

> On my server iis 4.0 it functions. I'm using de

> microsoft.jet.oledb.4.0 to connect. But on my customer's

> server it does not function. I get the error message:

>

> ADODB.Connection-Fehler '800a0e7a'

>

> ADO konnte die angegebene Datenquelle nicht finden.

> (ado was not able to find the data-source)4

>

> /cgi-bin/shop_diagramma/db.inc, Zeile 21

>

> so I have tried to connect with an dsn-less odbc-driver.

> That functioned, but the field names of the access-database-table

> were not right??? But they were. So my internet service provider

> don't know much about iis. So could you tell me what can be

> wrong on the server?

>

> thanks for your help.

>

> mailto:marco.voegeli@m...

> switzerland

>

>

>

>

Message #3 by "Ken Schaefer" <ken.s@a...> on Tue, 25 Jul 2000 10:11:16 +1000

Have you ever see the error:



error 'abcdef00'

The relevant code was not found



?



How about you post some code that you are using, and let us look?



Cheers

Ken





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

From: "M. V=F6geli" <marco.voegeli@m...>

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

Sent: Monday, July 24, 2000 3:00 PM

Subject: [asp_databases] ADODB.Connection-Fehler '800a0e7a' (ADO Connecti

on

Error)





> I have created an online-store with ms-97-access-databses (*.mdb)

>

> On my server iis 4.0 it functions. I'm using de

> microsoft.jet.oledb.4.0 to connect. But on my customer's

> server it does not function. I get the error message:

>

> ADODB.Connection-Fehler '800a0e7a'

>

> ADO konnte die angegebene Datenquelle nicht finden.

> (ado was not able to find the data-source)4

>

> /cgi-bin/shop_diagramma/db.inc, Zeile 21

>

> so I have tried to connect with an dsn-less odbc-driver.

> That functioned, but the field names of the access-database-table

> were not right??? But they were. So my internet service provider

> don't know much about iis. So could you tell me what can be

> wrong on the server?

>

> thanks for your help.

>

> mailto:marco.voegeli@m...

> switzerland

Message #4 by "Marco Voegeli" <marco.voegeli@m...> on Tue, 25 Jul 2000 11:03:04 +0200

Hello Ken



No, i have never seen this error. What do you mean with

"How about you post some code that you are using, and let us look?"



Should I send you some ASP-Code? That would be no problem...



Tell me.



bye

Marco







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

From: "Ken Schaefer" 

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

Sent: Tuesday, July 25, 2000 2:11 AM

Subject: [asp_databases] Re: ADODB.Connection-Fehler '800a0e7a' (ADO

Connection Error)





Have you ever see the error:



error 'abcdef00'

The relevant code was not found



?



How about you post some code that you are using, and let us look?



Cheers

Ken





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

From: "M. V�geli" <marco.voegeli@m...>

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

Sent: Monday, July 24, 2000 3:00 PM

Subject: [asp_databases] ADODB.Connection-Fehler '800a0e7a' (ADO Connection

Error)





> I have created an online-store with ms-97-access-databses (*.mdb)

>

> On my server iis 4.0 it functions. I'm using de

> microsoft.jet.oledb.4.0 to connect. But on my customer's

> server it does not function. I get the error message:

>

> ADODB.Connection-Fehler '800a0e7a'

>

> ADO konnte die angegebene Datenquelle nicht finden.

> (ado was not able to find the data-source)4

>

> /cgi-bin/shop_diagramma/db.inc, Zeile 21

>

> so I have tried to connect with an dsn-less odbc-driver.

> That functioned, but the field names of the access-database-table

> were not right??? But they were. So my internet service provider

> don't know much about iis. So could you tell me what can be

> wrong on the server?

>

> thanks for your help.

>

> mailto:marco.voegeli@m...

> switzerland

Message #5 by "Daniel Walker" <danielw@w...> on Tue, 25 Jul 2000 11:57:17

Post it on the list, Marco. Always post as much information on the list as 

you can about a problem. That way, there's more chance of getting an answer 

- or at least, a useful one :-) .



On 07/25/00, ""Marco Voegeli" wrote:

> Hello Ken



No, i have never seen this error. What do you mean with

"How about you post some code that you are using, and let us look?"



Should I send you some ASP-Code? That would be no problem...



Tell me.



bye

Marco







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

From: "Ken Schaefer" 

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

Sent: Tuesday, July 25, 2000 2:11 AM

Subject: [asp_databases] Re: ADODB.Connection-Fehler '800a0e7a' (ADO

Connection Error)





Have you ever see the error:



error 'abcdef00'

The relevant code was not found



?



How about you post some code that you are using, and let us look?



Cheers

Ken





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

From: "M. V�geli" 

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

Sent: Monday, July 24, 2000 3:00 PM

Subject: [asp_databases] ADODB.Connection-Fehler '800a0e7a' (ADO 

Connection

Error)





> I have created an online-store with ms-97-access-databses (*.mdb)

>

> On my server iis 4.0 it functions. I'm using de

> microsoft.jet.oledb.4.0 to connect. But on my customer's

> server it does not function. I get the error message:

>

> ADODB.Connection-Fehler '800a0e7a'

>

> ADO konnte die angegebene Datenquelle nicht finden.

> (ado was not able to find the data-source)4

>

> /cgi-bin/shop_diagramma/db.inc, Zeile 21

>

> so I have tried to connect with an dsn-less odbc-driver.

> That functioned, but the field names of the access-database-table

> were not right??? But they were. So my internet service provider

> don't know much about iis. So could you tell me what can be

> wrong on the server?

>

> thanks for your help.

>

> mailto:marco.voegeli@m...

> switzerland

Message #6 by "Ken Schaefer" <ken.s@a...> on Tue, 25 Jul 2000 20:56:01 +1000

Hi,



The "error" I was talking about means - "we can't help you because the

relevant code is not available for us to look at".



When I said "Post some code" it means cut and paste the relevant code that

is causing problems and "post" (send) it to the list.



Sorry for the confusion.



Cheers

Ken



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

From: "Marco Voegeli" <marco.voegeli@m...>

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

Sent: Tuesday, July 25, 2000 7:03 PM

Subject: [asp_databases] Re: ADODB.Connection-Fehler '800a0e7a' (ADO

Connection Error)





> Hello Ken

>

> No, i have never seen this error. What do you mean with

> "How about you post some code that you are using, and let us look?"

>

> Should I send you some ASP-Code? That would be no problem...

>

> Tell me.

>

> bye

> Marco

>

>

>

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

> From: "Ken Schaefer"

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

> Sent: Tuesday, July 25, 2000 2:11 AM

> Subject: [asp_databases] Re: ADODB.Connection-Fehler '800a0e7a' (ADO

> Connection Error)

>

>

> Have you ever see the error:

>

> error 'abcdef00'

> The relevant code was not found

>

> ?

>

> How about you post some code that you are using, and let us look?

>

> Cheers

> Ken

Message #7 by "M. V�geli" <marco.voegeli@m...> on Tue, 25 Jul 2000 12:19:45

Hello together



Here the code I used in an include in each asp-file which uses

database-connection:



<!-- #include file="adovbs.inc" -->



<%

Dim dbc

dim dbk

dim dbp



Dim strConn

Dim strpath



dim strconn2

dim strpath2



set dbc = Server.CreateObject("ADODB.Connection")

dbc.Provider="Microsoft.Jet.OLEDB.4.0"

dbc.Open server.MapPath("/cgi-bin/shop_diagramma") & "\db-user.mdb"







set dbp = Server.CreateObject("ADODB.Connection")

dbp.Provider="Microsoft.Jet.OLEDB.4.0"

dbp.Open server.MapPath("/cgi-bin/shop_diagramma") & "\db-products.mdb"



%>



So, what I should tell is that I got a note, to update

Microsoft Data Access Components to version 2.5.



This is downloadable on microsoft homepage, costless. I just was

not able to test it till now, because my isp was not there.



But here, I give you the link on which the shop functions:

<a href="http://www.access4u.ch/cgi-bin/shop_diagramma">Shop that 

functions</a>



And here the other (my customer's) server, which does not function:

<a href="http://www.diagramma.ch/cgi-bin/shop_diagramma">Shop that does not 

function</a>



Best regards

Marco

Message #8 by "Marco Voegeli" <marco.voegeli@m...> on Wed, 26 Jul 2000 16:01:54 +0200

Hello Phil



Thanks for your note. It was really the reason.



Bye

Marco



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

From: "Philip.Ware" 

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

Sent: Monday, July 24, 2000 4:49 PM

Subject: [asp_databases] RE: ADODB.Connection-Fehler '800a0e7a' (ADO Conn

ection Error)





Your customers server is most likely using a different JET.OLEDB dll

version.



Ask them to update to version 4.0 - MDAC_TYP Version 2.5 will update

the jet dll's to version 4.0



Phil.



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

> From: M. V�geli

> Sent: 24 July 2000 02:01

> To: ASP Databases

> Subject: [asp_databases] ADODB.Connection-Fehler '800a0e7a' (ADO

> Connection Error)

>

>

> I have created an online-store with ms-97-access-databses (*.mdb)

>

> On my server iis 4.0 it functions. I'm using de

> microsoft.jet.oledb.4.0 to connect. But on my customer's

> server it does not function. I get the error message:

>

> ADODB.Connection-Fehler '800a0e7a'

>

> ADO konnte die angegebene Datenquelle nicht finden.

> (ado was not able to find the data-source)4

>

> /cgi-bin/shop_diagramma/db.inc, Zeile 21

>

> so I have tried to connect with an dsn-less odbc-driver.

> That functioned, but the field names of the access-database-table

> were not right??? But they were. So my internet service provider

> don't know much about iis. So could you tell me what can be

> wrong on the server?

>

> thanks for your help.

>

> mailto:marco.voegeli@m...

> switzerland

>

>

>

Return to Index

P2P Archives