#1  
Old 12th September 2006, 03:10 AM
Darren Reist
 
Posts: n/a
Default Connection String for ADO Connection

Using ADODB, what is the appropriate connection string for a DSNless
connection to a NEXUS DB V1, using the ODBC Driver pack v1.

Thanks for your Help


  #2  
Old 12th September 2006, 09:48 AM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Connection String for ADO Connection

Darren Reist wrote:

> Using ADODB, what is the appropriate connection string for a DSNless
> connection to a NEXUS DB V1, using the ODBC Driver pack v1.


Something along the lines:

DRIVER={NexusDB V1 ODBC
Driver};Server=NexusDB@127.0.0.1;Transport=TCP;Dat abase=AliasName;


Here's the full list of recognized items:

Transport
the transport to use
possible string values: 'TCP', 'Internal', 'Named Pipes'
Internal means direct access to the data files, note that this
tries to start an internal server engine and only work for *ONE*
client instance at any given time.
(default: 'TCP')
Server
the Server name in the form nexusdb@serveraddressorname for tcp and
and ServerName for named pipes; not used for internal
(default: nexusdb@127.0.0.1)
Port
integer value for the port for TCP
(default: 16000)
Timeout
SQL Timeout in ms
(default: 10000 [10 sec])
Database
the database alias for tcp and named pipes
or the directory path for internal server
UserName
Password
User Name and passwordfor logging on to a secured server
(default: '')
BlockReadSize
BlockRead Size in bytes. Set to zero to disable Blockreads
Compression
Compression Type; 0 is none, 1 RLE compression,
2-10 zip compression with 10 is max compression (slowest


Additionally you can force a query to use a different timeout by using the
<PARAMS>Timout=value</PARAMS> tag in the query text. Value is the timeout
value in ms.


--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection Problem Arne De Herdt nexusdb.public.support.adoprovider 0 1st July 2010 06:16 PM
Connection timeout value Aurelien nexusdb.public.support.adoprovider 1 7th May 2010 08:28 AM
ADO.NET connection to database that has no alias ben909 nexusdb.public.support.adoprovider 0 15th April 2009 07:18 PM
Connection string Tonig123 nexusdb.public.support.adoprovider 1 5th February 2009 04:50 AM
When click on Build Connection string, windows crash G. de Nooij nexusdb.public.support.adoprovider 3 26th October 2005 08:53 PM


All times are GMT +11. The time now is 12:06 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.