.NET Logo
Welcome Guest Search | Active Topics | Members | Log In | Register

CodeToday.NET » Microsoft .NET Developer Forum » ASP.NET & Expression Web » connect sqlserver2005 sql authentication

connect sqlserver2005 sql authentication Options · View
Previous Topic · Next Topic
littleGirl
Posted: Tuesday, September 09, 2008 11:38:11 AM
Rank: มือสมัครเล่น
Groups: Member

Joined: 4/7/2008
Posts: 24
Location: BKK

 Dim cnVas As ADODB.Connection
Set cnVas = New ADODB.Connection
    
Dim strConn As String

strConn = "Provider=SQLOLEDB;Persist Security Info=true;User ID=usanee;Password=075215717;Initial Catalog=raprd;Data Source=APPVOUPR1;"

cnVas.Open strConn

แล้วมันฟ้อง error อย่างนี้ค่ะ

runtime error '-2147467259(80004005)' cannot open database raprd requested by login.The login failed

ช่วยหน่อยน่ะค่ะ

 


 
Back to top
 
fronzen
Posted: Thursday, September 11, 2008 9:43:17 AM
Rank: มือสมัครเล่น
Groups: Member

Joined: 4/22/2008
Posts: 18

ในเมื่อ connectionstring provider ของคุณเป็น OleDb

แล้วคุณไม่ลอง connect แบบ

dim cnVas as new OledbConnection() 
Back to top
 
Users browsing this topic
Guest

CodeToday.NET » Microsoft .NET Developer Forum » ASP.NET & Expression Web » connect sqlserver2005 sql authentication


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.

Sponsored by