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

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

PB 7.0.3
I'm trying to connect to a SQL Server 7 database in another location (i.e, over a WAN). I can connect to it just fine from SQL Server client, but I get an error "SQL Server unavailable or does not exist" error message when trying to connect to it from PB 7.0.3. Any suggestions? Connection over a wan (Internet) does work for us. If you can give us some more information maybe we can help you find a solution. <DFortner> wrote in message news:96CDFBF773F137B90065FB2E85256C5B.0065FB3C85256C5B@webforums... > I'm trying to connect to a SQL Server 7 databa...

Chinese became chaos code on PowerBuilder 9.0.3 connect to SQL server 7.0
I used PowerBuilder 9.0.3 connect to SQL server 7.0, I keyed in Chinese data when Chinese became chaos code on display. I preview or print out also got the chaos code. I used OLE DB to link with SQL server 7.0 Please give me comment to fix it. -- Best Regards Wong Tat Ming Tel: 25235090 Email: tmwong@diagnostix.com.hk You need the Unicode versions of these.... PB 10.0 or higher plus SS2005 will get you to full Unicode compatibility. "chu" <chuchoy@msn.com> wrote in message news:4588d7be$1@forums-1-dub... > I used PowerBuilder 9.0.3 connect to ...

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

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

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 try to trap SQLCA.SQLCode, SQLCA.SQLDBCode and SQLCA.SQLErrText and include them in the post - this will allow localize the problem better...

Can 7.0.3 clients connect to a 7.0.1 server?
We are wanting to deploy Vista/Windows 7 and I have seen that client 7.0.2 and up would be a better choice than what we currently use, 7.0.1. However, the server/MTA/POA/etc. is all running 7.0.1. Is it possible to connect a 7.0.3 hp3 client to a server that's still running 7.0.1 stuff? Or will we have to upgrade the server first before trying to deploy updated clients? I know that we can't run GW7 clients with a 6.5 server, for example, but I didn't know if the "client version must be less than or equal to the server to work" rule also applied to x.x.Y u...

Migrate from PB 7.0.2 Build 8046 to PB 7.0.3 Build 10009
Is it a good move ? I use PB 7.0.2 C3 Build 8047 on Windows NT 4 sp 6a, but I want to move to Windows 2000 soon. I read than only the version 7.0.3 and above are Windows 2000 compilant. Do I have to expect some problems if I move to the version 7.0.3 Build 10009 than I dwonloaded from the sybase web site. Thank for your answers... Franc. Hi, I don't know if there is a technical problem. But my app. and PB works on Winnt 4.0 and Win2K server very fine. And i've don't received any problem reports since a long time. (The versions i've tested are 7.0, 7.0.2 ...

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

PB 7.0.3 connecting against SQL Server 2005
Hi, I have a number of PB apps in 7.0.3 that will be connecting to SQL Server 2005 databases (2000 databases being migrated). I am hoping to start work on this project next week. From what I have gathered by reading some of the newsgroup postings, connection is only available through ODBC or OLEDB. I have installed the SQL Server 2005 Client Tools (Management Studio) and have noticed a 'SQL Native Client' driver (version 2005.90.1399.00) that was installed by viewing the ODBC Driver settings on my computer. Has anyone successfully completed a similar assignment o...

PB 7.0.3
Hi, I'm using PB 7.0.3. From the product documentation, I understand that PB 7 is certified to work with SQL Server 7. Is it certified to work with SQL Server for Windows 2000? Does PB 7.0.3 supply any native database driver for SQL Server 2000 or should I use ODBC to connect? Appreciate your time and help. Thanks. Regards Rajan This is a multi-part message in MIME format. --------------BA39BC6458FB11852465F3FF Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Rajan, we work with PB 7.0.3 and MSSQL 2000 with no problem. Use ODBC...

PB 7.0.3 Build 10108 connect problems to Oracle 8.1.7
I am trying to run an application that I migrated to PB 7.0.3 from PB 6.5 using an Oracle 8.1.7 database. I can connect to the database through all normal means (SQL Worksheet, SQL Plus, Powerbuilder Database Painter, previewing data windows, etc) but when I run the application I receive an error "999 DBMS is not supported in your current installation" after issuing the "Connect using SQLCA" statement. I have checked all things such as 1. Installed Oracle 8.1.7 client software in location on hard drive and made sure it was the only Oracle location refer...