PB6.5 connect MS SQL 2005 using native driver (DBMS=MSS (Msoft) SQL Server 6.0)Is it possible PB 6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to connect MS
SQL 2005?
The existing application is PB6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to
connect MS SQL 2000. It is work fine.
John
Hi John;
AFAIK .. it should work. The only restrictions would be
1) PB 6.5 will not understand SS2005 functionality. You will be restricted
to the SS 6.0 (as you are today with SS2000) feature set.
2) The MSS setting connects using the NTDBLIB.dll from MS. I do not believe
that this is supplied with SS2005. So you will need to install the SS20...
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...
OLE DB vs. MSS MS SQL Server 6.x to MSS 7.0 DBMSI'm looking for info on the pros and cons of using OLE DB to connect to a MSS
7.0 database compared to using the native database driver.
I've tried it both ways, and they both seem to work for client our client server
apps. It seems as though the native MSS 6.x driver is easier to configure. And
we appear to be able to read and write data OK. Are there any gotchas lurking
out there? Can anyone provide a reference?
Thanks,
Marvin Young
marvy@atg.wa.gov
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
I just finis...
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...
Connectivity of PowerBuilder 6.5 and SQL Server 7.0Hi 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...
Connecting to SQL Server in PowerBuilder 6.0 Enterprise EditDear all,
I have been experiencing major problems in connecting to Micorosft SQL Server
7.0 with PB6.0. My application is just unable to connect to Microsoft SQL Server
7.0. Kindly help.
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
You need at least 6.5.1
"Gauri" <gauri@boshu.com> wrote in message
news:8POi9n3tAHA.209@forums.sybase.com...
> Dear all,
> I have been experiencing major problems in connecting to Micorosft SQL
Server
> 7.0 with PB6.0. My application is just unable to connect to Mi...
A Problem to Connect SQL Server 2000 Through MSS MS SQL Server 6.x InterafaceHi,
We have two SQL Server 2000 database servers. I have no problem to connect
serverA through MSS MS SQL Server 6.X. But I cannot connect to serverB
through MSS MS SQL Server 6.X.
I tried to connect to serverB through ODBC. It is connected well, but there
was error message said "Catalog tables could not be created and are not
available for use."
My PowerBuilder version is 7.0.2 and build 8046.
Mindy
...
DBMS MSS MSSQL Server 6.x not supported in current installati have this DB error message when my program run on win95 machine.
what is the cause of the problem, and how can i solve this problem on win95
machine?
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
Make sure PBMSS070.DLL is deployed (or PBMSS060 or PBMSS050 depending on the
version of PB)
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
"-= ...
DBMS MSS MSSQL Server 6.x not supported in current installati have this DB error message when my program run on win95 machine.
what is the cause of the problem, and how can i solve this problem on win95
machine?
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
Do you have the PbMSSXX.DLL file in right place and the client Driver of MS
installed ??
"-= Siang Chuen =-" <scphoo@tm.net.my> wrote in message
news:iKgdiP3IAHA.280@forums.sybase.com...
> i have this DB error message when my program run on win95 machine.
> what is the cause of the problem, and how can i solve...
problem when connecting MS SQL Server 7.0 with powerbuilder 6.5Dear 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.
...
Stored procedures,MSS Sql Server 7.0, and Powerbuilder 6.5I have a stored procedure that performs an update of a table based upon two
input values, a "char(12)" and an "int" type. When running this update
inside SQL Server 7.0, it works. However, when I run it in my Powerbuilder
application, I get the error "Invalid character value for cast
specification", as though I have some data type compatability error. I
checked my code and everything seems appropriately typed.
Also, it seemed that when I was using SQL Server 6.5, everything worked
fine. Any insights out there?
There was a bug reported with numeric dat...
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not all #6
hi there!
I've uploaded my website at online server. which has its database on its local server. Now whenever Im trying to open the website. I get the following message instead of website.
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
Im using sql server 2000 for database. Asp.net 2.0
Please hel...
EAServer 6.0 connect to MS SQL SERVER using ODBC ConnectionI am currently migrating from EAServer 4.2 to 6.0. I am
trying to connect a SQL Server database through an ODBC
connection in EAServer 6.0. When I set up the data source
and tried to ping the database server, it gives me an error
saying it cannot connect to the database. I have tried to
change the database type from SQL SERVER to JCM_ODBC and
other multiple things to try to connect, but it still fails.
The odbc connection is properly set up but I can't seem to
connect through EAServer. Any help would be appreciated.
Could you please give the log of EAServer6 which is under
...
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...