Urgent!!Connecting to MS SQL Server7.0 with PB 5.0.04 on NT4.0

Hi!

This is urgent!!

Does anyone know how to connect MS SQL Server 7.0 from PB 5.0.04. I have
connected to MSS 7.0 with ODBC 3.70 (come with MSS7.0) from PB5.0.04,
but the embedded SQL statements in my program retrieve all kinds of
gabbish to me. I believe there is something wrong with the ODBC drivers
setting, how should I config the ODBC drivers ?

I have tried to use MS SQL Server 6.5 native drivers to connect to 7.0 ,
but I 've got the error message, something like 'Datatype not supported'
? Why is that ?

Cherry

0
wmyeung
6/20/1999 7:30:02 AM
sybase.powerbuilder.connection 3893 articles. 0 followers. Follow

1 Replies
593 Views

Similar Articles

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

The problem, at least with ODBC 3.x, is that Microsoft added some new datatypes
that PB has no idea what to do with.  So it maps them to a string datatype,
which is most often wrong.

On Sun, 20 Jun 1999 15:30:02 +0800,
 in powersoft.public.powerbuilder.connectivity
wmyeung <wmyeung@ust.hk> wrote: 
>Hi!
>
>This is urgent!!
>
>Does anyone know how to connect MS SQL Server 7.0 from PB 5.0.04. I have
>connected to MSS 7.0 with ODBC 3.70 (come with MSS7.0) from PB5.0.04,
>but the embedded SQL statements in my program retrieve all kinds of
>gabbish to me. I believe there is something wrong with the ODBC drivers
>setting, how should I config the ODBC drivers ?
>
>I have tried to use MS SQL Server 6.5 native drivers to connect to 7.0 ,
>but I 've got the error message, something like 'Datatype not supported'
>? Why is that ?
>
>Cherry
>

---
Bruce Armstrong [TeamSybase]            | Romac/Source International
mailto:Bruce.Armstrong@teamsybase.com   | mailto:jobs@sourcela.com
                                        | http://www.romac-source.com

Preach the gospel at all times. If necessary, use words. [Francis of Assisi]
http://www.kidbrothers.org                http://www.fccwc.org
http://www.harvest.org/knowgod/index.html

-----------== Posted via the PFCGuide Web Newsreader ==----------
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Bruce
6/22/1999 3:20:35 PM
Reply:

Similar Artilces:

Connecting to MS SQL 7.0 in PB 5.0
Hi How do I connect to MS SQL server 7.0 giving the IP address of the server, instead of the servername in the profile...... ??? Thanx in advance - Hamsa You need at least PB6.5.1 to connect to SQL7. Some things will sometimes work in PB5, but some (including connecting by IP address IIRC) don't work. 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 "Hamsa" <hamsaraj@uiscpl...

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

PB 5.0.04 on NT 4.0 running MS SQL Server 7.0?
Anyone running PB 5.0.04 on MS SQL 7.0? We're running against MS SQL 6.5 and are considering upgrading to take advantage of some of the new features. Are there new SQL drivers available or required? TIA, pat yuen pyuen@carmafinancial.com 5.0.04 doesn't work with SQL7, you'll need to upgrade to PB 6.5.1 or 7.0 Simon Pat Yuen wrote in message ... >Anyone running PB 5.0.04 on MS SQL 7.0? We're running against MS SQL 6.5 >and are considering upgrading to take advantage of some of the new features. >Are there new SQL drivers available or required?...

Oracle 8.0.5 and PB 5.0.04 connection
Hi All! My company wants to migrate to Oracle 8.0.5 but we will have PB 5.0.04 apps running on Win95 and NT clients. PB 5.0.04 contains only beta version of PBOR8050.dll which I would not like to use (we are talking thousands of users worlwide). Technote 47630 does not offer anything for Oracle 8.0.5. So, is there PB native driver (non beta) for PB 5.0.04 to talk to Oracle 8.0.5 ? Thank you No. But you can use the O73 driver, aslong as you don't need any specific Oracle8 functionality -- Terry Dykstra (TeamPS) Canadian Forest Oil Ltd. Gary Vashkulat wrote in me...

No Connect with FF 2.0.0.5 and TB 2.0.0.5
Name: Matze Email: infoatpc-scenedotnet Product: Firefox Summary: No Connect with FF 2.0.0.5 and TB 2.0.0.5 Comments: Hello, I have problems with Firefox 2.0.0.5 and Thunderbird. As soon as this version is not installed comes I any longer into Internet. No connection is indicated with both. 2.0.0.4 runs without problems up to the update on 0.5 Does someone know somewhat about an error?? MfG Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3 ...

Connection to MS SQL Server 7.0 with PB application built in 5.5.04
FYI.... I am in the process of upgrade an application database from MS SQL server 6.0 to 7.0 and I would like to know if there is a driver download that I can get so that I don't have to also upgrade the application as well. Is a database driver download available? It there is, where do I get it from? Thanks for the help. (My gut feeling is that the application will also have to be upgrade for the new native driver... Please say I am wrong) .......Shane Hi Shane, MS 7 does not have a native driver...

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

