Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GerhadKreuzer
Starting Member
5 Posts |
 Posted - 2008-10-16 : 09:59:06
|
| Hi,I have an old database which is a Access 2.0 file which is accessed from a VB3.0 application. Since ODBC was available, I am able to put the data into a SQL Server instead of using the Access 2.0 file. Which of the SQL Se´rver versions are able to talk with an old 16 bit application??Thanks for helpingGerhard |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-10-16 : 10:50:19
|
vb3? wow!!i guess you'd need 16 bit ODBC drivers and the 16 Bit ODBC framework.then in th eControl panel you'll have to create a dsn file for the sql server.i think this is how it should be done... haven't done any 16 bit dev in a looooong time  _______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
GerhadKreuzer
Starting Member
5 Posts |
Posted - 2008-10-16 : 13:06:36
|
| Hi,yes, I know, but I also see some posts, that the SQL2000 SP3 breaks the 16 bit connectivity and more of this, so I went to a forom which explicitly target SQL Server, hoping, that some of you can show me a 'short and painless way' do do it, or tell me, that there is no chance at all.The problem is, that the mdb-file is shared by 4 workstations and I want to use a network attached storage box with a raid system to bring in more safety.But after moving the file, I get some strange errors and as far as I can see, this third party box didnt know anything about microsofts VSHARE.vxd, a virtual device which supports sharing of resources. Something must be very special, which is gone after bringing in the box.If I can bring the date to some kind of SQL Server, I not only solve this problem, I also dramatically speed up the system, because the selects and joins are made on client side now!!And its only a intermediate solution until the new solution is ready.Thanks for helpingGerhard |
|
|
|
|
|
|
|
|
Connect SQL Server (which version) from VB3