Access 2000 database using MSDE, and I have it working using Jet but would
like to connect the database using MSDE.
I would appreciate any advice to where I need to edit the code, the code is
as follows:
<%@. Language=VBScript %
<HTML
<HEAD
<TITLE>Add New Record</TITLE
<%
strDBPath=server.MapPath("Employer.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";"
set RS = Server.CreateObject("ADODB.Recordset")
Conn.BeginTrans
RS.Open "Employer",Conn,3,3
RS.AddNew
RS("Employer ID") = Request("Employer ID")
RS("Employer Name") = Request("Employer Name")
RS("TitleID") = Request("TitleID")
RS("Forename") = Request("Forename")
RS("Surname") = Request("Surname")
RS("Web Address") = Request("Web Address")
RS("Email Address") = Request("Email Address")
RS("Date Recorded") = Request("Date Recorded")
RS("Employer ClassificationID") = Request("Employer ClassificationID")
RS.Update
Conn.CommitTrans
RS.Close
Conn.Close
%
</HEAD
<BODY
Member Registered
</BODY
</HTML
As mentioned I would be very grateful for any advice.
Love,
JoanneConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath &
";"
see
http://www.able-consulting.com/MDAC...Providers.htm#O
LEDBProviderForSQLServer
The code would be better with just an insert statement.
Even better calling a stored procedure with parameters.
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Joanne (bill884@.hotmail.com) writes:
> I would appreciate any help, I'm trying to connect a web front-end to an
> Access 2000 database using MSDE, and I have it working using Jet but
> would like to connect the database using MSDE.
Now, this sounds a bit funny to me. I've heard of people access SQL Server
databases from Access, but you want to do it the other way round from
you ASP code? (I assume what you post is ASP, but I don't know ASP, so
I could be wrong.) That does not seem very meaningful to me.
However, assuming that you in fact have a copy of the database that
you have migrated to SQL Server, then you could do:
> strDBPath=server.MapPath("Employer.mdb")
Remove this:
> Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath &
> ";"
Replace with:
Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=Employer
This assumes that you have MSDE running on the local server. If you
have MSDE on another machine, you should add Server=SERVERNAME to
the connection string.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
No comments:
Post a Comment