Has anyone ever gotten a linux box to speak to a MS SQL server? I am only assuming i need to configure an odbc DSN from linux to MSSQL, but am not successful yet. The end goal is to get phpBB2 to talk to my existing MSSQL database. In order for that to happen, apache has to use php and php has to use an odbc connection to MS SQL. Well, php in apache is working now, and php is set to use MS SQL. isql -s SERVER NAME PWD connects me to my MS SQL database just fine, but iodbctest is failing. I don't know enough to know what is wrong. Any help would be greatly apreciated! mike
What's iodbctest? Why not use the standard odbc interfaces? http://us2.php.net/manual/en/ref.uodbc.php A simple google search turned up this page expaining a simple usage: http://www.linuxjournal.com/node/6636/print -Jared On 5/28/06, Mike Leo <mleo963@yahoo.com> wrote:
Has anyone ever gotten a linux box to speak to a MS SQL server?
I am only assuming i need to configure an odbc DSN from linux to MSSQL, but am not successful yet.
The end goal is to get phpBB2 to talk to my existing MSSQL database.
In order for that to happen, apache has to use php and php has to use an odbc connection to MS SQL.
Well, php in apache is working now, and php is set to use MS SQL.
isql -s SERVER NAME PWD connects me to my MS SQL database just fine, but iodbctest is failing.
I don't know enough to know what is wrong.
Any help would be greatly apreciated!
mike _______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
thanks for the reply. I have followed similar instructions via link one already, to no avail, but I will try again with this link now, too. The "isql -v MSSQLServer username password" currently works, but my iodbctest doesn't, nor do PHP connections, refering to not being able to load the driver. I'll keep at it... --- Jared Greenwald <greenwaldjared@gmail.com> wrote:
What's iodbctest? Why not use the standard odbc interfaces?
http://us2.php.net/manual/en/ref.uodbc.php
A simple google search turned up this page expaining a simple usage:
http://www.linuxjournal.com/node/6636/print
-Jared
On 5/28/06, Mike Leo <mleo963@yahoo.com> wrote:
Has anyone ever gotten a linux box to speak to a MS SQL server?
I am only assuming i need to configure an odbc DSN from linux to MSSQL, but am not successful yet.
The end goal is to get phpBB2 to talk to my existing MSSQL database.
In order for that to happen, apache has to use php and php has to use an odbc connection to MS SQL.
Well, php in apache is working now, and php is set to use MS SQL.
isql -s SERVER NAME PWD connects me to my MS SQL database just fine, but iodbctest is failing.
I don't know enough to know what is wrong.
Any help would be greatly apreciated!
mike _______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
Where did you get this iodbc package? I searched (admittedly not for very long) on the php.net site and didn't find it there - only the odbc package. -Jared On 5/28/06, Mike Leo <mleo963@yahoo.com> wrote:
thanks for the reply.
I have followed similar instructions via link one already, to no avail, but I will try again with this link now, too.
The "isql -v MSSQLServer username password" currently works, but my iodbctest doesn't, nor do PHP connections, refering to not being able to load the driver.
I'll keep at it...
--- Jared Greenwald <greenwaldjared@gmail.com> wrote:
What's iodbctest? Why not use the standard odbc interfaces?
http://us2.php.net/manual/en/ref.uodbc.php
A simple google search turned up this page expaining a simple usage:
http://www.linuxjournal.com/node/6636/print
-Jared
On 5/28/06, Mike Leo <mleo963@yahoo.com> wrote:
Has anyone ever gotten a linux box to speak to a MS SQL server?
I am only assuming i need to configure an odbc DSN from linux to MSSQL, but am not successful yet.
The end goal is to get phpBB2 to talk to my existing MSSQL database.
In order for that to happen, apache has to use php and php has to use an odbc connection to MS SQL.
Well, php in apache is working now, and php is set to use MS SQL.
isql -s SERVER NAME PWD connects me to my MS SQL database just fine, but iodbctest is failing.
I don't know enough to know what is wrong.
Any help would be greatly apreciated!
mike _______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
participants (2)
-
Jared Greenwald
-
Mike Leo