By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,275 Members | 1,009 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,275 IT Pros & Developers. It's quick & easy.

MSDE

P: n/a
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.

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,

Joanne
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath &
";"

see
http://www.able-consulting.com/MDAC/...roviders.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!
Jul 20 '05 #2

P: n/a
Joanne (bi*****@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, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.