PHP :: Microsoft SQL Connection

SQL Error: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters
I'm trying to execute the following SQL statement and get the following error.

SELECT DomainNames.DomainName FROM DomainNames WHERE DomainNames.DomainName Like "*ab*" ORDER BY DomainNames.DomainName

SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

I'm running PHP4, Apache 1.3.12 (Win32) and connecting to an Access database on a Win2K box.

Odbc_exec(): SQL Error: [Microsoft][ODBC Microsoft Access Driver]
i am trying to write to the database through odbc. i get the following error:

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:inetpubwwwroot514VIP_SurveyProcess.php on line 41

my directory has read/write permissions why am i getting this? here is the code as an example:
...
$x = 10;
$querySet = "UPDATE Survey SET $rdoOption = $x";
odbc_exec($objConn, $querySet);
...

PHP On Microsoft-IIS/6.0
Is it possible to make IIS parse .html files the same way as Apache does
with AddType application/x-httpd-php .html in .htaccess?

PHP With Microsoft Sharepoint ?
I would like to ask if I can synchronize Sharepoint Services with my PHP
website?

Hint: I think it can be done by XML as a bridge.. but I am not sure and
wanna be sure.

PHP And Microsoft Access
Is it possible to use php to interface with an ms access database?

Our current database (customers, suppliers etc) is in ms access format and we need to run msaccess. I dont feel like converting the whole database over to mysql and we still need the original system, the idea will be that the staff can access the database on the road thru a webpage.

PHP And Microsoft Word
I have users who can sent a Word document as an attachment to an email
from a Microsoft-rich environment. I would like to be able to
"capture" that attachment as a blob and deposit it into a mysql
database. I am not sure how to do the capture.

PHP To Microsoft Outlook
Is it possible to send meeting notifications to microsoft outlook through php? I guess it would be sort of an e-mail sent to an individual telling them they have been invited to attend an event and the event info is automatically added to thier outlook calender or something?

Exporting To Microsoft Access
I have a PHP website with a mySQL database and a client wants to be able to see the database on his computer using Microsoft Access.

I would like to be able to make a special backdoor section for him, where he enters his username and password and is given a link which will make take a snapshot of the mySQL database and convert it to a Microsoft Access database which he can download to his computer.

Is this possible?

Since he isn't very computer savvy I need a way as user friendly as possible to let him download the database and view on his local computer.

Microsoft Exchange Server
Do any of you know a free PHP script that does the same stuff as Microsoft
Exchange Server?

Microsoft SAPI Problem With PHP
As I've found tons of VB and C# sample codes, I was trying to transform

it into PHP code, using the COM objects. My aim is to create a simple
html, that creates a wav from a text. Here's what I've tried -the php
script part-:

$Voice = new COM("SAPI.SpVoice");//works
//com_load_typelib("SAPI.SpVoice"); //This doesn't help...
$Voice->Speak("Hello!"); //works

$FileStream = new COM("SAPI.SpFileStream"); //works - I mean no error
$FileMode = SpeechStreamFileMode.SSFMCreateForWrite;// = 3 //works -
no error
$FileStream->Open("c:a.wav", 3, false); //works - no error
$Voice->AllowAudioOutputFormatChangesOnNextSet = false; //works - no
error
$Voice->AudioOutputStream = $FileStream; //HERE'S THE PROBLEM

$Voice->Speak("Hello world",1);
$FileStream->Close();

Here's the error I get for that line:
Uncaught exception 'com_exception' with message 'Error [0x80020003]
Member not found

PHP Wrapper For Microsoft SAPI
I can not figure out the reason why this does not go past step 2, it will not go to 2a. Code:

Microsoft Access -> PhpMyAdmin
Alright, so what’s going on is that I have coded an entire website with in mind to have an Access Database. So everything works great...

But now I am faced with the problem that I have to have my webpage work with phpMyAdmin, which works completely differently in running my sql statements and everything, ie: ->EOF, select statement, etc...

Is there a way for me to have a smooth transition for my code to work with phpMyAdmin instead of Access at the moment, because recoding all of this means an enormous amount of work with not much free time left on my hands. Code:

Microsoft Word Formatter
Anyone know of some sort of php script that can read and format Microsoft word documents?

PHP / Microsoft SQL V7/2000 - Page Results
Anyone know a simple way to page results of a SQL Select using Microsoft SQL ? I don't believe they have anything as handy as MySQL LIMIT.

