Unix access to MSSQL server/NT

Unix access to MSSQL server/NT

Post by Summus H » Thu, 04 Jun 1998 04:00:00



Dear experts,

I am working on a UNIX system running UNIXWARE and I need my program to
access data in the MS SQL server on NT over TCP/IP Ethernet connection. I
have no idea how I can do it - no odbc support on the Unix. Can some of
experts give a hint to me? Any library? Middleware .... etc.

Thanks in advance.

regards,
Summus

--
Pls delete ".nospam" from my email address if reply via email

 
 
 

Unix access to MSSQL server/NT

Post by William Stephen » Fri, 05 Jun 1998 04:00:00



> Dear experts,

> I am working on a UNIX system running UNIXWARE and I need my program to
> access data in the MS SQL server on NT over TCP/IP Ethernet connection. I
> have no idea how I can do it - no odbc support on the Unix. Can some of
> experts give a hint to me? Any library? Middleware .... etc.

> Thanks in advance.

> regards,
> Summus

> --
> Pls delete ".nospam" from my email address if reply via email

Just a try, but there is some ODBC connection stuff available for Perl.
Just go to www.perl.com and do some searching.

Bill

 
 
 

Unix access to MSSQL server/NT

Post by Edward Whale » Sat, 06 Jun 1998 04:00:00


William,
  I think that visigenics has an ODBC for Unixware.  At least they used to.
Ed



> > Dear experts,

> > I am working on a UNIX system running UNIXWARE and I need my program to
> > access data in the MS SQL server on NT over TCP/IP Ethernet connection. I
> > have no idea how I can do it - no odbc support on the Unix. Can some of
> > experts give a hint to me? Any library? Middleware .... etc.

> > Thanks in advance.

> > regards,
> > Summus

> > --
> > Pls delete ".nospam" from my email address if reply via email

> Just a try, but there is some ODBC connection stuff available for Perl.
> Just go to www.perl.com and do some searching.

> Bill

--
Edward Whalen
President
Performance Tuning Corporation
Database Performance Consultants

Web:   www.perftuning.com
 
 
 

Unix access to MSSQL server/NT

Post by Summus H » Sun, 07 Jun 1998 04:00:00


Dear Ed,

I checked with visigenic. They are not doing anything on ODBC anymore, but
JDBC ...
I am also out of luck to locate anything in perl too.

Any idea?

Summus

 
 
 

1. accessing DateTime in english MSSQL-Server from german NT 4.0

Hi everybody,

I have my databases on an english version Microsoft SQL-server 6.5 SP4
and have to access it from a german NT 4.0 SP3 using the german BDE of
Delphi 3 and the native MSSQL-driver. Now I have a problem when I try to
write data into a DateTime-field with certain months.

I figured out that the BDE or the native MSSQL-driver sends the date in
the form "dd-mmm-yyyy" to the server, e. g.:

UPDATE MyTable
SET ADate = "30-Apr-1998"
WHERE Idx = 5

This special example works, but when I try to send for example the date
"1-May-1998" then it is sent as:

UPDATE MyTable
SET ADate = "01-Mai-1998"
WHERE Idx = 5

("Mai" is the german name for this month) and the server expectedly does
not understand it. So it looks like the database driver uses the
national names of the months. When I configure my regional settings in
the control panel to english as system default and reboot then it works,
but this cannot be the solution, because I have to write applications
mainly for the german market. Using an ODBC-connection it works too,
even with german settings, but there are other disadvantages on that
approach.

Has anyone experienced this problem too (it should appear in other
languages too)?
Have you got any solution or workaround for that?
Who's to blame for that: Borland (Inprise) with its BDE or Microsoft
with its native driver?
How can I force the BDE or the MSSQL-driver to always use the english or
the numeric only date format like "dd-mm-yyyy"?

Any advice will be greatly welcome. Thanks in advance.

-- Asem

2. The Mysterious Error

3. Tools Oracle on UNIX/NT + SQLServer on NT + Tools for UNIX/NT(system)

4. SQL Tunning Issue

5. wait event: Direct Path Read

6. Unix/Perl-->NT/MSSQL

7. Followup - MSDE - no bound data

8. Remote JDBC-ODBC connection from unix client to NT mssql database

9. access db on unix file server or NT??

10. Trying to access 7.3.4 server under UNIX from 8.0 client under NT

11. Accessing mssql from unix host

12. Access MSSQL from UNIX