| Author |
 Topic Search  Topic Options
|
iSec 
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 15 May 2005 at 7:12pm |
Thank you so much guys... I downloaded the trial version, it's awesome!
One thing that my current hosting provider should know...That I am able to view and change all other databases they have installed  if i was someone that's malicious I'd have deleted all the databases on their server... Once I logged in using my db username/passsword I saw all the databases that hosting server has, here's a screenshot: |
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2005 at 7:22pm |
|
with MSSQL server and other servers some hosts allow the viewing of the
names(only). you can't view the actual content etc of the databases.
we used to do it that way but now to speed the database download up we
have reduced it to the default databases and the ones that are help to
the login username
Edited by dj air - 15 May 2005 at 7:22pm
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2005 at 8:37pm |
 dj air wrote:
with MSSQL server and other servers some hosts allow the viewing of the names(only). you can't view the actual content etc of the databases.
we used to do it that way but now to speed the database download up we have reduced it to the default databases and the ones that are help to the login username
|
Ask your host to investigate sp_MSdbuseraccess SP to get it setup the way dj air has it. Also eliminates the need for EM to load all the bn names so it's active a lot faster.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 May 2005 at 12:26am |
Moveing databases does not work. Is there a procedure to do this? Do you the my_SQL_Server_Setup.asp first to create the tables and relationship and the procedures? If so how do you then upload your data to the newly created tables. I keep getting the FOREGIN KEY ALREADY EXIST when used with import/export tool of SQL server.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 May 2005 at 10:57am |
|
it is possible to move MS SQL databases
i have up sized access databases from access 7.9 to SQL 7.9,
also i have tranferred 1 MS SQL database into IportalX for a client, without any major actions. just import data.
i found that if you do the tables one by one its ok
iusing DTS
- move author table
- move category table
- move forum table
- move topics table
- move threads
then move the other tables
make sure the deleivery /destination table is amending or deleting
existing records and that the owner of the table is correct ussually by
default dbo
once i made sure the threads table is set to dbo owner it went ok. all the otheres went 100% fine.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 May 2005 at 4:54pm |
I have successfully moved it but I got a new problem  I tried to register as a new user and when I fill the registeration form and click register I get the following:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'Last_visit', table 'iraqvoi_forum.dbo.tblAuthor'; column does not allow nulls. INSERT fails.
/forum/register.asp, line 969
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 May 2005 at 4:57pm |
Also, when posting a reply to an existing topic I get the following:
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/forum/post_message.asp, line 746
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 May 2005 at 5:24pm |
|
the first error means that you didn't tranfer correctly.. you didn't send the default values for the fields.
you need to set the default values for the tables now.
im not sure on the fiest one but think it may be related.
|
|
