Retrospective.Good times.

This is how the first version of ConnectionStrings.com looked. It listed only ODBC and OLE DB for Access and SQL Server.

1998

The UL list clickable tree view took some time to work out. The logotype was created by a friend. I was new in IT and did ASP and Visual Basic for a small company in Stockholm. I was very proud to put something up on the internet. My colleague showed it to his girlfriend whose reaction was "Is that really a website? It's not ready-made huh?" :)
The site was first published in the year 1998.

    
                                Click to expand

                                 i
                            
                            ODBC
                            SQLServer
                                    
                                            Standard Security:

                                            oConn.Open "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
                                            
                                            Trusted connection:

                                            oConn.Open "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
                                            
                                            Prompt for username and password:

                                            oConn.Properties("Prompt") = adPromptAlways

                                            oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
                                            
Access
                                    
                                            Standard Security:

                                            oConn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"
                                            
                                            Workgroup:

                                            oConn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""
                                            
                            OLE DB
                            SQLServer
                                    
                                            Standard Security:

                                            oConn.Open "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"00)
                                            
                                            Trusted Connection:

                                            oConn.Open "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
                                            (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
                                            
                                            Prompt for username and password:

                                            oConn.Provider = "sqloledb"

                                            oConn.Properties("Prompt") = adPromptAlways

                                            oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"
                                            
                                            Connect via an IP address:

                                            oConn.Open "Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
                                            (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
                                        
Microsoft Jet
                                    
                                            Standard security:

                                            oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=asdasd;"
                                            
                                            Workgroup (system database):

                                            oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""
                                            
                                            With password:

                                            oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;","admin", ""