Hane you tried
$result = mssql_query(EXEC getSomeCoolData '061451221', NULL, NULL );
Also, did you try mssql_init()?
-- bob
On Wed, 4 Jan 2006, meska wrote:
Hi,
I've done it in various ways, still, no luck..
Lets say i have a stored procedure getSomeCoolData declared as :
Using COMMIT is only required if you issued a BEGIN TRANS before your
INSERTs, UPDATEs and / or DELETEs. All transactions are automatically
committed if you don't use BEGIN TRANS. Are you backing up the
transaction logs regularly?
-- bob
On Fri, 16 Dec 2005, Alex Gemmell wrote:
Hello people,
Do you have the truncate log on checkpoint option enabled? Also, if you
want to reduce the size of the log file if shrinking doesn't work, try
running the following against the database. Of course, you should backup
the DB first.
SET NOCOUNT ON
DECLARE @LogicalFileName sysname,
I don't think this is an issue with an old vs new ntwdblib.lib. The reason
is because I don't belieeve there is a new ntwdblib.lib. Microsoft has
not made any changes to this library since SQL Server 6.5. Therefore, the
problem lies in the PHP 4.4.0 source code for the mssql extension.
-- bob
Then, is it safe to assume that you can run stored procedures and queries
that don't use a remote linked server? Fundamentally, I don't know why
PHP would be the problem, since the remote link is established within the
stored procedure. To make sure that it is not a problem with the mssql
Assuming you always connect to the server using the exact parameter values
for odbc_connect(), this does not look like an easy one to solve. I also
connect to a Sybase database on a Win2K server from PHP/Apache/Solaris.
However, I don't use the odbc extension. I use the odbtp extension, which
You have 3 options.
Option 1: Use PHP's native odbc extension. This option is limited, and
only works on @in32 platforms.
Option 3: Use PHP's COM support. This option only works on @In32
platforms, and does not follow the function paradigm of PHP's database
extensions. Example code:
Try odbtp, http://odbtp.sourceforge.net.
-- bob
On Fri, 15 Oct 2004, Swapan Mazumdar wrote:
Hi All,
I am quite new to php. I have a requirement to query dbase file to
implement searching on table columns. Now I am following a basic
approach using dbase_get_record_with_names($fileHandler,
ADODB is a PHP abstraction layer class. In other words it hides the fact
that it is using the odbc extension to connect to Access. And, it has
another driver that uses the COM extension to connect to Accesss
(ado_access).
Basically there are only 3 options for connecting to Access from PHP. They
, thanks again Bob, input is goood.
-TG
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, October 01, 2004 2:27 PM
To: Gryffyn, Trevor
Cc: [EMAIL PROTECTED]; Matt M.; Matthew Perry
Subject: RE: [PHP-DB] microsoft access
ADODB is a PHP abstraction
On Thu, 16 Sep 2004, Petrus Ali Saputra wrote:
John Holmes wrote:
Petrus Ali Saputra wrote:
Petrus Ali Saputra wrote:
Is there anyone here can tell me how to access Matisse DB? Thank you.
Isn't there anyone can help me?
ODBC?
Yes, but it will lower the ability of
Hi Brian
Why don't you just avoid using sybace_pconnect() with transactions?
I use ODBTP to connect to SQL Server and Sybase databases, and this is not
an issue. The reason is because ODBTP involves the use of a mediating
service that pools all connections, and automatically rollbacks
HI Bozhan
When you append the FOR XML clause at the end of a query, the xml data
will be sent in a single column result set. The column's type is ntext,
which is not easily handled by FreeTDS and PHP. The reason is because it
is UC2-2 encoded UNICODE text. UNICODE text is easier to deal with if
The reason is because the buffer used by the odbc extension to store field
names is only 32 bytes. You can try using the sybase or odbtp extension.
Otherwise, you will have to submit it as a bug, so that it will be fixed.
-- bob
On Thu, 9 Sep 2004, Anthony Robins wrote:
When retrieving ODBC
If HAVE_SQL_EXTENDED_FETCH is defined, then the odbc ext will use the
ODBC API function SQLExtendedFetch instead of SQLFetch to retrieve
records. SQLExtendedFetch is only necessary if a forward-only cursor is
not being used. In the case of the odbc ext, it uses a dynamic cursor if
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So far, ODBTP
performs quite well with IBM DB2 in regards to regular queries.
-- bob
--
The odbtp extension has be used quite successfully with DB2. You can get
it at http://odbtp.sourceforge.net. I have not personnally used it with
DB2, but there are posts on odbtp's help forum pertaining to DB2.
-- bob
On Tue, 3 Aug 2004, Javier Mestre wrote:
Any example how to use CLOB,BLOB
Assuming your PHP script is located on a Win32 server, you will have to
run the web server under a user account that has permission to access the
remote drive. You then have to reference the MS Access database by its
UNC path.
-- bob
On Mon, 2 Aug 2004, Paul Kain wrote:
I am aware that theres
You will have much better results if you use the odbtp extension instead
of the odbc extenstion, especially on Linux. The odbtp_field_type()
function will give you the correct type name.
Also, you could use the mssql extension. However, mssql_field_type()
returns type names that are not exact.
abstraction and I can't change all the ADOdb code.
Do you know why the function odbc_field_type don't give me the good result
?
Is is a PHP error, an unixODBC error or a freeTDS error ?
To acces to MsSqlServer, which ODBC connection do you prefer ?
thx to help me
Jeff
Robert Twitty [EMAIL
If this is the problem, then you should try the odbtp/mssql hybrid
extension, php_odbtp_mssql.dll. It is thread-safe, and is available at
http://odbtp.sourceforge.net.
-- bob
On Fri, 2 Jul 2004, Frank M. Kromann wrote:
That depends on the SAPI you are using. With CGI or FastCGI there is no
If you are using odbtp as a driver for the mssql ext, and want
mssql_field_type() to return the actual type name, then call
odbtp_set_attr( ODB_ATTR_FULLCOLINFO, 1 );
before you run any queries.
-- bob
On Thu, 3 Jun 2004, Frank M. Kromann wrote:
mssql_field_type() is the function for that.
FYI for the members of this list that are using ODBTP:
Version 1.1.1 has been released, and is available for download at
http://odbtp.sourceforge.net
Key Changes:
* All version 1.1 known bugs have been fixed.
* Data truncation detection.
* Auto char to wide char mapping for MS Access in UNICODE
Hi
I am not aware of a website that talks about cursors. However, I do know
that they should be avoided whenever possible. They tend to require a lot
of resources. I mostly use them in stored procedures when I need to loop
through a result set. If you like, I can provide you with MS SQL Server
It appears that you want to extend DB_coomon not DB. The reason is because
$dbh = MyDB::connect( $dsn );
returns an instance of the DB_common class. However, DB_common is the base
class for writing a PEAR DB driver class. And, what is really returned by
DB::connect() is an instance of the
On Wed, 12 May 2004, Alex Gemmell wrote:
Hello all,
I am fairly new to Linux/PHP so please bear with me. I have an awfully
awkward problem to solve - a stop gap solution for the next 6 months until
we have out in-house servers set up and running. I also have a very short
timeframe to sort
Hi Alex
ADODb will not work either. ADODb is basically a PHP abstraction class
library that relies on lower level database extensions to connect to the
various databases. The problem for you is that other than the odbc
extension combined with MDBTools, and the odbtp extension, there is no
other
If you are able to place the Access database on a Windows machine that can
be accessed by the Linux machine, then you can use odbtp. You can get it
at http://odbtp.sourceforge.net.
-- bob
On Wed, 5 May 2004 [EMAIL PROTECTED] wrote:
Hi,
I try to configure a web server under Debian/GNU/Linux
If you are able to place the Access database on a Windows machine that can
be accessed by the Linux machine, then you can use odbtp. You can get it
at http://odbtp.sourceforge.net.
-- bob
My problem is i can't modify my PHP code. Actually the web site runs on a
windows2000
On Wed, 14 Apr 2004, Matt Matijevich wrote:
[snip]
[/snip]
Thanks for the response.
If I was hitting the memory limit, wouldn't php throw me some kind of
error? Or would it just abort?
It's normally the job of the extesion to report the error. But, I am not
completely sure because I have
Hi Matt
Before sending the result set, the mssql extension stores the entire
result set into memory. However, PHP limits the amount of memory that
can be allocated by a script to 8MB. So, the query will fail if the
result set is larger than 8MB. You can change this value in php.ini with
the
A question pertaining to this topic was posted in another forum. I have
included the answer here for those who have to deal with this issue.
Unlike MS SQL Server 7.0/2000, MS Access 2000 does not use separate types
for non-UNICODE and UNICODE text data. Instead, ALL text data is stored as
for it. Security and
convenience are often strange bedfellows, and don't always get along.
You are correct in the IIS supports SSO.
david
Robert Twitty [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi David
Based on the amount of users accessing the site, there is a possibitity
Hi David
Do these few queries ALWAYS fail, or just occasinally fail? Is this
intranet site used by many people? If the same query always fails, you
can determine if it may be a thread-safe issue by running that query
outside of Apache as follows:
c:\php\php thequery.php
If the above fails,
on solution: we won't go into the is that a good idea question,
because it is moot, and I came out on the losing end); apparently I can't do
this with Apache 2 and Windows, and so, long story short, perhaps I should
consider other web server options.
Thanks, Bob!
david
Robert Twitty [EMAIL
You will need to install and configure the FreeTDS library. Another
alternative is to use ODBTP, which is available at
http://odbtp.sourceforge.net. It is much easier to
install and configure than FreeTDS, and supports all of the mssql_*
functions. However, ODBTP requires a WIn32 service to be
What type of field is PhaseFK?
-- bob
On Wed, 17 Mar 2004, david wrote:
Hello there!
I have just about driven myself crazy with an odd intermittent problem.
I have an intranet site, a good size one at that, on a Windows 2000 Server,
running Apache, connecting to another Windows 2000
as well.
Thanks!
david
Robert Twitty [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What type of field is PhaseFK?
-- bob
On Wed, 17 Mar 2004, david wrote:
Hello there!
I have just about driven myself crazy with an odd intermittent problem.
I have
Hi Mark
An alternative solution for connecting to MS Access is odbtp. Details are
available at http://odbtp.sourceforge.net. It provides better support for
ODBC, especially in regards to MS Access. Take a look at the
storedqry.php example at http://odbtp.sourceforge.net/examples.html. It
Is the machine running SQL Server also hosted by the same company? Is it
possible to use PHP on a Win32 machine so that you can use
the php_mssql.dll extension?
-- bob
On Fri, 12 Mar 2004, S K Rana wrote:
My domain is hosting through a hosting company on Linux with PHP 4.3.4.
Hosting
Hi Pascal
The odbc extension uses ODBC 2, while Access and Pervasive are most likely
using ODBC 3. This may or may not be the cause of your problem. Try using
the odbtp extension at http://odbtp.sourceforge.net. It uses ODBC 3, and
may give you better results.
-- bob
On Wed, 25 Feb 2004,
context' message? Do you know for sure that ODBTP handles that
correctly?
Thanks.
Michael
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 5:38 PM
To: Michael Flanagan
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MS SQL
Hi John
I have never used MSDE, but from my understanding if is suppose to behave
like SQL Server. When you installed it, did it mention anything about
whether or not TCP/IP connectivity should be supported? You may need to
ensure that the server is communicating over port 1433. If you are
)) {
$errorString .= $result-getMessage() .
$result-getDebugInfo ();
return FALSE;
}
return $result;
}
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 22, 2004 2:49 PM
To: Michael Flanagan
Cc: Php-Db
Subject: RE: [PHP-DB] MS
Hi Michael
You might get better results using the odbtp extension with support for
the mssql functions. Since you are using Windows, use
php_odbtp_mssql.dll instead of php_mssql.dll.
-- bob
On Thu, 19 Feb 2004, Michael Flanagan wrote:
Adam, Thanks for the suggestions. I don't want to ignore
with the 'Changed database
context' message? Do you know for sure that ODBTP handles that correctly?
Thanks.
Michael
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 5:38 PM
To: Michael Flanagan
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB
Your query resource was detached from the connection. Can you supply the
code prior to calling odbtp_fetch_row() and starting from odbtp_query()?
-- bob
On Tue, 17 Feb 2004, Sascha Kaufmann wrote:
l
Hello everyone
I try to port an application from Windows/ODBC to Linux/ODBTP, I have a
MSSQL
You cannot use the odbc mssql extensions to read nvarchar ntext
fields. You will have to use the odbtp extension located at
http://odbtp.sourceforge.net. It provides support for UNICODE data.
-- bob
On Fri, 13 Feb 2004, Juan Torres wrote:
Hello,
I have a connectoin ODBC with a SQL Server
Server 2000.
-- bob
On Fri, 13 Feb 2004, Alain [iso-8859-15] Barthélemy wrote:
Le jeudi 12 février 2004, 10:04:12 ou environ Robert Twitty [EMAIL PROTECTED] a
écrit:
Hi Alain
Documentation is just to manage and understand odbtp_set_attr(...) and so on
Documentation for all
Use the odbtp extension. It provides the best, easiest and maybe
only support for SQL Server's UNICODE data fields within PHP.
-- bob
On Fri, 13 Feb 2004, Juan Torres wrote:
How can I read from a SQL Server DB, a field of type 'nvarchar'. This field
contais japanese characters.
thanks!
Most of the PHP solutions I have seeen require the use of session
variables. You could create an array containing only the unique
identifiers of all the records, and then store it into a session variable.
You would then use another session variable to retain the page size, and
then include the
: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 12:34 PM
To: Karen Resplendo
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Paging large recordsets
Most of the PHP solutions I have seeen require the use of session
variables. You could create an array containing only
For MSSQL databases use the following syntax for executing a stored
procedure:
mssql_query( EXEC sp_name param1, param2, param3, ... );
Another alternative is to use the mssql_init(), mssql_bind()
mssql_execute() functions.
Also, better support for executing MS-SQL stored procedures is
ODBC is the only way that I am aware of for connecting to a Lotus Notes
database via PHP.
-- bob
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
I did a search on Google, and turned up a few links, but they all seemed
to be on about mail databases...
however, I need to talk to other
Unless I am mistaken, but isn't it possible to build the sybases extension
using the Sybase client library and not FreeTDS?
-- bob
On Wed, 11 Feb 2004, Alan Chan wrote:
Hi,
I found that there is a problem in the version compatibility between our
Sybase server and PHP/apache server. PHP can
If you are going to use a Notes database over the web, the easiest way to
do this is with the Lomino Web Servwer.
-- bob
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
Sadly, no...
I'm totaly new to Notes, and all I know is...
1. There is a databse, that stores our events
2. I need to
A better solution for connecting to SQL Server is the php_odbtp_mssql.dll
extension available at http://odbtp.sourceforge.net. The reason why is
because the php_mssql.dll was built using DB-Library, which is obsolete
and unsupported by Microsoft. This is why ntwdblib.dll is not in MDAC,
and
You can use ODBTP (http://odbtp.sourceforge.net) to connect to it using
MS's ODBC driver for Excel.
-- bob
On Fri, 6 Feb 2004, Griffiths, Daniel wrote:
I dont know any way to actually open and read the file with php, havent come across
any classes or methods that will do this.
My solution
ODBTP version 1.1 has been released is available at
http://odbtp.sourceforge.net
Many new functions and enhancements have been added to the odbtp
extension. The changes make it the best PHP solutiion for connecting to
MSSQL, Access, FoxPro and other Win32 ODBC accessible databases from any
.
Robert Twitty wrote:
The date() is for use with the 32-bit C time value returned by functions
like time(). Data from fields of type datetime are returned as strings in
the form Jan 9 2004 by the mssql extension as the default. To return it
using ISO format set mssql.datetimeconvert
The date() is for use with the 32-bit C time value returned by functions
like time(). Data from fields of type datetime are returned as strings in
the form Jan 9 2004 by the mssql extension as the default. To return it
using ISO format set mssql.datetimeconvert to On in the php.ini file, or
use
mssql_pconnect() may add to problem of too many connections. The reason
is because the persistent connection is associated with the Apache child
process and not the script. This is significant because you are not
guaranteed to be served by the same child everytime the script is invoked.
Thus,
Maybe you are running out of connections.
-- bob
On Wed, 21 Jan 2004, Stuart wrote:
I have a site that makes heavy use of a local SQL Server database. Every
6-12 hours the site continuously reports not being able to connect to
the database. That is the only info in the warning that's given.
You may need to set mssql.textlimit to a value greater than the default of
4096 characters.
-- bob
On Wed, 21 Jan 2004, Michael Lewis wrote:
John,
I'm getting much more than 255 characters. The field is not varchar but a
text field. I've looked into FREETDS as the most likely source of the
Use mssql_bind
-- bob
On Mon, 5 Jan 2004, Filipe Girafa wrote:
Hi,
how do i pass the arguments to the db when using the mssql_execute function?
thanks,
Filipe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is anyone using MS Access, FoxPro or any other file-based database via
ODBC with PHP?
-- bob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
To the best of my knowledge you cannot access an Access database directly
from UNIX or Linux. The reason is because the Jet Engine has not been
ported to those platforms. Your only options may be something
like EasySoft's ODBC-ODBC bridge or ODBTP.
-- bob
On Wed, 19 Nov 2003, Luke van Blerk
Setting SourceDB=c:\telefonia\; instead of
SourceDB=c:\telefonia\CDTCTL01.DBF; solved the problem.
-- bob
Warning: [S1000][1][Microsoft][ODBC Visual FoxPro Driver]Fox Error 1
[IM006][0][Microsoft][Administrador de controladores ODBC] Error de
SQLSetConnectAttr del controlador in
Take a look at ODBTP, which is located at http://odbtp.sourceforge.net.
ODBTP allows you to remotely connect to Win32-based ODBC from any machine,
including Linux/UNIX.
-- bob
On Wed, 15 Oct 2003, Ricardo C. Fernandez de C. wrote:
Hi,
The sad part is that there is 0 documentation about how to
You should use the mssql extension for this purpose. Another alternative
is odbtp.
-- bob
On Thu, 9 Oct 2003, rick rice wrote:
What do I need and where can I get it?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database
You cannot use FreeTDS to connect to an Access database. You also cannot
use odbc on Linux either. The only way to connect to an Access database
from Linux is with something like EasySoft's ODBC-ODBC bridge or ODBTP.
-- bob
On Thu, 11 Sep 2003, nabil wrote:
Yes , and I done myself to mssql
Yes
You cannot read varchar(255) data fields.
You cannot easily read ntext and nvarchar (UNICODE) fields.
No direct support for stored procedures.
-- bob
On Mon, 1 Sep 2003, Arnaud L wrote:
Hi,
We have migrate our SQL server to MSSQL2000.
Since this migration, we can't connect to MSSQL
is running on Linux. I am trying to retrieve simple data such as
text and numbers.
I am not sure what the TDS protocol setting should be. What are the typical
settings and how can I check it?
Would appreciate any tips for debugging.
Thanks.
- Original Message -
From: Robert Twitty
The win32 version of the mssql extension does not support the FOR
XML clause because it sends the results using ntext, which is the new
UNICODE text type introduced in SQL Server 7.0.
The mssql extension was built with DB-Library, which cannot read ntext
fields. DB-Library is obsolete, and
What platform are you using? Since it appears that the script is
crashing, you are probably on Linux or some other UNIX flavor. If this is
the case, the TDS protocol setting may not be correct. What type of date
are you retrieving with this stored procedure?
-- bob
On Sun, 17 Aug 2003,
I believe this is only applicable to fields of type text. It may have
no effect on varchar(255) fields. The purpose of this statement is to
limit the amount of memory allocated by the driver for text data. If it is
not specified, the driver will try to allocate 2GB of memory. The
extension sets
Unless I am mistaken, but isn't there an ODBC driver available for MySQL
called MyODBC?
-- bob
On Sun, 10 Aug 2003, Gerard Samuel wrote:
Larry E.Ullman wrote:
Im looking at venturing into working with PHP's ODBC extention.
Does anyone have any recommendations as to a Database, that is
This is true if Shaun was using MySQL, but he is using MSSQL. MSSQL
allowas you to declare char and varchar fields with lengths up to 8000
characters. Unfortunately the extension bundled with PHP cannot read
beyond the first 255 characters. This is primarily due to the fact that
the extension
If the other application opens the database exclusively, then you will not
be able to open it, even for read only. The only solution to modify the
sharing option used by the other application. Another problem you may
encounter is that the ODBC driver for Access is not thread safe.
-- bob
On
What is the setting of the ODBC connect string parameter SOURCEDB?
Does the PC running Apache have permission to access the path
specified by SOURCEDB?
-- bob
On Mon, 14 Jul 2003, YT Lee wrote:
I have a Windows XP PC configured as follow:
1. Apache 2.0.46
2. PHP 4.3.2
3. Microsoft Visual
In order o update fields without using a UPDATE statement you
have to use a cursor. In general, this is how ADO (the technology used by ASP)
performs its updates in the manner you outlined below. There are no
extensions bundled with PHP of which I am aware that allow you to update
data via a
What database are you using?
Also, are all the fields involved in the joins and whare clause
properly indexed? Depending on the database you are using, it is possible
to determine if the indexed fields are being used.
-- bob
On Tue, 3 Jun 2003, André Sannerholt wrote:
Hi everybody,
now I
Thanks for the tip. I will take this issue to the PHP-DEV list.
-- bob
- Original Message -
From: l0t3k [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 02, 2002 2:31 AM
Subject: [PHP-DB] Re: ODBTP, a possible solution for MS-SQL and other
databases
Robert,
this
Hello
I have been using PHP for about 9 months, and have chosen it as my primary
scripting language for web applications. I have and still use ASP and JSP.
IMHO, PHP is superior and easier to use than those languages except in one
area that is important to me, which is the ability to access MS
Does anyone know why all mail that I send to any aspect of the php-db list
is bounced when it is sent from the address below?
-- bob
- Original Message -
From: Robert Twitty [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 31, 2002 9:39 PM
Subject: Returned mail: see
85 matches
Mail list logo