Discussion: ado and new odbc hotness

I'm not exactly the hippest of programmers, but it's time i catch up with this ADO object.

I've generally always just gone into data sources, dns services i think (second tab) and created an odbc thingy there. And in the obj.open "odbc name", "SQL login", "password"

I've been seeing recently more and more the string taking place of the odbc and all the other, seeing as how it selects db and uid and password is all in the string. What is the significance of this? avoiding using the ODBC data source tool? So a company can have a centralized method of accessing X database? Cause it's more complicated so it looks cooler? I was setting up a connection for a page that had the server on teh local machine and kept getting loging failure, or not found issues... quickly became frustrated and resorted to my gui ways.

I tried searching on the google but that came up with me getting frustrated and no answers. well... anyways, that's my piece, anyone else have some wise words to shed some light on this subject?

I am assuming that you are referring to DSN-less connection. The ODBC driver is still present but the benefit is that the connection can be dynamically created and portable to all machines where the driver is present without having to create a new datasource each time. Are you having difficulties getting the string to work or creating the string? What programming language are you using?

Yea, i see that DSNless word a lot pertaining to this.

I'm using vbscript right now mainly, hence i always see your replies on that forum.

yea, i was having problems getting it to run, more or less just messing around with it. I'd get it to work with a constant password, and then when i tried to use a session cookie for login and password it'd start messing up and couldn't figure out why, i gave up, i was just curious. Cause it seems that if you wanted to update the database, say move it, rename it, something. You'd have to go into each program, and change that string. Unless each program was pointing to some centrally located string located somewhere, in which case i don't see why doing it the old way i'm used to wouldn't be easier, seems like higher maintenance....

I just use it, i can't say i really understand it, cause i've used a function in PHP before (written by some guy in the company WAAAY better than me obviously) where it'd make a connection to the DB, and then any time you wanted to query again, it'd return the link rather than make a new connection, I think that may be something what you're talking about, but i've never really understood it.... just used it *shrug* So i can't say i REALLY understand what you're talking about with portable/dynamic connection.

Do you have a question or issue or test you are trying to get working? One of the easiest ways to learn how to create a dsn-less connection is by creating data connection in VB's data environment viewing the string and modifying it until you can construct your own.