Connection of PB 6.0 to SQL Server 7.0 & Version B/W PB 6.0 and PB 7.0Can 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.0Can 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.3I'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.0I 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.0In 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.0I'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 10009Is 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.0I 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 2005Hi,
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.3Hi,
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.7I 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...