![]() ‘ close record set ‘ close connection to the databaseĮnd Sub - Sudipta Chatterjee using this connection string and it is working for all editions of SQL from 7 to 2008. ‘ your code to process the fields ‘ to access a field called username you would ‘ reference it like !username ‘ loop through the record set ‘ processing the records and fields. ![]() ![]() OpenResultset( rdOpenKeyset, rdConcurRowVer) End With ‘ set up a remote data object query ‘ specifying the SQL statement to run. ‘ change the connect string with your username, ‘ password, server name and the database you ‘ wish to connect to.ĬnMySql.CursorDriver = rdUseOdbc cnMySql.Connect = “uid=YourUserName pwd=YourPassword server=YourServerName ” & _ “driver= database=YourDataBase dsn= ” cnMySql.EstablishConnection ![]() ‘ set up a remote data connection ‘ using the MySQL ODBC driver. Dim cnMySql As New rdoConnection Dim rdoQry As New rdoQuery Dim rdoRS As rdoResultset ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |