SQL ODBC problem

John Pierce john at pierce.name
Wed Dec 14 01:17:44 UTC 2005


Maybe try

ODBCConnection toSqlServer: 'mySql' database: 'myDatabase' user: ''
password: ''

to get your windows logon to pass through. I seem to remember it working
this way.

John


On 12/13/05, Marcus Pedersén <marcus.pedersen at comhem.se> wrote:
>
> I have downloaded ODBCEnhancement and tried but I run in to another
> problem.
> I use Windows Authentication for login on my SQL and even though I use
> message
> ODBCConnection toSqlServer: 'mySql' database: 'myDatabase'
> user: 'myWindowsUsername' password: 'myWindowsPassword'
> I still get an error that says that it's: "not associated with a trusted
> SQL
> Server connection".
> Thanks alot for the help!
> Marcus
>
> ----- Original Message -----
> From: "Ramon Leon" <rleon at insario.com>
> To: "The general-purpose Squeak developers list"
> <squeak-dev at lists.squeakfoundation.org>
> Sent: Tuesday, December 13, 2005 12:12 AM
> Subject: RE: SQL ODBC problem
>
>
> > I found my FFI, somehow it got lost in a copy paste session.
> > So it was originaly included in the download.
> > Sorry for the trouble!
> > Another questuion though, as I'm new to connect to SQL I of
> > cause ran in to a new problem. (I have just used DBMS to get
> > info out of SQL db).
> > As you use the ODBCConnection class message dsn: user: password:
> > to astablish a connection to your sql, is there a specific
> > way to write the dsn?
> > I get an error saying "Data sourse name not found and no
> > default driver specified".
> > In dsn: I have written the name on my SQL-server. Do I have
> > to include the specific db that I intend to read from and how
> > about them drivers?
> > I use MS SQL!
> > Many many thanks!
> >  Marcus
>
> You need to either create an ODBC entry on the host server, or load the
> ODBCEnhancement package that will allow DSNless connections to
> SqlServer.
>
>
>
>
>


--
It's easy to have a complicated idea. It's very very hard to have a simple
idea. -- Carver Mead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeak-dev/attachments/20051213/fb3bba9e/attachment.htm


More information about the Squeak-dev mailing list