Hello,

I am looking for someone who have successfully connected Phakt 1.3 with UltraDev on a Microsoft SQL Server 2000 on Windows 2000 Pro.
This is really serious.

Thanks, Julien

Perhaps an indicator as to precisely what help it is you require? It is quite possible that any issues you are experiencing have already been dealt with when dealing with Access databases. I know SQL Server 2K and Access are different, but the configuration and usage of these two databases with PHAkT are extremely similar....

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>

Hmmm, ok Tim,

My problem is : i cannot view my tables list when i try to create a recordset in UD4. i tested my connexion before and it works.
I have empty fields in the list that appears ...

Does someone has this problem ?
<img src="D:\recordset.jpg" border=0>

This would seem to indicate a problem with your design time connection. Whilst testing the connection works, this isn't a full-on test. I've experienced errors similar to this before using other datbases.

Have you ensured that the Username/Password that you have used have the required permissions to access a list of tables?

The fact that you're not getting a connection failure, would seem to indicate to me that this is a permissions issue.

One thing that you must ensure, when using any of the Database behaviors in PHAkT is that the user that you use has Insert/Update/Delete permissions for all of your tables.

I hope this helps.

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 'm absolutely agree with you. But, another fact is that i can select the tables i want in the Advanced mode. I put "SELECT * FROM EMPLOYEE" and it works ! but it is not easy to use !

Back in the Simple mode, it doesn't works again ... <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>.

If i change, for example, the server model from PHP4 to ASP. I select my connexion in my new recordset and : it works ! so why does it works with ASP and not with PHP ? Hmmm.

After that, someone told me as you : unsufficient rights. Ok, so i gave myself all the rights it can be on my database. And nope <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>. Even that doesn't work.

I am very disapointed and <b>please</b> can someone help me ?

Sincerely, Julien

In ASP server model :
<img src="D:\asp-recordset.jpg" border=0>

Julien,

The fact that you can get things to work in Advanced mode by typing the SQL yourself just proves that it's a design time connection issue.

One of the reasons that it works in ASP and not in PHP is that ASP provides a number of methods to connect to a SQL Server Database, ADO, ADODB etc. PHP does not. PHP will only connect via ODBC....

Could you post the settings that you have used in your connection so that we can see where the problem might be?

BTW I cannot see any of the images you have posted, as they are showing as a local system path... so the images you have posted so far aren't much help I'm afraid....


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>

I have send a reply to your email with the screenshots ... <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>