Date: 08/24/06 (SQL Server)    Keywords: cms, crm, sql

При включении в домен компьютеров обнаружил неприятную особенность:
CRM-продукт использует BDE для доступа к MS SQL. Сервак, как я уже говорил, управляется Windows 2003 Server. Подозреваю, что проблема в том, что MS SQL Server никак не виден никаким продуктам, на это способным и для этого, собственно, предназначенным. Собственно, доходит до того, что на уже установленном MS SQL невозможно подключить регистрацию СБД. Никак не могу понять, где я что сделал не так.

Вкратце, параметры:
Windows 2003 Server PDC
MS SQL Server 2000 + SP2003

SQL-sever включен в Active Directory

Попытка установить коннект с включенной в домен клиентской машины. В ODBC вполне успешно прописан этот самый сервер. А вот BDE при попытке подключиться к серверу утверждает, что сервер не найден или не существует.

Какие могут быть пути решения проблемы?

Source: http://community.livejournal.com/sqlserver/51617.html

Date: 08/27/06 (Java Web)    Keywords: mysql, sql

Suddenly my Hard-disk & MySQL Server had gone read-only, thereby making this blog (because it is cached) and other sites inaccessible, including ssh access. Do you have any idea why this could have happened? A hard reboot rectified the error for now. But I am concerned about what caused this in the first place. Any ideas? Any [...]

Source: http://blog.taragana.com/index.php/archive/help-hard-disk-mysql-server-suddenly-read-only/

Date: 08/28/06 (Java Web)    Keywords: sql

Omid has discovered a vulnerability in Mambo & Joomla, which can be exploited by malicious users to conduct SQL injection attacks. Input passed to the “id” parameter when editing content isn’t properly sanitised before being used in a SQL query. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code. Successful exploitation requires “Editor” [...]

Source: http://blog.taragana.com/index.php/archive/mambo-joomla-sql-injection-vulnerability-discovered/

Date: 08/29/06 (PHP Community)    Keywords: php, software, database, sql, hosting

With their refusal to upgrade to php5 and let you install any kind of third party software they have effectively rendered themselves useless to me. With that said, does anyone know of any good hosting providers with ssh access? I'm wanting to use smarty, and play around with the Zend framework so I need php5. Also need some databases, I don't know if the free sql databases were just a godaddy thing or not, I hope not. thanks.

Source: http://community.livejournal.com/php/489542.html

Date: 08/29/06 (SQL Server)    Keywords: sql, hosting

How can I implement SQL Server Reporting Services in a shared hosting environment?

Source: http://community.livejournal.com/sqlserver/51812.html

Date: 08/29/06 (Web Development)    Keywords: php, mysql, software, database, sql, linux, hosting

I see that this forum recommends Dreamhost. How long have you been using it? Are they located in the U.S.? I don't know if the latter is necessary, but I guess if a host goes down and loses everyone's files, there could be a group law suit with some recovery. I don't know what to worry about the most, but I did go with a service once that suddenly disappeared. Luckily I had a techie who found the files still available somewhere and transferred them to another server for me.

I'm not a "techie". I'm also not a "designer" so if you check out my sites, please be kind on the critique of their appearance (search engine optimization and user-friendly access is my biggest concern).

I'm presently using a really cheap hosting service for one of my sites, 3ix. My son has used it for 2 yrs. with no problem. Has anyone here used them?

I have a site I need to move over to a server with Linux, MySQL, lots of database space available, lots of free software available, including PHP. 3ix offers a lot of software. Any suggestions would be appreciated.

Source: http://community.livejournal.com/webdev/350691.html

Date: 08/30/06 (MySQL Communtiy)    Keywords: mysql, sql

When I try to remotely connect to mysql, I'm getting the collowing error:

ERROR 2003: Can't connect to MySQL server on 'subdomain.domain.edu' (111)

As far as I can tell, "skip-networking" has been commented out in my.cnf -- a pound sign in the front means commented out, as far as I know. There is a /tmp/mysql.sock file, which should mean there's an available socket. I've compared my server against a test server I use, and the my.cnf files look pretty much identical.

The only different that I know of between my server at the test server is that the real server is behind a firewall, with packets being routed via snat. That might be my problem, because I can't seem to telnet to port 3306 from anywhere either.

Any help would be greatly appreciated. Thanks!

Source: http://community.livejournal.com/mysql/102128.html

Date: 08/31/06 (MySQL Communtiy)    Keywords: mysql, sql, web

      Hello, I just found the MySQL community and figured this could be an educational group to watch.  I am predominately a web developer 1st, and a DB scheme designer by necessity.  Otherwise I learned SQL on Access in 1999 then it took me 3-4 years to unlearn the MS way and now prefer MySQL.  So yeah, that's me.

