Re: 如何通过脚本断开与数据库的连接？关键在于将数据库连接与查询分开命名。 在上面的示例中，RedBinMain 用于查询，而不是连接。 下面的例子应该使前面的句子真正有意义：
dbc = Create Database Connection(
"ODBC:DSN=Excel 12.0;DBQ=I:\Engineering\Data\JMPTempData\redbindownload_JMPTMP.xlsx;DefaultDir=I:\Engineering\Data\JMPTempData;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;"
);
//your script here: RedBinMain = New SQL Query ........ << Run Foreground
Close Database Connection (dbc);
Re: 如何通过脚本断开与数据库的连接？谢谢你！ 这很有意义并且现在可以工作，尽管我一开始遇到 ODBC 错误，直到我删除了 DSN= 语句之前的“ODBC:”。
我在查询中也插入了“dbc”作为连接变量，以防其他人看到它。 这是新的工作代码供参考。</CODE></P><P> </P><PRE><CODE class=" language-jsl">dbc = Create Database Connection(
"DSN=Excel 12.0;DBQ=I:\Engineering\Data\JMPTempData\redbindownload_JMPTMP.xlsx;DefaultDir=I:\Engineering\Data\JMPTempData;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;"
);
RedBinMain = New SQL Query(
Version( 130 ),
Connection(dbc),
QueryName( "RedBinMain_beta" ),
Select(
Column( "RBNbr", "t1" ),
Column( "DMR", "t1" ),
Column( "Date_Entered", "t1" ),
Column( "Initiator", "t1" ),
Column( "Location", "t1" ),
Column( "AssignedPerson", "t1" ),
Column( "Problem", "t1" ),
Column( "USI_PN", "t1" ),
Column( "Customer", "t1" ),
Column( "Disposition", "t1" ),
Column( "LastUpdatedDate", "t1" ),
Column( "Cause", "t1" ),
Column( "Classification", "t1" ),
Column( "Defect_Code", "t1" ),
Column( "BrokenSubMenu", "t1"),
Column( "BrokenSubMenu_1", "t1"),
Column( "Dimensional_Code", "t1" ),
Column( "Notes", "t1" ),
Column( "Assignable_WorkCell", "t1" ),
Column( "DispositionerInvestigator", "t1" ),
Column( "ScrappedQuantity", "t1" ),
Column( "PreEtch", "t1" ),
Column( "PostEtch", "t1" )
),
From( Table( "RedBinMain_beta", Alias( "t1" ) ) )
) << Run Foreground;
Close Database Connection (dbc);
如何通过脚本断开与数据库的连接？你好，
我正在使用“文件”>“数据库”>“查询生成器”方法连接到 Excel 文件并创建一个表。 我可以使用 jmp 脚本关闭表，但连接仍保持活动状态并为其他用户锁定 excel 文件。 如何通过 jmp 脚本断开连接？ 我可以手动执行“文件”>“数据库”>“打开”>“断开连接”，但我想在运行脚本中自动执行此操作。
这是查询代码：
RedBinMain = New SQL Query(
Version( 130 ),
Connection(
"ODBC:DSN=Excel 12.0;DBQ=I:\Engineering\Data\JMPTempData\redbindownload_JMPTMP.xlsx;DefaultDir=I:\Engineering\Data\JMPTempData;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;"
),
QueryName( "RedBinMain_beta" ),
Select(
Column( "RBNbr", "t1" ),
Column( "DMR", "t1" ),
Column( "Date_Entered", "t1" ),
Column( "Initiator", "t1" ),
Column( "Location", "t1" ),
Column( "AssignedPerson", "t1" ),
Column( "Problem", "t1" ),
Column( "USI_PN", "t1" ),
Column( "Customer", "t1" ),
Column( "Disposition", "t1" ),
Column( "LastUpdatedDate", "t1" ),
Column( "Cause", "t1" ),
Column( "Classification", "t1" ),
Column( "Defect_Code", "t1" ),
Column( "BrokenSubMenu", "t1"),
Column( "BrokenSubMenu_1", "t1"),
Column( "Dimensional_Code", "t1" ),
Column( "Notes", "t1" ),
Column( "Assignable_WorkCell", "t1" ),
Column( "DispositionerInvestigator", "t1" ),
Column( "ScrappedQuantity", "t1" ),
Column( "PreEtch", "t1" ),
Column( "PostEtch", "t1" )
),
From( Table( "RedBinMain_beta", Alias( "t1" ) ) )
) << Run Foreground;
我尝试了下面的代码，但没有成功
close database connection(RedBinMain);
我缺少什么？
这里使用 ODBC 驱动程序“Excel 12.0”连接显示为“已连接”
数据存取
