| Author |
 Topic  |
|
|
toniya
Starting Member
India
9 Posts |
 Posted - 18 January 2008 : 13:12:37
|
Hello,
We migrated sql server 2000 to 2005 and now we are getting following error:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
When we try this - http://www.clickbankpromotionforum.com/setup.asp?RC=5 - we re not getting an option for sql server 2005. Selecting 7/2000 is not working also.
Any solution?
Thanks and regards,
Toniya |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 18 January 2008 : 13:17:53
|
| well, you will need to find out what format the connection string needs to be for SQL2005, a quick hunt on goole should do the trick, once you have the connection string, just tell setup that you are using sql 7/2000 |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 18 January 2008 : 13:21:20
|
Seen floating around here somewhere:
The first one is for Access 2007 ('cause someone will be looking for it sooner or later), and the second is for SQL Server 2005. I'd love to credit the person who originally posted this, but I can't seem to find the original topic...  |
Edited by - AnonJr on 18 January 2008 13:23:00 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 January 2008 : 14:41:27
|
| The connection strings for SQL Server 2000 works without problems. I have several forums on my test machine working from a SQL Server 2005 and I didn't need to change the connection strings from SQL Server 2000. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 18 January 2008 : 15:57:02
|
quote:
Originally posted by ruirib
The connection strings for SQL Server 2000 works without problems. I have several forums on my test machine working from a SQL Server 2005 and I didn't need to change the connection strings from SQL Server 2000.
didn't realise that rui, they obviously just need to read the readme file then probably |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 January 2008 : 16:54:21
|
Maybe there are optimized connection strings, but I have a big DB, from a Snitz 3.3. that had problems and I can run some "heavy" queries without noticeable issues. Of course, there is no load on the server, but works ok for me.
I would say something may be missing from the web server that's trying to connect to the SQL Server 2005 DB. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
toniya
Starting Member
India
9 Posts |
Posted - 19 January 2008 : 11:15:39
|
Hello,
Thanks everyone; unfortunatelly things are not working. Service provider is also not very helpful, pobably doen not know much about HELM and so on.
I am planning to delete completelly present newly created database at new service provider.
I have back up of old ms server 2000 dabase.
Now problem is how to restore this at new server.
I have SQL Server Management Studio Express.
I do not see any Migration Wizard here or convert tool from 2000 to 2005
1. How to convert that 2000 backed-up database (it is a BAK file) to 2005?, and
2. How to restore this?
Please advice step-by-step so we can proced.
Thanks and regards.
Toniya |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 January 2008 : 16:36:48
|
| I'm not sure about the tools available with Management Studio Express. With SQL Server Management Studio (the normal version), you could restore the Db in a local server and then use Management Studio to generate a script to create the DB structure, run that script on the destination DB and then import the data to that DB, using the Import feature from SQL Server Managenent Studio. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