Now my fun filled question:   Is there some sort of way to join 'SHOW TABLES' and 'SHOW FIELDS FROM' in a SQL query?  Maybe a multi-line query or such that is dynamic.  I've been rummaging through the MySQL reference manual and found nothing so far... though I did try the crazy idea of DESCRIBE (show tables); which was a long shot that did nothing.

Update:
Got this from beskov's comment.

SELECT table_name, column_name
FROM Information_Schema.columns;

And added WHERE to focus just on the DB I am interested in.

SELECT table_name, column_name
FROM Information_Schema.columns
WHERE table_schema = 'myDbName';

Source: http://community.livejournal.com/mysql/102165.html

Date: 09/02/06 (MySQL Communtiy)    Keywords: mysql, database, sql, hosting

Anyone know of a freeware tool to Synchronize a MySQL testing server on my machine, a MySQL remote server on my firm's server, and a MySQL client's server. Trick is that the database name's for each server is different according to each server's hosting scheme. Local has no prefix but the firm and client server's have prefix's. I have to do it in stages test->firm, test->client... that's fine because its better then nothing.

otherwise I am just going to write a script to try and transfer data between the servers with the testing server being the master of the others.

Source: http://community.livejournal.com/mysql/102449.html

Date: 09/06/06 (C Sharp)    Keywords: sql

Hi guys, me again.

Here's a stored procedure procedure

[SqlProcedure]
public static void GetLastAddressId()
{
string sqlString = "SELECT MAX(ADRID) FROM dbo.tblAddress";

SqlPipe sp = SqlContext.Pipe;
using (SqlConnection conn = new SqlConnection("context connection=true"))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.CommandText = sqlString;
string rdr = cmd.ExecuteScalar().ToString();
sp.Send(rdr);
}
}


Then, there is a TableAdapter with query which is set to return a Single Value.

Then, here is a place where I use that TableAdapter to get that maximum Id (inside some class):

public static string getLastAddressId()
{
DALTableAdapters.QueriesTableAdapter fs
= new DALTableAdapters.QueriesTableAdapter();

return (fs.GetLastAddressId()).ToString();
}


Why does the last line (the "return" line) give me an exception, saying that the referenced object doesn't exist? I'm sure I did something wrong with the stored procedure, as I never figured out how to send values like that from stored procedure to my program. Please, help.

Source: http://community.livejournal.com/csharp/75471.html

Date: 09/07/06 (SQL Server)    Keywords: sql

Hi all.
There is a strange problem I found. I upgraded SQL Server 2000 to 2005, I am a novice there. It seems that Views and inline functions do not support ORDER BY clause (The Select clause of a view may contain ORDER BY clause, but it seems to be ignored when running). More specifically, let dbo.Table1 be a table with columns ID, Name and a dbo.View1 created as:

CREATE dbo.View1
AS
SELECT TOP (100) PERCENT ID, Name
FROM dbo.Table1
ORDER BY Name

Then, if I run the query:

SELECT * FROM dbo.View1

it gives me no ordering (by [Name] field, neither in Management studio, neither in client applications (ADO 2.8 is used), while there WAS ordering in the same query results in MS SQL 2000. To get ordering, I must write again

SELECT * FROM dbo.View1 ORDER BY Name

What's wrong here? (I tried to find something in documentation, but could not find any useful things. The only essential note was that ORDER BY clause can't be used in views and inline function unless TOP attribute is specified in SELECT clause. But I knew that :-) ).

Source: http://community.livejournal.com/sqlserver/52104.html

Date: 09/07/06 (PHP Community)    Keywords: cms, php, css, sql, java, postgresql, web

My employers are in the process of opening up a PHP position in the DC area. The position in question is on a team responsible for developing sites, a CMS and other web tools for several magazines, some of which are relatively high-profile.

At present, I don't have any details regarding salary, etc -- but as far as I can tell, this would be a permanent position, and they do pay well, treat their employees well, and they are growing at what I think is a sustainable clip.

Skills I know we'll be looking for:
PHP (5+, some OO preferred, Zend Framework a plus)
PostgreSQL
CSS
Javascript (we'll be using the jQuery library)
DBA skills a big plus
Red Hat skills a plus

This is just a heads-up for the moment -- I'll put the actual job-posting here when it is approved, but for now if you're in the area and are looking for an opportunity, now would be a good time to dust off the old resume and update it.

Source: http://community.livejournal.com/php/493370.html

Date: 09/19/06 (Web Development)    Keywords: php, mysql, css, html, sql, java, web

Greetings to all,


Hello! I'm new to the WebDev community and was looking for a place to share my thoughts about web development. I'm into HTML and currently learning PHP and MySql. I can edit just about anything though :) (JavaScript, CSS whatever). I would like to make a web based game in PHP perhaps using a flash GUI. But not sure yet. Anyway thats about it just thought I'd introduce myself :)


Black Knight

Source: http://community.livejournal.com/webdev/353713.html

