Create ODBC source - Revision history

Alnaucler at 11:57, 5 August 2016

2016-08-05T11:57:41Z

← Older revision		Revision as of 13:57, 5 August 2016
Line 3:		Line 3:
	Start the ODBC manager		Start the ODBC manager
	:* On a computer with 32 bits operating system where you installed the 32-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC)		:* On a computer with 32 bits operating system where you installed the 32-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC)
	:* On a computer with '''64''' bits operating system where you installed the '''32-bits driver''', start C:\Windows\SysWOW64\odbcad32.exe		:* On a computer with '''64''' bits operating system where you installed the '''32-bits driver''', start ''C:\Windows\'''SysWOW64'''\odbcad32.exe''
	:* On a computer with 64 bits operating system where you installed the 64-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC).		:* On a computer with 64 bits operating system where you installed the 64-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC).

Alnaucler at 11:20, 6 April 2016

2016-04-06T11:20:10Z

← Older revision		Revision as of 13:20, 6 April 2016
Line 1:		Line 1:
	{{Note \| In order to create an ODBC source the PostGreSQL driver has to be installed. The drivers may be downloaded from '''[[~~Media:PGSQL_ODBC.zip~~ \| here]]''' and installation instructions may be found '''[[Installation ODBC driver \| here]]'''.}}		{{Note \| In order to create an ODBC source the PostGreSQL driver has to be installed. The drivers may be downloaded from '''[[Downloads \| here]]''' and installation instructions may be found '''[[Installation ODBC driver \| here]]'''.}}

	Start the ODBC manager		Start the ODBC manager

Alnaucler at 11:14, 6 April 2016

2016-04-06T11:14:30Z

← Older revision		Revision as of 13:14, 6 April 2016
Line 1:		Line 1:
	{{Note \| In order to create an ODBC source the PostGreSQL driver has to be installed. The ~~driver~~ may be downloaded from [[Media:PGSQL_ODBC.zip \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].}}		{{Note \| In order to create an ODBC source the PostGreSQL driver has to be installed. The drivers may be downloaded from '''[[Media:PGSQL_ODBC.zip \| here]]''' and installation instructions may be found '''[[Installation ODBC driver \| here]]'''.}}

	Start the ODBC manager		Start the ODBC manager
	:*On a computer with 32 bits operating system, go to Control Panel, Administrative Tools and Data Sources (ODBC).		:* On a computer with 32 bits operating system where you installed the 32-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC)
	:*On a computer with 64 bits operating system, start C:\Windows\SysWOW64\odbcad32.exe		:* On a computer with '''64''' bits operating system where you installed the '''32-bits driver''', start C:\Windows\SysWOW64\odbcad32.exe
			:* On a computer with 64 bits operating system where you installed the 64-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC).

	[[Image:ODBC Source1.png\|400px\|center]]		[[Image:ODBC Source1.png\|400px\|center]]

Alnaucler at 17:00, 18 March 2015

2015-03-18T17:00:31Z

← Older revision		Revision as of 19:00, 18 March 2015
Line 12:		Line 12:
	[[Image:ODBC Source2.png\|400px\|center]]		[[Image:ODBC Source2.png\|400px\|center]]
	<div align="center">		<div align="center">
	'' Select PostgreSQL Unicode driver and click on Finish button''		'' Select PostgreSQL '''Unicode''' driver and click on Finish button''
	</div>		</div>

Alnaucler at 15:08, 20 October 2014

2014-10-20T15:08:57Z