0.0.0.0 ????
Obviously a local IP, but what are its functions/purpose? Thanks for educating the uneducated. In article <MPG.18bf7ade16e851cb989680@news.grc.com>, shr@p.com says... > > > Obviously a local IP, but what are its functions/purpose? > > Thanks for educating the uneducated. > Any available adapter - i.e. not bound to specific IP address. -- Bloated Elvis In article <MPG.18bf7ade16e851cb989680@news.grc.com>, shr@p.com says... > > > Obviously a local IP, but what are its functions/purpose? > > Thanks for educating the une...

0.0.0.0
Can someone tell me the function of this scan? FWIN,2001/08/28,20:06:43 -6:00 GMT,0.0.0.0:800,255.255.255.255:800,UDP "Ben" <notben@home.com> wrote in message news:9mhion$2hf9$1@news.grc.com... > Can someone tell me the function of this scan? > FWIN,2001/08/28,20:06:43 -6:00 GMT,0.0.0.0:800,255.255.255.255:800,UDP Ben, I haven't a clue. 800 TCP mdbs_daemon 800 UDP mdbs_daemon http://www.robertgraham.com/pubs/firewall-seen.html http://www.robertgraham.com/pubs/firewall-seen.html#3.6 http://www.robertgraham.com/pubs/firewall-seen.html#3.2 -- ...

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

PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files
PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files. Compiled program running on the Win98 without MS SQL 7.0 client application installed. I can not get the DB connection by using external ip address like "202.199.12.12", but for internal ip address "10.4.32.2" which is one of our intranet ip address, it works well. The error is "unable to find SQL Server or SQL Server unvaliable". Both of the two ip adresses are associated with the same DB Server. Thanks ...

Powerbuilder 5.0/7.0 and MS SQL 7.0 Performance issues
We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app in PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0. Now we are migrating the database from MS SQL 6.5 to 7.0 SP2. We successfully converted the databases in a testing environment, but now the app runs terribly slow! I don't think it's a hardware issue -- the test box is a Compaq 8500 quad Xeon 500 w/1GB Ram. We experimented running the app as a PB 5.0 app against MS SQL 7.0 and the problem is the same. When we execute SQL directly against the DB outside of PB, we see no perf...

PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files #2
PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files. Compiled program running on the Win98 without MS SQL 7.0 client application installed. I can not get the DB connection by using external ip address like "202.199.12.12", but for internal ip address "10.4.32.2" which is one of our intranet ip address, it works well. The error is "unable to find SQL Server or SQL Server unvaliable". Thanks ...

Web resources about - Urgent!!Connecting to MS SQL Server7.0 with PB 5.0.04 on NT4.0 - sybase.powerbuilder.connection

Connecting rod - Wikipedia, the free encyclopedia
In a reciprocating piston engine , the connecting rod or conrod connects the piston to the crank or crankshaft . Together with the crank, they ...

COVER BOY: Dec. 15 Issue of ‘Time’ Features Mark Zuckerberg on Connecting the World
The cover of the Dec. 15 issue of Time features a familiar face — that of Facebook co-founder and CEO Mark Zuckerberg , the star of a long feature ...

Digital Media Wire - connecting people & knowledge —
dmwnews : Anomaly, the ambitious graphic novel by Brittenham and Haberlin, features augmented reality. http://bit.ly/Iwrxjr Already optioned ...

Connecting People to Brands and Products on Mobile
People come to Facebook not only to connect with friends and family but also with products and brands. Here's how we're making it easier to list ...

What stops users from connecting with an app through Facebook?
... This equals 850 million users who connect with apps using Facebook at a 59 percent conversion rate. About 590 million users back out of connecting ...

Home - WHLT 22 Connecting the Pine Belt Fan
Facebook is a social utility that connects people with friends and others who work, study and live around them. People use Facebook to keep up ...

US IT Staffing Recruiters Group - Connecting Ideas !
US IT Recruiter's Groups: IT Technical Recruitment. Its all about connecting to new Ideas !

Cold Christmas Bubbles - A Cool Connecting Dots Puzzle for Kids on the App Store on iTunes
Get Cold Christmas Bubbles - A Cool Connecting Dots Puzzle for Kids on the App Store. See screenshots and ratings, and read customer reviews. ...

Connecting a Relay to Arduino - Flickr - Photo Sharing!
Simple circuit to connect a 5V relay to one of the digital output pins of the Arduino. I drew this after a few threads showed up on the Arduino ...

Evidence Connecting Scott Roeder to Operation Rescue Found in Roder's Car - YouTube
Rachel Maddow unveils video evidence from KMBC TV in Kansas City of a note found in Scott Roeder's car at the time of his arrest for the murder ...

Resources last updated: 1/18/2016 5:49:51 PM