Connection problem with PowerBuilder 5.0.02 to MS SQL 7

Hello,

I am having a problem connecting PowerBuilder 5.0.02 to MS SQL 7.  The
application connects fine.  The problem is when I try to create a new
datawindow with a stored procedure on SQL 7.  I can view all the names of
the stored procedures but I can't see any of the code. I am using the odbc
driver 3.07.08.20 . When I try to look at the stored procedures I get the
message 'The database does not currently support retrieval of procedure
text.'  Everything worked fine in SQL 6.5.  

any help appreciated,

Bruce

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Bruce
5/16/2000 4:33:48 PM
sybase.powerbuilder.connection 3893 articles. 0 followers. Follow

2 Replies
759 Views

Similar Articles

[PageSpeed] 1
Get it on Google Play
Get it on Apple App Store

Hello Bruce,

Try it a newer version ODBC driver.
The SQL Server 7.0 CD include 3.70.06.23 ODBC driver.
I try it, and I can see the correct procedure.

Good luck,


Ajbi





Bruce <Nocanspam_Bruce.McDowell@edc.gov.ab.ca> az al�bbiakat �rta a
k�vetkez� h�r�zenetben: 5g4IDS1v$GA.202@forums.sybase.com...
> Hello,
>
> I am having a problem connecting PowerBuilder 5.0.02 to MS SQL 7.  The
> application connects fine.  The problem is when I try to create a new
> datawindow with a stored procedure on SQL 7.  I can view all the names of
> the stored procedures but I can't see any of the code. I am using the odbc
> driver 3.07.08.20 . When I try to look at the stored procedures I get the
> message 'The database does not currently support retrieval of procedure
> text.'  Everything worked fine in SQL 6.5.
>
> any help appreciated,
>
> Bruce
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


0
jbi
5/17/2000 6:47:41 AM
Another possibility is you have no [Microsoft SQL Server] section. This is
what we use to get the SQL to bring back the procedure text.    There's an odd
chance it's the driver too.
You should copy the section from your pbodb60.ini.

Excerpts of what should be in your pbodb050.ini
[Microsoft SQL Server]
PBSyntax='MS_SQLSERVER_SYNTAX'
...
...

[MS_SQLSERVER_SYNTAX]
PBSelectProcSyntax....


--
Stephen Dupre
Sybase Product Support
Concord, Mass.

Bruce wrote:

> Hello,
>
> I am having a problem connecting PowerBuilder 5.0.02 to MS SQL 7.  The
> application connects fine.  The problem is when I try to create a new
> datawindow with a stored procedure on SQL 7.  I can view all the names of
> the stored procedures but I can't see any of the code. I am using the odbc
> driver 3.07.08.20 . When I try to look at the stored procedures I get the
> message 'The database does not currently support retrieval of procedure
> text.'  Everything worked fine in SQL 6.5.
>
> any help appreciated,
>
> Bruce
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp



0
Stephen
5/19/2000 1:50:10 PM
Reply:

Similar Artilces:

problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
Dear All, I have some problem when connecting MS SQL Server 7.0 with powerbuilder 6.5 The error message is: Database transaction information not availiable. Call SetTrans or SetTransObject function. I have a window with 1 button and 1 datawindow The datawindow inside contain a SQL statement in the click event of the botton, the script is: parent.dw_1.SettransObject(SQLCA) parent.dw_1.retrieve() Can anyone tell me what is the problem? And how to solve it??? Thank You Very Much!!! It seems that the database connection is not available or not successfully connected. ...

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 ? ...

PowerBuilder 6.5 and MS SQL 7.0 Connection
I'm facing a problem in connecting powerbuilder 6.5 to MS SQL 7.0 on 'Windows ME' when i try to connect to database it creates the connection without giving any error but when i try to see the tables in database painter or anywhere else it does'nt show me the tables and gives me error "SQLSTATE = S1003 [ODBC][SQLSERVER]Program type out of range" i've formatted my hard disk and again installed 'Windows ME' and other required softwares but the problem is still there, any suggessition would be worth for me. Thanks Saqib Sardar What build of...

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...

Connectivity of PowerBuilder 6.5 and SQL Server 7.0
Hi Guys, I need help regarding connectivity with PB 6.5 and SQL Ser. 7.0. I am getting an error message "DBMS MS Sql Server ... not supported in current installation' or 'Unable to load the requested database interface". I have required files for both the system and for PB i.e., NTWDBLIB.DLL PBMSS60.DLL but still i am not able to connect to the database. Please help. Regards, MS Check the sybase site, there is useful infor about the matter. Good Luck, Alessandro Barbieri "mahesh" <mahesh.shah@codecindia.com> wrote in message new...

