Problem regarding the connection of PB 7.0 with SQL 7.0

I'm calling some stored procedures written in SQL Server 7.0 from the Power
Builder 7.0 through the SQL Server native driver connection. It doesn't
return back whenever I execute it from the Frontend while it works perfectly
when I execute that stored procedure from Query Analyser directly.
It has been working fine when I did the same operetion using PB 6.5 & SQL
6.5.
Plz help me in this regard as soon as possible.
Regards,
Guls


0
Guls
1/31/2000 3:21:50 PM
sybase.powerbuilder.connection 3893 articles. 0 followers. Follow

2 Replies
748 Views

Similar Articles

[PageSpeed] 47

try to trap SQLCA.SQLCode, SQLCA.SQLDBCode and SQLCA.SQLErrText and  include
them in
the post - this will allow localize the problem better. I'm using native
driver 6.x with PB7 and SQL 7 and
never encounter problems with stored procedures....
rgrds
rafael

Guls <Gul_Qadeer@netsolpk.com> wrote in message
news:KfLIO#$a$GA.306@forums.sybase.com...
> I'm calling some stored procedures written in SQL Server 7.0 from the
Power
> Builder 7.0 through the SQL Server native driver connection. It doesn't
> return back whenever I execute it from the Frontend while it works
perfectly
> when I execute that stored procedure from Query Analyser directly.
> It has been working fine when I did the same operetion using PB 6.5 & SQL
> 6.5.
> Plz help me in this regard as soon as possible.
> Regards,
> Guls
>
>


0
Rafael
2/1/2000 9:04:31 PM
Are you definitely using the native driver, rather than OLEDB?  We couldn't
get stored procedures to execute using OLEDB, but have no problems with
native.

Simon

Guls <Gul_Qadeer@netsolpk.com> wrote in message
news:KfLIO#$a$GA.306@forums.sybase.com...
> I'm calling some stored procedures written in SQL Server 7.0 from the
Power
> Builder 7.0 through the SQL Server native driver connection. It doesn't
> return back whenever I execute it from the Frontend while it works
perfectly
> when I execute that stored procedure from Query Analyser directly.
> It has been working fine when I did the same operetion using PB 6.5 & SQL
> 6.5.
> Plz help me in this regard as soon as possible.
> Regards,
> Guls
>
>


0
Simon
2/7/2000 10:21:08 AM
Reply:

Similar Artilces:

Connection of PB 6.0 to SQL Server 7.0 & Version B/W PB 6.0 and PB 7.0
Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please remember we are not planning to upgrade both software. When I was trying to connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003". OS=NT 4.0 Server PB=6.0 Enterprise Edition SQL SERVER=7.0 Corporate Edition I also want to know the versions between PB 6.0 to PB 7.0 If your are using the ODBC, which I assume you are, include Disablebind=1 in your DBParm. If your deployment environment is also NT, you will have to turn SQLSPY=1 using PFC services. Autocommit=FALSE and SetTransObject() ra...

Help me about connecting PB 6.0 to SQL Server 7.0 & Versions B/W PB 6.0 and PB 7.0
Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please remember we are not planning to upgrade both software. When I was trying to connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003". OS=NT 4.0 Server PB=6.0 Enterprise Edition SQL SERVER=7.0 Corporate Edition I also want to know the versions between PB 6.0 to PB 7.0 I don't believe this is going to be possible without at least upgrading to the latest maintenance release of 6.x. On Mon, 23 Aug 1999 00:59:56 -0700, in powersoft.public.powerbuilder.database Abdul Lateef <abdul_lat...

Connect MS-SQL 7.0 in PowerBuilder 7.0
In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ? Please post to the powersoft.public.powerbuilder newsgroups This is dedicated to PB issues when used within Jaguar Masun wrote: > In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but > in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ? ...

