DB's With Microsoft Access
Is it possible to create database that comply with PHP in Microsoft Access?
View Complete Forum Thread with Replies
Related Forum Messages:
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.
View Replies !
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); ...
View Replies !
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.
View Replies !
Microsoft Access
I wanted to find out if any of you know the odbc equivalent to mysql_query I'm using a Microsoft Access DB and need to insert values into a table ex. mysql_query("insert into cart(cookieId, MaterialListID, qty) values('" . GetCartId() . "', $MaterialListID, $qty)");
View Replies !
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.
View Replies !
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:
View Replies !
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:
View Replies !
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.
View Replies !
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
View Replies !
Inserting Records Into A Microsoft Access Database...
I'm still new at using PHP although thanks to these forums I'm learning quite a lot. Currently, I am trying to insert a new record into my access database. I can display records from it but not add new ones. I know that I am to use the 'INSERT' SQL function but how would an Access Database be different from mySQL? So far I've seen only mysql examples and havent been able to find anything on access...
View Replies !
Microsoft SQL Connection
I am looking to have a php page that will have a required include of a config file with the MS SQL connection creation. I want to have a form that saves into a MS SQL database. Could call out to a stored procedure or have inline code in the php page. Anyone have examples or generic sample code I can use?
View Replies !
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.
View Replies !
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?
View Replies !
Php+microsoft Sql Opinion
I use php with my mysql database a lot. I just had something come up where I need to access data from a microsoft sql database. Are there many problems with connecting php with a microsoft sql database? Would I be better off to use something like visual basic with asp?
View Replies !
Microsoft Frontpage
Is it easy to incorporate php into a microsoft front page website. I find it extrememly easy to create beautiful looking websites with frontpage but i want to add dynamics with php to it is that possible.
View Replies !
Microsoft SQL Server
I installed on my machine Apache2, PHP 5, and Microsoft SQL Server 2005 EXPRESS Edition. The op.system is Win2000. The problem, I can't connect to the SQL server via PHP. The PHP works, the sql server works(can accept connection with MSDE Query), and uncommented the line in php.ini about mssql extension. I tried with PHP 4.4.1 also, but still not working. After that I installed the SQL Server 2005 (not the Express version, but the 180 days trial version) on another machine, allowed remote connection, and I can connect to it via php without any problems.
View Replies !
Microsoft Word
I have an interface which allows people to manage and add customers. Each customer also has a category, for example 'Builders' I need a way of being able to do a mail merge to all clients with a selected category which is initialised from the web interface. For example, at the moment I can connect to MySQL and get all customers and if I go slightly further I could create a filter to do just what I need from within word. However, I need to be able to have the user choose which category from within their browser then click a button and it automatically does this filter. I was thinking maybe somehow I could export all users in a category to a CSV file and then have a mail merge doc setup which automatically pulled data from this each time the document was loaded - this would be OK I suppose if a word file could be opened which automatically had the desired filter.
View Replies !
Microsoft SQL ORDER BY
I am having a problem, I need to ORDER BY a "Reference number" field in my MS SQL DB, The only problem is, it is a varchar as it contains ref#'s like 1a, 22b, 43c. Obviously, with a straight ORDER BY I get a sort like 1, 10, 11a, 11b, 2, 21, etc I tried "CAST(SUBSTRING(ref, 1, 2) AS Integer)", however the lengths of the strings are different, theirfor I will get an error, "Can't convert 8a" etc. Any ideas on how I can sort this properly?
View Replies !
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
View Replies !
Converting .doc Microsoft Word
I have searched this form for this but was not able to find a clear answer for this. Is it possible to convert Microsoft Word ( .doc ) files to any other manupulatable format like txt, XML, HTML etc. I came across a script from phpclassess.org for doing this but it requires dom which requires windows which is not feasible for developement envionment.
View Replies !
Mail From A Microsoft Server
I am writing a script for a Win2000 server, it needs to be able to send email, but the server doesn't have an email server on it, is there a sendmail or qmail for windows? does anybody have any suggestions on how to make this work?
View Replies !
Support For Microsoft Servers
Please let me know if any one knows if PHP supports following MS servers and tools for the development and what interface does that provide. Microsoft .NET Servers BizTalk Server Commerce Server Content Management Server Sharepoint Portal Server SQL Server Integration/ Messaging Tools SOAP (.NET) Microsoft Transaction Server (MTS) Microsoft Message Queue (MSMQ) XML Web Services Microsoft XML Core Services (MSXML) .NET Framework Reporting and Analytics SQL Reporting Services FRX Crystal Reports
View Replies !
Escaping Function For Microsoft SQL?
I mainly know MySQL, but I'm porting some of my code to work with MS SQL Server. I normally run mysql_real_escape_string() on certain fields, but there doesn't appear to be a direct parallel for MS SQL. Ideally there'd be a function that works on both, so I don't have to customize it. Suppose I could write my own, but is there a more-or-less canned way of doing it?
View Replies !
Install PHP On Microsoft 2000 Professional
how to install PHP onto my computer. It uses microsoft 2000 professional. I have downloaded one of the later versions of the source code from php.net, but I'm having trouble configuring it. I tried the automatic installer, but I think it needs to be done manually.
View Replies !
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; ?>
View Replies !
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 :(
View Replies !
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?
View Replies !
Mail Merge Microsoft Word PHP
I have a database with patients name and address and i would like to send them letters. I would like to, from the click of a button, use php to retrieve the names and addresses, open microsoft word template, use mail merge and print out the letters.
View Replies !
Use A Microsoft SQL Database Using PHP Compared To MySQL?
I have only ever used MySQL with PHP but have been asked by a cleint if I would be able to develop a website and import data from an existing database that is updated by bespoke software that they have purchased and runs on their desktop machines (but the database is on a remote server). I guess what I am asking is how easy is it to use a Microsoft SQL database using PHP compared to MySQL?
View Replies !
Manipulate Microsoft Word Documents
I'm looking for a way to upload a microsoft word document to my server and count the number of words in it. does anyone know of any classes that i could use? i looked on php classes but couldn't find anything that will work on a linux box.
View Replies !
How To Create Microsoft Office Documents
I would like to use php to view, edit, and create Microsoft office Documents such as .doc, .xls, and .ppt using only php. In addition I would like to open these documents within a web browser and not the program itself. I googled and this is the best site that offer the most information, http://web.informbank.com/articles/t...-documents.htm All of the code does run error proof, but some work for example creating a word document and it doesn't have the functionality I am looking for. If you have any suggestions or can direct me to a tutorial on this subject, it will be of great help and appreciation.
View Replies !
Any Quirks Moving Form PHP/*nix To PHP/Microsoft
I've got a fairly sophisticated link management script that I've written in PHP and only run on *nix boxes. One of my clients is going to be launching a number of new sites over the next few months, but all of them will need to be hosted on Windows based servers due to the coding used for the sites (.net/sql). I know PHP is fairly cross-platform compatible, but I'm curious of any quirks I might run into when moving. For instance, my script makes heavy use of PHP's mail function, but since I have almost zero experience with windows servers I have no clue if there will be modifications required to get everything to function properly. Anyone with any experience happen to have any suggestions on what I might need to look at etc?
View Replies !
Apache Set Up On Microsoft XP Home Edition
I'm trying to install php/mysql and apache server on my PC. It's operating system is Microsoft XP home edition. I've downloaded and installed the files and made some changes i.e. renamed a file to php.ini and added some lines to the httpd.conf file. However when I try to view php in http://localhost it's advising that the page cannot be displayed. Is this to do with browser settings? Has anyone come across any similar problems? If so what did you do to get around the problem?
View Replies !
Create Microsoft Word Document
If I have a page of text generated through php on a blank page, is it possible to have a "submit" button that when it's clicked the text from that page goes straight to Microsoft Word.
View Replies !
Microsoft Exchange Mail Server
I have successfully setup my php.ini file on a web server to communicate with my Microsoft Exchange Mail server, and can test the ability to send mail using the mail() function to internet mail addresses. (mailboxes on our network), However, when attempting to send mail to an outside address (ex: someone at gmail dot com) the mail() returns "failed". Here's my setup. Windows 2003 IIs 6.0 webserver Windows 2003 box running Exchange 2003 Is it a change I need to make to php.ini to allow mail to outside email domains? Is it a setting I need to change within Exchange.
View Replies !
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?
View Replies !
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.
View Replies !
LDAP Connect To The Microsoft Active Directory
I have been trying to connect to the Microsoft Active Directory in order to access user and user group information form authentication on one of my websites. When I execute the code below, I am able to connect but cannot bind. <?php $conn=ldap_connect("localhost") or die("Couldn't connect"); echo "Connect result is " . $conn . "<br />"; ldap_set_option($conn, LDAP_OPT_PROTOCOL_VERSION,3); ldap_set_option($conn, LDAP_OPT_REFERRALS,0); $bind=ldap_bind($conn,'sarfaraz','password') or die("Couldn't Bind"); echo "Bind result is " . $bind . "<br />"; ldap_close($ds); ?> RESULT: Connect result is Resource id #2 Couldn't Bind I am currently developing this website on my personal computer (xp home, apache 2, php 5, mysql 5). I enabled the LDAP module in the php.ini, added php to the windows PATH, added libeay32.dll and ssleay32.dll to the system32 folder and restarted apache and the computer.
View Replies !
ODBC Function Using Microsoft Excel Driver
I'm trying to write the data in excel using php odbc function. when i inserting the records the following errors appear. Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Excel Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in D:wampwwwextra ....
View Replies !
|
TRACKER
