-
Can't create objects
I've installed the MSSQL7 that comes with office2000, and now i want to access the database with ASP.
I'm using ASPdb.free and i have installed the programs + moved the dll-files the then system32-dir + restarted.
When i run this scipt:
<%
Set MyDb=Server.CreateObject("AspDB.Free"
MyDb.dbQuickProps="1;Pubs;*;grid;4,auto,lightg rey"
Mydb.dbDSN = "DSN=Test_DSN;UID=sa;PWD=;"
MyDb.dbDBType = "SQL"
MyDb.aspdbFree
%>
i get the following error:
Error Type:
Server object, ASP 0177 (0x800401F3)
Server.CreateObject Failed
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/aspdb/test9.asp, line 6
When i try to run pureasp, i get:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'RAOS-HOMENTIUSR_RAOS-HOMENT'.
/aspdb/pureasp.asp, line 31
I've made a System DSN and tried both NT-verification + SQL-verification (using the "sa" account).
---
Help !
-
Can't create objects (reply)
Rasmus,
It sounds like you forgot to "REGISTER the DLL".
Register the dll using REGSVR32 (DOS) or MTS (Microsoft Transaction Server).
See detailed instructions at:
http://www.aspdb.com/docs/aspdb.htm#Installation_Details
That should do it.
Mark.
------------
Rasmus Østergård at 12/13/99 4:55:48 PM
I've installed the MSSQL7 that comes with office2000, and now i want to access the database with ASP.
I'm using ASPdb.free and i have installed the programs + moved the dll-files the then system32-dir + restarted.
When i run this scipt:
<%
Set MyDb=Server.CreateObject("AspDB.Free"
MyDb.dbQuickProps="1;Pubs;*;grid;4,auto,lightg rey"
Mydb.dbDSN = "DSN=Test_DSN;UID=sa;PWD=;"
MyDb.dbDBType = "SQL"
MyDb.aspdbFree
%>
i get the following error:
Error Type:
Server object, ASP 0177 (0x800401F3)
Server.CreateObject Failed
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/aspdb/test9.asp, line 6
When i try to run pureasp, i get:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'RAOS-HOMENTIUSR_RAOS-HOMENT'.
/aspdb/pureasp.asp, line 31
I've made a System DSN and tried both NT-verification + SQL-verification (using the "sa" account).
---
Help !
-
Can't create objects (reply)
Thanks for the very fast reply Mark !!!!
And more importenly: thanks for solving my problem.
Rasmus
------------
Mark at 12/13/99 5:12:18 PM
Rasmus,
It sounds like you forgot to "REGISTER the DLL".
Register the dll using REGSVR32 (DOS) or MTS (Microsoft Transaction Server).
See detailed instructions at:
http://www.aspdb.com/docs/aspdb.htm#Installation_Details
That should do it.
Mark.
------------
Rasmus Østergård at 12/13/99 4:55:48 PM
I've installed the MSSQL7 that comes with office2000, and now i want to access the database with ASP.
I'm using ASPdb.free and i have installed the programs + moved the dll-files the then system32-dir + restarted.
When i run this scipt:
<%
Set MyDb=Server.CreateObject("AspDB.Free"
MyDb.dbQuickProps="1;Pubs;*;grid;4,auto,lightg rey"
Mydb.dbDSN = "DSN=Test_DSN;UID=sa;PWD=;"
MyDb.dbDBType = "SQL"
MyDb.aspdbFree
%>
i get the following error:
Error Type:
Server object, ASP 0177 (0x800401F3)
Server.CreateObject Failed
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/aspdb/test9.asp, line 6
When i try to run pureasp, i get:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'RAOS-HOMENTIUSR_RAOS-HOMENT'.
/aspdb/pureasp.asp, line 31
I've made a System DSN and tried both NT-verification + SQL-verification (using the "sa" account).
---
Help !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|