ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Connecting to a database (https://www.excelbanter.com/excel-programming/362773-connecting-database.html)

cmpcwil2[_20_]

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


Robin Hammond[_2_]

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





All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com