🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #522

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

#522
From: Galaxy��VOLUNTEERS��Database
Date: Tue, 24 Feb 2009 10:53
36 lines
2671 bytes
�������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
����oledb
����Select *
����From OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
���� 'Data Source="c:\csv\";User ID=Admin;Password=;Extended properties=Text
')...[filename#csv]

�������ۼ�:
http://topic.csdn.net/t/20020522/15/743652.html

�� �� firbird ( ����) �Ĵ�������
��: ��: лл��...��System.data.oledb�Ͳ���Ҫ��װSybase�ͻ��˻����������˰ɣ�
: �� �� ZAKU (Dem����ɫ�н�����) �Ĵ������ᵽ: ��
: : ��oledb provider for odbc��namespaces����system.data.oledb
: : �����ַ��http://www.connectionstrings.com/sybase-advantage
: : msdn�Ͽ��Բο���
: : http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnectionstringbuilder.provider.aspx
: : http://msdn.microsoft.com/en-us/library/zb01ae7f.aspx


--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30]
Technical Details
Message-ID: <4eZL9Q$b0W@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news2.glorb.com!feeder.erje.net!news2.arglkargh.de!news.n-ix.net!newsfeed.freenet.de!news2.euro.net!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,a23b09d2bea4ed5f
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news2.glorb.com!feeder.erje.net!news2.arglkargh.de!news.n-ix.net!newsfeed.freenet.de!news2.euro.net!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: Re: [���]��ô��C#���� Sybase��ݿ⣿
Date: 24 Feb 2009 10:53:59 GMT
Organization: ��ˮ˼Դ
Message-ID: <4eZL9Q$b0W@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1235472074.A