Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

Re: SqlConnection problem

 
 
Rick Spiewak
Guest
Posts: n/a
 
      08-27-2003
Do you need a fully qualified address for your server?
torightfax.mydomain.com?

"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

[Network
> 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

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

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

with
> 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.

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



 
Reply With Quote
 
 
 
Reply

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



Advertisments