![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Connect to DXL Server Topic Summary: How do I connect to a DXL server via DXL? Created On: 29-Aug-2008 16:09 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() Answer: I found this example. Take a look at www.connectionstrings.com to see what the exact connection string should be for your database. | |
![]() |
|
I need to extract some data from an SQL database. In this forum I found the following code to connect to a Access database:
"... vCS = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\\DOORS.MDB" // path !!! oConn = oleCreateAutoObject("adodb.connection") oRst = oleCreateAutoObject("adodb.recordset") oFields = oleCreateAutoObject("adodb.fields") olePut( oConn , "ConnectionString" , vCS ) oleMethod( oConn , "Open") oleGet( oConn , "ConnectionString" , sConn ) olePut( oRst , "Source" , "Select * from Table1" ) // SQL statement olePut( oRst , "CursorType" , 0 ) // 0 = forward cursor only olePut( oRst , "CursorLocation" , 3 ) // client cursor olePut( oRst , "Mode" , 1 ) // locking = readonly olePut( oRst , "ActiveConnection" , oConn ) // set connection oleMethod( oRst , "Open" ) ..." My question is: How do I have to change the code to connect to an SQL database. There must be information about the server, database, user id, password. How shall the connect string look like? Does anybody have experience with this stuff? Any suggestions, code fragments or helpful hints would be highly appreciated. ------------------------- Peter |
|
![]() |
|
![]() |
|
Sorry: the topic title should have been: "Connect to SQL server"
------------------------- Peter |
|
![]() |
|
![]() |
|
I found this example.
Take a look at www.connectionstrings.com to see what the exact connection string should be for your database. ------------------------- Tony Goodman Smart DXL limited www.smartdxl.com |
|
![]() |
|
![]() |
|
Tony,
thanks for your reply. Now I got the connection to the SQL server. But I have no idea how the DXL code should look like to access the records/fields within the database. The link within your code did not help very much. Does anybody have an example code fragment how this can be done? Thanks Peter ------------------------- Peter |
|
![]() |
|
![]() |
|
Here is another link.
MySQL ODBC Programming You will find examples on the internet in VB or .NET, but you will need to convert to DXL. ------------------------- Tony Goodman Smart DXL limited www.smartdxl.com |
|
![]() |
|
![]() |
|
Tony,
thanks a lot. I got it working now. ------------------------- Peter |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Connect to DXL Server
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.