yī zhǒng Windows wǎng luò lián jiē, zhǐ néng yóu yǐ tōng guò wǎng luò de shēn fèn yàn zhèng de yòng hù dǎ kāi。 yòng hù yóu qí Windows dēng lù ID biāozhì, qiě bù bì shū rù dān dú de SQLServer dēng lù ID。
shù jù kù lián jiē pèi zhì yǔ jù :<addname=" lián jiē zì fú chuàn míng "connectionString="DataSource=localhost;InitialCatalog= shù jù kù míng chēng ;IntegratedSecurity=True"providerName=" lián jiē shí lì ( lì rú System.Data.SqlClient)"/>
java: jdbc lián jiē dào SQLServer
a. jiě yā jdbc 'ān zhuāng bāo , jiāng sqljdbc_auth.dll wén jiàn kǎo bèi %systemroot%windows/system32 xià
b. zài biān yì qì xià BuildPath->ConfigureBuildPath..., tiān jiā kuò zhǎn jar wén jiàn , jí bǎ sqljdbc.jar
c. lián jiē cān zhào yǔ jù rú xià:
zài sqlserver2000 zhōng jiā zài qū dòng hé URL lù jìng de yǔ jù shì
StringdriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
StringdbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sample";
ér sqlserver2005 zhōng jiā zài qū dòng hé url de yǔ jù zé wéi
StringdriverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
StringdbURL="jdbc:sqlserver://localhost:1433;DatabaseName=sample"; |