Leroy Schulz
|
| Posted: 10/16/2005, 5:56 PM |
|
Is anyone using CodeCharge Studio with Pervasive SQL?
[L]
|
|
|
 |
Leroy Schulz
|
| Posted: 10/16/2005, 6:45 PM |
|
To elaborate:
I'm presently learning CodeCharge Studio (and still oh so very green. <g>)
I've done the following:
1) Created a new project using the Application Builder.
2) Created a new connection using my Pervasive SQL ODBC DSN.
3) Added the single (test) table that I created in the database.
4) Added a primary key and completed the Application Builder wizard.
5) Published the project.
The live preview page gives me the following error:
Warning: mysql_pconnect(): Can't connect to MySQL server on 'localhost'
(10061) in C:\Program Files\Apache
Group\Apache2\htdocs\MyProjectPervSQL\db_mysql.php on line 99
Database error: pconnect(, , $DBPassword) failed.
MySQL Error: 0 ()
Session halted.
See attached for the connection properties. I noticed that the "Server
Database Type" says "MySQL". There isn't a "Pervasive.SQL" option in the
drop-down. Ditto for the "PHP Database Library" field.
If I test the connection via Project Settings > Connections, the test
connection succeeds.
How do I begin troubleshooting this?
[L]
|
|
|
|
Leroy Schulz
|
| Posted: 10/16/2005, 6:49 PM |
|
Hmmm. It doesn't look like this newsgroup allows attachments.
How should I post a screenshot?
[L]
"Leroy Schulz" <mail@frostbytes.ca> wrote in message
news:diuvo1$mi0$1@news.codecharge.com...
> To elaborate:
>
> I'm presently learning CodeCharge Studio (and still oh so very green.
> <g>)
> I've done the following:
>
> 1) Created a new project using the Application Builder.
>
> 2) Created a new connection using my Pervasive SQL ODBC DSN.
>
> 3) Added the single (test) table that I created in the database.
>
> 4) Added a primary key and completed the Application Builder wizard.
>
> 5) Published the project.
>
> The live preview page gives me the following error:
>
> Warning: mysql_pconnect(): Can't connect to MySQL server on 'localhost'
> (10061) in C:\Program Files\Apache
> Group\Apache2\htdocs\MyProjectPervSQL\db_mysql.php on line 99
> Database error: pconnect(, , $DBPassword) failed.
> MySQL Error: 0 ()
> Session halted.
>
> See attached for the connection properties. I noticed that the "Server
> Database Type" says "MySQL". There isn't a "Pervasive.SQL" option in the
> drop-down. Ditto for the "PHP Database Library" field.
>
> If I test the connection via Project Settings > Connections, the test
> connection succeeds.
>
> How do I begin troubleshooting this?
>
> [L]
>
>
>
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/16/2005, 7:45 PM |
|
Sound like the Connection to the database on the Server is NOT the same as your local machine.
If you have published to a Linux machine then the database connectivity is not ODBC.
Look up you php manual on connectivity and also manually change the connection string in the common file.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
Leroy Schulz
|
| Posted: 10/17/2005, 8:45 AM |
|
> Sound like the Connection to the database on the Server is NOT the same as
> your
> local machine.
In this case we're only talking about one machine: my (local) development
machine.
> If you have published to a Linux machine then the database connectivity is
> not
> ODBC.
Linux isn't involved. I'm running Windows XP Pro.
> Look up you php manual on connectivity and also manually change the
> connection
> string in the common file.
So you're figuring this is a PHP configuration issue then?
[L]
|
|
|
|
Leroy Schulz
|
| Posted: 10/17/2005, 9:12 AM |
|
The screenshot is at www.frostbytes.ca/connection_properties_01.gif
Thanks.
[L]
"Leroy Schulz" <mail@frostbytes.ca> wrote in message
news:dj0gvm$d6m$1@news.codecharge.com...
>> Sound like the Connection to the database on the Server is NOT the same
>> as your
>> local machine.
>
> In this case we're only talking about one machine: my (local) development
> machine.
>
>> If you have published to a Linux machine then the database connectivity
>> is not
>> ODBC.
>
> Linux isn't involved. I'm running Windows XP Pro.
>
>> Look up you php manual on connectivity and also manually change the
>> connection
>> string in the common file.
>
> So you're figuring this is a PHP configuration issue then?
>
> [L]
>
>
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 10/17/2005, 9:41 AM |
|
Hi Leroy,
Loog at the Server connection setings (as well as the message you got). The
error message complained about MySQL. YOu dessign connection is using
Pervasive, but your deployment connection (the server connection) is using
MySQL.
Make sure to set it the same as your design connection and it should work.
Long time no talk :)
|
|
|
|
Leroy Schulz
|
| Posted: 10/17/2005, 10:53 AM |
|
Hi Ben,
> Loog at the Server connection setings (as well as the message you got).
> The
> error message complained about MySQL.
Yep, I noticed that. I think the problem is I'm new to CodeCharge, PHP, and
ODBC all at once. I really don't like not knowing things. <g>
> YOu dessign connection is using Pervasive, but your deployment connection
> (the server
> connection) is using MySQL. Make sure to set it the same as your design
> connection and it should work.
I did see that yesterday, but I was getting frustrated and thought I'd avoid
a slog of trial and error by posting here.
> Long time no talk :)
True, true. Since our phone conversation my client postponed the CodeCharge
project because of several other priorities, but now this is back to the
top.
Thanks for the reply. I hope things are well with you.
[L]
|
|
|
|
Leroy Schulz
|
| Posted: 10/17/2005, 11:23 AM |
|
I've double-checked my connection properties, and I see that the "Database"
value has been cleared and the drop-down does not list "Pervasive.SQL".
(See www.frostbytes.ca/connection_properties_02.gif .)
Further, on the "Server" tab, I can select ODBC as the PHP Database Library,
but again "Pervasive.SQL" doesn't appear in the "Database" drop-down. (See
www.frostbytes.ca/connection_properties_03.gif.)
Any ideas?
[L]
|
|
|
|
Leroy Schulz
|
| Posted: 10/17/2005, 11:36 AM |
|
I think I'm getting a little further. Please see
http://www.frostbytes.ca/screenshot_01.gif.
Any ideas what my next step should be?
[L]
"Leroy Schulz" <mail@frostbytes.ca> wrote in message
news:dj0oen$gmr$1@news.codecharge.com...
> Hi Ben,
>
>> Loog at the Server connection setings (as well as the message you got).
>> The
>> error message complained about MySQL.
>
> Yep, I noticed that. I think the problem is I'm new to CodeCharge, PHP,
> and ODBC all at once. I really don't like not knowing things. <g>
>
>> YOu dessign connection is using Pervasive, but your deployment connection
>> (the server
>> connection) is using MySQL. Make sure to set it the same as your design
>> connection and it should work.
>
> I did see that yesterday, but I was getting frustrated and thought I'd
> avoid a slog of trial and error by posting here.
>
>> Long time no talk :)
>
> True, true. Since our phone conversation my client postponed the
> CodeCharge project because of several other priorities, but now this is
> back to the top.
>
> Thanks for the reply. I hope things are well with you.
>
> [L]
>
>
|
|
|
|
Leroy Schulz
|
| Posted: 10/18/2005, 1:29 PM |
|
Anyone?
[L]
"Leroy Schulz" <mail@frostbytes.ca> wrote in message
news:dj0qvp$hqv$1@news.codecharge.com...
>I think I'm getting a little further. Please see
>http://www.frostbytes.ca/screenshot_01.gif.
>
> Any ideas what my next step should be?
>
> [L]
>
>
> "Leroy Schulz" <mail@frostbytes.ca> wrote in message
>news:dj0oen$gmr$1@news.codecharge.com...
>> Hi Ben,
>>
>>> Loog at the Server connection setings (as well as the message you got).
>>> The
>>> error message complained about MySQL.
>>
>> Yep, I noticed that. I think the problem is I'm new to CodeCharge, PHP,
>> and ODBC all at once. I really don't like not knowing things. <g>
>>
>>> YOu dessign connection is using Pervasive, but your deployment
>>> connection (the server
>>> connection) is using MySQL. Make sure to set it the same as your design
>>> connection and it should work.
>>
>> I did see that yesterday, but I was getting frustrated and thought I'd
>> avoid a slog of trial and error by posting here.
>>
>>> Long time no talk :)
>>
>> True, true. Since our phone conversation my client postponed the
>> CodeCharge project because of several other priorities, but now this is
>> back to the top.
>>
>> Thanks for the reply. I hope things are well with you.
>>
>> [L]
>>
>>
>
>
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/18/2005, 8:09 PM |
|
Leroy,
Sorry I am php person so I maybe giving you a wrong idea,
I noticed that in your ODBC setting that there is no USERID and PASSWORD. Can you trying filling them in the Data Properties Area and having another crack at it?
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
Leroy Schulz
|
| Posted: 10/19/2005, 9:47 AM |
|
Hi Edd,
Thanks for your reply. A couple of things:
1) I don't have a username or ID on this connection because it's just test
data running on a local connection.
2) I've confirmed that Pervasive SQL does not support LIMIT clauses. I
don't know why CodeCharge is using one. (See
http://www.frostbytes.ca/screenshot_01.gif.)
Any other ideas?
[L]
"Edd" <Edd@forum.codecharge> wrote in message
news:24355b8fec442d@news.codecharge.com...
> Leroy,
> Sorry I am php person so I maybe giving you a wrong idea,
>
> I noticed that in your ODBC setting that there is no USERID and PASSWORD.
> Can
> you trying filling them in the Data Properties Area and having another
> crack at
> it?
>
> Edd
> _________________
> a simple idea....
> www.syntech.com.au
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/19/2005, 3:10 PM |
|
Open your connection in the prokect explorer scroll down unril your see the Limit / Top parameter. Turn that off.
I think that you orriginally set this as MySQL so the parameter stayed even though you changed databases.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
Benjamin Krajmalnik
|
| Posted: 10/24/2005, 5:51 PM |
|
Leroy,
You still have the connection properties off.
I will be in the office tomorrow, although a bit busy.
If you want, give me a call and I'll see if I can help you remotely.
Sorry I did not get back to you sooner. Have been busy and was ill over the
weekemnd, so did not check anything.
|
|
|
|
