Results 1 to 2 of 2

Thread: Help: SQL-DMO

  1. #1
    Goutam Guest

    Default Help: SQL-DMO

    Hi All,<BR>I am running SQL Server 7.0 and I wanted to create a web interface to SQL server. this is the following code to create the SQL-DMO object.<BR><BR>On Error Resume Next<BR>Dim oSQLServer<BR>Set oSQLServer = Server.CreateObject("SQLOLE.SQLServer")<BR><BR>Set Session("SQLServer") = Nothing<BR><BR>If Err.Number &#062; 0 Then<BR> Response.Write("SQL DMO could not be initialized!<BR>" & Err.Description)<BR> Err.Clear<BR> Response.End<BR>End If<BR><BR>But everytime i try to run the program the object is not created. can somebody recommend why its not ? Any help will be much appreciated

  2. #2
    Goutam Guest

    Default Answer Help: SQL-DMO

    Hi ppl, <BR>well after posting the above message i did some reading in MSDN...sadly had no amswer but checking the dll files in my system found the fle "sqldmo.dll"<BR><BR>so changing the createobject ("sqldmo.sqlserver") solves all the problem!!!!

Posting Permissions

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