Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Connection from ASP to SQL server

Reply
Thread Tools

Connection from ASP to SQL server

 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      02-07-2005
vichet wrote:
> Dear All;
>
> I have two servers: Webserver(WebServer) and Database
> server(DBServer).
>
> In Webserver, i asp to connect to sqlserver in dbserver. but i can not
> connect it, it show error "No Trust Connection"
>
> but the save connection string, when i used it in VB, it is ok. Also
> i can connect from webserver to dbserver by using Analy Query, it is
> ok
>
> please help "How to connect it". below is my asp code:
>
>
> <%
> set cnt=server.createobject("adodb.connection")
> cnt.open "Provider=SQLOLEDB.1;Data Source=Dbserver;Initial
> Catalog=MyDB;Uid=dbadmin;pwd=root"
>
> .
> .
> .
> %>
>
> Vichet

Your error is covered in this article:
http://www.aspfaq.com/show.asp?id=2009

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


 
Reply With Quote
 
 
 
 
vichet
Guest
Posts: n/a
 
      02-07-2005
Dear All;

I have two servers: Webserver(WebServer) and Database server(DBServer).

In Webserver, i asp to connect to sqlserver in dbserver. but i can not
connect it, it show error "No Trust Connection"

but the save connection string, when i used it in VB, it is ok. Also i can
connect from webserver to dbserver by using Analy Query, it is ok

please help "How to connect it". below is my asp code:


<%
set cnt=server.createobject("adodb.connection")
cnt.open "Provider=SQLOLEDB.1;Data Source=Dbserver;Initial
Catalog=MyDB;Uid=dbadmin;pwd=root"

 
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
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
Do the Self-Paced Training Kits: Microsoft SQL Server 2000 include Eval copy of SQL Server? Brian Whiting Microsoft Certification 2 12-29-2005 04:24 AM
sql server express vs sql server 2000 code Daves ASP .Net 1 06-13-2005 12:24 PM
How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server Belinda ASP General 4 06-11-2004 12:16 PM
Can't connect to SQL Server, using Windows Authentication users of SQL server? help =?Utf-8?B?UmV6YQ==?= ASP .Net 3 06-07-2004 06:42 PM



Advertisments