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 cuco]


Arlen,

Great book.

I have a problem with the LoadSQLServer utility. I created the
ADONetSamples database using Enterprize Manager, as you specified in Chapter
4. Next, when I try the LoadSQLServer utility, no matter what the user ID or
password is, I get the following message:

"Could not connect to SQL Server with UserID sa and provided password."

I have changed from Windows Authentication to Mixed-Mode, still nothing.

Any help is appreciated.



import-bot (20211) [Avatar] Offline
#2
Re: LoadSQLServer Utility Problem
[Originally posted by cuco]

>
> Arlen,
>
> Great book.
>
> I have a problem with the LoadSQLServer utility. I created the
> ADONetSamples database using Enterprize Manager, as you specified in Chapter
> 4. Next, when I try the LoadSQLServer utility, no matter what the user ID or
> password is, I get the following message:
>
> "Could not connect to SQL Server with UserID sa and provided password."
>
> I have changed from Windows Authentication to Mixed-Mode, still nothing.
>
> Any help is appreciated.
>
>
>

I continue to try to solve this problem. I have Windows Authentication back
ON and I have added a user 'sa' with administrator rights and a password. When
the LoadSQLServer utility runs, and after
I enter via the 'sa' user and password, the following message is displayed.

"Something went wrong:
System.ArgumentException: Invalid delimiter = found in the connection
option value.
at System.Data.SqlClient.ConStringUtil.ParseStringIntoHashtable(String
conString, Hashtable values)
at System.Data.SqlClientConStringUtil.ParseConnectionString(String
connectionString)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String
value)
at ADONETUtilities.SQLServerCreator.Connect(String strDatabaseName,
String strUserId, String strPassword)
at LoadSQLServer.Form1.CreateAndLoadData()"

Help!





import-bot (20211) [Avatar] Offline
#3
Re: LoadSQLServer Utility Problem
[Originally posted by arlen]


There have been a fair number of problems with that utility - I'm afraid that
I didn't do as much testing as I probably should have done smilie

If you are using SQL Server (rather than MSDE) perhaps the easiest thing would
be for me to mail you a SQL Backup file. . .

Arlen
import-bot (20211) [Avatar] Offline
#4
Re: LoadSQLServer Utility Problem
[Originally posted by cuco]



Arlen,

Yes, if you do have a possible solution that you can email me, I would
appreciate it. I'm running SQL 2000 Enterprise.

I'm working long hours everyday trying to come up to speed on SQL Server
2000, .NET and ADO.NET. Your book is doing a great job with my ADO.NET
learning curve.

Thanks in advance,

Peter
import-bot (20211) [Avatar] Offline
#5
Re: LoadSQLServer Utility Problem
[Originally posted by arlen]

Can you send me your e-mail address. You can mail me at
Arlen.Feldman@FrontRange.com.

Thanks,

Arlen

>
>
> Arlen,
>
> Yes, if you do have a possible solution that you can email me, I would
> appreciate it. I'm running SQL 2000 Enterprise.
>
> I'm working long hours everyday trying to come up to speed on SQL Server
> 2000, .NET and ADO.NET. Your book is doing a great job with my ADO.NET
> learning curve.
>
> Thanks in advance,
>
> Peter