CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Provider-Error with SQL 7

Print topic Send  topic

Author Message
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
>
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.