ODBC

SBS >> ODBC I need to create an ODBC connection from XP Pro client to our SQL Server (on
the network). We are running SBS2003 Premier.

Can I:

1. Remote control to these machines (like VNC) and do this without having
to visit
the machines in turn...or...
2. Upload some kind of install so that it updates the ODBC DSN?

I need some help. I have around 30 machines to do, and I would rather spend
30 minutes doing this than a whole day!

Please help.

skc

Information Technology343

SBS >> ODBC Hi SKC,

Thanks for posting here.

For your description, I understand that you want to know whether you can
create ODBC connection for remote client PCs and can update the ODBC DSN.
If I am off base, please don't hesitate to let me know.

To answer your question, you can use RDP or VNC to logon remote client PCs
to create ODBC connection. You can refer to the steps:
1. Click Start, click Command Prompt, and then type "tsmmc.msc" (no
quotation marks) in command line. Press Enter to open the remote desktops
console.

2. Right-click Remote Desktops in the left root node and click Add new
connection to add PCs you want to control.

And you can also manage the client PCs in Server Management Console.
1. Click client Computers node in Server Management Console and all domain
client PCs are listed in right panel.
2. Click any PC you want to manage and click Connect to Computer via
Terminal services in left side of link. You can logon to the pc.

Prerequisite:

1. Configure the internal Windows XP machine as the SecureNAT client. It
means that the Default Gateway of the internal machine must be the internal
IP of the SBS.

2. If you have ISA Server 2000 installed on the SBS 2003, we may perform
the following steps:

1) Create a Client Address Set, and then add the IP addresses of the
internal machines that need to use ODBC through SBS.
2) Create a Protocol Rule to allow all outgoing traffic, and then apply to
the newly created Client Address Set.
3) Create a Site and Content Rule to allow sites and contents, and then
apply to the newly created Client Address Set.
4) Restart the Firewall service.

After that, your internal machines should be able to connect ODBC through
SBS.

In addition, we would also like to give some reference about how to use
script to implement your needs. You can refer to the following KB articles:

How To Set Up ODBC Data Sources When Distributing Apps
http://support.microsoft.com/default.aspx?scid=kb;en-us;123008

: How to Use SQLConfigDataSource to Create an Access System DSN
http://support.microsoft.com/default.aspx?scid=kb;en-us;231156

RegisterDatabase Method Does Not Modify ODBC.INI File
http://support.microsoft.com/default.aspx?scid=kb;en-us;132329

Hope above information helps! Please note script is not supported in the
newsgroups. If you have any further concern or question about the script of
the KB I suggest you post to our MSDN newsgroups. I have provided the link
below:

http://msdn.microsoft.com/newsgroups/default.asp

The reason why we recommend posting appropriately is you will get the most
qualified pool of respondents, and other partners who read the newsgroups
regularly can either share their knowledge or learn from your interaction
with us. Also, this is to make sure that the responders can better track
the problem I appreciate your understanding.

I am looking forward you!

Have a nice day!

Best Regards,

Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>Thread-Topic: ODBC
>thread-index: AcWWr/rpBMXBov0dRjWrKOnggEvd7Q==
>X-WBNR-Posting-Host: 83.104.194.213
>From: =?Utf-8?B?U2tj?= <EMail@HideDomain.com>
>Subject: ODBC
>Date: Mon, 1 Aug 2005 08:45:02 -0700
>Lines: 16
>Message-ID: <EMail@HideDomain.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:140506
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>I need to create an ODBC connection from XP Pro client to our SQL Server
(on
>the network). We are running SBS2003 Premier.
>
>Can I:
>
> 1. Remote control to these machines (like VNC) and do this without having
>to visit
> the machines in turn...or...
> 2. Upload some kind of install so that it updates the ODBC DSN?
>
>I need some help. I have around 30 machines to do, and I would rather
spend
>30 minutes doing this than a whole day!
>
>Please help.
>
>skc
>