The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

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

Generally I have very much enjoyed ADO.NET - it is a pleasant read and has
even produced a couple of laughs - not bad for such heavy material.
Trying to work the chapter 21 (remoting) example has led nowhere however.
Having downloaded the sample files (which do not appear to include an
installer by the way), placed them where they need to be, I attempted to work
chapter 21. This, of course, requires the tables to be created and populated
using the loader in the utility directory.
Problem: No matter which account and password I enter into the start-up pane I
am informed that I do not have a trusted connection and the program
terminates. There does not appear to be any source code for the loader so
everything has ground to a halt. Any suggestions would be welcome. At this
point I am completely stalled.

Thanks in anticipation.
import-bot (20211) [Avatar] Offline
#2
Re: Extreme Frustration...
[Originally posted by arlen]


Sorry about the installer - I will get that up there soon!

I'm not entirely sure what the problem is that you are having. One thing you
might try is to manually create the database in SQL Server Enterprise Manager.
. .

If that doesn't work, let me know - also if you can tell me the exact error
message - does it say "Could not connect to SQL Server with UserID. . ." or do
you get an "Error Creating Database" error?

Thanks,

Arlen

> Generally I have very much enjoyed ADO.NET - it is a pleasant read and has
> even produced a couple of laughs - not bad for such heavy material.
> Trying to work the chapter 21 (remoting) example has led nowhere however.
> Having downloaded the sample files (which do not appear to include an
> installer by the way), placed them where they need to be, I attempted to work
> chapter 21. This, of course, requires the tables to be created and populated
> using the loader in the utility directory.
> Problem: No matter which account and password I enter into the start-up pane I
> am informed that I do not have a trusted connection and the program
> terminates. There does not appear to be any source code for the loader so
> everything has ground to a halt. Any suggestions would be welcome. At this
> point I am completely stalled.
>
> Thanks in anticipation.
import-bot (20211) [Avatar] Offline
#3
Re: Extreme Frustration...
[Originally posted by peteraharrison]

Arlen,
The problem, I believe is that I do not normally use SQL logins and passwords
on my development machines, but rely on the Windows security if that makes
sense. (I run the Enterprise version of SQL.) The loader insists on a SQL
login and password and "sa" with a blank password does not let me in. The
message states (in MS-Speak) that "sa" is not a trusted name. At this point
I'm stalled since any login-password combination I can use in tne Enterprise
Manager does not get me by.
However, I have now successfully accomplished what I needed to do with an
existing database and all is well.

Again, thanks for your prompt replies and, again, for an informative book. May
you write many more!


Peter.
>
> Sorry about the installer - I will get that up there soon!
>
> I'm not entirely sure what the problem is that you are having. One thing you
> might try is to manually create the database in SQL Server Enterprise Manager.
> . .
>
> If that doesn't work, let me know - also if you can tell me the exact error
> message - does it say "Could not connect to SQL Server with UserID. . ." or do
> you get an "Error Creating Database" error?
>
> Thanks,
>
> Arlen
>