import-bot (20211) [Avatar] Offline
#1
[Originally posted by bcostell]

I wrote this before I checked the other messages, but I'll give you my
perspective as well.

Re. Sample database (Chapt 4). I don't have SQL2000 but did install the MSDE.
I was able to create the ADONETSamples database but when I can't get
LoadSQLServer to run properly. The SQL login box comes up with the sa user and
no password. When I try to run, there's an error that says user sa is not
associated with a trusted connection.

I am able to connect to the database via an ODBC DSN, but this is also with a
trusted connection. I assume I can create the scripts from the LoadSQLServer
source but I am in a real hurry.

Any way around? Or, is there an equivalent Access database? Everybody can use
an Access mdb.
import-bot (20211) [Avatar] Offline
#2
Re: MSDE - Trusted connection - Access db
[Originally posted by bcostell]

> I wrote this before I checked the other messages, but I'll give you my
> perspective as well.
>
> Re. Sample database (Chapt 4). I don't have SQL2000 but did install the MSDE.
> I was able to create the ADONETSamples database but when I can't get
> LoadSQLServer to run properly. The SQL login box comes up with the sa user and
> no password. When I try to run, there's an error that says user sa is not
> associated with a trusted connection.
>
> I am able to connect to the database via an ODBC DSN, but this is also with a
> trusted connection. I assume I can create the scripts from the LoadSQLServer
> source but I am in a real hurry.
>
> Any way around? Or, is there an equivalent Access database? Everybody can use
> an Access mdb.


I should have read all the messages. It appears there is an Access equivalent
in ADONETSAMPLE Access