What is "Class not registered"?

Results 1 to 2 of 2

Thread: What is "Class not registered"?

  1. #1
    Molly Liu Guest

    Default What is "Class not registered"?

    Can anyone help me on the error below?<BR><BR> Provider error &#039 80040154&#039 <BR><BR> Class not registered <BR><BR> /wb_or1/test.asp, line 19 <BR><BR>The line 19 of test.asp is : <BR> MyConnect.Open ConnectStr<BR><BR>Below is the entire test.asp:<BR><BR>&#060;%@ <BR> ENABLESESSIONSTATE = False<BR> LANGUAGE=VBScript <BR>&#037;&#062;<BR><BR>&#060;HTML><BR><BR>&#060;H EAD><BR>&#060;TITLE>Test&#060;/TITLE><BR>&#060;/HEAD><BR><BR>&#060;BODY><BR><BR>&#060;!--#INCLUDE VIRTUAL="include/adovbs.inc" --><BR><BR>&#060;% <BR> ConnectStr="DSN=tsled1 on nt_dev"<BR> Set MyConnect = Server.CreateObject("ADODB.Connection")<BR> MyConnect.Open ConnectStr<BR><BR> Set MyRecSet = MyConnect.Execute("Select * from nv_user")<BR><BR> strtable = MyRecSet.GetString(,,"&#060;/td>&#060;td>","&#060;/td>&#060;/tr>&#060;tr>&#060;td>","&nbsp;")<BR>&#037;&#062;<B R><BR>&#060;TABLE><BR> &#060;TR>&#060;TD><BR> &#060;% response.write(strtable) &#037;&#062;<BR> &#060;/TR>&#060;/TD><BR>&#060;/TABLE><BR><BR>&#060;/BODY><BR><BR>&#060;/HTML><BR>

  2. #2
    Raymond Brogan Guest

    Default RE: What is

    you wrote:<BR>ConnectStr="DSN=tsled1 on nt_dev"<BR><BR>it wont be recognized by the .dll file. the line should read:<BR>ConnectStr="DSN=tsled1;uid=;pw="<BR>with DSN connection, you specify the user id and the pw<BR>if these are left blank, then use the above code.<BR>if not, for example, uid is sam and password is mary to the dsn tsled1, then the string should read:<BR>ConnectStr="DSN=tsled1;uid=sam;pw=mary"<B R><BR>to set up these parameters: click control panel,ODBC data sources(32), filedsn or sysdsn...hopefully you are using systemDSN,pick your dsn name, click configure or advanced and look in the user id and password textboxs. you can add or make any appropriate changes there.<BR>Hope this help you out<BR>Happy Programming!<BR>Ray<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •