I'm going to answer my own question. The correct syntax is: odbc://username:password@/odbc_data_source_name
It's fine now. George George McCown GIS Analyst 1 george.mccown&jjg.com 678.333.0228 (Direct) 678-333-0826 (Fax) Jordan, Jones & Goulding 6801 Governors Lake Parkway, Building 200 Norcross, Ga 30071 www.jjg.com From: McCown, George Sent: Friday, July 17, 2009 1:09 PM To: 'pmapper-users@lists.sourceforge.net' Subject: pear DB, RESULT_JOIN for sql server Hello Armin, Would you know the correct syntax for using: "RESULT_JOIN" odbc://'':''/h...@odbc_connection_dsn||db_ta...@db_join_field@0...@field1,f ield2,field3||SHAPE_join_field||1" to a sql server using sql server authentication? I've tried adding user , pass, and server name in place of host. Presently I'm using: "RESULT_JOIN" "odbc://'':''/<servername>@odbc_connection_dsn||temp2.gisuser.JOIN_TEST5 @officeid...@0@Zip||OfficeID2||0" PHP error log: Standard Message: DB Error: connect failed DBMS/Debug Message: [nativecode=28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''''.] ** odbc://'':''/gis-ba...@mapserver Any help would be appreciated George This email and any files transmitted with it are intended solely for the use of the individual and/or entity to whom it is addressed. Unless noted otherwise above, any distribution or copying of this email is strictly prohibited. This email IS NOT a binding agreement on behalf of JJG. If you have received this message in error, please immediately notify the sender and delete this message from your computer. Jordan, Jones and Goulding, Inc., 6801 Governors Lake Pkwy, Norcross, Ga. 30071 www.jjg.com ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users