connect to a database

[Peter Morris]

Newbie question, I'm just learning ASP

I am having trouble connecting to a database. I have set up the
ODBC data source Northwind to link to the Northwind database.

Now, I'm running the following script:

<% @language = vbscript %>
<%
Option explicit
Response.expires = 0
dim objConn, objRS, strQuery
dim strConnection
Set ObjConn = server.createObject("ADODB.connection")
strConnection = "DSN=Northwind;database=northwind;"
strConnection = strConnection & "UID=sa;PWD=;"
objConn.open strConnection
....
%>

This produces the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'YOUR-D10B605044\IUSR_YOUR-D10B605044'.
/asp24/hour13/readdata.asp, line 10
Why is this happening? Why can't I connect?

Note - there doesn't seem to be anything wrong with the database or the
DSN. I have created a visual basic program which successfully opens
and reads the same database and DSN. This connects like so:

Dim cnn1 As ADODB.Connection
Dim rstRec As ADODB.Recordset
Dim strCnn As String

Sub main()
Set cnn1 = New ADODB.Connection
strCnn = "DSN=Northwind;Database=Northwind;UID=sa;PWD=; "
cnn1.Open strCnn
End Sub

Why does it work in visual basic, but not in VBScript? Is there
perhaps something I must configure in IIS for it to work, or something
like that?

--
_______________________
/_____________________(_)
| ______________________ email to
| | |__________________(_) Peter_Morris_1 at
| |/____________________ btinternet dot com
|_____________________(_)

[Robb Meade]

"Peter Morris" wrote ...

Newbie question, I'm just learning ASP
Welcome aboard - tickets please :o)
I am having trouble connecting to a database. I have set up the
ODBC data source Northwind to link to the Northwind database.

hmm...I've not used ASP and Access databases together, usually SQL, so I'm
not sure if I can be much help...

Couple of things to check,

I took this :

Access connection string looks like this;
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Temp\Northwind.mdb"

from

http://www.tek-tips.com/gfaqs.cfm/le...id/333/fid/178

and also this:

A typical connection string for the Access Northwind database is:
"provider=Microsoft.Jet.OLEDB.4.0; data source=YourPath\Northwind.MDB"

from

http://msdn.microsoft.com/library/de...dataadonet.asp
again, I've not connected into an Access database from ASP before, but the
connection string would be the first thing I'd look at.

Followed by double checking the username/password - as the error message
does suggest a login problem.

And also the permissions on the directory that the access database is stored
in, if you plan to write to the database I think you'll need to enable the
'write' permission from the ISM within IIS (I might be wrong).

Good luck!

Robb

[Robb Meade]

"Peter Morris" wrote ...

[snip]

This might also be handy...

http://www.asp101.com/samples/viewas...database%2Easp

Do a search within that page for 'access connection code' - and it should
take you to the correct line in there example.

Robb

[Peter Morris]

"Robb Meade" <ro********@NOSPAMkingswoodweb.net> wrote in message
news:P7**********************@news-text.cableinet.net...

"Peter Morris" wrote ...

[snip]

This might also be handy...

http://www.asp101.com/samples/viewas...database%2Easp

Do a search within that page for 'access connection code' - and it should
take you to the correct line in there example.

Robb

Thanks. one of the links you provided gave the correct connection string,
which is:
strConnection = "Driver={SQL Server}; Server=(local); Database=Northwind;
UID=sa; PWD=;"