Connecting Powerbuilder 7.03 to MS SQL 2000

I have been told that the dll's included in the 7.03 version of PB has the 
ability to connect to and work with SQL 2000.  I have installed the upgrade 
but, when I open the database with the MSS driver the database is not 
updateable.  In all the painters PB will not allow me to edit the data.  I 
know that for Sybase SQL Server you need to run a script on the database to 
allow the driver to communicate with PB.  Am I missing this file somewhere 
or is there another way to enable PB to work with SQL 2000?


Thanks,
Paul Swanson
0
Paul_Swanson
8/29/2001 6:39:40 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

3 Replies
583 Views

Similar Articles

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

We work with PB7/SQL2000 with no problems, we didn't have to run any scripts
or do anything special, it just worked.
When you say it's not updateable, do you mean you get an error message, if
so, what?
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


<Paul_Swanson> wrote in message
news:82FF554238E37DF50066827185256AB7.0066828285256AB7@webforums...
> I have been told that the dll's included in the 7.03 version of PB has the
> ability to connect to and work with SQL 2000.  I have installed the
upgrade
> but, when I open the database with the MSS driver the database is not
> updateable.  In all the painters PB will not allow me to edit the data.  I
> know that for Sybase SQL Server you need to run a script on the database
to
> allow the driver to communicate with PB.  Am I missing this file somewhere
> or is there another way to enable PB to work with SQL 2000?
>
>
> Thanks,
> Paul Swanson


0
Simon
8/30/2001 10:01:11 AM
I have seen this problem when the table you are working with in the painter
has no index. (It may have nothing to do with which database you are working
with.)

<Paul_Swanson> wrote in message
news:82FF554238E37DF50066827185256AB7.0066828285256AB7@webforums...
> I have been told that the dll's included in the 7.03 version of PB has the
> ability to connect to and work with SQL 2000.  I have installed the
upgrade
> but, when I open the database with the MSS driver the database is not
> updateable.  In all the painters PB will not allow me to edit the data.  I
> know that for Sybase SQL Server you need to run a script on the database
to
> allow the driver to communicate with PB.  Am I missing this file somewhere
> or is there another way to enable PB to work with SQL 2000?
>
>
> Thanks,
> Paul Swanson


0
Avatar
8/30/2001 2:32:14 PM
It may also be a rights issue.  Be sure your connection logon id has rights
to update the database.


<Paul_Swanson> wrote in message
news:82FF554238E37DF50066827185256AB7.0066828285256AB7@webforums...
> I have been told that the dll's included in the 7.03 version of PB has the
> ability to connect to and work with SQL 2000.  I have installed the
upgrade
> but, when I open the database with the MSS driver the database is not
> updateable.  In all the painters PB will not allow me to edit the data.  I
> know that for Sybase SQL Server you need to run a script on the database
to
> allow the driver to communicate with PB.  Am I missing this file somewhere
> or is there another way to enable PB to work with SQL 2000?
>
>
> Thanks,
> Paul Swanson


0
Avatar
8/30/2001 2:33:28 PM
Reply:

Similar Artilces:

