freelanceprogrammers.org Forum Index » PHP
dsn less connection
Joined: 14 Jul 2005
Posts: 1
dsn less connection
Hello
i am making a site for a company with php and ms sql server there database
is on sql server which is hosted on windows server
and website will be hosted on another server which is unix
they have given me dsn and id pass for sql server
how do i connect to sql server from unix server remotely can anyone tell me
the code to connect i dont have mssql functions in php unix hosting on the
server so i have to make a connnection by some other way
if anyone can tell me what should i do how do i connect to sql server.
Thanks
[Non-text portions of this message have been removed]
Joined: 29 Apr 2005
Posts: 10
dsn less connection
Farhan khalid wrote:
> Hello
> i am making a site for a company with php and ms sql server there database
> is on sql server which is hosted on windows server
> and website will be hosted on another server which is unix
> they have given me dsn and id pass for sql server
> how do i connect to sql server from unix server remotely can anyone tell me
> the code to connect i dont have mssql functions in php unix hosting on the
> server so i have to make a connnection by some other way
> if anyone can tell me what should i do how do i connect to sql server.
> Thanks
you need a middle man... i use http://freetds.org/
Joined: 15 Jul 2005
Posts: 2
dsn less connection
Hi Farkan,
you have to connect via an odbc installed on your unix site. You are
going to connect via *odbc_connect*, and all the tasks for accessing the
ms sql server will be through odbc.
I have an application that is working very fine. It`s installed on an
unix webserver, accessing a database in a windows machine..
Here is the site.
http://www.iodbc.org/
Good luck, and if you need help don`t hesitate to e-mail me.
Sergio Gonzalez
Farhan khalid wrote:
>Hello
> i am making a site for a company with php and ms sql server there database
>is on sql server which is hosted on windows server
> and website will be hosted on another server which is unix
> they have given me dsn and id pass for sql server
> how do i connect to sql server from unix server remotely can anyone tell me
>the code to connect i dont have mssql functions in php unix hosting on the
>server so i have to make a connnection by some other way
> if anyone can tell me what should i do how do i connect to sql server.
> Thanks
>
>
>[Non-text portions of this message have been removed]
>
>
>
>PHP Data object relational mapping generator - http://www.meta-language.net/
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Joined: 15 Jul 2005
Posts: 3
dsn less connection
Farhan,
you need to you odbc functions as you have DSN.
Thanks
On 7/14/05, Farhan khalid <farhan2kf@...> wrote:
> Hello
> i am making a site for a company with php and ms sql server there database
> is on sql server which is hosted on windows server
> and website will be hosted on another server which is unix
> they have given me dsn and id pass for sql server
> how do i connect to sql server from unix server remotely can anyone tell me
> the code to connect i dont have mssql functions in php unix hosting on the
> server so i have to make a connnection by some other way
> if anyone can tell me what should i do how do i connect to sql server.
> Thanks
>
>
> [Non-text portions of this message have been removed]
>
>
>
> PHP Data object relational mapping generator - http://www.meta-language.net/
> Yahoo! Groups Links
>
>
>
>
>
>
>
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
China Wholesale - Electronics Products
Character Studio - Tutorials and Help