Instead of creating a DSN, why don't you provide a dynamic connection
string at run time instead? It's more secure and easier to maintain.
You can get ODBC connection string syntax from connectionstrings.com.
-mary
On Mon, 17 Sep 2007 22:07:47 -0700, pradeep <pwpradeep@xxxxxxxxx>
wrote:
Hello,
How to create system DSN (ODBC) on windows 2003 for SQL Server located
on remote machine ?
Re: Question re MailMerge and VB.NET ... There is an ODBC API call to create a DSN which you should, in theory, call ... ' lpszDriver is a string containing the Driver name /exactly/ as it appears ...Private Const ODBC_CONFIG_DSN = 2 ... ' an example showing how to make a SQL Server DSN... (microsoft.public.word.mailmerge.fields)
RE: Run-time error 3011 using Foxpro ODBC ... it is enough to just mention the DSN.... -The constant acTable is ignored unless the database source type is MS ... Dim strConnect As String... DoCmd.TransferDatabase acImport, "ODBC Database", strConnect,, ... (microsoft.public.data.odbc)
Re: Linked Table Properties - using ODBC trying to rmv DATABASE NA ... the connect parms after creating a link table. ... The relink is executed by calling the refreshLink method.... The DSN setup also has the appropriate signon and password. ... I tried resetting the connect string in the refreshLink method but it does ... (microsoft.public.access.tablesdbdesign)
RE: Edit ODBC settings ... simply hard-coding the new DSN for each), but found that it was failing ... because my ProvideX ODBC connect string exceeds 255 characters when I use the ... T:\DBFolder to C:\Data\Apps\DBFolder so that it will work on the server.... can I now edit the path in the ODBC-linked table to reflect the local path in ... (microsoft.public.access.queries)
Re: Word 2003 MailMerge with SQL Server 2000 problem ... Okay, I switched the way I was connecting, and started using a DSN... If I could either create a DSN-less connection string for Mail Merge, ... Personally I wouldn't use the 1=1 workaround on the grounds that the query...SQL Server does but I once did this with Oracle to get around some problem ... (microsoft.public.word.mailmerge.fields)
