Visualworks and native connection to SQL Server

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
ron
Reply | Threaded
Open this post in threaded view
|

Visualworks and native connection to SQL Server

ron
Hi,
 
On this link (http://www.cincomsmalltalk.com/userblogs/cincom/blogView?content=vwfactsheet) it says that "VisualWorks supports connectivity via ODBC, and via native connections to Oracle, Sybase, SQL Server, PostgreSQL, MySQL, and DB/2 "
 
Which parcel do I have to use to get a native connection to SQL Server?
 
Regards,
 
Ron
 
 
 
 
De informatie verzonden met dit emailbericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Afzender staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden email, noch voor tijdige ontvangst daarvan. Afzender attendeert erop dat de vertrouwelijkheid van informatie verzonden per email niet gewaarborgd is.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Sender is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Please note that the confidentiality of e-mail communication is not warranted.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: Visualworks and native connection to SQL Server

Boris Popov, DeepCove Labs (SNN)
That's not accurate. VisualWorks uses ODBC to connect to SQL Server, but Microsoft calls their driver SQL Native Client as of late. Go figure.

Sent from my iPhone

On 2011-03-31, at 7:54, "Ron Dobbelstein" <[hidden email]> wrote:

Hi,
 
On this link (http://www.cincomsmalltalk.com/userblogs/cincom/blogView?content=vwfactsheet) it says that "VisualWorks supports connectivity via ODBC, and via native connections to Oracle, Sybase, SQL Server, PostgreSQL, MySQL, and DB/2 "
 
Which parcel do I have to use to get a native connection to SQL Server?
 
Regards,
 
Ron
 
 
 
 
De informatie verzonden met dit emailbericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Afzender staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden email, noch voor tijdige ontvangst daarvan. Afzender attendeert erop dat de vertrouwelijkheid van informatie verzonden per email niet gewaarborgd is.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Sender is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Please note that the confidentiality of e-mail communication is not warranted.
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: Visualworks and native connection to SQL Server

Joerg Beekmann, DeepCove Labs (YVR)

I suspect ODBC **is** the native connectivity mechanism for SQL Server now. In that case both statements are correct.

 

Joerg

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Boris Popov, DeepCove Labs
Sent: Thursday, March 31, 2011 4:57 AM
To: Ron Dobbelstein
Cc: [hidden email]
Subject: Re: [vwnc] Visualworks and native connection to SQL Server

 

That's not accurate. VisualWorks uses ODBC to connect to SQL Server, but Microsoft calls their driver SQL Native Client as of late. Go figure.

Sent from my iPhone


On 2011-03-31, at 7:54, "Ron Dobbelstein" <[hidden email]> wrote:

Hi,

 

On this link (http://www.cincomsmalltalk.com/userblogs/cincom/blogView?content=vwfactsheet) it says that "VisualWorks supports connectivity via ODBC, and via native connections to Oracle, Sybase, SQL Server, PostgreSQL, MySQL, and DB/2 "

 

Which parcel do I have to use to get a native connection to SQL Server?

 

Regards,

 

Ron

 

 

 

 

De informatie verzonden met dit emailbericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Afzender staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden email, noch voor tijdige ontvangst daarvan. Afzender attendeert erop dat de vertrouwelijkheid van informatie verzonden per email niet gewaarborgd is.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Sender is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Please note that the confidentiality of e-mail communication is not warranted.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: Visualworks and native connection to SQL Server

Wallen, David

Also, I believe that you can select either SQL Server Native Client or “regular” SQL Server Client when you create your ODBC DSN via the control panel. At least that was how it worked around a year or so ago. For VW,  the main difference offhand is the newer varchar(max) column types.

 

- Dave

 


From: [hidden email] [mailto:[hidden email]] On Behalf Of Joerg Beekmann, DeepCove Labs
Sent: Thursday, March 31, 2011 8:33 AM
To: Boris Popov, DeepCove Labs; Ron Dobbelstein
Cc: [hidden email]
Subject: Re: [vwnc] Visualworks and native connection to SQL Server

 

I suspect ODBC **is** the native connectivity mechanism for SQL Server now. In that case both statements are correct.

 

Joerg

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Boris Popov, DeepCove Labs
Sent: Thursday, March 31, 2011 4:57 AM
To: Ron Dobbelstein
Cc: [hidden email]
Subject: Re: [vwnc] Visualworks and native connection to SQL Server

 

That's not accurate. VisualWorks uses ODBC to connect to SQL Server, but Microsoft calls their driver SQL Native Client as of late. Go figure.

Sent from my iPhone


On 2011-03-31, at 7:54, "Ron Dobbelstein" <[hidden email]> wrote:

Hi,

 

On this link (http://www.cincomsmalltalk.com/userblogs/cincom/blogView?content=vwfactsheet) it says that "VisualWorks supports connectivity via ODBC, and via native connections to Oracle, Sybase, SQL Server, PostgreSQL, MySQL, and DB/2 "

 

Which parcel do I have to use to get a native connection to SQL Server?

 

Regards,

 

Ron

 

 

 

 

De informatie verzonden met dit emailbericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Afzender staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden email, noch voor tijdige ontvangst daarvan. Afzender attendeert erop dat de vertrouwelijkheid van informatie verzonden per email niet gewaarborgd is.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Sender is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Please note that the confidentiality of e-mail communication is not warranted.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: Visualworks and native connection to SQL Server

Boris Popov, DeepCove Labs (SNN)

Yes, we’re using SQL Server Native Client 10.0 from SQL Server 2008 R2 Feature Pack at the moment without any issues.

 

As a side note, there is no longer a need to create ODBC DNSs in the control panel as full ODBC string can be specified from within VisualWorks’ connection profile AFAIK.

 

-Boris

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Wallen, David
Sent: Thursday, March 31, 2011 12:44 PM
To: [hidden email]
Subject: Re: [vwnc] Visualworks and native connection to SQL Server

 

Also, I believe that you can select either SQL Server Native Client or “regular” SQL Server Client when you create your ODBC DSN via the control panel. At least that was how it worked around a year or so ago. For VW,  the main difference offhand is the newer varchar(max) column types.

 

- Dave

 


From: [hidden email] [mailto:[hidden email]] On Behalf Of Joerg Beekmann, DeepCove Labs
Sent: Thursday, March 31, 2011 8:33 AM
To: Boris Popov, DeepCove Labs; Ron Dobbelstein
Cc: [hidden email]
Subject: Re: [vwnc] Visualworks and native connection to SQL Server

 

I suspect ODBC **is** the native connectivity mechanism for SQL Server now. In that case both statements are correct.

 

Joerg

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Boris Popov, DeepCove Labs
Sent: Thursday, March 31, 2011 4:57 AM
To: Ron Dobbelstein
Cc: [hidden email]
Subject: Re: [vwnc] Visualworks and native connection to SQL Server

 

That's not accurate. VisualWorks uses ODBC to connect to SQL Server, but Microsoft calls their driver SQL Native Client as of late. Go figure.

Sent from my iPhone


On 2011-03-31, at 7:54, "Ron Dobbelstein" <[hidden email]> wrote:

Hi,

 

On this link (http://www.cincomsmalltalk.com/userblogs/cincom/blogView?content=vwfactsheet) it says that "VisualWorks supports connectivity via ODBC, and via native connections to Oracle, Sybase, SQL Server, PostgreSQL, MySQL, and DB/2 "

 

Which parcel do I have to use to get a native connection to SQL Server?

 

Regards,

 

Ron

 

 

 

 

De informatie verzonden met dit emailbericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Afzender staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden email, noch voor tijdige ontvangst daarvan. Afzender attendeert erop dat de vertrouwelijkheid van informatie verzonden per email niet gewaarborgd is.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Sender is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Please note that the confidentiality of e-mail communication is not warranted.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc