Hi All,
I heve one system that need access SQL Server 2005.
This system run on SOLARIS 10.
Have any way to do this?
Thanks
Hello Retf,
Microsoft don't supply their own drivers for non-Windows based clients any
longer, so you have to use a 3rd-party product.
To connect to SQL Server from SOLARIS, there are other third party ODBC
drivers for Solaris; and of course, the JDBC driver for SQL Server.
Your choices (in no particular order) are :
1. You could reverse engineer the undocumented TDS protocol yourself.
This
could and does change between versions of SQL Server, so only attempt this
if
you want an on-going maintenance challenge. Several people have done such
reverse engineering for the portions of TDS they needed and have reported
it's
not that difficult. Once such is the FreeTDS project that is reverse
engineering the TDS specification and is currently implementing CTLIB,
DBLIB,
and JDBC interfaces for TDS. ODBC and Perl DBD drivers are planned.
The FreeTDS JDBC driver is a type 4 driver and should work on any JVM. The
CTLIB and DBLIB interfaces are known to compile under AIX, Linux, and
FreeBSD
without any problems. More info from <http://sunsite.unc.edu/freetds/>
and/or
<http://metalab.unc.edu/freetds/index.html>.
The mailing list archive can be viewed at
<http://franklin.oit.unc.edu/cgi-bin/lyris.pl?enter=freetds>. Source-code
can be
downloaded from <ftp://freetds.internetcds.com/pub/freetds_dbd/>
<http://metalab.unc.edu/freetds/index.html>
2. If you can use Java/JDBC then see the "jdbc.txt" FAQ entry for details
of
that
3. The recommended option is that you acquire an ODBC/OLE-DB driver from a
driver vendor that will offer on-going support. However, many ODBC vendors
have either moved from pure client drivers to "3-tier" driver systems which
many people don't want, or they have moved from ODBC into OLE-DB.
Therefore
you may have trouble finding just what you want. (Success and failure
stories
welcome - but be persistent with whichever vendors you talk to - they may
not
be actively advertising what you want, but that doesn't mean they don't
still
have old but working copies of it buried in a cupboard somewhere).
Vendors to try are (in no particular order) :-
OpenLink www.openlinksw.com <http://www.openlinksw.com>
Merant (were Intersolv
<http://www.merant.com/datadirect/products/odbc/Connect/overview.asp>
Visigenic www.visigenic.com <http://www.visigenic.com>
Easysoft www.easysoft.com <http://www.easysoft.com>
(ODBC-ODBC
Bridge)
Applix corp.
4. For other pointers to ODBC/JDBC/OLEDB vendor's :-
<http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/jdbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/oledbven.htm>
<http://www.unixodbc.org>
<http://www.algonet.se/~sommar/mssqlperl/unix.html>
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
Im searcheing for 3rdparty component that make it possible, tahnks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escreveu na mensagem
news:LvO%23AF%23XHHA.296@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment