connection string

[Guest_imported]

my connection is all wrong how do i fix this?





Session.timeout = 60

If IsObject(Session("cpedis1_conn&quot) Then
Set conn = Session("cpedis1_conn&quot
Else
Set conn = Server.CreateObject("ADODB.Connection&quot
conn.open "driver=SQL
Server;server=cpmicro1;UID=laker; PWD=zoloft;database=30c"
Set Session("cpedis1_conn&quot = conn
End If
%>
<%
If IsObject(Session(&quot;Equipment_Listing_rs&quot) Then
Set rs = Session(&quot;Equipment_Listing_rs&quot
Else
sql = &quot;SELECT * FROM [Equipment Listing]&quot;
Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot
rs.Open sql, conn, 3, 3
If rs.eof Then
rs.AddNew
End If
Set Session(&quot;Equipment_Listing_rs&quot = rs
End If
%>

 

[codestorm]

Put curly brackets around the driver
ie driver={SQL Server} codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[Guest_imported]

ok done that. what else?

 

[arya009]

Try

conn.open &quot;driver=SQLOLEDB.1;....&quot;

 

[DougP]

arya009

To keep the smiley face out of your response turn of the &quot;Emotions/Smileys&quot; located at the bottom of this reply in &quot;Step 2 Options&quot;
DougP, MCP