Connect to MS SQL

Hi everyone,
I am interested in connecting VisualWorks to MS SQL Server. What would be the best way to do that?
Thanks,
David
SageTea, The Smart Solution
http://sageteagroup.com
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

1. Do,
Parcel loadParcelByName: 'ODBCEXDI'.

2. Inspect,
connection := ODBCConnection new.
connection environment: 'DRIVER={SQL Server Native Client
10.0};DATABASE=TestDatabase;UID=TestLogin;PWD=TestPassword;SERVER=(local
)\SQL2012CTP3;'.
connection connect.
session := connection getSession.
session
        prepare: 'SELECT 1';
        execute;
        answer.

3. Use Glorp.

HTH,

-Boris

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On
Behalf Of David Long, CEO, SageTea Group
Sent: Saturday, May 26, 2012 1:23 PM
To: [hidden email]
Subject: [vwnc] Connect to MS SQL

Hi everyone,
I am interested in connecting VisualWorks to MS SQL Server. What would
be the best way to do that?
Thanks,
David
SageTea, The Smart Solution
http://sageteagroup.com
_______________________________________________
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

Cool, will give it a shot, thanks Boris.

regards,
David
On 26/05/2012 1:28 PM, Boris Popov, DeepCove Labs wrote:

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

Hi Boris,

it seems to be getting stuck on a nil password when I try it from
Smalltalk.

I have a different program called DatAdmin here that can connect to it
no problem.

What DatAdmin did though is use this as the data source:

C:\Users\User\AppData\Roaming\DatAdmin\data\Data Source=SVR-DEV;User
ID=xxx;password=xxx;Initial Catalog=xxxDB;Max Pool Size = 200;

I can see DatAdmin put file in its directory that has this as the contents:

<Connection type="mssql" adtype="driver">
  <Authentization>sql</Authentization>
  <DataSource>svr-dev</DataSource>
  <Login>xxx</Login>
  <Password>xxx</Password>
  <DatabaseMode>all</DatabaseMode>
  <DataTreeName>data source=svr-dev;user id=xxx;password=xxx;initial
catalog=xxxdb;max pool size = 200;.con</DataTreeName>
</Connection>

I haven't been able to get it to go from Smalltalk though when I try and
put in the parameters in the string you sent. Based on this info, is
there some change I need to make to the environment string to get the
ODBC connection class to do the same thing?

If I can get Smalltalk to connect to MS SQL server - that would be quite
cool. Please let me know what you think..

thanks,

David




On 26/05/2012 1:28 PM, Boris Popov, DeepCove Labs wrote:

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

Hi Boris,

it seems to be getting stuck on a nil password when I try it from
Smalltalk.

I have a different program called DatAdmin here that can connect to it
no problem.

What DatAdmin did though is use this as the data source:

C:\Users\User\AppData\Roaming\DatAdmin\data\Data Source=SVR-DEV;User
ID=xxx;password=xxx;Initial Catalog=xxxDB;Max Pool Size = 200;

I can see DatAdmin put file in its directory that has this as the contents:

<Connection type="mssql" adtype="driver">
  <Authentization>sql</Authentization>
  <DataSource>svr-dev</DataSource>
  <Login>xxx</Login>
  <Password>xxx</Password>
  <DatabaseMode>all</DatabaseMode>
  <DataTreeName>data source=svr-dev;user id=xxx;password=xxx;initial
catalog=xxxdb;max pool size = 200;.con</DataTreeName>
</Connection>

I haven't been able to get it to go from Smalltalk though when I try and
put in the parameters in the string you sent. Based on this info, is
there some change I need to make to the environment string to get the
ODBC connection class to do the same thing?

If I can get Smalltalk to connect to MS SQL server - that would be quite
cool. Please let me know what you think..

thanks,

David

On 26/05/2012 1:28 PM, Boris Popov, DeepCove Labs wrote:

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

David,

There's only so much we can do to help out via email, please see "ODBC
Driver Connection String Keywords" section in the below document,

http://msdn.microsoft.com/en-us/library/ms130822(v=sql.105).aspx

Given there's an ODBC source defined in your system for this
application, you're likely going to need to use something along the
lines of the below as your connection string (translating OLE DB
settings into matching ODBC names),

DSN=svr-dev;Database=xxxDB;UID=xxx;PWD=xxx;

Another helpful resource is the following,

http://www.connectionstrings.com/sql-server-2008

HTH,

-Boris

-----Original Message-----
From: David Long [mailto:[hidden email]]
Sent: Monday, May 28, 2012 9:15 AM
To: Boris Popov, DeepCove Labs; Tom Naujokas; [hidden email]
Subject: Re: [vwnc] Connect to MS SQL

Hi Boris,

it seems to be getting stuck on a nil password when I try it from
Smalltalk.

I have a different program called DatAdmin here that can connect to it
no problem.

What DatAdmin did though is use this as the data source:

C:\Users\User\AppData\Roaming\DatAdmin\data\Data Source=SVR-DEV;User
ID=xxx;password=xxx;Initial Catalog=xxxDB;Max Pool Size = 200;

I can see DatAdmin put file in its directory that has this as the
contents:

<Connection type="mssql" adtype="driver">
  <Authentization>sql</Authentization>
  <DataSource>svr-dev</DataSource>
  <Login>xxx</Login>
  <Password>xxx</Password>
  <DatabaseMode>all</DatabaseMode>
  <DataTreeName>data source=svr-dev;user id=xxx;password=xxx;initial
catalog=xxxdb;max pool size = 200;.con</DataTreeName> </Connection>

I haven't been able to get it to go from Smalltalk though when I try and
put in the parameters in the string you sent. Based on this info, is
there some change I need to make to the environment string to get the
ODBC connection class to do the same thing?


If I can get Smalltalk to connect to MS SQL server - that would be quite
cool. Please let me know what you think..

thanks,

David




On 26/05/2012 1:28 PM, Boris Popov, DeepCove Labs wrote:
> be the best way to do that?
> Thanks,
> David
> SageTea, The Smart Solution
> http://sageteagroup.com
> _______________________________________________
> 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

Ok, I was able to get in by using Glorp MS_SQLServerConnection and by
setting up a local DSN in Windows 7.

thanks for the help,

David

On 26/05/2012 1:28 PM, Boris Popov, DeepCove Labs wrote:

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

This is the sql server connect string I use:
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Dear David,

>it seems to be getting stuck on a nil password when I try it from
>Smalltalk.
>
Just in case it is relevant:  a Glorp Login has a 'secure' instVar that
defaults to true.  When it is true, the password is nilled after its
first use - see the implementation in Login>>password.  If you want to
reuse a Login and/or are unconcerned about the password persisting in
your image, set secure to false.

                Yours faithfully
                      Niall Ross

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