Re: Dataset - Error
From: Daniel Joskovski (omnis_at_NOSPAMunetREMOVECAPS.com.mk)
Date: 06/09/04
- Next message: Disillusioned_01: "Re: Java vs dotnet job market"
- Previous message: The Poster Formerly Known as Kline Sphere: "Re: Java vs dotnet job market"
- In reply to: Papri Chakravorty: "Dataset - Error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Jun 2004 00:12:54 +0200
Ok.
Analyzing your connection string, I realize that you try to connect to SQL
server which is on another machine then yours
(your WS is CHAKP, and data source is SEAFS that mean to me that machine on
which sql-server is running have name SEAFS) to achieve trusted connection
and use integrated security, your two machines must be in the same domain,
or your workstation and your server must run under win2000 server, so if it
is not the case I recommend you to use mixed mode security (SQL and Windows)
and put Username and Password in connection string. In case that you can
afford trusted connection still you must impersonate your identity when
accessing SQL server.
Regards,
Daniel
"Papri Chakravorty" <anonymous@discussions.microsoft.com> wrote in message
news:C11FEF15-450C-42A0-B88D-C8184E3EF908@microsoft.com...
> Hello Experts,
>
> Yesterday I was trying to just populate a datagrid with a dataset.
> I used the following code in the page load event after using connection,
adapter and data set
> in the design mode
>
> Dim nC As SqlConnection = New SqlConnection("data source=SEAFS;initial
catalog=Northwind;integrated security=SSPI;persist security
info=False;workstation id=CHAKP;packet size=4096")
> Dim selectCMD As SqlCommand = New SqlCommand("SELECT CustomerID,
CompanyName FROM Customers", nC)
> selectCMD.CommandTimeout = 30
> Dim DA As SqlDataAdapter = New SqlDataAdapter()
> DA.SelectCommand = selectCMD
>
> nC.Open()
>
> Dim DS As DataSet = New DataSet()
> DA.Fill(DS, "Products")
>
> nC.Close()
>
> .When i tried to build and browse,
> it gave me the following error
>
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection
>
> Can you please let me know what is causing this?
>
> I cannot proceed with the following chapters unless I get this clear.
>
> Many thanks
> Papri Chakravorty
- Next message: Disillusioned_01: "Re: Java vs dotnet job market"
- Previous message: The Poster Formerly Known as Kline Sphere: "Re: Java vs dotnet job market"
- In reply to: Papri Chakravorty: "Dataset - Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
