SQL support

I have just seen that v7 has been released with SQL support.

I remember reading a while back that there were two types of SQL systems.

My server (oneandone) offers: MS-SQL database

Is this compatable with version 7?

I have tried already to set it up but failed

Thanks

Nathan 

Thanks Bruce, I have ftp'd the SQL version, sorry if this sounds like a newbie question, but I host my account with 'oneandone' they give the SQl

 database name as: "db735180790" and the

 user name as : "dbo7351879"

 

Dim strSQLServerName  'Holds the name of the SQL Server
Dim strSQLDBUserName  'Holds the user name (for SQL Server Authentication)
Dim strSQLDBPassword  'Holds the password (for SQL Server Authentication)
Dim strSQLDBName  'Holds name of a database on the server

 

is the dbname the name (location) of my old db in access - so I can import it?

I have an import feature with oneandone should I use that to create the tables?

 

Cheers for any help offered.

Nathan

Thanks Bruce.

I am trying to setup my SQL version, but in the setup thingy it asks for:

strSQLServerName = "" 'Holds the name of the SQL Server

Is this the http address of the site? - Doesnt work!

(I have all the fields)

You can do it with DTS in SQL Enterprise Manager or the upsizing wizard in Access (or the control panel option of your host for that matter) As for the sql_server_connection.asp file you need to get the correct info from your host:

Dim strSQLServerName = "servername"  'which can be (local) or server2929 ask your host can also be an IP Address
Dim strSQLDBUserName  = "dbo7351879"
Dim strSQLDBPassword  ="*******"
Dim strSQLDBName  ="db735180790"