Hello, I have an established ODBC connection to a Notes Domino Server where I can
connect to tables and pull down information using MS Access. So as far as I'm
aware the ODBC part is confirugred properly.
My linked server properties are
Provider Name: Microsoft OLE DB Provider for ODBC Drivers
Product name: Tracking_System {copied from dsn name}
Data source: Tracking_System {copied from dsn name}
Provider String/Location/Catalog: {null}
Security Tab - use this security context: (Notes user ID - fully qualified)
and my password - the same info I used to create ODBC which worked.
Server Options: Data Access and Use Remote Collation are the only items
checked... timeouts are both zero
Linked server to ODBC DSN ...Server, and want to create a linked server to this same ODBC DSN:...Provider = "Microsoft OLE DB Provider for ODBC Driver" ... Then i connect to the SQL Server using QA, and try to run my query (that ... (microsoft.public.sqlserver.server)
Re: Mail Merge Data Source from Web Pages ... I do not believe it can be done without an intermediate step, because Word will not open files on Internet URLs such as http: or ftp: as mailmerge data sources. ... Whataver the data source, Word seems to insist on having /something/ that can be reached via the Windows file system or is held on the local workstation. ... For example, "file data sources" such as .txt, .mdb etc. can be reached directly, but even "server-based" data sources such as SQL Server tables can only reached by having either an ODBC User/System DSN, an ODBC file DSN, an OLE DB .udl or ..odc file, or an external text file converter installed on the local machine. ... (microsoft.public.word.mailmerge.fields)
Re: Does connection string need anything on system? ... This DSN needed to be configured to know which database driver was going to be needed and which actual data source was being used. ... This is what the ODBC Manager tool in Control Panel> Admin Tools is for...setting up a DSN. ... With OLEDB, you code directly against the provider and, as long as the provider is present on the target machine, the code can talk to it. ... (microsoft.public.dotnet.framework.aspnet)
Re: ODBC-Server Middleware ... We are looking for an ODBC driver which meets the following ... Dirty read is configurable per Data Source... Multiple ports for differential configurations could be ...Server Software should run on Solaris ... (comp.databases.informix)
Re: Alternative to using DSN to connect to database ... you have to use .NET ODBC provider....Server is NOT optimized. ... Just because of the Admiistrator thinking DSN is easier for him to control ... > Basically my problem is that the ODBC Connection Manager in Control Panel ... (microsoft.public.dotnet.framework.adonet)
