ODBC Connection Setup

I'm running SBS 2003 Premium SP1 and all is well. I've installed a new SQL
based application that requires a simple ODBC connection to the SQL database
.
I have about 50 PCs to setup this ODBC link to my SBS server and there must
be a faster way to do this via a script or through Group Policies.
Has anyone tried this and how? I've used GPs for simple things like folder
redirection, but I'm not that strong on it.
Thanks.
KenI've taken to using file-based DSNs placed in a server folder that everyone
can access. It's turned out to be the best solution in my case.
Randall Arnold
"shepcon" <shepcon@.discussions.microsoft.com> wrote in message
news:E02D79DC-D435-4C36-9FF8-4C541F6116D4@.microsoft.com...
> I'm running SBS 2003 Premium SP1 and all is well. I've installed a new
> SQL
> based application that requires a simple ODBC connection to the SQL
> database.
> I have about 50 PCs to setup this ODBC link to my SBS server and there
> must
> be a faster way to do this via a script or through Group Policies.
> Has anyone tried this and how? I've used GPs for simple things like
> folder
> redirection, but I'm not that strong on it.
> Thanks.
> Ken
>sql

ODBC Connection Setup

I'm running SBS 2003 Premium SP1 and all is well. I've installed a new SQL
based application that requires a simple ODBC connection to the SQL database.
I have about 50 PCs to setup this ODBC link to my SBS server and there must
be a faster way to do this via a script or through Group Policies.
Has anyone tried this and how? I've used GPs for simple things like folder
redirection, but I'm not that strong on it.
Thanks.
Ken
I've taken to using file-based DSNs placed in a server folder that everyone
can access. It's turned out to be the best solution in my case.
Randall Arnold
"shepcon" <shepcon@.discussions.microsoft.com> wrote in message
news:E02D79DC-D435-4C36-9FF8-4C541F6116D4@.microsoft.com...
> I'm running SBS 2003 Premium SP1 and all is well. I've installed a new
> SQL
> based application that requires a simple ODBC connection to the SQL
> database.
> I have about 50 PCs to setup this ODBC link to my SBS server and there
> must
> be a faster way to do this via a script or through Group Policies.
> Has anyone tried this and how? I've used GPs for simple things like
> folder
> redirection, but I'm not that strong on it.
> Thanks.
> Ken
>

ODBC Connection Problem

Hi all
I'm attempting to setup a linked server to a cache database within
Enterprise Manager. I setup an ODBC driver on the server and the
connection worked when tested.
Selected Micorsoft OLE DB Provider for ODBC Driver from the drop down
list.
Entered the data source name in the Data Source field and I keep
getting "error 7399: OLE DB provider 'MSDASQL' reported an error. OLE
DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x800004005;]"
Does the ODBC driver need to be installed on the same drive as SQL?
The driver is a system DNS stored on C: while SQL is installed on
another drive.
Or am I missing some parameters in the setup?
Thanks
mike
Got it to work.
Had to set everything up on the server and not on my machine.

ODBC Connection Problem

Hi all
I'm attempting to setup a linked server to a cache database within
Enterprise Manager. I setup an ODBC driver on the server and the
connection worked when tested.
Selected Micorsoft OLE DB Provider for ODBC Driver from the drop down
list.
Entered the data source name in the Data Source field and I keep
getting "error 7399: OLE DB provider 'MSDASQL' reported an error. OLE
DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x800004005;]"
Does the ODBC driver need to be installed on the same drive as SQL?
The driver is a system DNS stored on C: while SQL is installed on
another drive.
Or am I missing some parameters in the setup?
Thanks
mikeGot it to work.
Had to set everything up on the server and not on my machine.

ODBC Access to SQL Table

I need your help. I have a MS SQL Server in our DMZ that I need to setup an
MS Access ODBC connection to the SQL Server. I am using port 1433 opened on
the firewall but I can't bring up the SQL Server. Is there as way to
trouble shoot these issues or maybe a document on setting up ODBC
connections? I have no trouble within the LAN in our Active Directory.
Please help! Thanks
NC Beach BumDoes your SQL Server allow incoming connections for TCP/IP on port 1433.
Perhaps check your client configuration and make sure that it allows
incoming connections. If this is SQL 2005 you can use your surface area
configuration tool to make sure the protocol is allowed.
--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"NC Beach Bum" <NCBeachBum@.discussions.microsoft.com> wrote in message
news:EBE2C819-A798-48BD-A179-B511C9D79B31@.microsoft.com...
>I need your help. I have a MS SQL Server in our DMZ that I need to setup
>an
> MS Access ODBC connection to the SQL Server. I am using port 1433 opened
> on
> the firewall but I can't bring up the SQL Server. Is there as way to
> trouble shoot these issues or maybe a document on setting up ODBC
> connections? I have no trouble within the LAN in our Active Directory.
> Please help! Thanks
> --
> NC Beach Bum

ODBC Access to SQL Table

I need your help. I have a MS SQL Server in our DMZ that I need to setup an
MS Access ODBC connection to the SQL Server. I am using port 1433 opened on
the firewall but I can't bring up the SQL Server. Is there as way to
trouble shoot these issues or maybe a document on setting up ODBC
connections? I have no trouble within the LAN in our Active Directory.
Please help! Thanks
NC Beach Bum
Does your SQL Server allow incoming connections for TCP/IP on port 1433.
Perhaps check your client configuration and make sure that it allows
incoming connections. If this is SQL 2005 you can use your surface area
configuration tool to make sure the protocol is allowed.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"NC Beach Bum" <NCBeachBum@.discussions.microsoft.com> wrote in message
news:EBE2C819-A798-48BD-A179-B511C9D79B31@.microsoft.com...
>I need your help. I have a MS SQL Server in our DMZ that I need to setup
>an
> MS Access ODBC connection to the SQL Server. I am using port 1433 opened
> on
> the firewall but I can't bring up the SQL Server. Is there as way to
> trouble shoot these issues or maybe a document on setting up ODBC
> connections? I have no trouble within the LAN in our Active Directory.
> Please help! Thanks
> --
> NC Beach Bum

odbc + sql problem

Anyone could please help me ?
I have a simple asp program connecting to sql7.0.
I have the system dsn setup already.
After I transfer everything from the old hard disk to new hard disk, I
cannot login through asp program anymore. Below is the error message but I
don't know why it has to do with the iusr account. Thanks a lot. (any image
of setup would be helpful)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'CENTRAL\IUSR_CENTRAL'.So, the error message is that this user:
doesn't exist as a SQL login.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'CENTRAL\IUSR_CENTRAL'.
175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL
http://support.microsoft.com/?id=175671
307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User
http://support.microsoft.com/?id=307002
176380 How To Use ASP with a SQL Trusted Connection with Guest Account
http://support.microsoft.com/?id=176380
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.