Web Wiz Forums - SQL support

Print Page | Close Window

SQL support

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=468
Printed Date: 28 March 2026 at 6:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL support

Posted By: Nathan
Subject: SQL support
Date Posted: 24 February 2003 at 2:13am

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

Replies:

Posted By: WebWiz-Bruce
Date Posted: 24 February 2003 at 3:49am

There is an ms SQL server version avaialble from the forum download page.

If you are using the forum with SQL server, then you need to download the SQL server version, which is different to the access version as it also contains a file to create the database and stored procedures to make it run faster.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Nathan
Date Posted: 24 February 2003 at 12:02pm

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

Posted By: WebWiz-Bruce
Date Posted: 24 February 2003 at 1:03pm

The SQL server version won't upgrade an access version to SQL server.

There are no upgardes you will have to do this manually between versions, or try using the upsize wizard in access if the version numbers are the same.

Posted By: Nathan
Date Posted: 25 February 2003 at 1:01am

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)

Posted By: Nathan
Date Posted: 25 February 2003 at 1:10am

PS my server (one and one) says that I can import an access database into an SQL one. There is an option on the control panel to do this - will this work with the forum db?

Posted By: michael
Date Posted: 25 February 2003 at 9:57am

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"

Posted By: Nathan
Date Posted: 26 February 2003 at 1:49am

Thanks Micheal, I have asked my server for the servername - I'll post another message if I need more help - most likely!

Cheers

Nathan

Posted By: PrimeraRacer
Date Posted: 11 March 2003 at 3:04am

Nathan.

did you sort this in the end? I'm trying the same thing with one and one but I cant get my access database to import into the SQL table. all the other details I have ok and can get a version working, just no data. They are being a right bunch of arse about it. have you had any joy? its looking like I'm gonna have to start a fresh again!!

Posted By: Nathan
Date Posted: 11 March 2003 at 3:38am

Nope, I didnt get an answer from One and one - I tried calling their support line - no one every answered! I tried emailing them 20 times and nothing. I have since cancelled my contract with one and one and moved to Gear Host who is fab!

Sorry i cannot help more.

Nathan