who can share one ODBC setting

[lhgh20]

who can share one ODBC setting or tell me how to set,thx

 

[sevenstars7]

what SO you use? windows 7 64 bits???

 

[lhgh20]

windows 2003 X64
how to set the ODBC
like this：
indows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\ODBC]

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI]

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\BillCruxRF]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="BillCruxRF"
"LastUser"="BillCruxRF"
"Trusted_Connection"="Yes"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC]
"TraceFile"="C:\\Users\\ADMINI~1\\AppData\\Local\\Temp\\1\\SQL.LOG"
"TraceDll"="C:\\Windows\\system32\\odbctrac.dll"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources]
"RF_User"="SQL Server"
"BillCruxRF"="SQL Server"
"RF_WORLD_NOVUS"="SQL Server"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\RF_User]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="RF_User"
"LastUser"="rfaccountuser"
"Trusted_Connection"="Yes"
"Description"="RF_User"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\RF_WORLD_NOVUS]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="RF_WORLD_NOVUS"
"LastUser"="rfaccountuser"
"Trusted_Connection"="Yes"
"Description"="RF_WORLD_NOVUS"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\RF_WORLD]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="RF_WORLD"
"LastUser"="rfaccountuser"
"Trusted_Connection"="Yes"
"Description"="RF_WORLD_NOVUS"

this is other one setting！

 

[sevenstars7]

windows 2003 X64
how to set the ODBC
like this：
indows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\ODBC]

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI]

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\BillCruxRF]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="BillCruxRF"
"LastUser"="BillCruxRF"
"Trusted_Connection"="Yes"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC]
"TraceFile"="C:\\Users\\ADMINI~1\\AppData\\Local\\Temp\\1\\SQL.LOG"
"TraceDll"="C:\\Windows\\system32\\odbctrac.dll"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources]
"RF_User"="SQL Server"
"BillCruxRF"="SQL Server"
"RF_WORLD_NOVUS"="SQL Server"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\RF_User]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="RF_User"
"LastUser"="rfaccountuser"
"Trusted_Connection"="Yes"
"Description"="RF_User"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\RF_WORLD_NOVUS]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="RF_WORLD_NOVUS"
"LastUser"="rfaccountuser"
"Trusted_Connection"="Yes"
"Description"="RF_WORLD_NOVUS"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\RF_WORLD]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="VZIDC-12"
"Database"="RF_WORLD"
"LastUser"="rfaccountuser"
"Trusted_Connection"="Yes"
"Description"="RF_WORLD_NOVUS"

this is other one setting！

For my db i changed those like [HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\RF_WORLD] to [HKEY_CURRENT_USER\Software\Wow6432Node\ODBC\ODBC.INI\RF_WORLD]

add that to all the entrys and execute them

 

[Ron]

Add to both the system and user DSN tabs. Set them to connect via 127.0.0.1,1433 (you need to set mssql to bind on port 1433) and log in with windows authentication.

216:
BillCruxRF
RF_User
RF_World
223/2232:
BILLING
RF_User
RF_World