- 论坛徽章:
- 0
|
因工作关系,需要用到sybase
sybase 12.5.3 for linux 安装完毕,
isql -Usa -P 可以连上默认数据库
现创建一个用户数据库,比如叫testdb,语句如下:
use master
go
disk init name='testdb_part1',physname='/opt/sybase-12.5/data/testdb_part1.dat',size=512000
go
disk init name='testdb_part2',physname='/opt/sybase-12.5/data/testdb_part2.dat',size=512000
go
disk init name='testdb_part3',physname='/opt/sybase-12.5/data/testdb_part3.dat',size=512000
go
disk init name='testdb_part4',physname='/opt/sybase-12.5/data/testdb_part4.dat',size=512000
go
disk init name='testdblog',physname='/opt/sybase-12.5/data/testdblog.dat',size=512000
go
create database testdb on testdb_part1=1000,testdb_part2=1000,testdb_part3=1000,testdb_part4=1000 log on testdblog=1000
go
use testdb
go
checkpoint
go
exec sp_addlogin 'testuser','testpasswd','testdb'
go
exec sp_addalias testuser,dbo
go
但登陆
isql -Utestuser -Ptestpasswd
Msg 4002, Level 14, State 1:
Server 'SYBASE':
Login failed.
CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
--SYBASE就是默认的数据库
isql -Utestuser -Ptestpasswd -Stestdb报的错误也一样
请教小弟错在那里?
另:正在网上寻找相关sybase基本资料阅读中.但以上问题还是希望大大们能够帮忙解答一下.感谢
[ 本帖最后由 Linuxcn.com 于 2007-6-11 16:50 编辑 ] |
|