/    Sign up×
Community /Pin to ProfileBookmark

ODBC connecting to MSSQL PHP Error?

Copy linkTweet thisAlerts:
Nov 26.2017

Hi,

I was wondering if someone could lend me a hand on the issue im having. We currently have an internal web for our users. The website was created by another person using PHP and that person we cannot reach them. The website was hosted using XAMPP on a windows server using ODBC to connect to a windows sql server for that database.

Currently I migrated the htdocs to a ubuntu Server 14.04 running NGINX with php5.

I installed the current packages and i was succefuly able to connect to the database (see picture)

My issue is on the website when i put the username and password it should authenticate to the db of windows but instead it gives me this error on the NGINX log

[code=php]PHP Warning: odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQ
LConnect[/code]

to post a comment
PHP

0Be the first to comment 😎

×

Success!

Help @killmasta93 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.18,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...