>
> I believe you can learn the JDBC URL by looking at the
> neo-query.xml file,
> or at least the format.
>
thanx Darryl -you mean this, yes?
<var name='url'>
<string>
jdbc:macromedia:sqlserver://astro:1433;databaseName=tasswebdev
;SelectMethod=direct;sendStringParametersAsUnicode=false
;MaxPooledStatements=1000
</string>
</var>
nope, CFEclipse.QuantumDB can't connect:
Error: Driver returned a null connection:
[name=sql_twdjdbc
, username=cfuser, password=****
, connect=jdbc:macromedia:sqlserver://10.240.0.11:1433;
databaseName=tasswebdev;
, [EMAIL PROTECTED]
(tried sqlserver://10.240.0.11:1433 and sqlserver://<machine_name>:1433)
looks like not many ppl are using QuantumDb with SQLServer...
I'll keep looking I suppose...
thanx
barry.b
<var name='sql_twdjdbc'>
<struct type='coldfusion.server.ConfigMap'>
<var name='update'><boolean value='true'/></var>
<var name='alter'><boolean value='true'/></var>
<var name='delete'><boolean value='true'/></var>
<var name='disable_blob'><boolean value='true'/></var>
<var name='buffer'><number>64000.0</number></var>
<var name='storedproc'><boolean value='true'/></var>
<var
name='password'><string>381B1AAF945FBEDAF301BB1839F5BA32</string></var>
<var name='insert'><boolean value='true'/></var>
<var name='drop'><boolean value='true'/></var>
<var
name='CLASS'><string>macromedia.jdbc.MacromediaDriver</string></var>
<var name='description'><string></string></var>
<var name='create'><boolean value='true'/></var>
<var name='NAME'><string>sql_twdjdbc</string></var>
<var name='DRIVER'><string>MSSQLServer</string></var>
<var name='select'><boolean value='true'/></var>
<var name='url'>
<string>
jdbc:macromedia:sqlserver://astro:1433;databaseName=tasswebdev
;SelectMethod=direct;sendStringParametersAsUnicode=false
;MaxPooledStatements=1000
</string>
</var>
<var name='blob_buffer'><number>64000.0</number></var>
<var name='revoke'><boolean value='true'/></var>
<var name='urlmap'>
<struct type='coldfusion.server.ConfigMap'>
<var name='datasource'><string></string></var>
<var
name='sendStringParametersAsUnicode'><string>false</string></var>
<var name='pageTimeout'><string></string></var>
<var name='MaxPooledStatements'><string>1000</string></var>
<var name='port'><number>1433.0</number></var>
<var name='TimeStampAsString'><string>no</string></var>
<var name='systemDatabaseFile'><string></string></var>
<var name='defaultpassword'><string></string></var>
<var name='informixServer'><string></string></var>
<var name='database'><string>tasswebdev</string></var>
<var name='host'><string>astro</string></var>
<var name='UseTrustedConnection'><string>false</string></var>
<var name='args'><string></string></var>
<var name='logintimeout'><number>30.0</number></var>
<var name='CONNECTIONPROPS'>
<struct>
<var name='DATABASE'><string>tasswebdev</string></var>
<var
name='SENDSTRINGPARAMETERSASUNICODE'><string>false</string></var>
<var name='PORT'><string>1433</string></var>
<var
name='MAXPOOLEDSTATEMENTS'><string>1000</string></var>
<var name='HOST'><string>astro</string></var>
<var name='SELECTMETHOD'><string>direct</string></var>
</struct>
</var>
<var name='defaultusername'><string></string></var>
<var name='databaseFile'><string></string></var>
<var name='maxBufferSize'><string></string></var>
<var name='selectMethod'><string>direct</string></var>
<var name='SID'><string></string></var>
</struct>
</var>
<var name='ISJ2EE'><boolean value='false'/></var>
<var name='interval'><number>420.0</number></var>
<var name='grant'><boolean value='true'/></var>
<var name='timeout'><number>1200.0</number></var>
<var name='username'><string>cfuser</string></var>
<var name='pooling'><boolean value='true'/></var>
<var name='disable_clob'><boolean value='true'/></var>
<var name='disable'><boolean value='false'/></var>
<var name='login_timeout'><number>30.0</number></var>
</struct>
</var>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
