|
 |
asp_databases thread: RE: How do I use OLEDB to connect to a access- db?-?
Message #1 by "Frankie, Loh Teck Seng" <lohts@p...> on Mon, 3 Jul 2000 21:23:29 +0800
|
|
Greeting;
Can I ask what is book is that?
Thanks.
-----Original Message-----
From: Chris Ullman [mailto:chrisu@w...]
Sent: Thursday, June 29, 2000 7:41 PM
To: ASP Databases
Subject: [asp_databases] RE: How do I use OLEDB to connect to a access
db? ?
To elaborate, as I recommend in my book (plug, plug), create a UDL file
(create a blank text document and change it to have .udl suffix. Then choose
the Jet 4.0 OLE DB Provider and connect it to the database of your choice.
Check the test connection is working and then open the udl file and use the
text that has been automatically generated as a connection string.
Chris
-----Original Message-----
From: Chris Ullman [mailto:chrisu@w...]
Sent: Thursday, June 29, 2000 12:28 PM
To: ASP Databases
Subject: [asp_databases] RE: How do I use OLEDB to connect to a access
db? ?
The Jet 4.0 OLE Db Provider which comes with Access 2000?
Chris
-----Original Message-----
From: Warren S. Wyght [mailto:wswyght@t...]
Sent: Thursday, June 29, 2000 4:24 AM
To: ASP Databases
Subject: [asp_databases] How do I use OLEDB to connect to a access db??
Last night the server crashed and the network needed to be re-built, this
lost all the connections to the databases. I was told they did not use
DNS to make the connection nor did they use ADO, so I think they may have
used OLEDB.
Here is my question, do you know of a way to connect to a Access DataBase
over the web that is ASP compliant and uses OLEDB? I have read about this
being possible but have never found a way to do it.
The connection looked like this, there is no DNS= in it nor is there the
connectionstring line in this at all. What kind of connection is it and
what do I need on the server to make it work once more??
<%
Set objConn= Server.CreateObject("ADODB.Connection")
objConn.Open("global_pro") 'global_pro.mdb is the DB
'on an other server in the company but not the webserver there is a DNS with
a 'glob_pro
DNS but no path to it that I ever saw.
Set objRS=Server.CreateObject("ADODB.Recordset")
select_veh="Select Data.* From Data" & _
" WHERE Data.[Who Sold To] LIKE('N%') order by Data.Date"
objRS.Open select_veh, objConn
%>
If you don't know of a way but know where I may find the info I need that
would be great.
Warren S. Wyght
Message #2 by Chris Ullman <chrisu@w...> on Mon, 3 Jul 2000 12:16:44 +0100
|
|
Sorry should have mentioned, Beginning ASP 3.0!
Chris
-----Original Message-----
From: Frankie, Loh Teck Seng [mailto:lohts@p...]
Sent: Monday, July 03, 2000 2:23 PM
To: ASP Databases
Subject: [asp_databases] RE: How do I use OLEDB to connect to a access
db? ?
Greeting;
Can I ask what is book is that?
Thanks.
-----Original Message-----
From: Chris Ullman [mailto:chrisu@w...]
Sent: Thursday, June 29, 2000 7:41 PM
To: ASP Databases
Subject: [asp_databases] RE: How do I use OLEDB to connect to a access
db? ?
To elaborate, as I recommend in my book (plug, plug), create a UDL file
(create a blank text document and change it to have .udl suffix. Then choose
the Jet 4.0 OLE DB Provider and connect it to the database of your choice.
Check the test connection is working and then open the udl file and use the
text that has been automatically generated as a connection string.
Chris
-----Original Message-----
From: Chris Ullman [mailto:chrisu@w...]
Sent: Thursday, June 29, 2000 12:28 PM
To: ASP Databases
Subject: [asp_databases] RE: How do I use OLEDB to connect to a access
db? ?
The Jet 4.0 OLE Db Provider which comes with Access 2000?
Chris
-----Original Message-----
From: Warren S. Wyght [mailto:wswyght@t...]
Sent: Thursday, June 29, 2000 4:24 AM
To: ASP Databases
Subject: [asp_databases] How do I use OLEDB to connect to a access db??
Last night the server crashed and the network needed to be re-built, this
lost all the connections to the databases. I was told they did not use
DNS to make the connection nor did they use ADO, so I think they may have
used OLEDB.
Here is my question, do you know of a way to connect to a Access DataBase
over the web that is ASP compliant and uses OLEDB? I have read about this
being possible but have never found a way to do it.
The connection looked like this, there is no DNS= in it nor is there the
connectionstring line in this at all. What kind of connection is it and
what do I need on the server to make it work once more??
<%
Set objConn= Server.CreateObject("ADODB.Connection")
objConn.Open("global_pro") 'global_pro.mdb is the DB
'on an other server in the company but not the webserver there is a DNS with
a 'glob_pro
DNS but no path to it that I ever saw.
Set objRS=Server.CreateObject("ADODB.Recordset")
select_veh="Select Data.* From Data" & _
" WHERE Data.[Who Sold To] LIKE('N%') order by Data.Date"
objRS.Open select_veh, objConn
%>
If you don't know of a way but know where I may find the info I need that
would be great.
Warren S. Wyght
---
Wrox Professional Wireless Developer Conference, Amsterdam, July 10-12.
Covering application of WAP, XML, ASP, Java and C++ to wireless computing,
choose from 40+ technical sessions delivered by industry experts:
http://www.wroxconferences.com/ConferenceHome.asp?ConfID=9
---
You are currently subscribed to asp_databases
|
|
|
View Cart
