Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » CMUD Beta Forum
grunthork
Novice


Joined: 22 Jun 2009
Posts: 38

PostPosted: Wed Oct 13, 2010 5:16 am   

[3.30]Pro #SQLDB remote connection to MSSQL 2008 R2 Express
 
Can someone assist me in connecting to my database? I have a windows 7 computer on my LAN running MSSQL Server Express 2008 R2. I can successfully connect to the database remotely using SQL Configuration manager. I'm having trouble using #SQLDB to connect to the database remotely through CMUD. I opened an offline session and typed:

Code:

#SQLDB nameformydb sqldatabasename mssql myLANsqlserverName PortNumber username Password


The error i recieve (after 10 min of waiting) is:
"Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL server does not exist or network access denied. ConnectionOpen (Connect())."

I was using Dynamic ports to connect on the server configuration, and after i couldn't get it to work, I changed it to port 1433. Any help would be much appreciated. I also included the ntwdblib.dll in the Cmud folder.
Reply with quote
Tech
GURU


Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA

PostPosted: Wed Oct 13, 2010 5:35 am   
 
Are you runnin CMUD or CMUDPro? From the documentation for #SQLDB:
Quote:
NOTE: To use protocols other than SQLite, you MUST be using CMUDPro.
_________________
Asati di tempari!
Reply with quote
grunthork
Novice


Joined: 22 Jun 2009
Posts: 38

PostPosted: Fri Oct 15, 2010 5:02 am   Why, PRO, of course!
 
Using Cmud Pro v3.30.
If you don't have the protocol, you get a different message I believe.
Reply with quote
Zugg
MASTER


Joined: 25 Sep 2000
Posts: 23377
Location: Colorado, USA

PostPosted: Fri Oct 15, 2010 4:04 pm   
 
Unfortunately, if it doesn't work then there isn't much I can do. CMUD is just using the ZeosLib open-source database routines. It's possible that the version of your database server or the version of the ntwdblib.dll isn't supported. You can try looking in the Zeoslib forums at http://zeos.firmos.at/portal.php to see if anybody else is having trouble with SQL Server running locally.
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » CMUD Beta Forum All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2009 Zugg Software. Hosted by Wolfpaw.net