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)
