-
Юбилейный DevConfX пройдет 21-22 июня в Москве. Как всегда — Вы решаете, кто попадет в программу секции Backend — голосуйте за интересные доклады
Обращение к удаленной базе данных
- Автор темы svirol
- Дата начала
Pablo Escobar
Guest
Re: Обращение к удаленной базе данных
какой хост у бд? (*nix, win или что?)
Demiurg
Guest
Re: Обращение к удаленной базе данных
значит запрещено подключение к mysql с удаленного сервера.
Яро
бард-скальд
http://php.weblogs.com/adodb
Если кто не знает.
Кстати, вышла версия 2.0
2.00 13 May 2002
Added drivers informix72 for pre-7.3 versions, and oci805 for oracle 8.0.5, and postgres64 for postgresql 6.4 and earlier. The postgres and postgres7 drivers are now identical.
Interbase now partially supports ADODB_FETCH_BOTH, by defaulting to ASSOC mode.
Proper support for blobs in mssql. Also revised blob support code is base class. Now UpdateBlobFile() calls UpdateBlob() for consistency.
Added support for changed odbc_fetch_into api in php 4.2.0 with $conn->_has_stupid_odbc_fetch_api_change.
Fixed spelling of tablock locking hint in GenID( ) for mssql.
Added RowLock( ) to several databases, including oci8, informix, sybase, etc. Fixed where error in mssql RowLock().
Added sysDate and sysTimeStamp properties to most database drivers. These are the sql functions/constants for that database that return the current date and current timestamp, and are useful for portable inserts and updates.
Support for RecordCount() caused date handling in sybase and mssql to break. Fixed, thanks to Toni Tunkkari, by creating derived classes for ADORecordSet_array for both databases. Generalized using arrayClass property. Also to support RecordCount(), changed metatype handling for ado drivers. Now the type returned in FetchField is no longer a number, but the 1-char data type returned by MetaType. At the same time, fixed a lot of date handling. Now mssql support dmy and mdy date formats. Also speedups in sybase and mssql with preg_match and ^ in date/timestamp handling. Added support in sybase and mssql for 24 hour clock in timestamps (no AM/PM).
Extensive revisions to informix driver - thanks to Samuel CARRIERE samuel_carriere#hotmail.com
Added $ok parameter to CommitTrans($ok) for easy rollbacks.
Fixed odbc MetaColumns and MetaTables to save and restore $ADODB_FETCH_MODE.
Some odbc drivers did not call the base connection class constructor. Fixed.
Fixed regex for GetUpdateSQL() and GetInsertSQL() to support more legal character combinations.
Если кто не знает.
Кстати, вышла версия 2.0
2.00 13 May 2002
Added drivers informix72 for pre-7.3 versions, and oci805 for oracle 8.0.5, and postgres64 for postgresql 6.4 and earlier. The postgres and postgres7 drivers are now identical.
Interbase now partially supports ADODB_FETCH_BOTH, by defaulting to ASSOC mode.
Proper support for blobs in mssql. Also revised blob support code is base class. Now UpdateBlobFile() calls UpdateBlob() for consistency.
Added support for changed odbc_fetch_into api in php 4.2.0 with $conn->_has_stupid_odbc_fetch_api_change.
Fixed spelling of tablock locking hint in GenID( ) for mssql.
Added RowLock( ) to several databases, including oci8, informix, sybase, etc. Fixed where error in mssql RowLock().
Added sysDate and sysTimeStamp properties to most database drivers. These are the sql functions/constants for that database that return the current date and current timestamp, and are useful for portable inserts and updates.
Support for RecordCount() caused date handling in sybase and mssql to break. Fixed, thanks to Toni Tunkkari, by creating derived classes for ADORecordSet_array for both databases. Generalized using arrayClass property. Also to support RecordCount(), changed metatype handling for ado drivers. Now the type returned in FetchField is no longer a number, but the 1-char data type returned by MetaType. At the same time, fixed a lot of date handling. Now mssql support dmy and mdy date formats. Also speedups in sybase and mssql with preg_match and ^ in date/timestamp handling. Added support in sybase and mssql for 24 hour clock in timestamps (no AM/PM).
Extensive revisions to informix driver - thanks to Samuel CARRIERE samuel_carriere#hotmail.com
Added $ok parameter to CommitTrans($ok) for easy rollbacks.
Fixed odbc MetaColumns and MetaTables to save and restore $ADODB_FETCH_MODE.
Some odbc drivers did not call the base connection class constructor. Fixed.
Fixed regex for GetUpdateSQL() and GetInsertSQL() to support more legal character combinations.
Alex2003
Новичок
Вот и я дошел до этой проблемы...
Тема та же.
Есть Мускуль на FreeBsd.(сервер)
Есть еще одна машина, на которой хочу бекапиться(winNT).
Обе они во внутренней сетке. Хотелось бы дать доступ к Мускулю для компов из внутренней сетки.
Пробовал создать пользователя и указать ему - с каких хостов есть доступ... не получилось. Может в конфиге есть какая строчка?
Тема та же.
Есть Мускуль на FreeBsd.(сервер)
Есть еще одна машина, на которой хочу бекапиться(winNT).
Обе они во внутренней сетке. Хотелось бы дать доступ к Мускулю для компов из внутренней сетки.
Пробовал создать пользователя и указать ему - с каких хостов есть доступ... не получилось. Может в конфиге есть какая строчка?
