SQL Server native support

VA Smalltalk is a "100% VisualAge compatible" IDE that includes the original VisualAge technology and the popular VA Assist and WidgetKit add-ons.

Moderators: Eric Clayberg, wembley, tc, Diane Engles, solveig

SQL Server native support

Postby Rakesh » Thu Oct 22, 2009 12:41 pm

Are there any goodies or packages that support SQL Server 2005/2008 native client? We would like to use the XML datatype capabilities of SQL Server. However, this is not supported by the default ODBC driver - odbc32.dll. Could it be as simple as updating the ini file to reference the new SQL native client DLL and updating/adding a few methods?
Rakesh
 
Posts: 5
Joined: Thu Oct 22, 2009 12:20 pm

Re: SQL Server native support

Postby tc » Thu Oct 22, 2009 10:08 pm

Hello,

Usually, native DB support requires calls into the vendor's DLL which is a large task because one has to make sure parameters are passed in and read out correctly.

It seems to me that Unity Software sold native SQL Server support years ago.

--tc
tc
Moderator
 
Posts: 304
Joined: Tue Oct 17, 2006 7:40 am
Location: Raleigh, NC

Re: SQL Server native support

Postby Rakesh » Fri Oct 23, 2009 8:53 am

Unity software link seems to be outdated...takes me where I don't want to go anymore :)
Rakesh
 
Posts: 5
Joined: Thu Oct 22, 2009 12:20 pm

Re: SQL Server native support

Postby tc » Fri Oct 23, 2009 11:03 am

Hello,

Yes, bad link, but this one works http://www.unitysoftware.com/, and click on 'Database Drivers' under 'Products'.

--tc
tc
Moderator
 
Posts: 304
Joined: Tue Oct 17, 2006 7:40 am
Location: Raleigh, NC

Re: SQL Server native support

Postby Rakesh » Fri Oct 23, 2009 1:32 pm

Thanks
Rakesh
 
Posts: 5
Joined: Thu Oct 22, 2009 12:20 pm

Re: SQL Server native support

Postby louis_andriese » Sun Oct 25, 2009 6:09 am

Rakesh,

if you have any luck obtaining the drivers (I've mailed Unity a year ago and never got a reply) please post your experiences with them. I'm very interested in "native" mssql connectivity.

Kind regards,

Louis
louis_andriese
 
Posts: 20
Joined: Thu Dec 13, 2007 5:19 am
Location: Waalwijk, The Netherlands

Re: SQL Server native support

Postby Rakesh » Fri Oct 30, 2009 8:59 am

I am not sure if Unity Software is in business. All emails have bounced back from both domains unity-software.com and unitysoftware.com. The phone number seems to be disconnected too, with no forwarding information.
Tough.
Rakesh
 
Posts: 5
Joined: Thu Oct 22, 2009 12:20 pm


Return to VA Smalltalk 7.0, 7.5 & 8.0

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest