Linux Freetds ODBC
Feb 21, 2007
I am configuring a Linux server to connect to a MSSQL database using freetds and an ODBC driver setup.
I have all but completed this, but I am stuck with some mis-configuration that I cant figure out.
Here's the problem. I can connect the the mssql server using tsql, but I cannot connect to it using isql, which is what I need to get php to connect to it.
Here is applicable part of the freetds.conf file.
Code:
[TDS]
host = 10.10.64.102
port = 1433
tds version = 8.0
here's the odbc.ini. (This was setup using the linux GUI ODBCadmin tool).
Code:
[MSSQLServer]
Description = TDS
Driver = TDS
Servername = 10.10.64.102
Database = MyDb
UID = myuser
PWD = mypassword
Port = 1433
here are the commands I am using to connect:
Code:
#tsql -H 10.10.64.102 -p 1433 -U username -P password
#isql -v MSSQLServer username password
I can connect with the username and password using tsql, but not with isql or php.
View 1 Replies
ADVERTISEMENT
May 28, 2009
I had a small question about ODBC. I created a new connection to a MySQL database with the 'ODBC Data Source Administrator' on my Win 2008 / IIS 7 webserver.
In this administration panel the ODBC data source works just fine. When I fill in the required values I receive the list of available databases and pressing the "test" button results in a successful connection.
But when I want to use this connection in other software, a C++ application and a PHP application, they supply me with errors "Couldn't connect to database", etc.
So the ODBC connection is correct (so are the credentials in the software 100% sure of that), but software can't use the connection. Because the software worked perfectly on an older server I think I'm missing out on some sort of setting which enables applications to use the connection (or something like that).
View 0 Replies
View Related
Apr 20, 2014
I suddenly started to get the following error
Windows 2008 server 64 bits 24 gigs ram sql express php plesk 11.5.30 latest update passed the latest self test with no problem
Internal error: ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
Message ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
File aps_php.php
Line 11933
Type Exception
Go To Previous Page
View 1 Replies
View Related
Sep 29, 2014
I am using user authentication with the following components:
Apache/2.4.10 (Win32) + mod_auth_basic + mod_authn_dbd + mod_dbd + ODBC Driver + Microsoft SQL Server 2008(SP3).
It works fine except when I do not provide any username when browser asks for username and password. In this case I receive the "Internal Server Error" as the response instead of "Unauthorized" response.
The most interesting part of the error.log is:
[Sat Sep 27 21:23:17.639860 2014] [authn_dbd:error] [pid 1208:tid 1636] [client 127.0.0.1:1363] AH01656: Query execution error looking up '' in database [[dbd_odbc] SQLBindParameter returned SQL_ERROR (-1) at apr_dbd_odbc.c:604 [Microsoft][ODBC SQL Server Driver]Invalid precision value HY104 ]
The AuthDBDUserPWQuery directive in my httpd.conf is:
AuthDBDUserPWQuery "SELECT password FROM member WHERE CONVERT(VARCHAR(10), member_Index) = %s"
And the member_Index column in the database is smallint.
View 5 Replies
View Related
Dec 21, 2008
if it's possible to use ODBC to connect to a Windows box from a Linux cPanel server. We have attempted connections from PHP (both as CGI as well as Apache module) and we get:
Fatal error: Call to undefined function odbc_pconnect() in...
and
Fatal error: Call to undefined function odbc_connect() in...
Is ODBC possible on cPanel servers?
View 2 Replies
View Related
Jun 20, 2014
I am trying to install Magento on my apache server. I am running into the dreaded mcrypt issue as Magento needs it to run. I have now been googling for the past few hours and have gotten nowhere.
Here are my details:
Linux
Centos 5.5
PHP 5.3.3
x86_64
Plesk 12
I have tried installing all sorts of different repos and it just isn't working.
When I try to install using # yum install php-mcrypt I get the following:
Loaded plugins: fastestmirror
Package php-mysql is obsoleted by php-mysqlnd, trying to install php-mysqlnd-5.5.13-3.el5.remi.x86_64 instead
--> Processing Dependency: php53-gd for package: psa-php53-configurator
--> Processing Dependency: php53-imap for package: psa-php53-configurator
[Code].....
View 6 Replies
View Related
Feb 25, 2015
Does Parallels support Plesk 12 being installed on a Linux VM that is provisioned on Microsoft Windows Server 2012 R2 Hyper-V?Is it fully supported?
View 2 Replies
View Related
Oct 30, 2009
I am looking to start offering web hosting packages and I was wondering if it was worth offering just Linux hosting or Windows as well?
View 12 Replies
View Related
Aug 12, 2008
I need a powerfull vps with lxadmin control panel.
With support 24/7/365 and best uptime.
With 384 MB Ram.
View 5 Replies
View Related
Sep 4, 2009
Most if not all the applications that we produce use PHP/MySQL and we're currently on Windows/IIS environment.
We're looking to change our hosting company and upgrade our servers and I'm eager to migrate over Linux/Apache.
The only problem is, some of our applications use the COM object to integrate with PowerPoint, can this still be done on Linux.
Also is anybody aware of any other potential floors when migrating over?
View 2 Replies
View Related
Mar 13, 2009
i am a wap develper(mobile web).I need a vps with 30-40 Gigs of space and about 200-250 Bandwidth with cpanel.my bugget is under $35 .Please suggest me one for these requirements.
View 4 Replies
View Related
Oct 20, 2009
I tried going from swf to mpg by using
[url]
and I was thinking of going from mpg to avi using ffmpeg. The problem is that swf to mpg ran up with an error. I was wondering if anyone know of the best way to proceed with this.
There is also audio on the swf files.
View 8 Replies
View Related
Jan 2, 2008
I am looking at linux vps due to money constraints. Ive had lots of experience with windows vps... its really simple, just use remote desktop .
Is there something similar for linux vps? Giving me a desktop like environment to mess around in? How does that work? Is there a tutorial on how to use one, transfer files, etc.
im talking about using windows XP to community to a linux vps.
View 12 Replies
View Related
May 24, 2008
To make ASP run under Linux, PHP script files are saved as ASP extensions and are redirected to the PHP interpreter. So it looks like the server serves ASP files, but these are actually PHP scripts.
View 3 Replies
View Related
Oct 1, 2008
Can anyone recommend a decent VPS place, need atleast decent ram for apache, mysql, xcache, php, 200 - 400 BW, for hosting about 2 websites. (need them on a separate machine from my others). Good connectivity matters since our users will be mainly from all over euorpe, USA and Russia and former Russian region.
View 12 Replies
View Related
Feb 2, 2008
There is some version of ASP.NET for linux that is reliable?
View 1 Replies
View Related
Aug 2, 2007
in dos we run dir /p and with if the folder was very long show only 10 list and witn click on enter,show page2 and ...
but in linux how may?
i run ls /p but don`t answer to me
View 3 Replies
View Related
May 27, 2007
I have Debian Etch 4.0 and am intending to run a LAMP (Linux, Apache, MySQL and PHP) installation on Debian.
I have setup AMP on windows boxes to run successfully. I have very good microsoft O/S skills but have vague skills around Linux which I need to learn quickly for my job. First of all I need to setup a LAMP installation so does anyone have a recommendation of a simple and easy LAMP installation step-by-step solution for me?
View 4 Replies
View Related
Dec 11, 2007
I have a dedicated Linux server with CentOS and Directadmin.
How do I get ASP.net on a Linux server, I only could find one that seems something about it, but I cant seem to understand how that will work, and how to install it YEP thats how smart I am.
View 6 Replies
View Related
Jul 8, 2008
I have recently purchased a GoDaddy Virtual Server running Fedora 7, with the Plesk Control Panel 8.3 installed - if I had remembered this site then I probably wouldn't have chosed GoDaddy, however my colleague runs a GoDaddy server and it works like a dream. I have only one domain on the site, running Boonex Dolphin 6.1. The site however runs EXCEPTIONALLY slow.
I have spoken with many friends that use Dolphin and they have no major issues. I also did a search on Google and found that there appear to be no major speed issues with Dolphin.
The site I am running is http://www.tkd-web.com
I wondered if some of you guys could take a look and let me know if it looks like a hosting issue or a scripting issue. Or what information do you need to know to find out the answer to this problem.
I would be really grateful to anyone that can even point me in the right direction, as I don't want to go off and start shouting the odds about GoDaddy etc, I just want to find the most effective solution to my issue.
View 14 Replies
View Related
Apr 26, 2008
How can i run my "aspx.cs" files on Linux server. But by default on my Linux box, it just shows the code of the "aspx.cs" file ..
How can i make aspx.cs run on linux server..
View 2 Replies
View Related
May 18, 2009
I'm interested in having an unmanaged VPS with Ubuntu 7.1 or 8.04 installed (or available to Rebuild under the HyperVM) from the state of Missouri (should have at least some IPs already available from the region).
View 2 Replies
View Related
Jan 5, 2009
I am currently with a company operating out of the Netherlands, however for what I am spending I do not feel I am receiving timely responses to support tickets (I'm talking days with no reply, at all). So, I am looking to switch. My current budget is around $300 USD/mo, however, I can spend more if the deal is right.
I need a host that is not easily scared off by American DMCA take-down notices. Please understand, nothing I do is illegal. In fact, to be blunt, I write software for online games and charge a fee to users who wish to access my software. I was using dedicated hosts within the United States to satisfy my customer base, however, one particular company, Nexon America (just one of the companies whose online games I develop software for) more or less got me dropped by every host I went to. I host absolutely no copyrighted files of any kind, images, textual, video, or binary.
View 12 Replies
View Related
May 23, 2009
I'd like to know that is Linux virus free server or not?
Is there any possibility to run a virus on linux server while uploading files (virus affected) from local system to server end by ftp client?
View 14 Replies
View Related
Feb 1, 2009
does it matter which 1 you use? and if so which one is the best
View 14 Replies
View Related
Apr 5, 2009
for a project i'm setting up a WDS server for rapid deployment of Windows 2008 servers.
The information regarding WDS and automated deployments is clear for me.
The only, and probably biggest problem is how to configure the linux dhcp/pxe server to able to boot an image from the WDS to start the installation.
Unfortunately I haven't found much information about it.
I hope some one here can push me in the right direction.
View 1 Replies
View Related
Jul 2, 2009
I currently colocated at Chicago FDC Servers, OUTSTANDING BY THE WAY! Cheap too! But that is not my area of concern, since I already have a colocation, I was wondering if people could give me ideas what to do with it. I colocated because I found them, they offered me an affordable colocation.
I do not wish to host STEAM GAME SERVERs like counter strike.
If I had a ventrilo license, I could host a huge ventrilo, but I do not. Teamspeak is out of the question.
View 12 Replies
View Related
Jun 5, 2009
my /var is full any idea what to delete
root@host [/var]# du -sh *
12K account
16K aquota.user
13M cache
188M cpanel
28K db
32K empty
8.0K games
73M lib
8.0K local
32K lock
35M log
16K lost+found
4.0K mail
7.5G named
8.0K nis
8.0K opt
4.0K portsentry
8.0K preserve
92K profiles
12K quota.user
8.0K racoon
900K run
6.5M spool
8.7M tmp
24K yp
root@host [/var]#
---
even i can move named folder if some one guide how to move and change the path in conf because i dont no the location of conf files etc
*mod if i am on wrong place move it*
View 14 Replies
View Related
Oct 3, 2009
I have a website related to my business, i want to host it on the internet. But i do not know which web hosting to follow. I want great security to my data. Please tell me Which web hosting is best whether Windows web hosting or Linux web hosting?
View 24 Replies
View Related
Aug 4, 2009
We have a nameserver(DNS) on freebsd which the other linux admin works on.
We had switched webservers and that created a problem to an ftp user who uploads her pics to our webserver.
www.sitename.com/~username/ is her account
and she uploads at ftp://sitename.com
since we moved the server she cant do that, now i thought of this which the other admin says its not possible but i dont believe so.
what if i add a dns alias entry as (cname)
www.sitename.com/~username/ point to old server
ftp://sitename.com point to old server
www.sitename.com (new website main domain) point to new server
can i do this?
View 2 Replies
View Related