Parse Error For Microsoft.XMLHTTP
I want the following ASP code to be rewritten in PHP:

<%
Set xml = Server.CreateObject("Microsoft.XMLHTTP")
xml.Open "GET", "http://www.mydomain.com", False
xml.Send
Response.Write(xml.responseText)
%>

I tried myself with ASP2PHP conversion tool. The following code was generated. But does not work. I get a parse error. Please help!

<?PHP
$xml->Open "GET" "http://www.mydomain.com" $False;
$xml->Send;
echo $xml->responseText;
?>

How To Embed Microsoft Word In A Page Using Php
how to embed or open microsoft word file in a page using php script

Any Ideas How To Run Macro In Microsoft Publisher Through PHP COM ?
my macro in Publisher changes "123" into "321" (example)
but I can't be able to run it.
This is how far I get throught with PHP & Publisher:

<?
$pub = new COM('publisher.application') or die('Unable to load
Publisher');
print "Loaded Publisher, version {$word->Version}
";

$pub->Open('xxx.pub');

$pub->Documents[1]->SaveAs('xxx2.pub');

$pub = null;

?>

this works, but of course does not do anything else than open xxx.pub
and save it as xxx2.pub. I am trying to run my macro:

$pub->Documents[1]->RunMacro(replaceme);

where replaceme is my macro. I tried different variations:

$pub->Documents[1]->Run(replaceme);
$pub->Documents[1]->Application->Run(replaceme),

etc but no luck so far :(

Microsoft Access Dropdown List
l am building a new site using PHP which has a lot of pages pulling from an Access Database. I would like to have a dropdown list that pulls exhibitions from the database and then when the user selects one it shows the rest of the details from DB just below the dropdown list, hope that makes sense. Code:

Reading Microsoft Office Documents?
I need to be able to upload a Microsoft office document and then show the contents to the visitor, in addition i need to be able to write documents on the fly.

Is there a way of doing this, or will i have to spend days researching and programming my own classes to handle it?

PHP Will Not Read More Than 4096 From My Microsoft Sql Text Field.
I have a textarea that is saving to a mssql text (very large) field. The insert, update is working fine. However, when php reads the data using mssql_result function, I'm getting limited to 4096 characters read by php. I know that there are at least 6000 characters and I can see them using microsoft's query analyzer. This is not a magic quotes, single quote, quote, html entity or anthing like that. PHP will not read more than 4096 from my microsoft sql text field. Any ideas how I can get php to read more?

Insert Into Microsoft Access Table Using ODBC
The following lines of code don't return an error but they also do not insert the row into the database:

$SQLText="Insert into member (MailingID, MemberID, [File As], EMail, LetterID, AudienceID, DateSent, Sent) Select $MailingCode, $row[0], '".$row[5]."', '".$row[6]."', $LIDToInsert, $AIDToInsert, '".$DateSent."', 1;";

print '<br>'.$SQLText;

$rs_upd=odbc_exec($link, $SQLText);

if (!$rs_upd) die("Couldn't update database");

I've tested the resulting $SQLText string in Access directly and it works find there so this must be a PHP or ODBC issue.

Microsoft JET Database Engine Error '80040e10'
I am new to ASP, I am trying to create a page using ASP that will read from a database and write to my page, but I get this error every time: Microsoft JET Database Engine error ?e10' No value given for one or more required parameters.

Microsoft And Zend Announce Collaboration To Enhance PHP On IIS
Microsoft's Product Unit Manager for Internet Information Services
(IIS), announced a new collaboration with Zend to improve
performance and stability of PHP on Windows.
This isn't just vaporware, either. During Andi Gutmans' keynote
(Andi is one of the creators of PHP and co-founder of Zend), Bill
announced the availability of a technical preview release of FastCGI
for IIS and demoed it for the audience as well.
FastCGI is a new component for Microsoft's Web server platform that
is available for download & evaluation today. It works IIS 6.0 in
Windows 2003 Server and IIS 5.1 in Windows XP. Even cooler, it also
works with the brand new IIS 7.0 making its debut with Windows Vista
and, later, as part of Windows Server code-named "Longhorn."
This announcement continues to solidfy IIS as the premiere Web
application server whether you are developing sites with ASP.NET or
any other server framework. Moreover, regardless of the programming
language or framework they choose, developers building sites of any
size can leverage the full capabilities of the Microsoft platform
with enterprise-class security, speed and stability.

Inserting A Date Into A Microsoft Access 97 Database
I was wondering if anyone could help me insert a short date into microsoft access 97 using php? i can insert text no problem but i can't seem to be able to insert a date properly. i have been using

//$date = "#" . "$sqlmonth" . "1" . "$cboyear" . "#";

$strSQL = "INSERT INTO tblSupport (tDate) VALUES ($date)";
$result = odbc_exec($connect, $strSQL);

Note: i can insert a date if i hard code it like putting in #01

Warning: SQL Error: [Microsoft][ODBC Driver Manager]
Cannot get an ODBC (or MSSQL) connection to MS Sql Server 7. Using a system datasource and it connects fine, but PHP does not like it. I've had no problem with NT4 but Win2K is another story...

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:inetpubwwwrootindex.php on line 8

Can I Convert MySQL Db Records Into Microsoft Word Documents?
i found the solution to export
file from mysql db into *.csv. but is there anyway to convert the
contents into *.doc and save in my webserver and providing a link for
the end users to download the word file?

FYI, the database records are obtained by end users submitting the
forms themselve and i saved it in my db...

DB Connection Handling - I Get "too Many Connection" - What's The Solution?
I have a php-webpage that needs the database in the beginning and in
the end of the script. In the middle there is a lot of processing that
takes several seconds - during that time I don't use the database
connection.

What is the best approach? Should I close the connection after I'm
done with it OR should I reuse the connection thru my whole script?

Where can I read more about this? Any pointers?

Today I'm using the same connection thru my script. And sometimes I
get an error from the database "too many connections". What does that
mean? My webserver provider says that I have at least 100 connections
to play with. How come I get this error?

PHP Equivalent For Server.CreateObject("Microsoft.XMLHTTP") In ASP
I'm new to PHP, so I'm trying to figure out how to do things that I used to do in ASP.

One of those things is getting data from another web page, server-side.

In ASP, I'd do this:

Set objXML = Server.CreateObject("Microsoft.XMLHTTP")
objXML.open "GET", strURL, False
objXML.send()

I could then use regexp to pull out data from objXML.responseText.

How can I do the same thing in PHP?

Raw SSL Connection
I need to send (not post, just send) some string to an SSL server. This is nog a SSL enabled webserver, but a pure SSL-server wich doensn't understand HTTP. Therefor I think I need to make a SSL socket connection and fwrite() the string to the socket. The SSL-server performs certificate authorisation, so I need to send my certificate and private key with the string.
As far as I understand, PHP can't to this so I need to perform the ssl handshake myself with some openssl functions, then ssl encrypt the string with another openssl function, send it to the socket... read the response, decrypt it, and process this further?

Does anyone have a clue how to do this?
cURL is not an option since cURL, as far as I know, only talks HTTP over a wide range of protocols.

I've been messing with 'openssl s_client' but after the SSL handshaking completes the connection is closed and I am unable to send a message.

Php Sql Connection
i get this error when trying to use php to add something into the database, i thought Php wasnt compiled correctly but i am using phpMyAdmin so surely that uses mysql_connect!! and that works fine. I am using a cobalt raq4 if that has anything to do with it!
Error i get!

Fatal error: Call to undefined function: mysql_connect() in /home/sites/site20/web/vb/confadd.php on line 2 Code:

<?php
mysql_connect ('localhost','username','password');
mysql_select_db ('database');
$result=mysql_query("INSERT INTO table (accesscode,referee,username,password) VALUES ('$accesscode','$referee','$newuser','$password')");
echo ("User has been added");?>

Which Connection Is Best?
I started with php and mysql and i discovered three methods for connecting
to a database:

$conn="DRIVER={MySQL ODBC 3.51 DRIVER};SERVER=10.0.0.181;DATABASE=reserv";
$connect=odbc_connect($conn,'root','pw');

include('/inetpub/wwwroot/resphpaccess/adodb/adodb.inc.php');
$db = &ADONewConnection('mysql');
$db->Connect('localhost', 'root', 'pw', 'reserv');

$link = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Impossible de se connecter : " . mysql_error());

Which one is the best and why?
What are the pro/contras for each?

Connection To An Outside Db
Can we connect to a database(mySQL) using php, on another site. IE: siteOne.co.uk runs some script that can connect to siteTwo.co.uk mysql database, therefore looking as its got is own etc? Any ideas or a straight NO.

I did mention about running a php to xml page that reads the db and converts it to an xml page and then it can get the data from there with absolute path etc ?

Database Connection ?
I am very new to PHP...Can i get the starting code for connecting to database....how to open the connection...what is the connectionstring ?

Oracle Connection
I am running a PHP script on unix. I am trying to connect to Oracle database. Before i start using the functions like Ora_Logon etc, what steps do i have to take in order to make PHP talk to Oracle database?

I Need A Universal Connection
I am interested in developing a web application to which I can attach any of db
like mysql,access,sql server,oracle ... as it is there in most of projects where during the installation we select any of optional db.

how to write such a code which can work with all of databases.

Db Connection Issues
The pages I have are template driven and they seem to work until I try and connect to the MySql db - then the pages don't want to display properly. I am sure it is some error in the way I am coding it. code:

Connection Errors ?
host -{ The server }- is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

anyone know why this message show up allot of times and goes away only after restarting mysql and apache ? is there a other way if fixing this ?

Authorize.net AIM Connection
Has anyone else connected using the AIM method yet? Code snippets would help me see the error of my ways.

SQL Anywhere 5.5 Odbc Connection
Is possible connect to database SQL Anywhere 5.5 started by
rtdsk50.exe from php using odbc?

I have error : Unable to connect to database server: unable to start
database engine, SQL state 08001.

I can connect to database using the same data source from MS Access.

Best Way To Set DB Connection Settings
I was wondering what is the best way to code the DB connection settings, by settings I mean the username/password and DB name. Right now I'm doing it in every php file that talks to the MySQL DB, but I think it may not be a good idea. How do you guys do it? like call it from a central file or something?

Remote DSN Connection
I am trying to set up a website to connect to an SQL Anywhere database located on a remote machine.

The webserver is located on a linux server, while the database is running on a windows machine on the local network.

How can I connect to this remote database, and what ports will I have to enable access to through the firewall?

Connection Pooling In PHP?
Is that when using pconnect to mysql, it is already mean connection
pooling?

Open Db Connection
I'm trying to close unnecessary db connection to reduce the concurrent
connection. Is there any way I can find the open connection?

PHP SSH And Mysql Connection
For a long time I've been trying to connect to mysql through a SSH tunnel. Although that si possible by setting up the tunnel manually (with 'ssh -L ...'), I'd like it to be done by PHP itself.

Now, with the SSH2 extension (http://www.php.net/manual/en/ref.ssh2.php) it is possible to issue a 'ssh2_connect' and then a 'ssh2_tunnel' command.
That returns a socket resource to the destination server.
So far, all fine.

Problem:
How can I force that socket onto 'mysql_connect'?
I mean, what I have is:
$tunnel = ssh2_tunnel($connection, ཆ.0.0.101', 12345);

But $tunnel is a PHP resource, and not in the format ':/path/to/socket' that mysql_connect expects...

Is this possible at all?

Sybase Connection
This is the first time I need to connect via PHP to a Sybase DB.
I'm working with PHP5 and Apache 2 under WinXP... no problem
connecting with Mysql...
I enabled in php.ini the correct dll: "php_sybase_ct.dll" but when I
restart Apache got this error:

PHP Startup: Unable to load dynamic library 'c:phpphp_sybase_ct.dll'
- Can't find the specified module

I read that the library needs Sybase DLL: on my PC I installed the
whole Sybase SQL Studio 8 (it works fine) but no result... the
php_sybase_ct.dll is in the same dir as the other DLLs (c:php) and
Sybase is in c:programssybase...

JDBC Connection
Can PHP connect via JDBC?

Connection Pool
Is anyone aware of a means of connection pooling (to MySQL, say) in php?

Database Connection
<?php

I have a question about 2 connection strings to a ms sql database.

# TEST DATABASE

$connecttest = MSSQL_CONNECT("TEST", "sa", "123456") or exit("Unable to
connect to MS SQL Server at 10.0.10.58");

$select = mssql_select_db ("database1",$connecttest) or exit("Unable to
select database TEST");

# PRODUCTION DATABASE

$connectprod = MSSQL_CONNECT("PROD", "sa", "654321") or exit("Unable to
connect to database at 10.0.10.59");

$select = mssql_select_db ("database2",$connectprod) or exit("Unable to
select database PROD");

$SQL = "SELECT * FROM table1";

$RESULT = mssql_query($SQL);

// What data will i find here? Is it data from the TEST or from PROD and
will it be data from database1 or from database 2?

?>