472,958 Members | 2,286 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

How to Connect SQL database from server2005 over dyndns in php?

Dear all,

How to connect SQL Database from Server 2005 through dyndns in php,

My dyndns address - xxx-xxx.dyndns.org
Port - 3389(default)

This is the code i am using:
Expand|Select|Wrap|Line Numbers
  1. $dsn = 'DRIVER={SQL Server};SERVER=xxxx-xxxx.dyndns.org:3389\SQLEXPRESS;DATABASE=CXXXXXXC';
  2. $connection = odbc_connect($dsn,'sa','xxxxxx') or die('ODBC Error:: '.odbc_error().' :: '.odbc_errormsg().' :: '.$dsn); 
And the error like this

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection., SQL state 08001 in SQLConnect in C:\wamp\www\qamaruae\components\com_amc1234\views\ amc1234\tmpl\statement.php on line 3
ODBC Error:: 08001 :: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. :: DRIVER={SQL Server};SERVER=xxxx-xxxxx.dyndns.org:3389\SQLEXPRESS;DATABASE=xxxxxxxx xxx

Please helpme
Nov 19 '10 #1
0 1372

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: programer | last post by:
Can I use Activex (as vb) to connect database when I use vc.net.
2
by: Mathew | last post by:
Can any one pls help me, How to connect SQL Server database thru vb.net. But it gives an error. I tried to connect thru SQLDataAdapter. General network error. Check your network documentation. ...
3
by: venkatesh | last post by:
hai to everybody I need to know how to connect database ms access or oracle with c or c++? please if u know tell I am interested in doing project with c thanks in advance....
1
by: arun_kumar112 | last post by:
HI , I am new member of this comminity, let me introduce first, i am MCA final year student, doing a project on network system, and database . will you tell me how can we connect database (...
1
by: nagendra prasad | last post by:
how to connect database for visualbasic using ADO
0
by: ankitkumar | last post by:
can any one suggest me how to connect the c++ with sql server 2005
3
by: Raymond Chiu | last post by:
Dear All, I have posted my question as below. But no answers, hope it can found here. ...
3
by: iedayah88 | last post by:
can sombody help me..after i create database in oracle.. what i must do to connect database and sql.. it's i must setup odbc first? is yes, how to setup odbc in localhost?
2
by: chetan ghadiya | last post by:
how to connect database in vb ?
1
by: rishiverma | last post by:
how to connect database create in sql server ,to my web site upload on domain.
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.