Vista - Odbc

**climberman** · 01-08-2009

I am trying to make some changes in the odbc system but I keep getting this error. Here is a link to a snap shot.

Untitled Document

Can't find the place to make a change I am logged on as an administrator.

SCSIraidGURU · 01-08-2009

Try doing a restart and logging in as administrator.

**climberman** · 01-08-2009

I am logged in as an administrator

But I will try it

**climberman** · 01-08-2009

Yes I am logged in as administrator but apparently the Microsoft access drivers are not loaded. Can't figure out how to load them.

SCSIraidGURU · 01-08-2009

administrative tools - Data Sources (ODBC). You can create the DSNs for each database.

**climberman** · 01-08-2009

That is were I went but it says that I need to load the drivers for ms access

SCSIraidGURU · 01-08-2009

I use SQL 2000 and 2005 databases. I create the database in SQL and point the DSN to it. Do you have the access database created to point the DSN to ?

**climberman** · 01-08-2009

Yes but I can't point to it because it wont let me I need drivers maybe something isn't there I don't know

SCSIraidGURU · 01-08-2009

Are you creating the correct DSN for it. Does it need a user or system DSN. On SQL server, its system DSN. Are you choosing the correct data source type. For SQL 2000 and 2005, its SQL Server. Some databases are ODBC.

**climberman** · 01-08-2009

It only shows SQL and nothing else there should be an MS Access.

01-08-2009	#1 (permalink)
climberman Vista Home Premium 64bit 24 posts	Odbc I am trying to make some changes in the odbc system but I keep getting this error. Here is a link to a snap shot. Untitled Document Can't find the place to make a change I am logged on as an administrator.
My System Specs

01-08-2009	#2 (permalink)
SCSIraidGURU Vista x64 Ultimate 1,823 posts	Re: Odbc Try doing a restart and logging in as administrator.
My System Specs

01-08-2009	#3 (permalink)
climberman Vista Home Premium 64bit 24 posts	Re: Odbc I am logged in as an administrator But I will try it
My System Specs

01-08-2009	#4 (permalink)
climberman Vista Home Premium 64bit 24 posts	Re: Odbc Yes I am logged in as administrator but apparently the Microsoft access drivers are not loaded. Can't figure out how to load them.
My System Specs

01-08-2009	#5 (permalink)
SCSIraidGURU Vista x64 Ultimate 1,823 posts	Re: Odbc administrative tools - Data Sources (ODBC). You can create the DSNs for each database.
My System Specs

01-08-2009	#6 (permalink)
climberman Vista Home Premium 64bit 24 posts	Re: Odbc That is were I went but it says that I need to load the drivers for ms access
My System Specs

01-08-2009	#7 (permalink)
SCSIraidGURU Vista x64 Ultimate 1,823 posts	Re: Odbc I use SQL 2000 and 2005 databases. I create the database in SQL and point the DSN to it. Do you have the access database created to point the DSN to ?
My System Specs

01-08-2009	#8 (permalink)
climberman Vista Home Premium 64bit 24 posts	Re: Odbc Yes but I can't point to it because it wont let me I need drivers maybe something isn't there I don't know
My System Specs

01-08-2009	#9 (permalink)
SCSIraidGURU Vista x64 Ultimate 1,823 posts	Re: Odbc Are you creating the correct DSN for it. Does it need a user or system DSN. On SQL server, its system DSN. Are you choosing the correct data source type. For SQL 2000 and 2005, its SQL Server. Some databases are ODBC.
My System Specs

01-08-2009	#10 (permalink)
climberman Vista Home Premium 64bit 24 posts	Re: Odbc It only shows SQL and nothing else there should be an MS Access.
My System Specs

Similar Threads
Thread	Forum
ODBC drivers	Drivers
odbc connection	Microsoft Office
SQL Select in ODBC	Vista General
change odbc	PowerShell
odbc	Vista General