Connection String in Excel VBA

[joprotus]

I am currently developing a VBA program that automatically connects the pivot table to an MS Access database. My problem is how can I make my program flexible to handle different databases like SQL Server or Oracle. Is it possible to generate a different connection string at run time?:banghead:

Any help will be appreciated.:help

[Bob Phillips]

Of course it is.

Create separate sub-routines with the different connection strings setup, and call the appropriate one at runtime.

You will have to determine how that decision is made.

[joprotus]

Thanks xld, but is it possible to make more flexible like a connection builder.

[Bob Phillips]

You would need to elaborate what you mean by that.

[anandbohra]

hope this will help u to quickly recall the connection string code


http://www.connectionstrings.com/

[joprotus]

Thank you guys for the help. I am sorry if I didn't make myself clear here. Fortunately, I solved this problem already. Here's the link of the solution: Building Database Connection String Programmatically (http://msexcelvba.blogspot.com/2007/08/building-database-connection-string.html)