ODBC error "Program type out of range" , SQL State S1003 : PB6.0--->MS SQL Server7.0 on WIN NT4.0

Hi,

I have installed SQL Server 7.0 Standard Ed. on Windows NT 4.0 with Service
Pack 4.

Then I installed Power Builder 6.0 Enterprise Ed. on the same server machine
NT 4.0 + SQL Server 7.0

After defining an ODBC DSN and Profile in PB 6.0, when i try to connect from
within Profile setup, it connects to the SQL Server 7.0 Database. But when i
click on the Tables or Database icons on the toolbar to open the DB or
tables, I get an error message like

SQLSTATE =S1003
[MICROSOFT] [ODBC DRIVER MANAGER] Program Type Out of Range

The same type of profile & ODBC settings on the Win95 and Win98 clients
doesn't give any problems..



Can somebody suggest a solution..

Thanx

T. Sivakumar
HCL Infosystems Ltd., Coimbatore
tshiv@hotmail.com or hclpso@vsnl.com





0
hclpso
3/3/1999 3:28:07 PM
sybase.powerbuilder.connection 3893 articles. 0 followers. Follow

1 Replies
1018 Views

Similar Articles

[PageSpeed] 5

Please review postings within the last day or two, I've put the URL there for a
fix.

Jim O'Neil
Sybase Technical Support

hclpso wrote:

> Hi,
>
> I have installed SQL Server 7.0 Standard Ed. on Windows NT 4.0 with Service
> Pack 4.
>
> Then I installed Power Builder 6.0 Enterprise Ed. on the same server machine
> NT 4.0 + SQL Server 7.0
>
> After defining an ODBC DSN and Profile in PB 6.0, when i try to connect from
> within Profile setup, it connects to the SQL Server 7.0 Database. But when i
> click on the Tables or Database icons on the toolbar to open the DB or
> tables, I get an error message like
>
> SQLSTATE =S1003
> [MICROSOFT] [ODBC DRIVER MANAGER] Program Type Out of Range
>
> The same type of profile & ODBC settings on the Win95 and Win98 clients
> doesn't give any problems..
>
> Can somebody suggest a solution..
>
> Thanx
>
> T. Sivakumar
> HCL Infosystems Ltd., Coimbatore
> tshiv@hotmail.com or hclpso@vsnl.com



0
Jim
3/3/1999 9:48:37 PM
Reply:

Similar Artilces:

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 The problem, at least with ODBC 3.x, is that ...

V5.0.4, "dbo." & MS-SQL 7.0
Does anyone know of a work-around for configuring MS-SQL 7.0 so that table names don't need [dbo].[tablename]? I have a customer application that was written against MS-SQL 6.5 that now has to be run against MS-SQL 7.0. On MS-SQL 6.5 the "dbo" was assumed and so all of the sql in this app has no owner prefix. Any help would be greatly appreciated, Dave Rae As a follow-up to my original message: 1) I am using the MS supplied SQL Server 7 ODBC driver for connectivity 2) I have to run the app using V5.0.4 3) When I use V7, any SQL that I modify to include the &...

[ 0.0.3562.0 ] ==> Using "isc.org" instead of "dotgov.gov"
Gang... We used to be using "windows.com" for characterization and testing. But it's not signed, so it can't be used for DNSSEC testing. So I switched over to "dotgov.gov" which *is* signed and which would likely be stable over the long term. But as we found out, for some bizarre reason, some resolvers don't "like" returning the IP of "dotgov.gov". So now I've switched over to "isc.org" ... which is signed and which most resolvers appear to like. I need to look into that "beanfield.net" resolv...

MS SQL 7.0 -> "Syntax error or access violation" w/DW arg
I'm just switching to MS SQL 7.0 (with PB 6.5.1). I'm connecting using the ODBC drivers installed from the MS SQL 7.0 CD. I have noticed that when I pass an argument to a datawindow where the argument is used in the SELECT clause, I get: [37000] [Microsoft][ODBC SQL Server Driver]Syntax error or access violation In its simplest form, the DW data source is: SELECT :RetArg FROM MyTable RetArg is defined as a string. Trying it as a string array yields a different error ("String data, right truncation"). Anybody know how to get around this? Please tr...

