persistent odbc connections

[Anon]

Hi,
I am new at php, and I am trying to use a persistent odbc connection using odbc_pconnect. I can get the initial connection no problem. My problem occurs when i go to a new screen, and try to use the same connection to do some more processing. I am passing(tryint to at least)the connection id created when i first make the connection, so i can use it on the new screen. Unfortunately, it does not get passed...I did a print of what was being passed, and it only gives "Resource id " instead of "Resource id #2". All other parameters i am passing work perfectly (I am passing them in the href/link that takes me to the new screen) Is what i am trying to do possible? If not, is there a way to establish just one odbc connection for php scripts?

Thanks,
Aditya Dhekney
[e-mail]

[daarius]

no, you dont need to pass resource id's like that... infact you dont need to do that.

the link will stay alive untill your script reaches the end, or it encounters exit();

so just connect once, and do your job.

[Anon]

I just want to clarify how persistent connections work then. This is my understanding: You make a persistent odbc connection, and it stays alive until either you use the exit(); function, or the script ends->unsure about this, because in the documentation, it states : "Persistent connections are SQL links that do not close when the execution of your script ends". In any case, would the following work:

In the first php script, i create a connection using odbc_pconnect...that gives me a resource...now, i somehow go to another screen, and want to use the same connection, so i create another connection using the same method. (my understanding)->but now, instead of creating a new resource and adding overhead time, php realizes that a connection for that resource already exists, and instead of creating a new one, just keeps using the old connection. Is my understanding of this correct?

Thanks in advance,
Aditya Dhekney
[e-mail]