![]() ![]()
OdbcCom = New OdbcCommand(stSQL, odbcCon) OdbcCon = New OdbcConnection(stConnection) StConnection = "Driver= IsDatabaseLocal=yes Database=" stDatabaseĭim stSoureFile As String = "C:\Users\Dennis Wallentin\Documents\Data\SalesData.xlsm" StDataBase = "C:\Users\Dennis Wallentin\Documents\Valentina DBs\FirstDB.vdb" Sub Retrieve_Data_ValentinaDB_ADO_ODBC_Driver() WsTarget.Cells(2, 1).CopyFromRecordset adoRecordset WsTarget.Cells(1, lnCountFields 1).Value = _ LnCountFields = įor lnCountFields = 0 To lnCountFields - 1 "FileDSN=C:\Users\Dennis Wallentin\Documents\Valentina.dsn"ĪdoRecordset.Open Source:=stSQL, ActiveConnection:= _ ![]() Set wsTarget = ThisWorkbook.Worksheets("Data") Sub Retrieve_Data_ValentinaDB_ADO_FILEDSN() 'Microsoft ActiveX Data Objects Library x.x In both cases I use the Microsoft ADO library in order to work with the database and with its data. In the second case I create the connection string in code. It contains the following information:ĭatabase=C:\Users\Dennis Wallentin\Documents\Valentina DBs\FirstDB.vdb In the first case I use a DSN file as the source for the connection string. #Nsb appstudio alternative driverWhat we need to do before using the licensed ODBC driver is to register it on the computer which requires us to create a user DSN or a File DSN. #Nsb appstudio alternative codeI have intentionally left out all comments of the code as it should be rather self-explanatory. Once installed Valentina Reports will be part of the Studio.Ĭonnecting to a Valentina DB through VBA using ODBC We can also use their excellent Valentina Reports to create highly customized reports both for Valentina DBs and also for SQLite DBs. The Studio enables us to work with databases and also to connect to Valentina Office Servers. #Nsb appstudio alternative proIn addition to the Valentina DB product Paradigma Software also offers related tools such as the Valentina Pro Studio, which supports 18 Valentina DB platforms.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |