Heya Everyone,
              How are we all?
I have a bit of a problem...
I'm using WinXP Service Pack 2 with vs.net
I'm trying to create a DSN connection to an Access 2000 Database using an asp.net form as the interface.
I have referenced the DAO 3.6 Library... But I keep getting an error with I compile...

####################
The source code is:
####################

Dim Dbs As DAO.Database
Dim Connect As New DAO.PrivDBEngine

Public Function OpenDatabaseConnection(ByVal TableName As String) As Boolean
        Dbs = connect.OpenDatabase("", False, False, _
        "DSN=Bulletin_Boards;UID=test;PWD=test;")

        Dbs.OpenRecordset(TableName, DAO.RecordsetTypeEnum.dbOpenDynaset _
        , DAO.RecordsetOptionEnum.dbInconsistent _
        , DAO.LockTypeEnum.dbOptimistic)
        Return True
End Function


######################
The error Message is:
######################

Server Error in '/Work/Bulletin_Boards' Application.
ODBC--connection to 'Bulletin_Boards' failed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: ODBC--connection to 'Bulletin_Boards' failed.

Line 15: Dbs = connect.OpenDatabase("", False, False, _
Line 16: "DSN=Bulletin_Boards;UID=test;PWD=test;")



Could someone please help me?
I have no idea what I have done wrong?
Slightly lost... Looking for help...
Thanking you in advance...

This is basic, but did you create the DSN through your Data Sources? If so, did you test the connection? Did the connection work?

If you answered yes to all three of these, then I am not sure where to start, other than your UID and PWD.

The way I handle this sort of connection would be:

Dim stUID As String = "****"
Dim stPWD As String = "****"

Then ...

Dbs = connect.OpenDatabase("", False, False, _
        "DSN=Bulletin_Boards;", stUID, stPWD)

I have done this in VBScript, and I had to create the connection first, then I used this syntax...

Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open "DSN=AssetManagement;", strUserName, strPassword

I know these are different connection types, but please note the difference in syntax surrounding the UID and PWD.

The connection may be failing because you are not properly passing these credentials.



mmcdonal

Yeah, I created the connection and tested it... It worked fine... I have also tried it without UID and PWD (Updated the DSN as well to include no user or password), but still nothing... I will keep trying... Thank you for your help... It is muchly appreciated...