Hyderabad Emergency Services

Hyderabad Emergency Services
*	24-hr Pharmacies	*	Ambulance	*	Blood Banks
*	Eye Banks	*	Fire	*	Fuse Call
*	Govt Hospitals	*	Medical Services	*	Oxygen
*	Police
24-hr Pharmacies Name Phone No Apollo Pharmacy 23601380 Health Pharmacy 23310618 Kamineni Pharmacy 24022272 to 76 Medwin Pharmacy 23202902/4621 TOP ….more info www.jaganinfo.com
Ambulance Name Phone No Free service 102 CDR Ambulance 23456789 Apollo 23548888 AP Centre for Emerg. Medicare (Apathbandu) 24603566 TOP
Blood Banks Name Phone No Gandhi Hospital 27702222 Govt. Chest Hospital 23814421/22 Govt. ENT Hospital 24740245/24742329 Heritage Medical Centre 23730202/23736650 Bhanji Kheraj Blood Bank 24745243 CDR Blood Bank 23221221 Ext. 4558 Kamineni Blood Bank 24022272 to 76 Institute of Transfusion Medicine and Research 23319491 Matadin Goel Blood Bank 23226624 Medwin Blood Bank 23202902/4616 Modern Blood Bank 24731976/24606106 TOP….more info www.jaganinfo.com
Eye Banks Name Phone No Ramayamma International 23548266 Sarojini Devi Eye Bank 23317274 Kapadia Eye Bank 23317274 Chiranjeevi Eye Bank 23359066 L V Prasad Eye Bank 23548267 TOP….more info www.jaganinfo.com
Fire Name Phone No Fire 101 Divisonal Fire Office 26500102/3/ 23260091 TOP
Fuse Call Name Phone No General Complaints 1912 Electricity Control Room 23232051 Abids 24734941 AC Guards 23310691 Ashoknagar 27616140 Indira Park 27611424 Amberpet 27037540 Asmanghad, Saleemnagar 24069306 Azamabad 27664283 Balanagar 23771258 Banjara Hills 23356862 Begumpet 23313987 Bolaram 27862116 Bowenpally 27750912 Bolaram 27862116 Bowenpally 27750912 Chaderghat 24528351 Champapet 24068340 Chanchalguda 24527024 Chandulal Baradari 24520286 Charminar 24521106 Clock Tower 27704637 Falaknuma 24440411 Feelkhana 24614591 Gachi Bowli 23010362 Gandhi nagar 27611424 Gunfoundry 23235305 Gymkhana, Sec’bad 27840342 Himayatnagar 27638577 Indira Park 27616140 James Street 27844336 Lalbazar 27744406 Malkajgiri 27053266 Mehdipatnam 23514020 Moghulpura 24523149 Musheerabad 27664283 Moula Ali 27120765 Narayanaguda 23223389 Padmarao nagar 27615109 Sanjeeva Reddi Nagar 23730213 Santoshnagar 24530479 Sanatnagar 23704249 Saroornagar 24045522 Sitaphalmandi 27616372 Sitarampet 24732553 Sultanbazar 24656509 Somajiguda 23235300 Tarnaka 27821633 Yellareddiguda 23742589 TOP….more info www.jaganinfo.com
Govt Hospitals Name Phone No Dental Hospital 24601930 ESI, Erragadda 23700531 Cancer Hospital 23318422 ENT, Koti 24740245 Fever Hospital, Nallakunta 27667844 Gandhi Hospital, Secunderabad 27702222 Golconda Hospital 23513776 Govt. Maternity Hospital, Koti 24653647 Homeopathy Hospital 24046817 King Koti Hospital 24756085 Koti Maternity Hospital 24653647 Mental Hospital, Erragadda 23814441 Military Hospital, Secunderabad 27792580 MNJ Cancer Hospital, Red Hills 23318422 Niloufer Hospital (for children), Red Hills 23391652 NIMS, Panjagutta 23320332/23314887 Nizamia Gen. Hospital 2524422/2524424 Osmania General Hospital, Afzalganj 24600121/24 Railway Hospital, Secunderabad 27001134 SD Eye Hospital, Mehdipatnam 23317274 State TB Centre, Erragadda 23811797 TOP
Medical Services Name Phone No LV Prasad Eye Institute 23608262 Andhra Mahila Sabha 27617801 Apollo Hospital 23608856 Apollo Heart Institute 23548888 Care Hospital (Hyderabad) 24735465-70 Care Hospital (Secunderabad) 27706252/27717452 Care Hospital (Yellareddyguda) 23742589 Mahavir Hospital 23393134 Mediciti 23237644 Kamineni Hospital 24022272-76 Medinova 23311122/23311133 Medwin Hospital 23202902/4000 CDR Hospital (Hyderguda) 23221221 Niloufer Hospital 23391652 Osmania General Hospital 24600122 St. Theresa’s Hospital 23701013 The Nizam’s Institute of Medical Sciences 23320332/23318120 Vijay Marie Hospital 23315055 Yashoda Superspeciality Hospital (Somajiguda) 23312642/9999/1022 Yashoda Superspeciality Hospital (Malakpet) 24555555 /24547070 Oxygen Cylinder/Bed Service 24740108 Cancer Hospital 23318422 TOP
Oxygen Name Phone No Asiatic Indl. Gases 23095911 IOL, Sanathnagar 23811756 OXEE Co 23701710 TOP
Police Name Phone No Police 100 Crime Stopper 1090 Police Exchange 23230191 Police Control Room (City) 23232222 Police Control Room (RR dt) 23235398 Traffic Police 23234065 Cooking Gas Emergency Cell 27801123

