Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Connecting to a database


Hi,
I have been reading through numerous posts and various web pages on how
to connect to a database and just need some assistance with this please.
I have been given a connection string (from a C# app) with numerous
elements such as server name database name password etc, can I make a
connection with just the connection string or do I need to find out
more, for example what type of database it is that I am trying to
connect to? What are the minimum parameters needed for connecting to a
database?
This is new ground for me so apologies for my ignorance.

Thanks in advance for any advice


--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=546656

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default Connecting to a database

There's a big collection of connection strings he
http://www.carlprothman.net/

or, you could get the excellent MZTools add-in which has a utility to create
the string.

Robin Hammond
www.enhanceddatasystems.com

"cmpcwil2" wrote in
message ...

Hi,
I have been reading through numerous posts and various web pages on how
to connect to a database and just need some assistance with this please.
I have been given a connection string (from a C# app) with numerous
elements such as server name database name password etc, can I make a
connection with just the connection string or do I need to find out
more, for example what type of database it is that I am trying to
connect to? What are the minimum parameters needed for connecting to a
database?
This is new ground for me so apologies for my ignorance.

Thanks in advance for any advice


--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile:
http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=546656



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically connecting to a remote database Tony Excel Discussion (Misc queries) 0 April 14th 08 05:35 PM
Connecting To a Excel Database NOODLES101487 Excel Programming 1 October 14th 05 02:26 PM
Connecting to External Database Geert Excel Programming 1 January 10th 05 04:46 PM
Need Help Connecting To DB J.Adams Excel Programming 3 May 31st 04 06:34 PM
Excel Connecting to SQL Server Database - Need your Help Rajesh G Excel Programming 2 February 27th 04 08:01 PM


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"