Query SQLServer

[kirpi@kirpi.it]

There is an SQLServer database somewhere, and I would like to grab and
publish some data to my web pages.
I was told: "please, do", and given server address, database name, id,
and password.

My site is hosted on Linux at aruba.it and I do not have root rights,
nor any chance to edit whatever server setup. All I can do is use the
available tools, which you cand find here http://62.149.140.28/ver.php

All I need is query for a few data with an easy SELECT and publish on
the web.

Question: would that be possible or impossible?

Thank you

[Henrik Hansen]

Re: Query SQLServer

"kirpi@kirpi.it " <kirpi.it@gmail .com> writes:
[color=blue]
> There is an SQLServer database somewhere, and I would like to grab and
> publish some data to my web pages.
> I was told: "please, do", and given server address, database name, id,
> and password.
>
> My site is hosted on Linux at aruba.it and I do not have root rights,
> nor any chance to edit whatever server setup. All I can do is use the
> available tools, which you cand find here http://62.149.140.28/ver.php
>
> All I need is query for a few data with an easy SELECT and publish on
> the web.
>
> Question: would that be possible or impossible?[/color]

If by SQLServer you mean a mysql server it would be possible. If it's
something else it's not possible because only mysql is enabled in
their php installation.

--
Henrik Hansen

[Erwin Moller]

Re: Query SQLServer

kirpi@kirpi.it wrote:
[color=blue]
> There is an SQLServer database somewhere, and I would like to grab and
> publish some data to my web pages.
> I was told: "please, do", and given server address, database name, id,
> and password.
>
> My site is hosted on Linux at aruba.it and I do not have root rights,
> nor any chance to edit whatever server setup. All I can do is use the
> available tools, which you cand find here http://62.149.140.28/ver.php
>
> All I need is query for a few data with an easy SELECT and publish on
> the web.
>
> Question: would that be possible or impossible?
>
> Thank you[/color]

Hi,

SQLServer means Microsoft SQL Server?
Or some other db?
MS SQL Server runs on W$ machines, not on *nix.

If you are going to query M$ SQL SERVER, you need some layer in between to
help you from *nix. (Several solutions exist)

If you have another DB, please say which one, and we can help better.

Regards,
Erwin Moller

[Jerry Stuckle]

Re: Query SQLServer

kirpi@kirpi.it wrote:[color=blue]
> There is an SQLServer database somewhere, and I would like to grab and
> publish some data to my web pages.
> I was told: "please, do", and given server address, database name, id,
> and password.
>
> My site is hosted on Linux at aruba.it and I do not have root rights,
> nor any chance to edit whatever server setup. All I can do is use the
> available tools, which you cand find here http://62.149.140.28/ver.php
>
> All I need is query for a few data with an easy SELECT and publish on
> the web.
>
> Question: would that be possible or impossible?
>
> Thank you
>[/color]

Hmmm, you're going to have to get your host to help you here.