GENERAL KNOWLEDGE

GENERAL KNOWLEDGE

GKindia
www.gkindia.com

Globalknowledge
www.globalknowledge.com

CURRENT AFFAIRS
…

Indiacurrentaffairs
www.indiacurrentaffairs.com

IQtest
www.iqtest.com

Exploratorium
http://www.exploratorium.edu/memory

Dictionary
www.dictionary.com

Encylopedia
www.encylopedia.com

Voycabulary
www.voycabulary.com

PUZZLES PRIZES Etc.,

Contests2win
www.contests2win.com

Puzzles
www.puzzles.com

Thinks
www.thinks.com

Puzz
www.puzz.com

Cluemaster
www.cluemaster.com

Mathpuzzle
www.mathpuzzle.com

Crossword-puzzles
www.crossword-puzzles.co.uk

Bestcrosswords
www.bestcrosswords.com

Cricinfo
www.cricinfo.com

CONTESTS

contest2win
www.contest2win.com

Glamsham
www.glamsham.com

CONTESTS FOR YOUTH

Zatang
www.zatang.com

MTVindia
www.mtvindia.com

QUEST
…

Lovingyou
www.lovingyou.com

Dqindia
www.dqindia.com

Indiaquest
indiaquest.net

keen
www.keen.com

Useekufind
www.useekufind.com

NEWS PAPERS in INDIA

NEWS PAPERS in INDIA

Times of India
www.timesofindia.com
Economic Times
www.economictimes.com
India Today
www.india-today.com
Outlook India
www.outlookindia.com
The Hindu
www.hinduonline.com
Deccan Chronicle
www.deccan.com
Samachar
www.samachar.com
Time Magazine
www.pathfinder.com
Andhra Prabha
www.andhraprabha.com
Vaartha
www.vaartha.com
Andhra Bhoomi
www.andhrabhoomi.com
World Wide News
www.worldwidenews.com
Hindustan Times
www.hindustantimes.com
Business World
www.buinessworld.com
Femina India
www.feminaindia.com
Asian News
www.newasia.com
Film Fare
www.filmfare.

Baby Names in India

Hindu Baby Names

Indiaparenting www.indiaparenting.com Indianchild www.indianchild.com Sanyal www.sanyal.com Hindunet www.hindunet.org Saranam www.saranam.com Babynology www.babynology.com

Christian Baby Names

Jesusanswers www.jesusanswers.com Gospelguitar www.gospelguitar.com Babynamesorigins www.babynamesorigins.com

Muslim Baby Names

