Maybe try <br><br>ODBCConnection toSqlServer: 'mySql' database: 'myDatabase' user: '' password: ''<br><br>to get your windows logon to pass through. I seem to remember it working this way.<br><br>John<br><br><br><div><span class="gmail_quote">
On 12/13/05, <b class="gmail_sendername">Marcus Pedersén</b> <<a href="mailto:marcus.pedersen@comhem.se">marcus.pedersen@comhem.se</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I have downloaded ODBCEnhancement and tried but I run in to another problem.<br>I use Windows Authentication for login on my SQL and even though I use<br>message<br>ODBCConnection toSqlServer: 'mySql' database: 'myDatabase'
<br>user: 'myWindowsUsername' password: 'myWindowsPassword'<br>I still get an error that says that it's: "not associated with a trusted SQL<br>Server connection".<br>Thanks alot for the help!<br>Marcus<br><br>----- Original Message -----
<br>From: "Ramon Leon" <<a href="mailto:rleon@insario.com">rleon@insario.com</a>><br>To: "The general-purpose Squeak developers list"<br><<a href="mailto:squeak-dev@lists.squeakfoundation.org">
squeak-dev@lists.squeakfoundation.org</a>><br>Sent: Tuesday, December 13, 2005 12:12 AM<br>Subject: RE: SQL ODBC problem<br><br><br>> I found my FFI, somehow it got lost in a copy paste session.<br>> So it was originaly included in the download.
<br>> Sorry for the trouble!<br>> Another questuion though, as I'm new to connect to SQL I of<br>> cause ran in to a new problem. (I have just used DBMS to get<br>> info out of SQL db).<br>> As you use the ODBCConnection class message dsn: user: password:
<br>> to astablish a connection to your sql, is there a specific<br>> way to write the dsn?<br>> I get an error saying "Data sourse name not found and no<br>> default driver specified".<br>> In dsn: I have written the name on my SQL-server. Do I have
<br>> to include the specific db that I intend to read from and how<br>> about them drivers?<br>> I use MS SQL!<br>> Many many thanks!<br>> Marcus<br><br>You need to either create an ODBC entry on the host server, or load the
<br>ODBCEnhancement package that will allow DSNless connections to<br>SqlServer.<br><br><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>It's easy to have a complicated idea. It's very very hard to have a simple idea. -- Carver Mead