Jump to content
  • 0

[HELP_FAST]Please look fast.


Thelasthero

Question

I found a off server that can run on windows xp 32 bit, i have downloaded and installed mssql server 2005 express, but when i try to connect to localhost, it says cannot connect to server bla bla. must i do something else before i can connect? must i have installed mysql 5.1?

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

You made something wrong in your steps. Mysql ? WTF L2Off uses MSSQL. Maybe you didn't setup the ODBC, or something. Check that you made everything as it should be. I can't tell you more cause i don't have more info, that error can have many reasons.

 

Link to comment
Share on other sites

  • 0

You made something wrong in your steps. Mysql ? WTF L2Off uses MSSQL. Maybe you didn't setup the ODBC, or something. Check that you made everything as it should be.

 

i have istalled odbc(not configured it or something just installed), then installed mssql server 2005 express, and i have a box when i run it that says:

Connect to a server:

 

Server Name: (here i add localhost)

Authentication: Windows Authentication

 

I press connect, and i get error sayying:

TITLE: Connect to Server

------------------------------

 

Cannot connect to localhost.

 

------------------------------

ADDITIONAL INFORMATION:

 

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

 

------------------------------

BUTTONS:

 

OK

------------------------------

.

 

A and what is allow remote connections? how do i enable this?

Link to comment
Share on other sites

  • 0

You MUST setup the ODBC correctly, you should setup the TCP/IP connections using SQL Server Surface Area Configuration.

i4_SQLSERVERCONFIG.jpg?id=020e7008418eba3c313331353439

P.S: Don't use Express version use Enterprise, cause Express has very limited functions. I think your problem is ODBC configuration.

Link to comment
Share on other sites

  • 0

You MUST setup the ODBC correctly, you should setup the TCP/IP connections using SQL Server Surface Area Configuration.

i4_SQLSERVERCONFIG.jpg?id=020e7008418eba3c313331353439

P.S: Don't use Express version use Enterprise, cause Express has very limited functions. I think your problem is ODBC configuration.

hm i'l try to install not express. but i have to find it for 32 bit....

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


  • Posts

    • Thank you for your reply. I have removed it from the L2Server.exe file, but the L2Server still crashes. It doesn't crash if I don't start l2npc, otherwise it will crash within a few days at the latest.
    • Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11 Telegram : https://t.me/ultrastore1 Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11
    • L2 ArenaWar: Low Rate PvP Server with Free Buffs & Autofarm [PVP]⚔️ [Free]🆓 Classic Interlude with  3x XP rates! Free starter pack(no grade) to kickstart your adventure! Autofarm for convenient grinding! Free buffs to keep you fighting fit! (2 job buffs) No experience loss on death! (Except with Karma) Clear Karma system to keep things fair! ⚖️ Active community of 800-1k players! Join our Discord to learn more! >> Discord <<     Server website: https://l2arenawar.com/en/    
    • This is dedication! 2 years working on a problem. Congratulations!
    • You indeed have to save player position over Enterworld to properly clean it up later (if you don't, even trying to delete packet content would eventually keep it up), that's what we do with debug packet (which is a reusable Map of ExServerPrimitive packets) on aCis.   It doesn't solve the FPS stuttering - more you draw/delete lines, more your client becomes laggy. It's like if client wasn't deleting drawn points/lines properly, but instead simply hide them and redrawn content above.   If you got a solution, I would happy to integrate it.   You should check aCis#Player _debug packet integration, it allows very big amount of lines/points to be drawn, it is also reusable.   https://gitlab.com/Tryskell/acis_public/-/blob/master/aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/Player.java?ref_type=heads https://gitlab.com/Tryskell/acis_public/-/blob/master/aCis_gameserver/java/net/sf/l2j/gameserver/network/clientpackets/EnterWorld.java?ref_type=heads  
  • Topics

×
×
  • Create New...