Article View: cn.bbs.comp.database
Article #523Re: [���]��ô��C#���� Sybase��ݿ⣿
From: ��ϵ����*Shiyanʲôʱ�����*5������
Date: Tue, 24 Feb 2009 10:55
Date: Tue, 24 Feb 2009 10:55
48 lines
2942 bytes
2942 bytes
���Ȼ�������Ȩ���ˣ�
�� �� 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
����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
--
[1;31mHebei
��������Զ��ů�ļ�
[0;1;5;36mqq����ϵ����[m
[1;33m��Ʒ����ӭ���� Tea ��
[m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.26.99][m
Technical Details
Message-ID:
<4eZLQY$bug@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow 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!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: qqlover.bbs@bbs.sjtu.edu.cn (��ϵ����*Shiyanʲôʱ�����*5������) Newsgroups: cn.bbs.comp.database Subject: Re: [���]��ô��C#���� Sybase��ݿ⣿ Date: 24 Feb 2009 10:55:07 GMT Organization: ��ˮ˼Դ Message-ID: <4eZLQY$bug@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1235472898.A Lines: 47