It's possible, but to access MS SQL you need to have some extensions
added. If you're hosting is on Windows, you'll need the MS SQL Client
tools. If you're running on UNIX, you'll need the FreeTDS library
(http://www.freetds.org) library. Alternatively, the Sybase functions
are supposed to work because they two are compatible protocol-wise, but
I've never tried it.

Depending on your host, they may or may not be willing to install these
for you.




--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[kirpi@kirpi.it]

Re: Query SQLServer

> SQLServer means Microsoft SQL Server?

Yes, it does: I'm sad to confirm that.

[color=blue]
> MS SQL Server runs on W$ machines, not on *nix.[/color]

Indeed, it runs on a machine which has nothing to do with me: I just
could have access to the database (id, password,...) with the purpose
of extracting a few data and publish them on my (linux powered) site.

[color=blue]
> Hmmm, you're going to have to get your host to help you here.
> [...]
> ...you'll need the FreeTDS library...
> Alternatively, the Sybase functions are supposed to work...[/color]

The issue is: my host does not install any extra software.
That's why I'm asking. Is there any dirty, raw trick to read (just
read, not write) data from that database?

Luigi

[Jerry Stuckle]

Re: Query SQLServer

kirpi@kirpi.it wrote:[color=blue][color=green]
>>SQLServer means Microsoft SQL Server?[/color]
>
>
> Yes, it does: I'm sad to confirm that.
>
>
>[color=green]
>>MS SQL Server runs on W$ machines, not on *nix.[/color]
>
>
> Indeed, it runs on a machine which has nothing to do with me: I just
> could have access to the database (id, password,...) with the purpose
> of extracting a few data and publish them on my (linux powered) site.
>
>
>[color=green]
>>Hmmm, you're going to have to get your host to help you here.
>>[...]
>>...you'll need the FreeTDS library...
>>Alternatively , the Sybase functions are supposed to work...[/color]
>
>
> The issue is: my host does not install any extra software.
> That's why I'm asking. Is there any dirty, raw trick to read (just
> read, not write) data from that database?
>
> Luigi
>[/color]

Luigi,

Not unless you have the appropriate libraries installed.

You might want to look for another host (perhaps on Windows?), or get a
VPS and do it yourself.


--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[kirpi@kirpi.it]

Re: Query SQLServer

> Not unless you have the appropriate libraries installed.

:-(

[color=blue]
> You might want to look for another host (perhaps on Windows?),
> or get a VPS and do it yourself.[/color]

That could be an idea...!
I know nothing about Windows: do you think that if I get a Windows
hosting then it will be smooth to connect to that database? Or again I
will need extra software to be installed?
I ask because a Windows hosting could come rather cheap, and could be
affordable.
Indeed a Linux VPS is the best solution, but the best I found is 20
euro/month, which is more than ten times the price I can afford... (you
know: children, house morgages, unemployment,.. .)

Luigi

[Jerry Stuckle]

Re: Query SQLServer

kirpi@kirpi.it wrote:[color=blue][color=green]
>>Not unless you have the appropriate libraries installed.[/color]
>
>
> :-(
>
>
>[color=green]
>>You might want to look for another host (perhaps on Windows?),
>>or get a VPS and do it yourself.[/color]
>
>
> That could be an idea...!
> I know nothing about Windows: do you think that if I get a Windows
> hosting then it will be smooth to connect to that database? Or again I
> will need extra software to be installed?
> I ask because a Windows hosting could come rather cheap, and could be
> affordable.
> Indeed a Linux VPS is the best solution, but the best I found is 20
> euro/month, which is more than ten times the price I can afford... (you
> know: children, house morgages, unemployment,.. .)
>
> Luigi
>[/color]

Yes, I understand about the hosting - I pay about that for each of my
servers. But it gives me the power and flexibility I need. And I
consider it to be a good investment.

As to the windows hosting, you'll have to look around. You will still
need the SQL Server client installed; check around to see what you can
find. I've seen all kinds of prices.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[kirpi@kirpi.it]

Re: Query SQLServer

> You will still need the SQL Server client installed

I live in the open-source world and (sorry) don't have the faintest
idea of how these Microsoft things work: should I also pay for that
"SQL Server client", or is it something I can download and use without
stress?

Luigi

[Jerry Stuckle]

Re: Query SQLServer

kirpi@kirpi.it wrote:[color=blue][color=green]
>>You will still need the SQL Server client installed[/color]
>
>
> I live in the open-source world and (sorry) don't have the faintest
> idea of how these Microsoft things work: should I also pay for that
> "SQL Server client", or is it something I can download and use without
> stress?
>
> Luigi
>[/color]

Luigi,

I don't know if the client itself is available or not. The server is
quite expensive, but comes with the client.

I suggest you try the Microsoft website.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Erwin Moller]

Re: Query SQLServer

Jerry Stuckle wrote:
[color=blue]
> kirpi@kirpi.it wrote:[color=green][color=darkred]
>>>You will still need the SQL Server client installed[/color]
>>
>>
>> I live in the open-source world and (sorry) don't have the faintest
>> idea of how these Microsoft things work: should I also pay for that
>> "SQL Server client", or is it something I can download and use without
>> stress?
>>
>> Luigi
>>[/color]
>
> Luigi,
>
> I don't know if the client itself is available or not. The server is
> quite expensive, but comes with the client.
>
> I suggest you try the Microsoft website.
>[/color]

Hi Jerry and Luigi,

Maybe this helps:
http://www.microsoft.com/sql/edition...s/default.mspx

It is a 'free' SQL Server version for developers or something like that.
(I cannot, will not, basically 100% refuses to read Microsoft mumbo-jumbo,
so judge for yourself.)

In general: M$ doesn't know the meaning of 'free', but maybe you can extract
some dll from that package that is legal to use (in some countries,
provided you contact Redmond first in 20-fold, by snailmail, asking
permission) or maybe not.

The highest (latest) usercontributio n on
http://nl2.php.net/manual/en/function.mssql-connect.php says:

------------------------
As described here: http://php.net/manual/en/function.ms...nect.php#58787
MSSQL Express Edition does not work with ntwdblib.dll bundled with PHP. But
if you have not installed MSSQL Server2000, you can find correct
ntwdblib.dll here: http://webzila.com/dll/1/ntwdblib.zip or try to find it
from main page (http://www.webzila.com) if link is not work.
--------------------------

Maybe that helps.

Regards,
Erwin Moller

[kirpi@kirpi.it]

Re: Query SQLServer

Thanks to you all.
I'll now make my homework, and let you know how things evolve.

Luigi