Re: [��]��ô��C#�� Sybase��ݿ⣿

Article View: cn.bbs.comp.database

Article #371

Back to cn.bbs.comp.database Previous Next

#371

From: ��
Date: Thu, 12 Mar 2009 04:55

37 lines
2749 bytes

ллǰ�漸��ͬѧ��ָ�㣬���������ASE Data Provider�ķ�ʽ���ӵġ�

��΢�ܽ�һ��ʹ�÷�����

�Ȱ�װSybase��ݿ⣬ѡ��Custom��ʽ��ѡ��ASE Data Providers�Լ������С���
װ��ɺ��ڰ�װĿ¼sybase\ADO.NET\dll\�����dll�ļ���Sybase.Data.AseClient.dl
l ��������������

���װSybase����ֻ�ǰ����dll�ļ�������Ŀ�У���ע��һ�£�Ӧ��Ҳ�ǿ��Եġ�
����û�Թ�

Ȼ������Ŀ������ǰ���ᵽ��dll,�� using Sybase.Data.AseClient;

Ȼ�������������SQL Server���õ� AseConnection�� AseCommand��AseDataReader��
�����ࡣ

�����ַ���������д�ģ�

string str_con = "Data Source=xxx.xxx.xxx.xxx;Initial Catalog=db_name;User I
D=xxx;Password=xxx;Port=4100;";


�� �� Dem (Galaxy��VOLUNTEERS��Database) �Ĵ������ᵽ: ��
: �������ODBC�����Ļ�,����������ҪProvider,�ͻ��˲���
: �ð�,����һ�»������������˵��,������Sybase ASE OLE DB Provider
: Sybase(oledb)
: ����������Ҫ��װole�ͻ��ˣ������ó��������data source.Ȼ����.net�оͿ�
: ��ʹ���ˡ�
: ����Provider=Sybase.ASEOLEDBProvider.2;Initial Catalog=��ݿ���;User ID=�û�
: ��;Data Source=���Դ;Extended Properties="";Server Name=ip��ַ;Network Prot
: ocol=Winsock;Server Port Address=5000;
: ��������ֱ��ʹ��.net��ɵ��ʽ�Ĵ��������ӡ�
: ����CSV
: .................������ʡ�ԣ�
--

[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.36.189][m

Technical Details

Message-ID: <4elZZe$biX@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,e84956a475322d7e,start
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!news.shec6.edu.cn!SJTU
From: firbird.bbs@bbs.sjtu.edu.cn (����)
Newsgroups: cn.bbs.comp.database
Subject: Re: [���]��ô��C#���� Sybase��ݿ⣿
Date: 12 Mar 2009 04:55:21 GMT
Organization: ��ˮ˼Դ
Message-ID: <4elZZe$biX@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1236832696.A
Lines: 37

Article View: cn.bbs.comp.database

Re: [���]��ô��C#���� Sybase��ݿ⣿

Re: [��]��ô��C#�� Sybase��ݿ⣿