Are you wanting to create the table via ASP?<BR>If so, simply build your SQL statement like so...<BR><BR>strSQL = " CREATE TABLE myDBName.myTable" &_<BR> " (myField1 datatype,myField2 datatype)"<BR><BR>Then execute it something like<BR><BR>Dim dbConn<BR>SET dbConn = Server.CreateObject("ADODB.Connection")<BR>DSN="my DSN;usr=myUserName;pwd=myPassword"<BR>dbConn.Execu te(strSQL)<BR><BR>Remember to close and destroy your connection when your done.
the problem isn't the sql as a language. The problem in a matter of fact is the SQL server and starting working it.<BR>I know how to create connection object via dsn or dsn-less<BR>when I start SQL server it request a server and I give it my local compter address i.e. 127.0.0.1 and it doesn't manage to create a connection.<BR><BR>can you please tell me how to start working with SQL. I know very good Access but I want to learn SQL which is much stronger then Accees is <BR><BR>thank's a lot