I am having so many problems trying to connect to a SQL Server db via my Mac. I'm using DSN-less connections.

I know the connection string works because I havr no connection problems on a pc.

Is there anyone out there who uses a Mac who can help me????

Thank you in advance...

Andrea

hey, i had problems with sql server also. try this connection string, but change it in web.confing file. here is two one is to my local sqlserver and the other is to a remote on the network. hope this helps<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<pre id=code><font face=courier size=2 id=code>
&lt;appSettings&gt;
&lt;add key="MM_CONNECTION_HANDLER_connStr" value="sqlserver.htm" /&gt;
&lt;add key="MM_CONNECTION_STRING_connStr" value="Trusted_Connection=yes;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Userarea;Data Source=Userarea;workstation id=user-601455" /&gt;
&lt;add key="MM_CONNECTION_DATABASETYPE_connStr" value="SQLServer" /&gt;
&lt;add key="MM_CONNECTION_SCHEMA_connStr" value="" /&gt;
&lt;add key="MM_CONNECTION_CATALOG_connStr" value="" /&gt;
&lt;add key="MM_CONNECTION_HANDLER_connlocal" value="sqlserver.htm" /&gt;
&lt;add key="MM_CONNECTION_STRING_connlocal" value="Trusted_Connection=yes;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=(local);workstation id=user-601455" /&gt;
&lt;add key="MM_CONNECTION_DATABASETYPE_connlocal" value="SQLServer" /&gt;
&lt;add key="MM_CONNECTION_SCHEMA_connlocal" value="" /&gt;
&lt;add key="MM_CONNECTION_CATALOG_connlocal" value="" /&gt;
&lt;/appSettings&gt;
</font id=code></pre id=code>

leave out the workstation id if your not on a network.

Edited by - crstratton on 13 Jun 2003 02:00:30

Thank you so much for your response.

Pardon my ignorance, but what web.config file are you talking about? Does this go in my connections .asp file?

Thanks again.

Andrea

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
ok, so you are using asp and not asp.net. this is what I have used for asp for sqlserver. if this does not work?

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> <pre id=code><font face=courier size=2 id=code>&lt;%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_ConnUserarea_STRING
MM_ConnUserarea_STRING = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Userarea;Data Source=Userarea;workstation id=user-601455"
%&gt;
</font id=code></pre id=code>