Connecting to a remote database

How to restrict who may read my entries?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Сообщества
• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > PHP web-programming > Connecting to a remote database 18 August 2005 17:56:41

Recent blog posts:

Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded…

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded…

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

They have birthday today:

xiongchong

henna diah

все >>

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

users & groups
i installed the latest version, which is 0.9.14.6. My user and group accounts are located in an ldap…

[SMARTY] break out of…
Hello list, my question: I have a foreach-loop. How can I break this loop before it ends? Greetings…

Fatal error: Call to a member…
Hello I am pleased if someone could explain me since is wrong the following function call: ($row…

Assigning PHP Arrays to…
Hi, Question: How can assign a PHP array to a Javascript array? Example…

Recent forum topics:

why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/Ticket/Display.html?id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…

Recent forum comments:

RE: Updating A Portion Of A Site
Thanks! I remembered just before I came back to check. It's amazing the things you forget. Thanks…

RE: Updating A Portion Of A Site
Use a FrontPage include file - see Help on Included Content. Or, if all pages are asp or PHP, use a…

RE: Index Files
What they are telling you is the home page of your site (before you publish it) must be named index.htm…

RE: Website diifers from local copy
I see it as a 40x68 icon (clear your cache) - as for the position check w/ Google API help Neither issue…

RE: Forced submit
"Ellie" <ellymay999nospam@nospamnetzero.com> wrote in message…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: Forced submit
Ellie wrote on 05 sep 2008 in microsoft.public.inetserver.asp.general: You cannot…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: why infix:<div>:(Int, Int…
On Thu, Dec 4, 2008 at 3:26 PM, David Green <david.green@telus.net> wrote: Using…

Moderators:

Administrator
Protorioris


Connecting to a remote database
R.S. Herhuth 18 August 2005 17:56:41
	Newbie alert! I am able to connect to a SQL Server Database on my local network by specifying the host as "testHost" the database is "DB". My question is if I'm outside the network what is the correct syntax that I need to call in the host in order to access the database? Thanks, ROn -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
		Add comment


Matt Babineau 18 April 2002 22:58:02 [ permanent link ]
	Try to access the SQL DB by IP Address. If you want to access it from outside you LAN, The machine the SQL DB is on has to have an external IP. Matt Babineau Freelance Internet Developer e: mbabineau@illuminatistudios.com p: 603.943.4237 w: http://www.illuminatistudios.com -----Original Message----- From: R.S. Herhuth [mailto:ronherhuth@pop.mindspring.com] Sent: Thursday, April 18, 2002 3:57 PM To: php-windows@lists.php.net Subject: [PHP-WIN] Connecting to a remote database Newbie alert! I am able to connect to a SQL Server Database on my local network by specifying the host as "testHost" the database is "DB". My question is if I'm outside the network what is the correct syntax that I need to call in the host in order to access the database? Thanks, ROn -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
		Add comment


Steff 19 April 2002 02:57:59 [ permanent link ]
	further on you should tell your DBMS that not only local scripts (users), but also external users may access your database. this is done by modifying the table "db" in the database "mysql". with this table you can control which hosts may access your dbs. the simplest but also most risky way is to set host = % and db = %. db = "DB" and host = "your.remote.machine" (or for several domains or IP-ranges) would be safer already (the rest of the fields/permissions to be set per row are mostly self-explaining). HTH steff Matt Babineau wrote:> Try to access the SQL DB by IP Address. If you want to access it from> outside you LAN, The machine the SQL DB is on has to have an external> IP.> Matt Babineau> Freelance Internet Developer> e: mbabineau@illuminatistudios.com > p: 603.943.4237> w: http://www.illuminatistudios.com> -----Original Message-----> From: R.S. Herhuth [mailto:ronherhuth@pop.mindspring.com] > Sent: Thursday, April 18, 2002 3:57 PM> To: php-windows@lists.php.net> Subject: [PHP-WIN] Connecting to a remote database> Newbie alert!> I am able to connect to a SQL Server Database on my local network by> specifying the host as "testHost" the database is "DB". My question is> if I'm outside the network what is the correct syntax that I need to> call in the host in order to access the database?> Thanks,> ROn> -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
		Add comment


Nigel Horne 18 August 2005 15:43:41 [ permanent link ]
	When I connect to a remote database I get this message: "An error has occured: Error connecting to the server: FATAL: Missing or erroneous ph_hba.conf file, see postmaster log for details." Naturally I have something wrong, this is NOT a bug report for that, rather it is a plea (RFE) for a more informative message. This message falls down in a number of ways: 1) Is it missing or is it erroneous? Why doesn't pgadmin know the difference? 2) Is the file on the local system or remote system? 3) Where is the ph_hba.conf file? 4) What is erroneous about it? 5) Where is the postmaster log file, on which machine, and what details am I looking for? 6) Why doesn't this box allow me to view the log file? 7) Last and least: occurred has two 'r's -Nigel Horne ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
		Add comment


Tino Wildenhain 18 August 2005 17:56:41 [ permanent link ]
	Nigel Horne schrieb:> When I connect to a remote database I get this message:> "An error has occured:> Error connecting to the server: FATAL: Missing or erroneous ph_hba.conf> file, see postmaster log for details."> Naturally I have something wrong, this is NOT a bug report for> that, rather it is a plea (RFE) for a more informative message.> This message falls down in a number of ways:> 1) Is it missing or is it erroneous? Why doesn't pgadmin know the> difference? Ah well, the message comes from the server, so guess what pgadmin can really know about it 2) Is the file on the local system or remote system? postmaster is the server. So look there (or ask your DBA) 3) Where is the ph_hba.conf file? Again, ask your sysadmin of the server. If you set up yourself, you would have read the documenation, right? ;)) hint 4) What is erroneous about it? It told you to read the logfile on the server to find out 5) Where is the postmaster log file, on which machine, and what details> am I looking for? See above 6) Why doesn't this box allow me to view the log file? Because you cant connect? And there is no fileaccess to joe average anyway ;) 7) Last and least: occurred has two 'r's Try to mess up your /etc/passwd on a unix box and then connect via ssh. Compare the messages you get and what to do ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
		Add comment

QAIX > PHP web-programming > Connecting to a remote database 18 August 2005 17:56:41

	see also: error when including a participant in… What services should be running for…		пройди тесты: Do you know women?		see also: Rubber brains [hello to all] Hi people!

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

Connecting to a remote database

Add new comment