Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Re: SqlConnection problem

Thread Tools

Re: SqlConnection problem

Rick Spiewak
Posts: n/a
Do you need a fully qualified address for your server?

"A.M" <(E-Mail Removed)> wrote in message
news:%23YoM$b%(E-Mail Removed)...
> Hi,
> I have a SqlDataAdapter based on a SqlConnection.
> I double checked the select query and follwing connection string precisely
> with ConnMaker.exe tool which i have downloaded from Microsoft Knowledge
> Base Article - 328101:
> "Data Source=TORIGHTFAX;Initial Catalog=LLAnalysis;User
> ID=report_sa;Password=a*b*c*;Network Library=DBMSRPCN;"
> The query and connection string worked fine with and also without

> Library=DBMSRPCN;]
> First time i start the VB.NET IDE and go to SqlDataAdapter->Preview
> Data->Fill Dataset it says:
> The data adapter could not return the data from the data source. the
> connection string is invalid.
> If i try to click on Fill Dataset again it shows the data preview fine

> later i have some anomaly in actual web pages (data doesn't appear righ in
> data grid)
> In the actual page, if I remove [Network Library=DBMSRPCN;] from
> connection string, the connection fails. It says "SQL Server does not

> or access denied. ". As i mentioned, that connection string worked fine

> ConnMaker.exe tool.
> The server listens on Named Pipes, TCP/IP and Mutiprotocol with default
> settings, There is no firewall between web server and Sql Server.

> is fine with network.
> Where the problem comes from ?
> Any help would be appreciated,
> Ali

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SqlConnection problem - MySQL Alan T ASP .Net 5 07-20-2010 12:37 PM
Help -- SQLConnection Problem Michael D Murphy ASP .Net 19 09-05-2005 11:57 PM
Can't open a SqlConnection Mark ASP .Net 3 07-19-2005 10:23 AM
Re: Reflection and SqlConnection WebDevHokie ASP .Net 0 07-10-2003 06:33 PM
Re: does an Sqlconnection object get shared at application level? Nick ASP .Net 0 06-27-2003 10:35 AM