We're trying to do a mail merge in Word using records from a SQL Server 7 database on one network and a PC on a different network. The network admin doesn't want to install any SQL Server components on the PC with Word. The solution we're trying at the moment is triggering a ColdFusion template to query the database, generate a tab delimited file which then gets e-mailed to the person doing the mail merge. I thought if we could set up a DSN using the Microsoft Text Driver on his PC, he could save the attachment to the same directory every time and get Word to snag the records from it. I thought it would be a doddle but I'm really struggling to set up the text DSN. Initially, trying to set it up displayed the error "Cannot insert attribute values (null) into (null)". Somehow, that stopped and the set-up seemed OK, with the schema.ini file containing the details of the basic text file in the same directory: ================================== CONTACTS.TXT Contact Company Address1 TownOrCity Postcode Aidan Whitehall The Net Profits 116 Ledburn Skelmersdale WN8 6TX Paul Halliday Netshopperuk Innovation House Rainford WA11 8LZ ================================== SCHEMA.INI [Contacts.txt] ColNameHeader=True Format=TabDelimited MaxScanRows=10000 CharacterSet=OEM Col1=Contact Char Width 255 Col2=Company Char Width 255 Col3=Address1 Char Width 255 Col4=TownOrCity Char Width 255 Col5=Postcode Char Width 255 ================================== But, when you query the data source via ColdFusion, you see this error: ============================================= ODBC Error Code = S1000 (General error) [Microsoft][ODBC Text Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. Hint: The cause of this error is usually either (1) You have used an incorrect data source name, or (2) You have changed the location of your data source either by moving it or renaming one of its parent directories. After moving a data source make sure you update its attributes using the ColdFusion Administrator. ============================================= Does anyone have any ideas on how to solve this? And does anyone know whether the CharacterSet should be OEM or ANSI? And if this solution is *completely* the wrong way of doing it, please say (skinning cats 'n all that). Thanks muchly. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
