What exactly is the proper way to do this? My forum works fine in Access. I did a DTS of all the tables to SQL Server. I changed the appropriate lines in the config.asp to point to SQL Server. When I refresehed the default page I get this error "Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /forum/inc_header.asp, line 114"
Could someone please help? I've tried to read other posts and I get more confused.
Also, DTSing the tables into SQL Server won't properly create table structure. Do a search on this forum for 'Access to SQL Server', for the recommended procedure for the upgrade. There are many posts on that issue.
Greetings, If your using a DSN on the web server, it may be easier to grant the IUSR_ account read/write to the database and use integrated security. I've always had bad luck using a login name and password with a DSN.
If you are using a connection string, make sure that the account name and password are specified correctly in your connection string.
It would also be better if you use the MSAccess upsize wizard to upsize to SQL Server instead of using DTS.
I've posted some tips and tricks of Snitz as well as the Server Hacker mods on my website so I won't post them again here.
It would also be better if you use the MSAccess upsize wizard to upsize to SQL Server instead of using DTS.
Sorry to disagree, but this is bad advice. The proper way to upgrade has been explained time and again here. Please do not advise people to do something that will cause problems with their forums. Besides creating problems with the table structure, the upsize wizard can create triggers that can cause serious problems as well. For detailed info visit this topic.
Topic Locked
Posted - 02 December 2003 : 13:40:45
