Provider = SQLOLEDB Server = www.myserver.com you can put a username and password in to verify database connectivity, then after that you can remove them. After you remove them though, your datasource will report not verified in CF Administrator. This won't be a problem if your sending login info with your queries though. Marlon -----Original Message----- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:40 AM To: CF-Talk Subject: OLEDB Datasource Config I have been using ODBC for SQL Server2000 and would like to switch to OLEDB but my tired old brain is confused by settings in Administrator and I cant get datasource to verify. It is running on same box as CF (I know, I know but this is a small dev box self hosted). What are the settings I use for Provider and server and what about usernames and passwords in cf settings. I always have left those blank in odbc (and used trusted connection which doesnt appear as an option in oledb) TIA Don ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
