Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Database query (stored procedure access)

prakasse
Advisor

Database query (stored procedure access)

Hi folks,

I have a simple query on the DB cocnept.
Can you let me know your view on this. ...

I have a 32-bit SQL and i plan to move to 64 bit SQL. I use stored procedures in my application.

I can be sure that when i install 64 bit SQL, automatically 64 bit stored procedures will be installed.

But should i change something in my application (i shall retain application as 32 bit) that calls these stored procedure.

Will the application just run like that? or should i modify some part of the application to access the 64 bit stored procedures in SQL?

Thanks,
Senthil
4 REPLIES
Eric Antunes
Honored Contributor

Re: Database query (stored procedure access)

Hi Senthil,

Is this an Oracle database? What application do you have??

Best Regards,

Eric Antunes


Each and every day is a good day to learn.
prakasse
Advisor

Re: Database query (stored procedure access)

it's SQL database and application is basically Power builder based.
Steven E. Protter
Exalted Contributor

Re: Database query (stored procedure access)

Shalom,

Oracle databases have upgrade steps outlined at http://technet.oracle.com and http://metalink.oracle.com (software contract required on the later) that convert 32 bit objects to 64 bit.

A test plan to validate functionality is required to make sure this actually works right.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Eric Antunes
Honored Contributor

Re: Database query (stored procedure access)

Hi Senthil,

I did a google search and found this google group that seems to answer your question:

http://groups.google.com/group/powersoft.public.powerbuilder.connectivity/browse_thread/thread/b65880fd60459293/5b6b4c1eac588ffc?#5b6b4c1eac588ffc

It seems that Powerbuilder communicates via ODBC so it should be fine.

Anyway, it is always a good idea to contact your application support/representative...

Best Regards,

Eric Antunes
Each and every day is a good day to learn.