doMxDateTimeTest = False # Requires eGenixMXExtensions doTimeTest = True # obsolete python time format if doAccessTest: if onWindows and (node == SQL_HOST_NODE or not is64bit.Python()): c = {'mdb': setuptestframework.makemdb(testfolder, mdb_name)} else: c = {'macro_find_temp_test_path': ['mdb', 'server_test.mdb'], 'proxy_host': THE_PROXY_HOST} # macro definition for keyword "driver" using macro "is64bit" -- see documentation c['macro_is64bit'] = ['driver', "Microsoft.ACE.OLEDB.12.0", "Microsoft.Jet.OLEDB.4.0"] connStrAccess = "Provider=%(driver)s;Data Source=%(mdb)s" print(' ...Testing ACCESS connection...') doAccessTest, connStrAccess, dbAccessconnect = tryconnection.try_connection(verbose, connStrAccess, 10, **c) if doSqlServerTest: c = {'macro_getnode': ['host', r"%s\SQLExpress"], # name of computer with SQL Server # 'host':'25.44.77.176;' # Network Library=dbmssocn', 'database': "adotest", 'user': '******', # None implies Windows security 'password': "******", # macro definition for keyword "security" using macro "auto_security" 'macro_auto_security': 'security', 'provider': 'SQLNCLI11; MARS Connection=True' } connStr = "Provider=%(provider)s; Initial Catalog=%(database)s; Data Source=%(host)s; %(security)s;" if node != SQL_HOST_NODE: if THE_PROXY_HOST:
try: #If mx extensions are installed, use mxDateTime import mx.DateTime doMxDateTimeTest = True except: doMxDateTimeTest = False #Requires eGenixMXExtensions doTimeTest = True # obsolete python time format if doAccessTest: c = {'dsn': setuptestframework.makemdb(testfolder)} if is64bit.Python(): c['driver'] = "Microsoft.ACE.OLEDB.12.0" else: c['driver'] = "Microsoft.Jet.OLEDB.4.0" connStrAccess = "Provider=%(driver)s;Data Source=%(dsn)s" % c doAccessTest = tryconnection.try_connection(connStrAccess) if doSqlServerTest: _computername = "192.168.100.101" # name of computer with SQL Server _databasename = "vernon" #or something else #_username="******" #_password="******" #if is64bit: # connStrSQLServer = "Provider=SQLNCLI11;Data Source=tcp:o9our2opzq.database.windows.net;Database=ADOtest;User ID=vernondcole@o9our2opzq;Password=Az0456xxx;Encrypt=True;" #else: # connStrSQLServer = "Provider=SQLOLEDB.1; Data Source=tcp:o9our2opzq.database.windows.net;Database=ADOtest;User ID=vernondcole@o9our2opzq;Password=Az0456xxx;" connStrSQLServer = r"Provider=SQLOLEDB.1; Integrated Security=SSPI; Initial Catalog=%s;Data Source=%s" % ( _databasename, _computername) #connStrSQLServer = r"Provider=SQLOLEDB.1; User ID=%s; Password=%s; Initial Catalog=%s;Data Source=%s" %(_username,_password,_databasename, _computername) print(' ...Testing MS-SQL login...') doSqlServerTest = tryconnection.try_connection(connStrSQLServer)
except: doMxDateTimeTest = False # Requires eGenixMXExtensions doTimeTest = True # obsolete python time format if doAccessTest: if onWindows and (node == SQL_HOST_NODE or not is64bit.Python()): c = {"mdb": setuptestframework.makemdb(testfolder, mdb_name)} else: c = {"macro_find_temp_test_path": ["mdb", "server_test.mdb"], "proxy_host": THE_PROXY_HOST} # macro definition for keyword "driver" using macro "is64bit" -- see documentation c["macro_is64bit"] = ["driver", "Microsoft.ACE.OLEDB.12.0", "Microsoft.Jet.OLEDB.4.0"] connStrAccess = "Provider=%(driver)s;Data Source=%(mdb)s" print(" ...Testing ACCESS connection...") doAccessTest, connStrAccess, dbAccessconnect = tryconnection.try_connection(verbose, connStrAccess, 10, **c) if doSqlServerTest: c = { "macro_getnode": ["host", r"%s\SQLExpress"], # name of computer with SQL Server #'host':'25.44.77.176;' # Network Library=dbmssocn', "database": "adotest", "user": "******", # None implies Windows security "password": "******", # macro definition for keyword "security" using macro "auto_security" "macro_auto_security": "security", "provider": "SQLNCLI11; MARS Connection=True", } connStr = "Provider=%(provider)s; Initial Catalog=%(database)s; Data Source=%(host)s; %(security)s;" if node != SQL_HOST_NODE:
try: #If mx extensions are installed, use mxDateTime import mx.DateTime doMxDateTimeTest=True except: doMxDateTimeTest=False #Requires eGenixMXExtensions doTimeTest = True # obsolete python time format if doAccessTest: c = {'dsn': setuptestframework.makemdb(testfolder)} if is64bit.Python(): c['driver'] = "Microsoft.ACE.OLEDB.12.0" else: c['driver'] = "Microsoft.Jet.OLEDB.4.0" connStrAccess = "Provider=%(driver)s;Data Source=%(dsn)s" % c doAccessTest = tryconnection.try_connection(connStrAccess) if doSqlServerTest: _computername = "192.168.100.101" # name of computer with SQL Server _databasename = "vernon" #or something else #_username="******" #_password="******" #if is64bit: # connStrSQLServer = "Provider=SQLNCLI11;Data Source=tcp:o9our2opzq.database.windows.net;Database=ADOtest;User ID=vernondcole@o9our2opzq;Password=Az0456xxx;Encrypt=True;" #else: # connStrSQLServer = "Provider=SQLOLEDB.1; Data Source=tcp:o9our2opzq.database.windows.net;Database=ADOtest;User ID=vernondcole@o9our2opzq;Password=Az0456xxx;" connStrSQLServer = r"Provider=SQLOLEDB.1; Integrated Security=SSPI; Initial Catalog=%s;Data Source=%s" %(_databasename, _computername) #connStrSQLServer = r"Provider=SQLOLEDB.1; User ID=%s; Password=%s; Initial Catalog=%s;Data Source=%s" %(_username,_password,_databasename, _computername) print(' ...Testing MS-SQL login...') doSqlServerTest = tryconnection.try_connection(connStrSQLServer)