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

OLE DB vs. MSS MS SQL Server 6.x to MSS 7.0 DBMS
I'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.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...

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

Connecting to SQL Server in PowerBuilder 6.0 Enterprise Edit
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 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 Interaface
Hi, 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 installat
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 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 installat
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 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.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. ...

Stored procedures,MSS Sql Server 7.0, and Powerbuilder 6.5
I 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 Connection
I 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.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...