[PHP-DB] Re: Help with SQLite and ADOdb

2004-02-22 Thread JeRRy
---davd wrote--- To: [EMAIL PROTECTED] Date: Sat, 21 Feb 2004 09:08:17 -0500 From: [EMAIL PROTECTED] Subject: Help with SQLite and ADOdb I'm working on a website whose hosting package doesn't include any db (except maybe gdbm). I've install sqlite in the home directory. The question is

[PHP-DB] Q

2004-02-22 Thread Remember14a
Dear friends, How do I enable the same.Comments, please You don't have permission to access /$_SERVER[PHP_SELF]/ on this server.

[PHP-DB] Connect to MSDE using PHP

2004-02-22 Thread John W. Holmes
I've downlownded and installed the Desktop Edition of MSSQL and am trying to connect to it with PHP. Has anyone ever accomplished this? I've uncommented the line in php.ini to load the MSSQL functions and they show up on a phpinfo() page, so that part is good. When I installed MSDE I tried it

[PHP-DB] Q

2004-02-22 Thread Remember14a
Dear friends, I have pap4, mysql, apache installed. How do I enable to access /$_SERVER[PHP_SELF]/ .Comments, please I getting folloing error You don't have permission to access /$_SERVER[PHP_SELF]/ on this server.

Re: [PHP-DB] Q

2004-02-22 Thread Doug Thompson
On Sun, 22 Feb 2004 11:02:29 EST, [EMAIL PROTECTED] wrote: Dear friends, I have pap4, mysql, apache installed. How do I enable to access /$_SERVER[PHP_SELF]/ .Comments, please Correct your syntax errors: \$_SERVER['PHP_SELF']\ Doug -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Robert Twitty
Hi Michael Can I see the script you are using that causes the problem? When I change the database context using the mssql extension under PERA it is not a problem. The PEAR DB drivers suppress all messages generated by their underlying extensions. The mssql DB driver will only stop if the

Re: [PHP-DB] Connect to MSDE using PHP

2004-02-22 Thread Robert Twitty
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

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Michael Flanagan
Robert, Believe it or not, it's a simple SELECT statement! (I'm not even aware that I'm changing context, nor exactly what that means. I thought that if I used the same $db resource, things would be fine.) Other SELECTs work, but not this particular one! Here's the script (the FindInDb

Re: [PHP-DB] Connect to MSDE using PHP

2004-02-22 Thread John W. Holmes
Robert Twitty wrote: 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

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Robert Twitty
Hi Michael Prior to executing a query with the PEAR mssql DB driver, the driver will always call mssql_select_db(). The db that was specified in the DSN is the one that is selected. If the db is changed after connecing via a query, i.e., use AnotherDB, this will cause a problem if the context

[PHP-DB] Bad date external representation

2004-02-22 Thread Steve
I am running into a Bad date external representation when I try to insert some data from one of my pages. This is the SQL statement: $sql=insert into Vehicle_List (Date_PU,Date_Called,Company,Stock_Number,VIN,Veh_Year,Veh_Make,Veh_Model,Veh_Color,

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Michael Flanagan
Hi Bob, Problem solved! In the process of looking around, to ensure that I wasn't switching db's, I found that the second SELECT I was doing was using an empty select string, as opposed to SELECT * FROM... I fixed tha blunder, and things started working. I'm never quite so stupid as when I'm