Re: ODBC & Remote SQL Server

1) Minimally, install the SQL Server 2005 native client on the client
system.
2) On the client system, use the Control Panel -> Administrative Tools ->
Data Sources applet to enter the required information.

"pradeep" <pwpradeep@xxxxxxxxx> wrote in message
news:1190092067.948256.107200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

How to create system DSN (ODBC) on windows 2003 for SQL Server located
on remote machine ?

Please, guide me.

Bye.



.

Relevant Pages

  • Re: SQL Server 2005 Express OLEDB Connection from VB6
    ... but consider that the SNAC provider has no MDAC dependency and exposes the entire gamut of SQL Server 2005 features--the ODBC provider does not. ... Microsoft SQL Server Native Client is a single ...
    (microsoft.public.sqlserver.connect)
  • Re: problem to connect sql server 2005 from localhost (W2k3)
    ... It's possible to connect the sql server via telnet? ... Solid Quality Mentors ... The ODBC - Driver Config is the same on XP ans W2k3. ... I am not use the native client, shared memory and tcp/ip is on, the rest ...
    (microsoft.public.sqlserver.connect)
  • Re: Export from Access 2007 to SQL2008
    ... You can try to fly to London, but if the drop you of in Iceland it makes no ... which is a SQL server instance on a different computer. ... Native client and odbc are two different issues.... ... When you upsize if you choose linked tables, then that is ODBC. ...
    (microsoft.public.access.externaldata)
  • Prompt user login when refresh data
    ... I have some Excel files which use Pivot Table to retrieve ... The backend data is stored in SQL server and ODBC ... (System DSN) ...
    (microsoft.public.excel.programming)
  • Re: How to do a mail merge in VBA
    ... I'm using Word 2000 and MS SQL Server 2000. ... I have already setup a System DSN in ODBC. ...
    (microsoft.public.word.mailmerge.fields)
Loading