How do I connect to an microsoft sqlserver 2000 with phakt... get alot of errors and it doesn't seem to work. any good tutorials...(exept the ones on udzone..allready read those) I'm going to get a mysql account, but in the meen time i'd like to start developing a page using a sqlserver 2000 database...

Cheers and hope for the best

// Leon

The procedure for doing this is exactly the same as for creating a connection to an Access database.

PHAkT uses ODBC to connect to SQL Server 2K, as it does to connect to Access. There is no difference in this respect.

Regards


Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Hello rawveg,

I have well seen your response about the connection on an sqlserver 2000. But i have approximatively the same probleme as Leon.
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 ! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>) Could you help me ?

Sincerely, Julien <img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle>

After setting up Php server model for your site please restart UltraDev and then create the connection and recordsets.

Use ODBC connection to connect to SQL Server 2000.

-----------------------
Cirstoiu Aurel Sorin
InterAKT Support
www.interakt.ro

Edited by - csorin on 17 May 2002 10:54:27

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