I'm learning .NET -- When running a little database test application I catch the error message "SQL Server does not exist or access denied". With a "0" in the title bar.
Assuming the first half of the message applies, is this a "Imports" issue? Where can I find a catalog of "Imports"? Here is my current Imports list:
Imports System.Data.SqlClient (added this last one, but it didn't help).
Assuming the second half of the message applies, this is my connection string:
strConn &= "Data Source=(local): "
strConn &= "Initial Catalog=C:\Inspec32\ISIdatabase.mdb; "
strConn &= "User ID=sa; "
strConn &= "Password='MACHUPICHU'; "
I tried it with and without the single quotes around the password. The password works if I directly access the database.
Please help -- Norm