MS SQL Database Connection

[Karl@CP PISTONS]

Does anybody know how or if it's even possible to use the vb scripting in mastercam Ver. 9 to connect and extract info from a MS SQL Database?

 

I can do it inside solidworks vb using the connection tools but that is a full vb package.

 

I made an attempt using the same style as my sw code but it does not recognize the connection type.

 

Karl

[Roger Martin from CNC Software]

Karl,

I haven't a clue about using VBScript to connect to an SQL database, but don't believe that the VBScript in Mastercam "limits" your ability to do so.

 

Something like this? ->

code:

---

StrConnect = "Driver={SQL Server};Server=127.0.0.1;Database=UserDB;UID=sa;PWD=1234"

Set cnt = CreateObject("ADODB.Connection")

cnt.Open StrConnect

 

Set recordSet = CreateObject("ADODB.Recordset")

SQLStr = "Select * from TableNames"

recordSet.Open SQLStr, cnt, 1, 1

---

www.connectionstrings.com

[Guest SAIPEM]

strDBServerName = "YourServerName"

strDBName = "YourDBName"

 

Set objSQLServer = CreateObject("SQLDMO.SQLServer")

objSQLServer.LoginSecure = True

objSQLServer.Connect strDBServerName, yourlogin, yourpassword

 

Set objDB = objSQLServer.Databases(strDBName)

Set colTables = objDB.Tables

For Each objTable In colTables

WScript.Echo "Table Name: " & objTable.Name

Next

[Karl@CP PISTONS]

Thanks for the info. Will try this as soon as I get a few minutes.

I knew this was the place to ask