ODBC data source + SQL 2000

Hello,
I'm running a SQL 2000 server on a win 2k3 machine.
I'm not familiar with Win 2k3 so I'm having a hard time looking for the
correct information.
I know my SQL server is up and running. I can connect to it from my
workstation through Enterprise Manager (EM) and the query analyzer (QA).
The funny thing is , when I login to the 2k3 machine and open up the
ODBC Data Source Administrator and try to create a system DSN, the 2k3
machine is not listed in the drop down menu.
It reads,
Which SQL Server do you wan tot connect to?
Server: <Dropdown menu>
I did just type the servername, winbox, and the test at the end was
sucessful. The reason I'm asking is because I'm having a hard time
getting my web app server (CF 5.0 on RH 9.0 w/Apache) creating a DSN
connection I can use to the SQL server.
Thanks.So what's the issue?
Linchi

quote:

---

>--Original Message--
>Hello,
>I'm running a SQL 2000 server on a win 2k3 machine.
>I'm not familiar with Win 2k3 so I'm having a hard time

---

looking for the

quote:

---

>correct information.
>I know my SQL server is up and running. I can connect to

---

it from my

quote:

---

>workstation through Enterprise Manager (EM) and the query

---

analyzer (QA).

quote:

---

>The funny thing is , when I login to the 2k3 machine and

---

open up the

quote:

---

>ODBC Data Source Administrator and try to create a system

---

DSN, the 2k3

quote:

---

>machine is not listed in the drop down menu.
>It reads,
>Which SQL Server do you wan tot connect to?
>Server: <Dropdown menu>
>I did just type the servername, winbox, and the test at

---

the end was

quote:

---

>sucessful. The reason I'm asking is because I'm having a

---

hard time

quote:

---

>getting my web app server (CF 5.0 on RH 9.0 w/Apache)

---

creating a DSN

quote:

---

>connection I can use to the SQL server.
>Thanks.
>.
>

---

|||I can't get my app server (MacroMedia CF server 5.0 running on RH 9) to
create an ODBC connection to SQL Server 2000 running on a 2k3 server.
I feel like I am taking crazy pills. I have done this config numerous
times with the same system architect. The only thing that is different
this time is that the SQL server is running on a 2k3 Machine.
CF server defaults the connection to 1433. I checked up the TCPIP
properties to make sure I did not close that port. It looks good.
Any ideas?
Linchi Shea wrote:

quote:

---

> So what's the issue?
> Linchi
>

---

sql

ODBC data source + SQL 2000

Hello,
I'm running a SQL 2000 server on a win 2k3 machine.
I'm not familiar with Win 2k3 so I'm having a hard time looking for the
correct information.
I know my SQL server is up and running. I can connect to it from my
workstation through Enterprise Manager (EM) and the query analyzer (QA).
The funny thing is , when I login to the 2k3 machine and open up the
ODBC Data Source Administrator and try to create a system DSN, the 2k3
machine is not listed in the drop down menu.
It reads,
Which SQL Server do you wan tot connect to?
Server: <Dropdown menu>
I did just type the servername, winbox, and the test at the end was
sucessful. The reason I'm asking is because I'm having a hard time
getting my web app server (CF 5.0 on RH 9.0 w/Apache) creating a DSN
connection I can use to the SQL server.
Thanks.So what's the issue?
Linchi
>--Original Message--
>Hello,
>I'm running a SQL 2000 server on a win 2k3 machine.
>I'm not familiar with Win 2k3 so I'm having a hard time
looking for the
>correct information.
>I know my SQL server is up and running. I can connect to
it from my
>workstation through Enterprise Manager (EM) and the query
analyzer (QA).
>The funny thing is , when I login to the 2k3 machine and
open up the
>ODBC Data Source Administrator and try to create a system
DSN, the 2k3
>machine is not listed in the drop down menu.
>It reads,
>Which SQL Server do you wan tot connect to?
>Server: <Dropdown menu>
>I did just type the servername, winbox, and the test at
the end was
>sucessful. The reason I'm asking is because I'm having a
hard time
>getting my web app server (CF 5.0 on RH 9.0 w/Apache)
creating a DSN
>connection I can use to the SQL server.
>Thanks.
>.
>|||I can't get my app server (MacroMedia CF server 5.0 running on RH 9) to
create an ODBC connection to SQL Server 2000 running on a 2k3 server.
I feel like I am taking crazy pills. I have done this config numerous
times with the same system architect. The only thing that is different
this time is that the SQL server is running on a 2k3 Machine.
CF server defaults the connection to 1433. I checked up the TCPIP
properties to make sure I did not close that port. It looks good.
Any ideas?
Linchi Shea wrote:
> So what's the issue?
> Linchi
>

ODBC connect string for named instance?

I am familiar with constructing ODBC connect strings for SQL server
databases using "SERVER=" and "Database=" clauses. If the SQL server is
running a named instance, instead of an unnamed one, do you put the instance
name in the "SERVER=" clause, or is there another clause for that?
-Richard M. Hartman
186,000 mi/sec: not just a good idea, it's the LAW!
You have insurance for your car and your health,
why not for your legal needs?
http://www.legalhmo.comI can't test this right now, but you should be able to set SERVER to
servername\instancename.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard M. Hartman" <hartman@.onetouch.com> wrote in message
news:%2355fg9unHHA.3544@.TK2MSFTNGP03.phx.gbl...
> I am familiar with constructing ODBC connect strings for SQL server
> databases using "SERVER=" and "Database=" clauses. If the SQL server is
> running a named instance, instead of an unnamed one, do you put the
> instance name in the "SERVER=" clause, or is there another clause for
> that?
> --
> -Richard M. Hartman
> 186,000 mi/sec: not just a good idea, it's the LAW!
> You have insurance for your car and your health,
> why not for your legal needs?
> http://www.legalhmo.com
>

ODBC connect string for named instance?

I am familiar with constructing ODBC connect strings for SQL server
databases using "SERVER=" and "Database=" clauses. If the SQL server is
running a named instance, instead of an unnamed one, do you put the instance
name in the "SERVER=" clause, or is there another clause for that?
-Richard M. Hartman
186,000 mi/sec: not just a good idea, it's the LAW!
You have insurance for your car and your health,
why not for your legal needs?
http://www.legalhmo.com
I can't test this right now, but you should be able to set SERVER to
servername\instancename.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard M. Hartman" <hartman@.onetouch.com> wrote in message
news:%2355fg9unHHA.3544@.TK2MSFTNGP03.phx.gbl...
> I am familiar with constructing ODBC connect strings for SQL server
> databases using "SERVER=" and "Database=" clauses. If the SQL server is
> running a named instance, instead of an unnamed one, do you put the
> instance name in the "SERVER=" clause, or is there another clause for
> that?
> --
> -Richard M. Hartman
> 186,000 mi/sec: not just a good idea, it's the LAW!
> You have insurance for your car and your health,
> why not for your legal needs?
> http://www.legalhmo.com
>