← Older revision		Revision as of 17:08, 20 October 2014
Line 1:		Line 1:
	{{~~Under construction~~\| ~~Images missing}}~~		{{Note \| In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [[Media:PGSQL_ODBC.zip \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].}}
	In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [[Media:PGSQL_ODBC.zip \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].

	~~{{Note \| The driver used is of~~ 32 bits ~~version~~ and ~~therefore the 32 bits~~ ODBC ~~manager on~~ 64 bits ~~computers should be used (~~C:\Windows\SysWOW64\odbcad32.exe~~)}}~~		Start the ODBC manager
	~~# Start the~~ ODBC ~~manager~~		:*On a computer with 32 bits operating system, go to Control Panel, Administrative Tools and Data Sources (ODBC).
	# Go to ~~the~~ System DSN tab		:*On a computer with 64 bits operating system, start C:\Windows\SysWOW64\odbcad32.exe
	~~# Click~~ on Add
	# Select PostgreSQL driver ~~XXX in the list~~		[[Image:ODBC Source1.png\|400px\|center]]
	~~# Click~~ on Finish button		<div align="center">
			'' Go to System DSN tab and click on Add''
			</div>

			[[Image:ODBC Source2.png\|400px\|center]]
			<div align="center">
			'' Select PostgreSQL Unicode driver and click on Finish button''
			</div>

			[[Image:ODBC Source3.png\|400px\|center]]
	# Give the ODBC data source a good descriptive name		# Give the ODBC data source a good descriptive name
	# Database = imsma OR staging		# Database = ''imsma'' OR ''staging''
	# Server is localhost if the database is on your computer		# Server is ''localhost'' if the database is on your computer
	# Port = 5432		# Port is normally 5432
	# User name = imsma		# User name = ''imsma''
	# Password = password		# Password = ''password''
			# Test the connection
	Test the connection		# Click on Save
	{{NavBox Technical Notes}}		{{NavBox Technical Notes}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 14:26, 20 October 2014

2014-10-20T14:26:43Z

← Older revision		Revision as of 16:26, 20 October 2014
Line 1:		Line 1:
	{{Under construction\| Images missing}}		{{Under construction\| Images missing}}
	In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [[~~Downloads~~ \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].		In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [[Media:PGSQL_ODBC.zip \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].

	{{Note \| The driver used is of 32 bits version and therefore the 32 bits ODBC manager on 64 bits computers should be used (C:\Windows\SysWOW64\odbcad32.exe)}}		{{Note \| The driver used is of 32 bits version and therefore the 32 bits ODBC manager on 64 bits computers should be used (C:\Windows\SysWOW64\odbcad32.exe)}}

Alnaucler at 16:40, 18 October 2014

2014-10-18T16:40:17Z

← Older revision		Revision as of 18:40, 18 October 2014
Line 1:		Line 1:
	{{Under construction\| Images missing}}		{{Under construction\| Images missing}}
	In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [Downloads \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].		In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [[Downloads \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].

	{{Note \| The driver used is of 32 bits version and therefore the 32 bits ODBC manager on 64 bits computers should be used (C:\Windows\SysWOW64\odbcad32.exe)}}		{{Note \| The driver used is of 32 bits version and therefore the 32 bits ODBC manager on 64 bits computers should be used (C:\Windows\SysWOW64\odbcad32.exe)}}

Alnaucler at 15:00, 17 October 2014

2014-10-17T15:00:10Z

← Older revision		Revision as of 17:00, 17 October 2014
Line 1:		Line 1:
			{{Under construction\| Images missing}}
	In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [Downloads \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].		In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [Downloads \| here]] and installation instructions may be found [[Installation ODBC driver \| here]].

Alnaucler: Created page with "In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [Downloads | here]] and installation instructions may be found [..."

2014-10-17T14:12:26Z

Created page with "In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [Downloads | here]] and installation instructions may be found [..."

New page

In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [Downloads | here]] and installation instructions may be found [[Installation ODBC driver | here]].

{{Note | The driver used is of 32 bits version and therefore the 32 bits ODBC manager on 64 bits computers should be used (C:\Windows\SysWOW64\odbcad32.exe)}}
# Start the ODBC manager
# Go to the System DSN tab
# Click on Add
# Select PostgreSQL driver XXX in the list
# Click on Finish button
# Give the ODBC data source a good descriptive name
# Database = imsma OR staging
# Server is localhost if the database is on your computer
# Port = 5432
# User name = imsma
# Password = password

Test the connection
{{NavBox Technical Notes}}
[[Category:NAA]]