Groups | Blog | Home
all groups > sql server odbc > september 2003 >

sql server odbc : 16 bits odbc for SQL Server


Fabian Castro
9/29/2003 8:10:14 AM
I have migrated a database from watcom 4.0(f) to a MS-SQL
server 7.0 running on a NT 4.0 service pack 6.0

Now, I am trying to get in with its current 16-bits
powerbuilder 4.0 (4.0.06) application.

According with an article I found at
http://www.sybase.com.cn/cn/content/support/exp_jszc_pb_dbm
s_00007.htm
I should have MSDBLIB3.DLL odbc library from microsoft and
PBMSS050.DLL from powersoft installed.

I have looked for them almost every web... and couldn't
find MSDBLIB3.DLL?

Finally, my obstacle is that I don't have a 16-bits odbc
for SQL Server 7.0. and can't compile the application on
the expensive further powerbuilder versions I don't have.

Could you give me a hand? It would be very wellcome,

Thanks,

Fabian Castro
Neil Pike
9/30/2003 7:24:55 AM
Fabian,

This was last shipped with SQL 6.5. So try downloading a SQL 6.5
servicepack...

[quoted text, click to view]

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
Fabian Castro
9/30/2003 8:36:52 AM
Hi Neil, thanks for your advice.

I have already found the MSDBLIB3.DLL?, as a matter of
fact the whole mdac 2.1 in sql 6.5 Service Pack 5.0 which
comes with the SQL 7.0 cd. SO I installed the mdac 2.1 on
the client hoping that the odbc driver MSDBLIB3.DLL would
be installed. However since this service pack the odbc
driver used by sql server is sqlsrv32.dll -32 bits-, which
is the one 7.0 also use.

Then I decided to change -by hand- the .dll in c:\windows
system and the information on the registry file. It would
have been nice.....of course it didn't work.

Now I'm searching for an old sql server 6.5 or a service
pack and will try to install its mdac.

Do you know when can I stil find something like that?

Thanks again,

fabian


[quoted text, click to view]
Fabian Castro
10/1/2003 3:26:34 PM
Hi Neil,

thanks again for your time. Take a look:

I went trough it

[quoted text, click to view]

I found the 65sp5, I've already had, and several others
from 65sp2 --> 65sp4.

The client odbc drivers -MDAC 2.1- which comes with sp5a
is actually the first release of its kind. So there is a
way to install it separately from the whole Service pack.
There is a runtime file provided for it. I have already
done this, when I was trying to get back to the old odbc
versions. "unfortunataley" its libraries already came
working at 32-bits.

It seems to me that to install the 16 bits odbc -client
side- I need one of the not longer supported MS SQL Server
versions. Looking at the sp2 --> sp4 I download from the
ftp source, I should applied them on the Server -the
setup.inf tells that, thoug I tried --> I failed. So the
files related to the client-side -such as odbc libraries-
have to be overwrite on the client. But I don't have the
old client installed.

Ummm, just wondering who I'm going to get one of these
unsopported things! Even when the company has its MS sql
Server 7.0 licensed on a Back office package it doesn't
look an easy way to go trough.

So far, baying a PowerBuilder license -Professional or
enterprise- for more than U$10,000 doesn't look fear when
all you need is to compile an application that is already
working.

So I will start a champaing for the well done yesterday's
16-bits applications that need a today's database.
Just kiding!

I really appreciate your advices my friend and if there is
more I will go for it. I am learning more than I thougt
and that's really great.

thanks

fabianc.

[quoted text, click to view]
Neil Pike
10/1/2003 4:13:09 PM
Fabian,

Try ftp.microsoft.com/bussys/sql

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
AddThis Social Bookmark Button