Joachim Uersfeld
|
Posted: 02/02/2001, 4:33 PM |
|
Hi,
i try your great program, i will buy a licence, but it will not work for me.
There ist the Provider-Error '80040154' , Class not registered , at
/sfadmin/Common.asp, line 35. The database connection string works in my
hand-made project. I try it with ten tables, all forms are created by the
new page wizard.
This is from common.asp:
strConn = "DRIVER={SQL
Server};SERVER=NTUESERVER2;DATABASE=store1UID=sa;PWD="
Set cn = Server.CreateObject("ADODB.Connection")
cn.open strConn, "", ""
sub openrs(rs, sql)
Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = adUseClient
rs.PageSize = RecordsPerPage
rs.Open sql, cn, , adLockReadOnly, adCmdText
end sub
I start it from Win 2000 Workstation with ADO 2.6 and try to connect to a
SQL Server 7 on an Win 2000 Server. The Query is ok and gives a result-set
(checked with sql-profiler).
What is wrong?
Joachim
from Mainz/Germany
|
|
|
CodeCharge
|
Posted: 02/03/2001, 3:21 AM |
|
I believe that thereis a typo in your connection string.
Please emailsupport@codecharge.com
Joachim Uersfeld <uersfeld@pc-team.de> wrote in message
news:95fjkr$ul9$1@news.codecharge.com...
> Hi,
>
> i try your great program, i will buy a licence, but it will not work for
me.
> There ist the Provider-Error '80040154' , Class not registered , at
> /sfadmin/Common.asp, line 35. The database connection string works in my
> hand-made project. I try it with ten tables, all forms are created by the
> new page wizard.
>
> This is from common.asp:
>
> strConn = "DRIVER={SQL
> Server};SERVER=NTUESERVER2;DATABASE=store1UID=sa;PWD="
>
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.open strConn, "", ""
>
> sub openrs(rs, sql)
> Set rs = Server.CreateObject("ADODB.Recordset")
> rs.CursorLocation = adUseClient
> rs.PageSize = RecordsPerPage
> rs.Open sql, cn, , adLockReadOnly, adCmdText
> end sub
>
> I start it from Win 2000 Workstation with ADO 2.6 and try to connect to a
> SQL Server 7 on an Win 2000 Server. The Query is ok and gives a result-set
> (checked with sql-profiler).
>
> What is wrong?
>
> Joachim
> from Mainz/Germany
>
>
|
|
|
Joachim Uersfeld
|
Posted: 02/03/2001, 4:03 AM |
|
Sorry, it's not a error with CodeCharge, it is a unknown error on my SQL
2000 Workstation. On the server, the generated code works very well.
Now, i purchase a licence!
Joachim
"CodeCharge" <support@codecharge.com> schrieb im Newsbeitrag
news:95gpj6$s8i$1@news.codecharge.com...
> I believe that thereis a typo in your connection string.
> Please emailsupport@codecharge.com
|
|
|
CodeCharge
|
Posted: 02/03/2001, 10:47 AM |
|
I'm not sure what it is, but please see: http://support.microsoft.com/support/kb/articles/Q275/9/17.ASP http://www.15seconds.com/faq/ASPMail/523.htm
If you use MTS, there is a related article here: http://support.microsoft.com/support/kb/articles/Q247/3/75.ASP
In either case I recommend installing the updated MDAC from: http://www.microsoft.com/data/download_260rtm.htm
Adam
Joachim Uersfeld <uersfeld@pc-team.de> wrote in message
news:95gs2t$vud$1@news.codecharge.com...
> Sorry, it's not a error with CodeCharge, it is a unknown error on my SQL
> 2000 Workstation. On the server, the generated code works very well.
>
> Now, i purchase a licence!
>
> Joachim
>
> "CodeCharge" <support@codecharge.com> schrieb im Newsbeitrag
>news:95gpj6$s8i$1@news.codecharge.com...
> > I believe that thereis a typo in your connection string.
> > Please emailsupport@codecharge.com
>
>
>
|
|
|
|