Format=TabDelimited
option in your connection string.SourceType
parameter by DBF
as in the following connection string:Trusted_Connection
that indicates that you are using the Microsoft Windows NT Authentication Mode to authorize user access to the SQL Server database. For example:(local)
like in the following sample:Address
parameter must be an IP address and must include the port. The Network
parameter can be one of the following:dbnmpntw
Win32 Named Pipes dbmssocn
Win32 Winsock TCP/IP dbmsspxn
Win32 SPX/IPX dbmsvinn
Win32 Banyan Vines dbmsrpcn
Win32 Multi-Protocol (Windows RPC) Server
parameter. If the Port is distinct to 3306 (default port), you must specify it.Option
can be one or more of the following values:1
- The client can't handle that MyODBC returns the real width of a column. 2
- The client can't handle that MySQL returns the true value of affected rows. If this flag is set then MySQL returns 'found rows' instead. One must have MySQL 3.21.14 or newer to get this to work. 4
- Make a debug log in c:myodbc.log. This is the same as putting MYSQL_DEBUG=d:t:O,c::myodbc.log
in AUTOEXEC.BAT. 8
- Don't set any packet limit for results and parameters. 16
- Don't prompt for questions even if driver would like to prompt. 32
- Enable or disable the dynamic cursor support. This is not allowed in MyODBC 2.50. 64
- Ignore use of database name in 'database.table.column'. 128
- Force use of ODBC manager cursors (experimental). 256
- Disable the use of extended fetch (experimental). 512
- Pad CHAR
fields to full column length. 1024
- SQLDescribeCol()
will return fully qualified column names. 2048
- Use the compressed server/client protocol. 4096
- Tell server to ignore space after function name and before '(' (needed by PowerBuilder). This will make all function names keywords! 8192
- Connect with named pipes to a MySQLd server running on NT. 16384
- Change LONGLONG
columns to INT
columns (some applications can't handle LONGLONG
). 32768
- Return 'user' as Table_qualifier
and Table_owner
from SQLTables (experimental). 65536
- Read parameters from the client and ODBC groups from my.cnf. 131072
- Add some extra safety checks (should not be needed but...). Option= 1030;
.Data Source=Servere NameInstance Name
like in the following example:(local)
in the Data Source
like in the following example:test
is the name of MySQL database. Also, you can replace the name of the database by the following connection string: server=localhost;DB=test
.'HDR=Yes'
, the provider will not include the first row of the selection into the recordset. If 'HDR=No'
, the provider will include the first row of the cell range (or named ranged) into the recordset.MAPILEVEL
indicates top level of folders).Data Source
property in the client application's connection string. This connection method allows PivotTable速 Service to tunnel through firewalls or proxy servers to the Analysis server. A special Active Server Pages (ASP) page, Msolap.asp, enables the connection through IIS. The directory in which this file resides must be included as part of the URL when connecting to the server (for example, http://www.myserver.com/myolap/).Data Source=
' must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.