Forums
This topic is locked
Help on Phakt ! Please
Posted 16 May 2002 09:26:52
1
has voted
16 May 2002 09:26:52 Julien Burzuum posted:
I have a problem about the connexion on an sqlserver 2000.I have a local SqlServer 2000 on my machine and when i try to connect through Phakt, i define my connexion (trivial) and tested it. All is ok. It is when i create a new recordset that the problem appears... when i select my connexion, the only tables i see is : none. The field is empty !.
Now look at that ! I uninstall Phakt 1.3.0 and reconfigure my site to use ASP instead of PHP server model. I try again to create a new recordset and then i can see my tables in my SQLServer 2000 !
I want to use PHP and Phakt ! Could you help me ?
Sincerely, Julien
Replies
Replied 17 May 2002 10:50:52
17 May 2002 10:50:52 Aurel Sorin Cirstoiu replied:
After setting up Php server model for your site please restart UltraDev and then create the connection and recordsets.
-----------------------
Cirstoiu Aurel Sorin
InterAKT Support
www.interakt.ro
-----------------------
Cirstoiu Aurel Sorin
InterAKT Support
www.interakt.ro
Replied 17 May 2002 10:54:02
17 May 2002 10:54:02 Julien Burzuum replied:
Thank you for your response and i'll try to be more precise ... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>. I have tested your solution without success.
The Phakt program works fine with MySQL, and Oracle because i have tried it in those both databases. I only use ODBC connexion. But with Microsoft SQL Server 2000 there is a real problem in UltraDev : I install it and when I try to make a recordset, the Phakt recordset appears correctly. I select my SQLServer connexion and try to view my tables but in the drop down list there is NOTHING ! <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>
I repeat that this problem only occurs with an SQL Server 2000 database. I have UltraDev 4 and all seams to be ok with it ...
Want more ? There is an error in the SimpleRecordsetPHP.htm script ... i gone deep in the dark ! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>. When you install Phakt, it create a PHAKT directory in Dreamweaver UltraDev 4\Configuration\Shared but in the code that show the PHP recordset (SimpleRecordsetPHP.htm), the path for the source file stringPHP.js show this : ../Shared/Impakt/Scripts/ stringPHP.js ! There a solution to my problem. I am blocked with this error and i hope that someone find the solution !
Sincerely, Julien
The Phakt program works fine with MySQL, and Oracle because i have tried it in those both databases. I only use ODBC connexion. But with Microsoft SQL Server 2000 there is a real problem in UltraDev : I install it and when I try to make a recordset, the Phakt recordset appears correctly. I select my SQLServer connexion and try to view my tables but in the drop down list there is NOTHING ! <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>
I repeat that this problem only occurs with an SQL Server 2000 database. I have UltraDev 4 and all seams to be ok with it ...
Want more ? There is an error in the SimpleRecordsetPHP.htm script ... i gone deep in the dark ! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>. When you install Phakt, it create a PHAKT directory in Dreamweaver UltraDev 4\Configuration\Shared but in the code that show the PHP recordset (SimpleRecordsetPHP.htm), the path for the source file stringPHP.js show this : ../Shared/Impakt/Scripts/ stringPHP.js ! There a solution to my problem. I am blocked with this error and i hope that someone find the solution !
Sincerely, Julien