asp访问SQLSERVER为什么总是出错?(50分)

F

fxb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-28

• #1

在ASP中用以下语句:
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver=SQL Server; server=XX.XX.XX.XX; uid=sa; pwd=password; database=your_database;"
xx.xx.xx.xx为IP地址
为什么总是出错呢?第二句错在哪里?这里有什么要注意的地方吗?如:权限,服务器名等.

 

Y

yaya8163

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-28

• #2

我的连接窜
Connection ="Provider=SQLOLEDB.1;Password=xxx;User ID=xx;Initial Catalog=xxx"

 

G

gmwing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #3

up

 

J

jsxjd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #4

连接串
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=MyTest;Data Source=10.32.103.100

 

F

fxb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #5

注意在:APS中

 

L

liuwen

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #6

Driver={SQL Server}

 

T

twos

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #7

sqlserver: conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename "
access: cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:/anydatabase.mdb"

 

S

sunylat

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #8

对于ASP使用SQL数据库，最方便就是使用ODBC建的数据源。在建立数据源后，使用代码如下：
<%
set cn=server.createobject("adodb.connection")
cn.connectionstring="dsn=数据源名;uid=账号;pwd=密码"
cn.open
cn.execute("SQL各种语句")
,查询语句可以直接赋值为记录集
set rs=cn.execute("SQL查询语句")
%>
有问题请发信：sunyl@dongyubooks.com

 

R

raymondcen

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-11

• #9

ASP中的连接串应该跟前几位说的一样
"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=XXXX;Initial Catalog=XXXX;Data Source=XXXX"