sql server odbc: MSDE -- sql server odbc

MSDE	Joanne 5/17/2004 9:40:09 PM

sql server odbc: 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: (which is setup for Jet at present)

<%@ 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

Re: MSDE

Mary Chipman
5/18/2004 9:45:42 AM

What you'll need to do is grant permissions for the login you are
using in MSDE to the database, and then create a connection string
that contains valid credentials. For connection string syntax
examples, see either one of these two sites:
http://able-consulting.com/ADO_Conn.htm
http://www.connectionstrings.com

--Mary

On Mon, 17 May 2004 21:40:09 +0000 (UTC), "Joanne"
[quoted text, click to view]

Re: MSDE

das
5/25/2004 2:01:04 AM

th syntax change her

Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "uid=;"pwd=

biswajit da

----- Mary Chipman wrote: ----

What you'll need to do is grant permissions for the login you ar
using in MSDE to the database, and then create a connection strin
that contains valid credentials. For connection string synta
examples, see either one of these two sites
http://able-consulting.com/ADO_Conn.ht
http://www.connectionstrings.co

--Mar

On Mon, 17 May 2004 21:40:09 +0000 (UTC), "Joanne
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.