Error connecting Pb 6.5 and Pb 7.0 to SQL SERVER 7.0 desktop(Window 98)
Today(9 Sep 1999), I can't connect to SQL Server 7.0 before this i can connect it. It give an Error "Unable to connect : SQL Server is unavailable or does not exist, Specified SQl Server not found ". I have check with Query analyzer , the Query analyzer can connect very well. Any one this have this problem, and how to solve this ??? TIA -- Regards Daniel Fransius not enough information... are you trying to use OLE DB ? ODBC ? Native driver ? What about security settings on the server ? What user id and password are you passing ? There is a lot of things ...

Problem regarding calling Stored procedures of SQL 7.0 from PB 7.0
I'm calling some stored procedures written in SQL Server 7.0 from the Power Builder 7.0 through the SQL Server native driver connection. It doesn't return back whenever I execute it from the Frontend while it works perfectly when I execute that stored procedure from Query Analyser directly. It has been working fine when I did the same operetion using PB 6.5 & SQL 6.5. Plz help me in this regard as soon as possible. Regards, Guls Guls: Would be helpfull if I new more about the procedure you are calling and/or any error messages you are getting. We use PB 7.0 with MS...

Problem regarding calling the stored Procedure of SQL 7.0 from PB 7.0
I'm calling some stored procedures written in SQL Server 7.0 from the Power Builder 7.0 through the SQL Server native driver connection. It doesn't return back whenever I execute it from the Frontend while it works perfectly when I execute that stored procedure from Query Analyser directly. It has been working fine when I did the same operetion using PB 6.5 & SQL 6.5. Plz help me in this regard as soon as possible. Regards, Guls We had similar issue. We regenerated the application LOTS of times. Then it worked. Make sure you regen everything several times. &q...

pb 7.0.3 build 10089 and sql server 7.0 : Slow Connection
We've got the same problem as earlier mentioned by Ken Freeman (see message below), but we're using pb version 7.0.3 Build 10089 and sql server 7.0?!!? Can anyone help us? "Ken Freeman" <kfreeman@ems.jsc.nasa.gov> wrote in message news:p1fXadCIBHA.201@forums.sybase.com... > We've recently upgraded from PB 6.5 to PB 7.0.2 (Build 8003). > Before the upgrade, a connection in development mode took a few seconds. > Now it takes several minutes. > > Does anyone know what might be cause the slowdown? > > Thanks, > Ken > > ...

PROBLEM with PB 7.0.3 AND SQL SERVER 7.0 USING SQL CURSOR
I am having a problem running a sql command with a cursor with Native drivers for MS sql Server 7.0.If i use ODBC or take out the order by clause in the statement it works fine By the way I am running powerbuilder 7.0.3 build 10009 The error code is : (Error 10008 (DB-Library) DB-Library Severity Level 9 Message Text ad token from SQL Server: Datastream processing out of synchronization) here a sample of the code DECLARE cur_Sec1 CURSOR FOR SELECT DISTINCT COL1,COL2 FROM TABLE1 WHERE COL1 = ??? ORDER BY COL1 ASC ; <<<<<<<<<<< ...

PB 7.0 and MS-SQL Server 7.0 login problem
I am having a problem connecting my app to the MS SQL-Server database. I'm sure it's something obvious that I'm missing. From my computer, it connects just finewith no login box. When I try to connect from a different computer, a login window pops up with "Admin" as the log in name. The database should be using a trusted connection from a computer within the domain. The user on the computer is successfully logged into the (NT 4) domain. Any ideas what I am failing to do? Hi, You must provide a valid login id on the other PC you specified and this login must ...

Problem with PB 7.0 And MS SQL Server 7.0 ODBC
I am having some problem using PowerBuilder 7.0 with MS SQL Server 7.0 and ODBC. Arguments to datawindows and nested SQL doesn't seem the work properly. The following is some lines from the ODBC trace-file: SELECT report.reportkey, report.reporttype, report.reportname FROM report WHERE exists (SELECT reportparam.reportkey FROM reportparam WHERE ( reportparam.reportkey = report.reportkey ) AND reportparam.paramtype = ? )) ORDER BY report.reportname VCHAR Length=4 ID=:as_paramtype *test* (10 MilliSeconds) Error 999 (rc -1) : SQLSTATE ...