ODBC Error: MS SQL Server 7.0 + PB 6.0 +WINNT 4.0
Hi, I have installed SQL Server 7.0 Standard Ed. on Windows NT 4.0 with Service Pack 4. Then I installed Power Builder 6.0 Enterprise Ed. on the same server machine NT 4.0 + SQL Server 7.0 + PB 6.0 ( no patches for any thing installed) After defining an ODBC DSN and Profile in PB 6.0, when i try to connect from within Profile setup, it connects to the SQL Server 7.0 Database. But when i click on the Tables or Database icons on the toolbar to open the DB or tables, I get an error message like SQLSTATE =S1003 [MICROSOFT] [ODBC DRIVER MANAGER] Program Type Out of Range on the...

Upgrade DNN 3.0.13 -> 3.1.0 error: The type initializer for "DotNetNuke.Data.DataProvider" threw an exception
I tested the upgrade on a test system and worked fine. But now I have published the code to upgrade the production site and receive this following error:  Server Error in '/' Application. Value cannot be null. Parameter name: type Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentNullException: Value cannot be null. Parameter name: typeSource Error: An unhandled exception was generated during ...

Server error "<add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> "
 Any ideas how to resolve this?    Server Error in '/' Application. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The sys...

Is there a quick a dirty way of achieving border="0" cellpadding="0" cellspacing="0" for html tables?
As the question states... I have HTML tables all over the place and really want to avoid having to manually add border="0" cellpadding="0" cellspacing="0" for each of them, can I override this in CSS?   Any help would be greatly appreciated. Thanks. Declare a css class for the table with all these properties initialized. That will do the workThanks & RegardsJacobMark As Answer if this post Helped you  Yes, define a class in css:.table { padding: 0px; border: 0px; } The only trick will be adding class="table" to the...

[ 0.0.3557.0 ] ==> New CSV "Snapshot" Technology
Gang... I've just finished rewriting the CSV results exporter for this latest release: [ 0.0.3557.0 ] In an eMail communication with Paul (sparky) he noted that his CSV export has all "No"s in the "System Resolver" column. The network where he had been testing DNSB was WiFi linked and a bit flaky. The problem was that DNSB continually checks and rechecks the "localness" of all nameservers so that any changes the user makes in their system's configuration will be reflected on the fly. But this meant that there's some chance that t...

[ 0.0.3570.0 ] ==> "/domains" is now Unix compatible
Gang... I'm 100% caught up in the group and DNSB survived the catch-up pass with only a *single* small update ... fixing the text file parser of the replacement "/domains" list to accept either Unix format (line-feed delimited) lines, or Windows (CR/LF delimited) lines. -- ________________________________________________________________ Steve. Working on: GRC's DNS Benchmark utility: http://www.grc.com/dev/DNSBench.exe In article <MPG.253a7948dbf125be221c@4.79.142.203>, Steve Gibson <news07_@_grc.com> wrote: > Gang... > &...

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

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

what is the difference bettween string.Format("{0:#.##}", and string.Format("{0:0.00}"
they both seem to do the same thing, what is the difference functionality that # versus 0  ?    string.Format("{0:#.##}", mydecimal); string.Format("{0:0.00}", mydecimal); Look here: http://msdn2.microsoft.com/en-us/library/0c899ak8.aspx Hope it helps Hi, As far as I know, they both are different. 0.00 can remain the position all the time. For example, decimal is 0.1 and then it will return to you with 0.10 by 0.00 format. With #.##, it will cut the unnecessary position in the decimal. For example, decimal is 0.1 and then i...

Web resources about - ODBC error "Program type out of range" , SQL State S1003 : PB6.0--->MS SQL Server7.0 on WIN NT4.0 - sybase.powerbuilder.connection

Resources last updated: 1/21/2016 6:42:18 AM