 |
grunthork
Novice
Joined: 22 Jun 2009
Posts: 38
|
 Posted: 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. |
|
|
|
|
Tech
GURU
Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA
|
Posted: 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! |
 |
|
|
grunthork
Novice
Joined: 22 Jun 2009
Posts: 38
|
Posted: 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. |
|
|
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: 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.
|
|
|
|
|
|
|
|
