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 wro
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
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
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, ove
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 t
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
d suggested and I still get the same result.
>
>
>
> 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
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
platfo
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 soluti
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 conta
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 databases
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 c
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 add/
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 a
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 Ser
SQL 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
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 pag
t; - Paul
>
> -Original Message-
> From: 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 s
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
> 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
Are you familiar 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
o fetch the message if
> an error is detected.
>
> - Frank
>
>
>
> > Hi Robert,
> >
> > I've seen your name on a few of the ODBTP posts. You're one of the
> > developers of same, yes? Are you familiar with the 'Changed database
> > con
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
unsuc
) {
> return FALSE;
> }
> $dbOpened = TRUE;
> }
> else {
> $dbOpened = FALSE;
> }
> return TRUE;
> }
>
> GetInfoFromDbHelper simply executes the SQL string:
>
> function GetInfoFromDbHelper ($db, &$select,
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, Pascal
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
shows
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 comp
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 in
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
acter
> fields 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:
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, then
Apache 2 and Windows, and so, long story short, perhaps I should
> consider other web server options.
>
> Thanks, Bob!
> david
>
> "Robert Twitty" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Hi David
> >
> > Do these few que
ly, I do not favor the SSO
> solution, but I understand the business drive 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]> wrot
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
UNICODE.
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 mem
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
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
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
> windows200
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 dr
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
sy
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
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.
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
>
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. For
ich ODBC connection do you prefer ?
>
> thx to help me
> Jeff
>
>
> "Robert Twitty" <[EMAIL PROTECTED]> a écrit dans le message de
> news:[EMAIL PROTECTED]
> You will have much better results if you use the odbtp extension instead
> of the odbc extenstion, especia
The problem is caused by the fact that the sybase extension was installed
instead of the mssql extension. The sybase extension supports some of the
mssql functions via aliasing. Unfortunately, mssql_init() is not supported
by the sybase ext. You basically have only 2 options:
1. Rebuild PHP with
Hi Damien
IMHO you should use the odbtp extension to connect to SQL Server
databases, especially on a Win32 platform. The Win32 version of the mssql
ext uses DB-Library. This library is obsolete, unsupported by MS, and does
not completely support SQL Server databases beyond version 6.5. Also,
bec
Hi Mark
The US Holocaust Memorial Museum (Department of Interior) primarily uses
PHP for web application development. The reason is because the main web
server is Apache on Solaris. IMHO, if you are using Apache on Linux/UNIX,
then PHP is probably your best choice. If you are using IIS on Window
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
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 f
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
--
On Thu, 19 Aug 2004, Gerard Samuel wrote:
> Robert Twitty wrote:
> > 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 e
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
HAVE_SQL_EXTENDE
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 r
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
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
transactio
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
>> Is there anyone here can tell me how to access Matisse DB? Thank you.
>
> Isn't there anyone can help me?
Look at http://www.matisse.com/pdf/developers/php.pdf
I found it by Googling for "Matisse PHP"
-- bob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
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($fileHandle
A very good solution for connecting to an MS Access database is the odbtp
extension. You can get it at http://odbtp.sourceforge.net. It provides
support for many of Access's features, such as UNICODE text data and query
processing, and stored query execution. An example on how to connect to a
MS Ac
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
a
There are many facters that have to be considered to make a proper
decision. First, as you have stated, mssql offers many features not
available in mysql. If these featuers are important, then you should
choose mssql. However, PHP's support for mysql is much better than its
support for mssql. PHP
no experience with odbtp, so can't really judge on that
> one.
>
> Anyway, thanks again Bob, input is goood.
>
> -TG
>
> > -Original Message-
> > From: Robert Twitty [mailto:[EMAIL PROTECTED]
> > Sent: Friday, October 01, 2004 2:27 PM
> > To:
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:
http://aspn.a
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
work
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
Subje
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
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,
>
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
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 curs
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 Visu
).
>
>
> - Original Message -
> From: "Robert Twitty" <[EMAIL PROTECTED]>
> To: "YT Lee" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 15, 2003 2:31 AM
> Subject: Re: [PHP-DB] PHP/ODBC/Apache/Netware/Foxpro
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 Thu
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
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 wa
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 se
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, vish.ko
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 Micros
--- Original Message -
> From: "Robert Twitty" <[EMAIL PROTECTED]>
> To: "vish.kohli" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, August 18, 2003 8:28 AM
> Subject: Re: [PHP-DB] Query runs fine on Console but not in PHP
>
>
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 MSS
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 o
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 Dat
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 t
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
> /var/ww
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
extensio
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
O
Based on my understanding of pconnect, it is a poor man's implementation
of connection pooling. Connection pooling requires a mediator server
between the client and database in order to maintain a connection for
reuse by another client. PHP does not provide such a server, so it uses
the web server
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,
@M
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 :
>
> [getS
94 matches
Mail list logo