Driver's SQLSetConnectAttr failed???

[Michael]

I have the page set up with a form that tells ASPdb what table to show, and I keep it in a session variable, problem is when it is a new session. I am trying to set up a default table to show when it is a new session, but can't seem to get it to work, and I have never seen this error code before:
<---- ERROR ---->
Error # = 0
Description = [Microsoft][ODBC Driver Manager] Driver&#39;s SQLSetConnectAttr failed
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = IM006
NativeError = 0

<---- CODE ---->
<%
Set Admin=Server.CreateObject(&#34;ASPdb.Pro&#34
Admin.dbmdb=&#34;D:Websdatavolzcpa.mdb&#34;
Admin.DBColor = &#34;10,auto,lightblue&#34;
Admin.dbGridTableTag = &#34;border=3 cellspacing=3 cellpadding=3&#34;
&#39;Admin.dbDebug=True
Admin.DbMode = &#34;Dual&#34;
if isempty(Request.Form(&#34;TableID&#34) then <----Start of &#34;show table&#34; code
F = todo
else
F = Request(&#34;TableID&#34
end if
If F <> &#34;&#34; then
Admin.dbReset(1)
Session(&#34;FR&#34 = F
End If
If F = &#34;games&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
If F = &#34;links&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
Admin.dbSQL = &#34;Select * from &#34; & Session(&#34;FR&#34 & &#34;&#34;
Admin.dbImageDir=&#34;images/&#34;
Admin.dbGridInc=10
Admin.dbNavigation=&#34;bottom&#34;
Admin.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete&#34;
Admin.dbNavigationIcon=&#34;std&#34;
Admin.dbUnit = 1
Admin.dbEditHideFlds=&#34;ID&#34;
Admin.dbFilterHideFlds=&#34;ID&#34;
Admin.dbFormHideFlds=&#34;ID&#34;
Admin.dbOptions = &#34;Heading=<B>#tablename#</B><BR>&#34;
Admin.dbEditParams=&#34;TableName=&#34; & Session(&#34;FR&#34 & &#34;,BookMarkFlds=0,InputSize=7x70,TableTag=BORDE R=2&#34;

Admin.aspDBPro

%>
<---- END CODE ---->

I would be grateful for any help!

Michael

[no fuss]

hi michael,
this is what i just found ...
haven&#39;t tried it yet, however

&#39;Workaround for SQLSetCOnnectAttrib problem, clear this non-real error
if cnnIntranet.errors.count > 0 then
if cnnIntranet.errors(0).number = 0 then
cnnIntranet.errors.clear
end if
end if

also see: http://support.microsoft.com/support/kb/articles/Q197/4/59.ASP



------------
Michael at 9/26/00 3:24:48 PM

I have the page set up with a form that tells ASPdb what table to show, and I keep it in a session variable, problem is when it is a new session. I am trying to set up a default table to show when it is a new session, but can&#39;t seem to get it to work, and I have never seen this error code before:
<---- ERROR ---->
Error # = 0
Description = [Microsoft][ODBC Driver Manager] Driver&#39;s SQLSetConnectAttr failed
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = IM006
NativeError = 0

<---- CODE ---->
<%
Set Admin=Server.CreateObject(&#34;ASPdb.Pro&#34
Admin.dbmdb=&#34;D:Websdatavolzcpa.mdb&#34;
Admin.DBColor = &#34;10,auto,lightblue&#34;
Admin.dbGridTableTag = &#34;border=3 cellspacing=3 cellpadding=3&#34;
&#39;Admin.dbDebug=True
Admin.DbMode = &#34;Dual&#34;
if isempty(Request.Form(&#34;TableID&#34) then <----Start of &#34;show table&#34; code
F = todo
else
F = Request(&#34;TableID&#34
end if
If F <> &#34;&#34; then
Admin.dbReset(1)
Session(&#34;FR&#34 = F
End If
If F = &#34;games&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
If F = &#34;links&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
Admin.dbSQL = &#34;Select * from &#34; & Session(&#34;FR&#34 & &#34;&#34;
Admin.dbImageDir=&#34;images/&#34;
Admin.dbGridInc=10
Admin.dbNavigation=&#34;bottom&#34;
Admin.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete&#34;
Admin.dbNavigationIcon=&#34;std&#34;
Admin.dbUnit = 1
Admin.dbEditHideFlds=&#34;ID&#34;
Admin.dbFilterHideFlds=&#34;ID&#34;
Admin.dbFormHideFlds=&#34;ID&#34;
Admin.dbOptions = &#34;Heading=<B>#tablename#</B><BR>&#34;
Admin.dbEditParams=&#34;TableName=&#34; & Session(&#34;FR&#34 & &#34;,BookMarkFlds=0,InputSize=7x70,TableTag=BORDE R=2&#34;

Admin.aspDBPro

%>
<---- END CODE ---->

I would be grateful for any help!

Michael

[Michael]

Thanks! But i just found my error! I forgot to enclose todo in &#34;F = todo&#34; with &#34;&#34;.


------------
no fuss at 9/26/00 3:34:32 PM


hi michael,
this is what i just found ...
haven&#39;t tried it yet, however

&#39;Workaround for SQLSetCOnnectAttrib problem, clear this non-real error
if cnnIntranet.errors.count > 0 then
if cnnIntranet.errors(0).number = 0 then
cnnIntranet.errors.clear
end if
end if

also see: http://support.microsoft.com/support/kb/articles/Q197/4/59.ASP



------------
Michael at 9/26/00 3:24:48 PM

I have the page set up with a form that tells ASPdb what table to show, and I keep it in a session variable, problem is when it is a new session. I am trying to set up a default table to show when it is a new session, but can&#39;t seem to get it to work, and I have never seen this error code before:
<---- ERROR ---->
Error # = 0
Description = [Microsoft][ODBC Driver Manager] Driver&#39;s SQLSetConnectAttr failed
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = IM006
NativeError = 0

<---- CODE ---->
<%
Set Admin=Server.CreateObject(&#34;ASPdb.Pro&#34
Admin.dbmdb=&#34;D:Websdatavolzcpa.mdb&#34;
Admin.DBColor = &#34;10,auto,lightblue&#34;
Admin.dbGridTableTag = &#34;border=3 cellspacing=3 cellpadding=3&#34;
&#39;Admin.dbDebug=True
Admin.DbMode = &#34;Dual&#34;
if isempty(Request.Form(&#34;TableID&#34) then <----Start of &#34;show table&#34; code
F = todo
else
F = Request(&#34;TableID&#34
end if
If F <> &#34;&#34; then
Admin.dbReset(1)
Session(&#34;FR&#34 = F
End If
If F = &#34;games&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
If F = &#34;links&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
Admin.dbSQL = &#34;Select * from &#34; & Session(&#34;FR&#34 & &#34;&#34;
Admin.dbImageDir=&#34;images/&#34;
Admin.dbGridInc=10
Admin.dbNavigation=&#34;bottom&#34;
Admin.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete&#34;
Admin.dbNavigationIcon=&#34;std&#34;
Admin.dbUnit = 1
Admin.dbEditHideFlds=&#34;ID&#34;
Admin.dbFilterHideFlds=&#34;ID&#34;
Admin.dbFormHideFlds=&#34;ID&#34;
Admin.dbOptions = &#34;Heading=<B>#tablename#</B><BR>&#34;
Admin.dbEditParams=&#34;TableName=&#34; & Session(&#34;FR&#34 & &#34;,BookMarkFlds=0,InputSize=7x70,TableTag=BORDE R=2&#34;

Admin.aspDBPro

%>
<---- END CODE ---->

I would be grateful for any help!

Michael

[Michael]

Well... I spoke too soon! I tried to update it and I got the error again. And the fix that no fuss suggested doesn&#39;t seem to work with ASPdb. Any other suggestions?


------------
Michael at 9/26/00 3:39:29 PM

Thanks! But i just found my error! I forgot to enclose todo in &#34;F = todo&#34; with &#34;&#34;.


------------
no fuss at 9/26/00 3:34:32 PM


hi michael,
this is what i just found ...
haven&#39;t tried it yet, however

&#39;Workaround for SQLSetCOnnectAttrib problem, clear this non-real error
if cnnIntranet.errors.count > 0 then
if cnnIntranet.errors(0).number = 0 then
cnnIntranet.errors.clear
end if
end if

also see: http://support.microsoft.com/support/kb/articles/Q197/4/59.ASP



------------
Michael at 9/26/00 3:24:48 PM

I have the page set up with a form that tells ASPdb what table to show, and I keep it in a session variable, problem is when it is a new session. I am trying to set up a default table to show when it is a new session, but can&#39;t seem to get it to work, and I have never seen this error code before:
<---- ERROR ---->
Error # = 0
Description = [Microsoft][ODBC Driver Manager] Driver&#39;s SQLSetConnectAttr failed
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = IM006
NativeError = 0

<---- CODE ---->
<%
Set Admin=Server.CreateObject(&#34;ASPdb.Pro&#34
Admin.dbmdb=&#34;D:Websdatavolzcpa.mdb&#34;
Admin.DBColor = &#34;10,auto,lightblue&#34;
Admin.dbGridTableTag = &#34;border=3 cellspacing=3 cellpadding=3&#34;
&#39;Admin.dbDebug=True
Admin.DbMode = &#34;Dual&#34;
if isempty(Request.Form(&#34;TableID&#34) then <----Start of &#34;show table&#34; code
F = todo
else
F = Request(&#34;TableID&#34
end if
If F <> &#34;&#34; then
Admin.dbReset(1)
Session(&#34;FR&#34 = F
End If
If F = &#34;games&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
If F = &#34;links&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
Admin.dbSQL = &#34;Select * from &#34; & Session(&#34;FR&#34 & &#34;&#34;
Admin.dbImageDir=&#34;images/&#34;
Admin.dbGridInc=10
Admin.dbNavigation=&#34;bottom&#34;
Admin.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete&#34;
Admin.dbNavigationIcon=&#34;std&#34;
Admin.dbUnit = 1
Admin.dbEditHideFlds=&#34;ID&#34;
Admin.dbFilterHideFlds=&#34;ID&#34;
Admin.dbFormHideFlds=&#34;ID&#34;
Admin.dbOptions = &#34;Heading=<B>#tablename#</B><BR>&#34;
Admin.dbEditParams=&#34;TableName=&#34; & Session(&#34;FR&#34 & &#34;,BookMarkFlds=0,InputSize=7x70,TableTag=BORDE R=2&#34;

Admin.aspDBPro

%>
<---- END CODE ---->

I would be grateful for any help!

Michael

[Mark]

Michael,
Be sure to read Tech Tip #5 at:
http://www.aspdb.com/techtips

What version of ASP-db are you running?
What is the date on the dll file?
It looks like you have an old copy of Pro.
Mark.


------------
Michael at 9/26/00 3:54:08 PM

Well... I spoke too soon! I tried to update it and I got the error again. And the fix that no fuss suggested doesn&#39;t seem to work with ASPdb. Any other suggestions?


------------
Michael at 9/26/00 3:39:29 PM

Thanks! But i just found my error! I forgot to enclose todo in &#34;F = todo&#34; with &#34;&#34;.


------------
no fuss at 9/26/00 3:34:32 PM


hi michael,
this is what i just found ...
haven&#39;t tried it yet, however

&#39;Workaround for SQLSetCOnnectAttrib problem, clear this non-real error
if cnnIntranet.errors.count > 0 then
if cnnIntranet.errors(0).number = 0 then
cnnIntranet.errors.clear
end if
end if

also see: http://support.microsoft.com/support/kb/articles/Q197/4/59.ASP



------------
Michael at 9/26/00 3:24:48 PM

I have the page set up with a form that tells ASPdb what table to show, and I keep it in a session variable, problem is when it is a new session. I am trying to set up a default table to show when it is a new session, but can&#39;t seem to get it to work, and I have never seen this error code before:
<---- ERROR ---->
Error # = 0
Description = [Microsoft][ODBC Driver Manager] Driver&#39;s SQLSetConnectAttr failed
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = IM006
NativeError = 0

<---- CODE ---->
<%
Set Admin=Server.CreateObject(&#34;ASPdb.Pro&#34
Admin.dbmdb=&#34;D:Websdatavolzcpa.mdb&#34;
Admin.DBColor = &#34;10,auto,lightblue&#34;
Admin.dbGridTableTag = &#34;border=3 cellspacing=3 cellpadding=3&#34;
&#39;Admin.dbDebug=True
Admin.DbMode = &#34;Dual&#34;
if isempty(Request.Form(&#34;TableID&#34) then <----Start of &#34;show table&#34; code
F = todo
else
F = Request(&#34;TableID&#34
end if
If F <> &#34;&#34; then
Admin.dbReset(1)
Session(&#34;FR&#34 = F
End If
If F = &#34;games&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
If F = &#34;links&#34; then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
Admin.dbSQL = &#34;Select * from &#34; & Session(&#34;FR&#34 & &#34;&#34;
Admin.dbImageDir=&#34;images/&#34;
Admin.dbGridInc=10
Admin.dbNavigation=&#34;bottom&#34;
Admin.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete&#34;
Admin.dbNavigationIcon=&#34;std&#34;
Admin.dbUnit = 1
Admin.dbEditHideFlds=&#34;ID&#34;
Admin.dbFilterHideFlds=&#34;ID&#34;
Admin.dbFormHideFlds=&#34;ID&#34;
Admin.dbOptions = &#34;Heading=<B>#tablename#</B><BR>&#34;
Admin.dbEditParams=&#34;TableName=&#34; & Session(&#34;FR&#34 & &#34;,BookMarkFlds=0,InputSize=7x70,TableTag=BORDE R=2&#34;

Admin.aspDBPro

%>
<---- END CODE ---->

I would be grateful for any help!

Michael