OT kind of.... SQL ODBC connection problem

Well, it looks like I can't send you my word file. If you send me your
email address I will send it to you off line.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale R. Kalsow
Sent: Monday, April 21, 2008 1:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT kind of.... SQL ODBC connection problem



Looks like it stripped of the attachment. Let's try that again. :^)

Setup Instructions for FRx 6.7

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Monday, April 21, 2008 1:37 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OT kind of.... SQL ODBC connection problem

Here are my instructions for FRx. I hope they help J

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Norman Hutchins
Sent: Monday, April 21, 2008 1:22 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OT kind of.... SQL ODBC connection problem

I'm trying to set up a ODBC connection to our SQL server for FRx, when I
do
I get the errors below. FYI, these connects work fine from the server,
so it
must be a remote connection problem. I have checked a bunch of the
settings
on the server and can't solve it.
http://images.devshed.com/fds/smilies/banghead.gif

If I use the SQL Server 2005 Native Client Driver the following error
occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Named Pipes Provider: No process is on the
other end of the pipe.

Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Communication link failure
Connection failed:
SQLState: '08001'
SQL Server Error: 0
[Microsoft][SQL Native Client]An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure
may be caused by the fact that under the default settings SQL Server
does
not allow remote connections.

---------------------------
OK
---------------------------

If I use the SQL Server 2000 Driver the following error occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 233

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(PreLoginHandshake()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
Check
your network documentation.

---------------------------
OK
---------------------------

Any help would be greatly appreciated.
http://images.devshed.com/fds/smilies/honorhim.gif

Norman

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I'm trying to set up a ODBC connection to our SQL server for FRx, when I do
I get the errors below. FYI, these connects work fine from the server, so it
must be a remote connection problem. I have checked a bunch of the settings
on the server and can't solve it.
http://images.devshed.com/fds/smilies/banghead.gif

If I use the SQL Server 2005 Native Client Driver the following error
occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Named Pipes Provider: No process is on the
other end of the pipe.

Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Communication link failure
Connection failed:
SQLState: '08001'
SQL Server Error: 0
[Microsoft][SQL Native Client]An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does
not allow remote connections.

---------------------------
OK
---------------------------

If I use the SQL Server 2000 Driver the following error occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 233


[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(PreLoginHandshake()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check
your network documentation.

---------------------------
OK
---------------------------

Any help would be greatly appreciated.
http://images.devshed.com/fds/smilies/honorhim.gif

Norman



[Non-text portions of this message have been removed]
Here are my instructions for FRx. I hope they help J



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norman Hutchins
Sent: Monday, April 21, 2008 1:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT kind of.... SQL ODBC connection problem



I'm trying to set up a ODBC connection to our SQL server for FRx, when I
do
I get the errors below. FYI, these connects work fine from the server,
so it
must be a remote connection problem. I have checked a bunch of the
settings
on the server and can't solve it.
http://images.devshed.com/fds/smilies/banghead.gif

If I use the SQL Server 2005 Native Client Driver the following error
occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Named Pipes Provider: No process is on the
other end of the pipe.

Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Communication link failure
Connection failed:
SQLState: '08001'
SQL Server Error: 0
[Microsoft][SQL Native Client]An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure
may be caused by the fact that under the default settings SQL Server
does
not allow remote connections.

---------------------------
OK
---------------------------

If I use the SQL Server 2000 Driver the following error occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 233

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(PreLoginHandshake()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
Check
your network documentation.

---------------------------
OK
---------------------------

Any help would be greatly appreciated.
http://images.devshed.com/fds/smilies/honorhim.gif

Norman


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Looks like it stripped of the attachment. Let's try that again. :^)





Setup Instructions for FRx 6.7





























From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale R. Kalsow
Sent: Monday, April 21, 2008 1:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT kind of.... SQL ODBC connection problem



Here are my instructions for FRx. I hope they help J

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Norman Hutchins
Sent: Monday, April 21, 2008 1:22 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OT kind of.... SQL ODBC connection problem

I'm trying to set up a ODBC connection to our SQL server for FRx, when I
do
I get the errors below. FYI, these connects work fine from the server,
so it
must be a remote connection problem. I have checked a bunch of the
settings
on the server and can't solve it.
http://images.devshed.com/fds/smilies/banghead.gif

If I use the SQL Server 2005 Native Client Driver the following error
occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Named Pipes Provider: No process is on the
other end of the pipe.

Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Communication link failure
Connection failed:
SQLState: '08001'
SQL Server Error: 0
[Microsoft][SQL Native Client]An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure
may be caused by the fact that under the default settings SQL Server
does
not allow remote connections.

---------------------------
OK
---------------------------

If I use the SQL Server 2000 Driver the following error occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 233

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(PreLoginHandshake()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
Check
your network documentation.

---------------------------
OK
---------------------------

Any help would be greatly appreciated.
http://images.devshed.com/fds/smilies/honorhim.gif

Norman

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]