Date: 09/21/06 (MySQL Communtiy)    Keywords: php, mysql, database, sql

My laptop dual boots Windows XP and Ubuntu with a shared FAT32 drive they can both access. I'm working on a PHP project and ideally I would like both XP and Ubuntu to be able to access the same databases. Does anybody know if this is possible? ie, install MySQL on both OSes but somehow have them look on the shared drived for the actual database files? Any pointers / guides you guys could give me would be greatly appreciated!

Source: http://community.livejournal.com/mysql/103467.html

Date: 09/22/06 (PHP Community)    Keywords: php, css, sql, java, postgresql

A couple of weeks back, I posted about a possible job opening in the DC area -- well, that one has been filled already with someone already in the company. However, they are now posting a new 6-month contract position with about a 50% chance of becoming a permanent position at the end of the contract.

The position is at The Atlantic Media Company, which produces (among others) The National Journal, Atlantic Monthly and Government Executive magazines. The position in question would assist in fleshing out a next generation content management system, and integrate it into the workflow of the various publications. DC area applicants are preferred, but remote work is not out of the question. I won't kid you that the pace of the work is frantic, but I know there are some who thrive on high expectations -- if that's your thing, by all means apply.

Skills:
PHP (5+, some OO preferred, Zend Framework a plus)
PostgreSQL
CSS
Javascript (we'll be using the jQuery library)
DB admin skills a big plus
Red Hat skills a plus

Send resumes and salary requirements to ssweet@nationaljournal.com

Source: http://community.livejournal.com/php/496611.html

Date: 09/22/06 (Java Web)    Keywords: php, mysql, sql, linux, apache

I have started developing an interesting PHP application for LAMP (Linux-Apache-MySQL-PHP) stack. I have to say it has been an wonderful experience so far. It is rather simple (really simple) and easy to setup little frameworks (read utility functions in a file) in php for your tasks. PHP has a delicious array of functionalities to use. [...]

Source: http://blog.taragana.com/index.php/archive/thoughts-on-professional-php-development/

Date: 09/25/06 (PHP Development)    Keywords: php, mysql, xml, sql, web

В настоящий момент мы ищем ведущего web программиста c серьезным опытом и отличным знанием PHP 5, MySQL, XML/XSLT, ООП для участия в разработке и развитии web проекта, основаного на концепции web 2.0 - www.comby.com.

Что мы предлагаем?
Работа с технологиями нового поколения, по-настоящему дружный коллектив, а также достойный профессионала уровень оплаты труда позволят Вам в полной мере реализовать свой профессиональный потенциал*.
*Заработная плата от 2000$
**На постоянную работу, полный рабочий день.

Контактная информация:
E-mail: comby-personal@comby.com
Тел: (495) 245-63-70
Контактное лицо: Антон
________________________________________
Web Life - Интернет компания c многолетним опытом создания и развития Интернет проектов в области телекоммуникаций.
Основное направление деятельности в России– развитие и продвижение проектов www.comby.com  и www.comfi.com .

Source: http://community.livejournal.com/php_dev/72522.html

Date: 09/25/06 (MySQL Communtiy)    Keywords: mysql, database, sql

Hello,

I'm making a wallpaper database for my site, and I have two tables: wallpapers and wpartist. The wallpapers table holds all of the wallpaper info (obviously), while the wpartist table has the info on the artists who made the wallpapers. The two tables are JOINed by the artistid field.

Right now I'm able to show all wallpaper results, but I would like to also be able to show only a certain category, like a specific character. Is it possible to do that now that WHERE is being used by the joined tables? Here is the code I'm using now:

$result = mysql_query
("SELECT * FROM wallpapers, wpartist
WHERE wallpapers.artistid = wpartist.artistid
order by date desc");


I hope you guys can help! =)

Source: http://community.livejournal.com/mysql/104162.html

Date: 10/05/06 (WebDesign)    Keywords: php, html, sql

I've had it. I am sick of their downtime. I have php,SQL, html,and video and audio files that have to move to a new home.

Where should I go? I want solid uptime, none of this bullshit. Who can you really stand by for your paying clients?

Source: http://community.livejournal.com/webdesign/1173187.html

Date: 10/05/06 (MySQL Communtiy)    Keywords: mysql, sql, web, hosting

My current contractor has a number of websites that were developed by a whole lot of different people. Because of the NDA, I can't cut & paste the code involved, but has anyone heard of a Error # 30 when using MyIsam tables on a 4.1.x MySql server? I've ransacked the documentation trying to figure out what caused this because the current solution offered by the hosting company is unacceptable.

Some more specifics... the error was with a UPDATE that took a field value and set it to myField = myField + 1; It's been bothering me because I have the mysql source code and I've tried walking through the code to figure out where this phantom error code came from.

Source: http://community.livejournal.com/mysql/104322.html