How to connect to Ms Sqlserver 7.0 with powerbuilder 6.5
I want to connect to Ms Sqlserver 7.0 with powerbuilder 6.5. Would you please tell me where I can download the native database driver? Thank you very much! Sincerely, Fang Jing fangjing@telekbird.com.cn I have not been able to find a native driver anywhere. We are having no real problems using the SQL 6.5 drivers with PB 6.5.1. You have to upgrade to PB 6.5.1 or there are some issues. (Like you can't paint a DW off of a stored proc) Hope this helps....Paul Fang Jing <fangjing@telekbird.com.cn> wrote in message news:tmKLHsSR$GA.289@forums.sybase.com... ...

connection problem from PB 6.5 and MS SQL 7.0
I experience this problem when trying to connect to MS SQL 7.0 from PB development Environment from Database painter. SQLState S1003 Microsoft ODBC Drive Manager PRogram Type out of Range. Your help much appreciated. Upgrade to 6.5.1 Syed <syedibrahim@hotmail.com> wrote in message news:UNYhqTUR$GA.191@forums.sybase.com... > I experience this problem when trying to connect to MS SQL 7.0 from PB > development Environment from Database painter. > > SQLState S1003 > Microsoft ODBC Drive Manager PRogram Type out of Range. > > Your help much appr...

Connecting to MS Sql server 2000 thru PowerBuilder 5.0
We're connecting to MS Sql server 6.5 from PowerBuilder 5.0 using a Native driver. We want to upgrade to MS Sql server 2000. Does the native driver in PB 5.0 for MS Sql Server 6.5 support MS Sql server 2000 also ?? If not , whether Sybase provide a native driver to connect MS Sql server 2000 from PB 5.0 ?? Thanks & Regards, Ravi. No, neither SQL7 nor SQL2000 is supported from PB5. Some people have got SQL7 to work (don't know about 2000), but mostly it won't, certainly for us it wouldn't. The best thing to do is try it and see whether you get problems w...

Problems to connect a PB 5.04 with MS SQL Server 7.0
I possess PB 5.04 and I need to connect with MS SQL Server 7.0 he/she saw ODBC. I am using the connection file with the MS SQL server: SQLSRV32.DLL 3.70.06.23 11/05/1999 ODBC 3.510.3513.0 When I execute the application for PB in Windows 95 it works, but when I try to execute by Windows 98 and I give retrieve in any datawindow he/she doesn't appear the data. Seemingly the I am supported it connected, mistake didn't come back. To use sql embeded doesn't also work, coming back garbage. Thank you, Francisco Freitas ODBC 3.x added some new datatypes that older v...

PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files
PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files. Compiled program running on the Win98 without MS SQL 7.0 client application installed. I can not get the DB connection by using external ip address like "202.199.12.12", but for internal ip address "10.4.32.2" which is one of our intranet ip address, it works well. The error is "unable to find SQL Server or SQL Server unvaliable". Both of the two ip adresses are associated with the same DB Server. Thanks ...

PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files #2
PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files. Compiled program running on the Win98 without MS SQL 7.0 client application installed. I can not get the DB connection by using external ip address like "202.199.12.12", but for internal ip address "10.4.32.2" which is one of our intranet ip address, it works well. The error is "unable to find SQL Server or SQL Server unvaliable". Thanks ...

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...

PB 7.0.1
Hi, I just found a solution for correcting the memory leak in 7.0.1, when connecting to MS SQL Server 6.5. May be this is already fixed in the latest releases. I just want to share this in case it's useful to any of you guys. When you connect to the MS SQL Server 6.5 database, be sure to have atleast something in your DBParm attribute of the DBProfile (or SQLCA transaction object at runtime). For example (SQLCA.DBParm = "AppName='IRIS',Host='ZNF9'"). In development time in the DBProfile dialog under "Network" tabpage Enter something i...

Connecting to MS SQL 6.5 through PB 5.0.02
I have set up a MS SQL ODBC connection in ODBC Administrator that has the server name and database name set, the rest is all default. In PB I make a new database profile called 'MS SQL' and set DBMS to 'ODBC'. In the 'Select Data Source' window that comes up I select the ODBC connection I just made on the 'Machine Data Source' tabpage. When I press OK to connect, PB crashes. I am running Win NT Server 4.0 and it has the MS SQL database, client software and PB installed on it. What am I doing wrong? I've tried all sorts of things like setting ...

Web resources about - Connection problem with PowerBuilder 5.0.02 to MS SQL 7 - sybase.powerbuilder.connection

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 12/11/2015 3:29:33 PM