How to set database profile to PowerBuilder 10.5 connect to MS-SQL Server 2000 sp4?
Hi: How to set database profile to PowerBuilder 10.5 connect to MS-SQL Server 2000 sp4? It seems that the special connection inferface for "MSS Microsoft SQL Server" is canceled in PowerBuilder 10.5. I do not want to via ODBC. Thanks! Wu; No, MSS driver (actually Microsoft's NTDBLIB.dll) was cancelled by Bill Gates in SQLServer v7. It was supported in 2000 - but ANSI only with limited functionality and dropped for SS2000 and 2005 in the Unicode world. So your choices are: ODBC, OLE-DB and ADO.net. There is new SNC driver for PB 11 that is simil...

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 7.0 and My SQL, MSDE database connection
Hi all Is it possible to connect My SQL database and Powerbuilder 7.0 Build 10312 application? If so what is the connection parameter? Also, Is it possible to connect MSDE Database and Powerbuilder 7.0 Build 10312 Application? If so what is the connection parameter for MSDE database? Is it any ODBC drivers need to be configured for the above said databases (My SQL and MSDE). Where could I get the ODBC drivers for My SQL database and MSDE database? also what is the installation procedure? Is there any special steps need to be followed to configure the My SQL or MSDE databases w...

Connecting to an SQL Server 2000 Database from Powerbuilder 6.5
I have a WINDOWS 2000 SERVER on which the SQL SERVER 2000 (Standard=20 Edition) is running.. From a WINDOWS NT Workstation Client (on the same Network) I' trying from within Powerbuilder to connect to my SQL SERVER 2000 database via ODBC. I created and configured the ODBC driver for this=20 connection as well as the associated Powerbuilder DB-Profile. When then I try to connect (from the Database Profiles popup window) to my database, the sonnection is successfull but when the popup window of Powerbuilder appears (in the Database Painter Window) for selecting the tables of the d...

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

MS SQL Server 7.0 and PowerBuilder 5.03
We have been battling a data transfer bug with SQL Server 7.0 where Microsoft's transfer manager is failing to transfer all objects to a data base. After completing one such transfer, we are having problems getting the PowerBuilder development environment to recognize table structures. My theory is that Microsoft has inadvertantly tossed some stored procedures used by PowerBuilder. My on-line PB documentation says that no scripts need to be run on SQL Server 6.5 because PB uses the system catalogs for its information. How about SQL Server 7.0? Are there any scripts I need to r...

MS-SQL Server 7 With PowerBuilder 7
I write a SQL statement like this: SELECT * FROM MATERIAL Table Material have 120,000 records data. Execute this Query in SQL Server Query Analyzer. It's spends about 2 minutes Execute this Query in PB 7.0 Database painter's ISQL Session It's spends over 10 minutes. I used Native drive not used ODBC to connect the MS-SQL 7.0. My database server have: Server's CPU x 4 Database Server : MS-SQL Server 7 How can I improve the performance in PowerBuilder? Thanks for your help! from Leo Leo, Depending on your requireme...

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

Connecting to sql server 2000 via ole db in Powerbuilder 7
I'm trying to do a direct connect to sql server 2000 using ole db. I've got one connectstring in my application (powerbuilder) that is accessing the database via odbc. I want to access a different database (for security purposes) using ole db. Is this possible? Here are my parameters: sqlca.dbms = ole db sqlca.database = picard sqlca.logid = picard sqlca.logpass = picard sqlca.servername = picardsqld1 Can someone please help with the syntax on connecting to this database. Thanks... It's possible, but oledb in PB7 doesn't work well at all. It's appa...

Powerbuilder 9
Hi, I am trying to get connected to Microsoft SQL server 2000 using SSL, through the native driver (MSS (Msoft) SQL Server 6.0). Unfortunately, the code I am supporting is such that I can't change to ODBC or OLEDB easily. Is there a way to set the native driver to communicate using SSL? I tried DBPARM=Encrypt=1 and many other similar combinations, but no luck so far. Thanks, Brian ...

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

Powerbuilder 7 nested SELECT parameter MS SQL Server 2000 error.
Hello. I was reviewing a little bit more my problem and I can redefine it as Powerbuilder 7.0 executing SELECT with a parameter on its WHERE clause, nested within other SELECT and executed against a MS SQL 2000 database, gives an error. i.e.: SELECT DISTINCT field FROM table WHERE data IN ( SELECT data FROM othertable WHERE otherfield= :lsVariable); generates an error where SQLCA.SQLCode= -1 AND SQLCA.SQLErrText='SQL...

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

PowerBuilder, connecting to MS SQL Server using MSS native driver: A field which is defined as a varchar (450) is truncated to 255 characters in PowerBuilder
PowerBuilder, connecting to MS SQL Server using MSS native driver: A field which is defined as a varchar (450) is truncated to 255 characters in PowerBuilder I am using Power Builder 7.0 with SQL Server 2000 Database. I created a datawindow using a varchar(450) field. It is allowing me enter and save 450 characters but when I retrieved the data it is truncating it to 255 chars. I looked in the database all 450 characters are there. Why it is truncating the data on retrieve? Please help me out if anybody knows the solution Thanks in advance because the native interface (Micr...

Web resources about - Connecting Powerbuilder 7.03 to MS SQL 2000 - sybase.powerbuilder.database

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/5/2015 9:32:00 PM