473,322 Members | 1,690 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

connecting to Sybase/MsSQL from python

Hi,
I'm hoping someone on the list has connected to sybase/MsSQL with something
that works with DBAPI 2.0 from a linux box (SUSE 9.2) because I can't seem
to get it done. I found Object Craft's python code that uses FreeTDS. But
I can't get it compiled. The code is looking for "sybdb.h" (first error) -
of course I don't have "sybdb.h". It is not in Object Crafts code nor in
the FreeTDS source. I'm guessing that I need sybase develop lib's but I
don't know where they are to be found.

So is there a kind sole out there that can help with instructions on what is
needed to get python talking to MsSQL.

jOHN
Jul 18 '05 #1
3 2279
On Feb 11, 2005, at 8:12 PM, John Fabiani wrote:
So is there a kind sole out there that can help with instructions on
what is
needed to get python talking to MsSQL.


Has anyone ever used this product:
http://www.object-craft.com.au/projects/mssql/

Any feedback, positive or negative?

___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://dabodev.com/
Come to PyCon!!!! http://www.python.org/pycon/2005/

Jul 18 '05 #2

"John Fabiani" <jf******@yolo.com> schrieb im Newsbeitrag
news:OJ*****************@newssvr22.news.prodigy.ne t...
Hi,
I'm hoping someone on the list has connected to sybase/MsSQL with
something
that works with DBAPI 2.0 from a linux box (SUSE 9.2) because I can't seem
to get it done. I found Object Craft's python code that uses FreeTDS.
But
I can't get it compiled. The code is looking for "sybdb.h" (first
error) -
of course I don't have "sybdb.h". It is not in Object Crafts code nor in
the FreeTDS source. I'm guessing that I need sybase develop lib's but I
don't know where they are to be found.

So is there a kind sole out there that can help with instructions on what
is
needed to get python talking to MsSQL.

jOHN


Use mxODBC?

--

Vincent Wehren
Jul 18 '05 #3
[John Fabiani]
I'm hoping someone on the list has connected to sybase/MsSQL with something
that works with DBAPI 2.0 from a linux box (SUSE 9.2) because I can't seem
to get it done. I found Object Craft's python code that uses FreeTDS. But
I can't get it compiled. The code is looking for "sybdb.h" (first error) -
of course I don't have "sybdb.h". It is not in Object Crafts code nor in
the FreeTDS source. I'm guessing that I need sybase develop lib's but I
don't know where they are to be found.
Hmmm, google("sybdb.h source", submit="I'm feeling Lucky")

lands on

http://www.freetds.org/reference/a00337.html

which has a GPL licence declaration on the top, so it seems that the
FreeTDS have an OSS version available.

If your compile is failing because it cannot find the file, perhaps you
neglected to run "./configure" before starting the compile?

http://www.freetds.org/userguide/config.htm
So is there a kind sole out there that can help with instructions on what is
needed to get python talking to MsSQL.


Sorry, can't help you there, haven't used FreeTDS.

But I hate to see questions being asked a *second* time without some
form of reasonable answer .....

As already mentioned by another poster, have you considered using ODBC?
There are several python ODBC implementations.

HTH,

--
alan kennedy
------------------------------------------------------
email alan: http://xhaus.com/contact/alan
Jul 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: bigoxygen | last post by:
Hi. I am experiencing problems connecting to MSSQL. I'm not sure where to begin looking for the problem. I don't know if the problem is originating with PHP or MSSQL What should the host name...
1
by: the_rev_dharma_roadkill | last post by:
Hello, I'm a newbie to Python. In order to get much use out of it at my site, I must be able to connect it to Oracle8i databases. I'm running Python 2.2.2 on Tru64 (osf1 V5.1a). First...
4
by: Steve | last post by:
I am developing an application for a client that will have data in a MS SQL Server database. Costs have to be kept down so I have to develop using the free version of any and all tools I may need....
18
by: David Rysdam | last post by:
What module is most recommended for accessing Sybase from Python? This one: http://www.object-craft.com.au/projects/sybase/sybase/ ? Also, is there any module that provides a generic DB API and...
1
by: no0obster | last post by:
Hello, I'm writing an application that should create a SQL Server 7 database if it doens't exist. i'm using the System.Data.SqlClient objects to connect and run queries. My connection fails...
4
by: Dan | last post by:
I have compiled and installed sybase-.037 , the module to add sybase to python. However, when I try to use it I get Import error: /usr/local/lib/python2.3/site-packages/sybasect.so undefined...
1
by: bg_ie | last post by:
Hi, I like to develope an application which uses a MsSQL database. I believe that C# works really well with MsSQL. To start with, I'd like to host the sql server locally on my machine as I...
1
by: farukcse | last post by:
Dear sir, i am tring to use mssql with php for my web application. But i am facing problme with arabic chararcters. it appears like as ������������. can anyone tell me how to fix this error? ...
3
nico5038
by: nico5038 | last post by:
When I open a package in my VS2005 application, it's showing a warning that there's a connection string for a datasource that needs to be synchronized. Clicking the button "freezes" VS2005 for more...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.