Babynology www.babynology.com Islam http://islam.about.com MuslimMatrimonial www.muslimmatrimonial.com Muslim-names www.muslim-names.co.uk

DATABASE CONNECTION STRINGS

DATABASE CONNECTION STRINGS : all in one place ….more info www.jaganinfo.com

SQL Server ODBC Standard Security: “Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;” Trusted connection: “Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;” Prompt for username and password: oConn.Properties(”Prompt”) = adPromptAlways oConn.Open “Driver={SQL Server};Server=Aron1;DataBase=pubs;” OLE DB, OleDbConnection (.NET) Standard Security: “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;” Trusted Connection: “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;” (use serverName\instanceName as Data Source to use an specific SQLServer instance, only SQLServer2000) Prompt for username and password: oConn.Provider = “sqloledb” oConn.Properties(”Prompt”) = adPromptAlways oConn.Open “Data Source=Aron1;Initial Catalog=pubs;” Connect via an IP address: “Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;” (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default)) ….more info www.jaganinfo.com SqlConnection (.NET) Standard Security: “Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;” - or - “Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False” (both connection strings produces the same result) Trusted Connection: “Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;” - or - “Server=Aron1;Database=pubs;Trusted_Connection=True;” (both connection strings produces the same result) (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) Connect via an IP address: “Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;” (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default)) Declare the SqlConnection: C#: using System.Data.SqlClient; SqlConnection oSQLConn = new SqlConnection(); oSQLConn.ConnectionString=”my connectionstring”; oSQLConn.Open(); VB.NET: Imports System.Data.SqlClient Dim oSQLConn As SqlConnection = New SqlConnection() oSQLConn.ConnectionString=”my connectionstring” oSQLConn.Open() ….more info www.jaganinfo.com Data Shape MS Data Shape “Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;”….more info www.jaganinfo.com Access ODBC Standard Security: “Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;” Workgroup: “Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;” Exclusive: “Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=” ….more info www.jaganinfo.com OLE DB, OleDbConnection (.NET) Standard security: “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;” Workgroup (system database): “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;” With password: “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;” ….more info www.jaganinfo.com Oracle ODBC New version: “Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;” Old version: “Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;” OLE DB, OleDbConnection (.NET) Standard security: “Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;” This one’s from Microsoft, the following are from Oracle Standard Security: “Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;” Trusted Connection: “Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;” ….more info www.jaganinfo.com OracleConnection (.NET) Standard: “Data Source=MyOracleDB;Integrated Security=yes;” This one works only with Oracle 8i release 3 or later Specifying username and password: “Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated Security=no;” This one works only with Oracle 8i release 3 or later Declare the OracleConnection: C#: using System.Data.OracleClient; OracleConnection oOracleConn = new OracleConnection(); oOracleConn.ConnectionString = “my connectionstring”; oOracleConn.Open(); VB.NET: Imports System.Data.OracleClient Dim oOracleConn As OracleConnection = New OracleConnection() oOracleConn.ConnectionString = “my connectionstring” oOracleConn.Open() Core Labs OraDirect (.NET) Standard: “User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0″ ….more info www.jaganinfo.com Data Shape MS Data Shape: “Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw” ….more info www.jaganinfo.com MySQL ODBC ODBC 2.50 Local database: “Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;” ODBC 2.50 Remote database: “Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;” ODBC 3.51 Local database: “DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;” ODBC 3.51 Remote database: “DRIVER={MySQLODBC3.51Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;” OLE DB, OleDbConnection (.NET) Standard: “Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;” Connector/Net 1.0 (.NET) Standard: “Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;” Specifying port: “Server=Server;Port=1234;Database=Test;Uid=UserName;Pwd=asdasd;” Default port is 3306. Enter value -1 to use a named pipe connection. Declare the MySqlClient connection: C#: using MySql.Data.MySqlClient; MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = “Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;”; oMySqlConn.Open(); VB.NET: Imports MySql.Data.MySqlClient Dim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = “Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;” oMySqlConn.Open() ….more info www.jaganinfo.com MySqlConnection (.NET) eInfoDesigns.dbProvider: “Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false” Declare the MySqlConnection: C#: using eInfoDesigns.dbProvider.MySqlClient; MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = “my connectionstring”; oMySqlConn.Open(); VB.NET: Imports eInfoDesigns.dbProvider.MySqlClient Dim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = “my connectionstring” oMySqlConn.Open() SevenObjects MySqlClient (.NET) Standard: “Host=server; UserName=myusername; Password=mypassword;Database=mydb;” Core Labs MySQLDirect (.NET) Standard: “User ID=root; Password=pwd; Host=localhost; Port=3306; Database=test;Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0″ ….more info www.jaganinfo.com Interbase ODBC, Easysoft Local computer: “Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password” Remote Computer: “Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password” ODBC, Intersolv Local computer: “Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password” Remote Computer: “Driver={INTERSOLVInterBaseODBCDriver (*.gdb)};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password” OLE DB, SIBPROvider Standard: “provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey” Specifying character set: “provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey;character set=ISO8859_1″ Specifying role: “provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey;role=DIGITADORES” ….more info www.jaganinfo.com IBM DB2 OLE DB, OleDbConnection (.NET) from ms TCP/IP: “Provider=DB2OLEDB;NetworkTransportLibrary=TCPIP;NetworkAddress=***.***.***.***;InitialCatalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW” APPC: “Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW” IBM’s OLE DB Provider (shipped with IBM DB2 UDB v7 or above) TCP/IP: Provider=IBMDADB2;Database=sample;HOSTNAME=db2host;PROTOCOL=TCPIP;PORT=50000;uid=myUserName;pwd=myPwd; ODBC Standard: “driver={IBMDB2ODBC DRIVER};Database=myDbName;hostname=myServerName;port=myPortNum;protocol=TCPIP; uid=myUserName; pwd=myPwd” ….more info www.jaganinfo.com Sybase ODBC Standard Sybase System 12 (or 12.5) Enterprise Open Client: “Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password” Standard Sybase System 11: “Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;” Intersolv 3.10: “Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;” Sybase SQL Anywhere (former Watcom SQL ODBC driver): “ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db;Uid=username;Pwd=password;Dsn=”"”"” Note! The two double quota following the DSN parameter at the end are escaped quotas (VB syntax), you may have to change this to your language specific escape syntax. The empty DSN parameter is indeed critical as not including it will result in error 7778. OLE DB Adaptive Server Anywhere (ASA): “Provider=ASAProv;Data source=myASA” Adaptive Server Enterprise (ASE) with Data Source .IDS file: “Provider=Sybase ASE OLE DB Provider; Data source=myASE” Note that you must create a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs. Adaptive Server Enterprise (ASE): “Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;User Id=username;Password=password” - some reports on problem using the above one, try the following as an alternative - “Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial Catalog=myDBname;User Id=username;Password=password” This one works only from Open Client 12.5 where the server port number feature works, allowing fully qualified connection strings to be used without defining any .IDS Data Source files. AseConnection (.NET) Standard: “Data Source=’myASEserver’;Port=5000;Database=’myDBname’;UID=’username’;PWD=’password’;” Declare the AseConnection: C#: using Sybase.Data.AseClient; AseConnection oCon = new AseConnection(); oCon.ConnectionString=”my connection string”; oCon.Open(); VB.NET: Imports System.Data.AseClient Dim oCon As AseConnection = New AseConnection() oCon.ConnectionString=”my connection string” oCon.Open() ….more info www.jaganinfo.com Informix ODBC Informix 3.30: “Dsn=”;Driver={INFORMIX3.3032BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd Informix-CLI 2.5: “Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;Uid=username;Pwd=myPwd” OLE DB IBM Informix OLE DB Provider: “Provider=Ifxoledbc.2;password=myPw;User ID=myUser;Data Source=dbName@serverName;Persist Security Info=true” ….more info www.jaganinfo.com Ingres ODBC DSN-less “Provider=MSDASQL.1;DRIVER=Ingres;SRVR=xxxxx;DB=xxxxx;PersistSecurityInfo=False;uid=xxxx;pwd=xxxxx;SELECTLOOPS=N;Extended Properties=”"”SERVER=xxxxx;DATABASE=xxxxx;SERVERTYPE=INGRES”" ….more info www.jaganinfo.com Mimer SQL ODBC Standard Security: “Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;” Prompt for username and password: “Driver={MIMER};Database=mydb;” ….more info www.jaganinfo.com Lightbase Standard Standard: “user=USERLOGIN;password=PASSWORD;UDB=USERBASE;server=SERVERNAME” ….more info www.jaganinfo.com PostgreSQL Core Labs PostgreSQLDirect (.NET) Standard: “User ID=root; Password=pwd; Host=localhost; Port=5432; Database=testdb;Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0″ ….more info www.jaganinfo.com Paradox ODBC 5.X: Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=c:\pathToDb\;Dbq=c:\pathToDb\;CollatingSequence=ASCII” 7.X: “Provider=MSDASQL.1;PersistSecurityInfo=False;Mode=Read;Extended Properties=’DSN=Paradox;DBQ=C:\myDb;DefaultDir=C:\myDb;DriverId=538;FIL=Paradox7.X;MaxBufferSize=2048;PageTimeout=600;’;Initial Catalog=C:\myDb” ….more info www.jaganinfo.com OleDbConnection (.NET) Standard “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myDb;Extended Properties=Paradox 5.x;” ….more info www.jaganinfo.com DSN ODBC DSN: “DSN=myDsn;Uid=username;Pwd=;” File DSN: “FILEDSN=c:\myData.dsn;Uid=username;Pwd=;” ….more info www.jaganinfo.com Firebird ODBC - IBPhoenix Open Source Standard: “DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=D:\FIREBIRD\examples\TEST.FDB” .NET - Firebird .Net Data Provider Standard: “User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0″ ….more info www.jaganinfo.com Excel ODBC Standard: “Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;” TIP! SQL syntax: “SELECT * FROM [sheet1$]” - i.e. worksheet name followed by a “$” and wrapped in “[" "]” brackets. OLE DB Standard: “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=”"Excel 8.0;HDR=Yes;IMEX=1″”" “HDR=Yes;” indicates that the first row contains columnnames, not data “IMEX=1;” tells the driver to always read “intermixed” data columns as text TIP! SQL syntax: “SELECT * FROM [sheet1$]” - i.e. worksheet name followed by a “$” and wrapped in “[" "]” brackets. Text ODBC Standard: “Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;” OLE DB Standard: “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=”"text;HDR=Yes;FMT=Delimited”"” “HDR=Yes;” indicates that the first row contains columnnames, not data ….more info www.jaganinfo.com DBF / FoxPro ODBC standard: “Driver={MicrosoftdBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;” OLE DB, OleDbConnection (.NET) standard: “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=” ….more info www.jaganinfo.com AS/400 (iSeries) OLE DB, OleDbConnection (.NET) IBM Client Access OLE DB provider: “PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;USER ID=myUserName;PASSWORD=myPwd” Where MY_SYSTEM_NAME is the name given to the system connection in OperationsNavigator IBM Client Access OLE DB provider: “PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;USER ID=myUserName;PASSWORD=myPwd;DEFAULT COLLECTION=MY_LIBRARY;” Where MY_SYSTEM_NAME is the name given to the System Connection, and MY_LIBRARY is the name given to the library in iSeries Navigator. ODBC IBM Client Access ODBC driver: “Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUserName;Pwd=myPwd” Exchange OLE DB Exchange OLE DB provider: “ExOLEDB.DataSource” Specify store in the connection open command like this: conn.open “http://servername/mypublicstore” ….more info www.jaganinfo.com Visual FoxPro OLE DB, OleDbConnection (.NET) Database container (.DBC): “Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine” Free table directory: “Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general” Force the provider to use an ODBC DSN: “”Provider=vfpoledb.1;DSN=MyDSN”" ….more info www.jaganinfo.com ODBC Database container (.DBC): “Driver={MicrosoftVisualFoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO” Free Table directory: “Driver={MicrosoftVisualFoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO” UDL UDL: “File Name=c:\myDataLink.udl;”