SQL on windows...

[-Luke-]

Just trying putting SQL 2000 on my new pc witch is Windows 7. but it says it not compatable, what sql should i be using please ?

 

[-Luke-]

yes im trying to create a mir2 db.. not sure what you mean by master tho, and i dnt know what by creating a new db further up on the left tree..

 

[jasper]

in the object explorer window on the left side, right click on Databases to create a new database

 

[-Luke-]

I was doing that but was getting a error when i try add it, so this morning i uninstalled sql and re installed made it with a new name and worked fine, now have my db made, now need to restore db, but when i try search for in in dbserver it doesnt appear on sql but it is in there ?

do i need a differnt type of db ? because like sql 2005 can back up 2000 can it ?

and thank you very much for your help :thumbup2:

 

[Gezza]

When searching in sql for the database change the file types to all files. Sql 05 can restore a 2000 database yes.

 

[-Luke-]

I did that but nothing shows still and i have sql 2008

-Edit -

Fixed!! All sorted thanks to every who helped

 

[-Luke-]

One last thing how do i open i.e STDITEMS.. because normaly it just says open table or some thing, i can open but will only show 1000 rows witch is no good. How do i open so i can see every thing no limit ?

Edit -

When i select "Top 1000 Rows" that doesnt even let me edit nothing not even item name or what ever..
When i select "Edit Top 200 Rows" that does let me edit but only shows 200 items, when i need to see all of them.

 

[jasper]

apparantly you can change that command in the Tools > Options > SQL Server Object Explorer > Commands. Changed the value in options to 0 and you can open the entire table.

 

[-Luke-]

Cheers jasper sorted now

one last thing now.. i hope lol, when i run all the gates the m2server gives this error

"[03/06/2010 13:34:37] StartTimer exception: Unspecified error"



-Edit - Fixed.

 

[-Luke-]

Got a problem with DBserver and M2Server now..

DBServer error

TFrmDBSrv.starttimer
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected

M2Server error -

[03/06/2010 14:26:10] LoginServer Connected(192.168.0.6:5600)
[03/06/2010 14:26:10] Gate[0](192.168.0.6:51310) Opened...
[03/06/2010 14:26:13] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:16] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:19] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:22] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:25] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:28] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:31] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:34] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:37] DBServer Connected(192.168.0.6:6000)

All the ips are correct checked many of times now.

EDIT -

I also get the same errors with the offline ip 127.0.0.1

-------
Where it says Server name in the pic, is that what i put in "SQLHost=", in the dbsrc ??

 

[Chris22]

Got a problem with DBserver and M2Server now..

DBServer error

TFrmDBSrv.starttimer
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected

M2Server error -

[03/06/2010 14:26:10] LoginServer Connected(192.168.0.6:5600)
[03/06/2010 14:26:10] Gate[0](192.168.0.6:51310) Opened...
[03/06/2010 14:26:13] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:16] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:19] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:22] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:25] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:28] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:31] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:34] DBServer Connected(192.168.0.6:6000)
[03/06/2010 14:26:37] DBServer Connected(192.168.0.6:6000)

All the ips are correct checked many of times now.

EDIT -

I also get the same errors with the offline ip 127.0.0.1

-------
Where it says Server name in the pic, is that what i put in "SQLHost=", in the dbsrc ??

On your picture you server name should be here in m2server, setup!

[SQL]
UseSQL=TRUE
SQLHost=<<<<<<< (Luke-PC whatever it is)
SQLUsername=sa
SQLPassword=sa
SQLDatabase=Mir2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=Mir2

There is another in db server that needs to be the same.