Hi, John --

>Still wrestling with ODBC, huh?
Of course, but I'm going to lick this darn thing :)

>OK, it may be that you are supplying the wrong values with SQLCONNECT(). You should be connecting with
I'm pretty sure they were in the same order as you mentioned, but just to doublecheck I went back and deleted things and copied exactly what you have here.

>The Datasource name should be defined. Look into your system settings to see if you have a DSN defined with that DataSource name.
It was, but I deleted and rebuilt it according to your paragraph below

>The DataUserID should be the UserID expected by the database -or- ODBC and has nothing to do with your network login ID. Same for password.
Well, that's neat news that I (quite obviously) didn't understand. So these are things that I could capture and if I were tapping into a database that would need to know who the person was, then use them instead of another logon screen?


>Now, if I recall, you're working with Access. Go to the ODBC Data Source Administrator app in Control Panel. Go to the System DSN tab. Hit the Add button and then choose MS Access 97 as your datasource. Give the new System DSN a name (such as "mydata") and select which MDB file you want to connect to. In VFP, then, all you need from there on is:
Good memory. Yes, it is Access. And I did all that. In fact, it's what I had done before but I deleted what I had and followed your directions exactly. The only difference is that datasource said MS Access but not MS Access 97. Does that have anything to do with it?

>nConn=SQLCONNECT("mydata","","") && No need for UserID or Password.
Okay, so I put this line in my code. I can connect no problem. I'm making the connection fine. And when the datasource choosing screen pops up I just press enter because my datasource is already highlighted. When the name/password screen comes up I just press enter (it's empty, becuase I've got just "" in the sqlconnect line) and it works just fine... connects me right on.

What I'm trying to do is get rid of the datasource choosing screen and the name/password screen altogether. They're apparently not necessary since I just enter on through them. So I'd like to get rid of them.

Sorry this is so long and I don't mean to seem argumentative or anything. I'm just very confused. Who knows, maybe I'm asking the impossible or something. But it just seems that those screens are unnecessary. Thanks for bearing with me.