Connecting to MS SQL 7.0 in PB 5.0
Hi How do I connect to MS SQL server 7.0 giving the IP address of the server, instead of the servername in the profile...... ??? Thanx in advance - Hamsa You need at least PB6.5.1 to connect to SQL7. Some things will sometimes work in PB5, but some (including connecting by IP address IIRC) don't work. S. -- Simon Caldwell Get Real Systems Ltd Holtby Manor, Stamford Bridge Road, York, YO19 5LL Tel 01904 481999 Fax 01904 481666 Visit us at www.getrealsystems.com Specialists in e-Procurement and supply chain technology "Hamsa" <hamsaraj@uiscpl...

how do you do a select into using powerbuilder 8.0 connecting to sql server 7.0
I have a powerbuilder app that used to connect to a sql anywhere database that is now connecting to sql server. I have found an equivalent to the today(*) function: select substring(convert(char(10), getdate(), 120), 1, 10) The problem with this is that it will not work in a select-into because sub quereies are not allowed. So, what I want to do is a select-into using the above conversion query, store it in a local date variable above but I keep getting a syntax error(I have also tried using a local string variable and I get the same error) . Here is the code that generates the...

Powerbuilder 5.0/7.0 and MS SQL 7.0 Performance issues
We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app in PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0. Now we are migrating the database from MS SQL 6.5 to 7.0 SP2. We successfully converted the databases in a testing environment, but now the app runs terribly slow! I don't think it's a hardware issue -- the test box is a Compaq 8500 quad Xeon 500 w/1GB Ram. We experimented running the app as a PB 5.0 app against MS SQL 7.0 and the problem is the same. When we execute SQL directly against the DB outside of PB, we see no perf...

Error connecting ASE 11.9.2 databases through PB 7.0 and IM 7.0
Hi, I receive this error message every time I try to list tables of ASE database through PB 7.0 and IM 7.0. "Store Procedure sp_pb70table not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)" I could not find that store procedure in the existing store procedure in the Adaptive server Sybsystemprocs database too. According to your instalation manual book, I can re-create them by running the pbsys.sql scripts, which I supposed to find it in the \sybtools directory. But I don't have that directory ...

Web resources about - Problem regarding the connection of PB 7.0 with SQL 7.0 - sybase.powerbuilder.connection

Connection - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

iMedia Connection: Interactive Marketing News, Features, Podcasts and Video - iMediaConnection.com
High-quality data, if not used properly, can still lead marketers to make bad decisions. Consider these common ways that numbers are used to ...

HTTP persistent connection - Wikipedia, the free encyclopedia
... tacked on to an existing protocol. If the browser supports keep-alive, it adds an additional header to the request: Following this, the connection ...

CareerSonar Turns Facebook Friends Into Job Connections
Looking for a job ? Among your Facebook friends lies the potential for employment. CareerSonar , a new service, brings together a person’s connections ...

Kings Cross identities arrested in connection with murder
Two Kings Cross identities&nbsp;have been arrested in connection with the murder of a man at Sydney hotel.

Faith: Spirits lift in connection with home
We need to more adequately understand the spirituality of our unique place on earth.

FBI mulls connection between Super Bowl, CA fiber optic cable cuttings
... authorities, who have been baffled by more than a dozen attacks on San Francisco Bay Area data lines, are probing whether there is any connection ...

Report: Man arrested in connection with Ashley Olsen's murder
Italian media agency reports that a non-EU male has been arrested in the murder of the 35-year-old American

Toyota and Kymeta rely on satellites to power this Mirai's data connection
They're hoping to achieve gigabit wireless speeds within the next few years.

Star Wars Rebels Trailer Reveals Force Awakens Connection - Collider
The new extended trailer for the mid-season premiere of the Disney XD animated series Star Wars Rebels reveals a huge connection to The Force ...

Resources last updated: 1/23/2016 6:08:17 PM