Creating a database and tables with ASP

• edpritch

  SSC Rookie

  Points: 44

  More actions

  October 28, 2002 at 9:45 am

  #80046

  I am using stargateinc.com as a service provider and they have this SQL package called a Value App. They create an instance of SQL server for my use. OK, fine... now I am trying to create a database using the File DSN I was given. I have the following:

  I was provided with a File DSN name, server IP address, User name, and password. I have no idea what is in their File.dsn

  <%

  dim conn

  dim rs

  Set conn = Server.Createobject("ADODB.CONNECTION")

  conn.Open "FILEDSN=MyDomain.com_sql.dsn", "MyUserID", "MyPssword"

  Set rs = Server.CreateObject("ADODB.Recordset")

  %>

  OK, no errors there.

  Now I try to create a database using:

  <%

  dim sql

  sql = "CREATE DATABASE DataTest"

  rs.open sql, conn

  response.Write("Database Created")

  %>

  And I get a 500 Server Error.

  All this works fine on my localhost server. But not online on there's. Am I doing something wrong?

  Thanks in advance

  Ed

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739122

  More actions

  October 28, 2002 at 10:07 am

  #439613

  Perhaps the path to the file DSN isn't correct? Or you don't have rights.

  Try a simple "select @@version" with your DSN and see if that works.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones