Connection JDBC64 ODBC64 W764 sous mathematica8

[norbya]

Code :

1
2
Needs["DatabaseLink`"]
Conn = OpenSQLConnection[JDBC["odbc", "test"]]

JDBC::error:

[Microsoft][Gestionnaire de pilotes ODBC] Longueur de chaîne ou de mémoire tampon non valide >>

$Failed

je n'arrive pas à me connecter via jdbc à mon pilote odbc (test ok)

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
derniers pilotes Firebird-2.5.0.26074_1_x64, Firebird_ODBC_2.0.0.150_x64,java jdk-6u23-windows-x64
 
JDBCDrivers[] // MatrixForm
 
{
 {JDBCDriver["Name" -> "Microsoft Access(ODBC)", 
   "Driver" -> "sun.jdbc.odbc.JdbcOdbcDriver", 
   "Protocol" -> 
    "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; Dbq=", 
   "Version" -> 2., 
   "Description" -> 
    "Microsoft Access file using JDBC-ODBC Bridge distributed with \
the Sun JVM.  This driver only works on Windows.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\accessodbc.m"]},
 {JDBCDriver["Name" -> "hsqldb", "Driver" -> "org.hsqldb.jdbcDriver", 
   "Protocol" -> "jdbc:hsqldb:file:", "Version" -> 2., 
   "Description" -> 
    "HSQL Database Engine - Version 1.8.0.2 - This JDBCDriver has \
been deprecated.  Please use HSQL(Standalone).", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\hsqldb.m"]},
 {JDBCDriver["Name" -> "HSQL(Memory)", 
   "Driver" -> "org.hsqldb.jdbcDriver", 
   "Protocol" -> "jdbc:hsqldb:mem:", "Version" -> 2., 
   "Description" -> 
    "HSQL Database Engine (In-Memory Mode) - Version 1.8.0.2 -  This \
mode runs the database engine in a way that the database is not \
persistent and exists entirely in random access memory. As no \
information is written to disk, this mode should be used only for \
internal processing of application data or certain special \
applications.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\hsqldbmemory.m"]},
 {JDBCDriver["Name" -> "HSQL(Server)", 
   "Driver" -> "org.hsqldb.jdbcDriver", 
   "Protocol" -> "jdbc:hsqldb:hsql://", "Version" -> 2., 
   "Description" -> 
    "HSQL Database Engine (Server Mode) - Version 1.8.0.2 -  This \
mode runs a database server with a proprietary communications \
protocol that enables clients from various Java Virtual Machines and \
computers to access a database.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\hsqldbserver.m"]},
 {JDBCDriver["Name" -> "HSQL(Server+TLS)", 
   "Driver" -> "org.hsqldb.jdbcDriver", 
   "Protocol" -> "jdbc:hsqldb:hsqls://", "Version" -> 2., 
   "Description" -> 
    "HSQL Database Engine (Server Mode with TLS) - Version 1.8.0.2 - \
This mode runs a database server with Transport Layer Security (TLS) \
protocols.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\hsqldbservertls.m"]},
 {JDBCDriver["Name" -> "HSQL(Standalone)", 
   "Driver" -> "org.hsqldb.jdbcDriver", 
   "Protocol" -> "jdbc:hsqldb:file:", "Version" -> 2., 
   "Description" -> 
    "HSQL Database Engine (In-Process Mode) - Version 1.8.0.2 -  This \
mode runs the database engine as part of your application program in \
the same Java Virtual Machine. The main drawback is that it is not \
possible by default to connect to the database from outside your \
application.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\hsqldbstandalone.m"]},
 {JDBCDriver["Name" -> "HSQL(Webserver)", 
   "Driver" -> "org.hsqldb.jdbcDriver", 
   "Protocol" -> "jdbc:hsqldb:http://", "Version" -> 2., 
   "Description" -> 
    "HSQL Database Engine (Webserver Mode) - Version 1.8.0.2 -  This \
mode is used when access to the computer hosting the database server \
is restricted to the HTTP protocol. The only reason for using the Web \
Server mode is restrictions imposed by firewalls on the client or \
server machines and it should not be used where there are no such \
restrictions. The HSQLDB Web Server is a special web server that \
allows JDBC clients to connect via HTTP.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\hsqldbwebserver.m"]},
 {JDBCDriver["Name" -> "HSQL(Webserver+TLS)", 
   "Driver" -> "org.hsqldb.jdbcDriver", 
   "Protocol" -> "jdbc:hsqldb:https://", "Version" -> 2., 
   "Description" -> 
    "HSQL Database Engine (Web Server Mode with TLS) - Version \
1.8.0.2 - This mode runs a web server database with Transport Layer \
Security (TLS) protocols.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\hsqldbwebservertls.m"]},
 {JDBCDriver["Name" -> "jtds_sqlserver", 
   "Driver" -> "net.sourceforge.jtds.jdbc.Driver", 
   "Protocol" -> "jdbc:jtds:sqlserver://", "Version" -> 2., 
   "Description" -> 
    "Microsoft SQL Server using jTDS - Version 1.2.5 - This \
JDBCDriver has been deprecated.  Please use MS SQL Server(jTDS).", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\jtds_sqlserver.m"]},
 {JDBCDriver["Name" -> "jtds_sybase", 
   "Driver" -> "net.sourceforge.jtds.jdbc.Driver", 
   "Protocol" -> "jdbc:jtds:sybase://", "Version" -> 2., 
   "Description" -> 
    "Sybase Adaptive Server using jTDS - Version 1.2.5 - This \
JDBCDriver has been deprecated.  Please use Sybase(jTDS).", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\jtds_sybase.m"]},
 {JDBCDriver["Name" -> "mysql", "Driver" -> "com.mysql.jdbc.Driver", 
   "Protocol" -> "jdbc:mysql://", "Version" -> 2., 
   "Description" -> 
    "MySQL using Connector/J - Version 5.1.13 - This JDBCDriver has \
been deprecated.  Please use MySQL(Connector/J).", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\mysql2.m"]},
 {JDBCDriver["Name" -> "MySQL(Connector/J)", 
   "Driver" -> "com.mysql.jdbc.Driver", "Protocol" -> "jdbc:mysql://",
    "Version" -> 2., 
   "Description" -> 
    "MySQL using Connector/J - Version 5.1.13 - This supports all \
known MySQL server versions.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\mysql.m"]},
 {JDBCDriver["Name" -> "ODBC(DSN)", 
   "Driver" -> "sun.jdbc.odbc.JdbcOdbcDriver", 
   "Protocol" -> "jdbc:odbc:", "Version" -> 2., 
   "Description" -> 
    "JDBC-ODBC Bridge distributed with the Sun JVM.  This driver only \
works on Windows.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\odbcdsn.m"]},
 {JDBCDriver["Name" -> "odbc", 
   "Driver" -> "sun.jdbc.odbc.JdbcOdbcDriver", 
   "Protocol" -> "jdbc:odbc:", "Version" -> 2., 
   "Description" -> 
    "JDBC-ODBC Bridge distributed with the Sun JVM - This JDBCDriver \
has been deprecated.  Please use ODBC(DSN).  This driver only works \
on Windows.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\odbc.m"]},
 {JDBCDriver["Name" -> "PostgreSQL", 
   "Driver" -> "org.postgresql.Driver", 
   "Protocol" -> "jdbc:postgresql://", "Version" -> 2., 
   "Description" -> 
    "PostgreSQL using PostgreSQL JDBC Driver - Version 8.4.701. ", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\postgresql.m"]},
 {JDBCDriver["Name" -> "Microsoft SQL Server(jTDS)", 
   "Driver" -> "net.sourceforge.jtds.jdbc.Driver", 
   "Protocol" -> "jdbc:jtds:sqlserver://", "Version" -> 2., 
   "Description" -> 
    "Microsoft SQL Server using jTDS - Version 1.2.5 - This supports \
Microsoft SQL Server 6.5, 7, 2000, 2005, and 2008.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\sqlserverjtds.m"]},
 {JDBCDriver["Name" -> "Sybase(jTDS)", 
   "Driver" -> "net.sourceforge.jtds.jdbc.Driver", 
   "Protocol" -> "jdbc:jtds:sybase://", "Version" -> 2., 
   "Description" -> 
    "Sybase Adaptive Server Enterprise using jTDS - Version 1.2.5 - \
This supports Sybase Adaptive Server Enterprise 10, 11, 12, and 15.", 
   "Location" -> 
    "C:\\Program Files\\Wolfram \
Research\\Mathematica\\8.0\\SystemFiles\\Links\\DatabaseLink\\\
DatabaseResources\\sybasejtds.m"]}
}

merci de votre aide

[makowski]

quelle idée de passer par odbc, le pilote java de Firebird n'a pas besoin d'odbc
http://firebirdsql.org/index.php?op=files&id=jaybird