Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot connect to Access

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I am using Win2000, IIS5.
I cannot open the database (Access) by using ADO. For example:
Set con=Server.CreateObject("ADODB.Connection")
con.Open "DSN"

What is the possible problem?

Thank you!
 
what is the error it is giving

try Con.Open DNS=xx;UID=xx;PWD=xx; or if you have no username password then

Con.Open DNS=xx;UID=;PWD=; Unicorn11
unicorn11@mailcity.com

[red]Luck is not chance, it's toil; fortune's expensive
smile is earned.[red]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top