SQL ODBC problem

Marcus Pedersén marcus.pedersen at comhem.se
Tue Dec 13 22:04:10 UTC 2005


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.






More information about the Squeak-dev mailing list