ODBC Connection problems

[DawnTreader]

Hello All

i have an access database which has tables linked from a SQL server database
through the use of an ODBC connection.

this access database has a bunch of queries that i use to populate pivot
tables in an excel workbook. the workbook is a reporting tool that creates a
central set of KPI information. this tool has been working great for about a
year.

however now it seems that certain pivot tables are failing to connect
properly to the queries and retrieve new data. no error messages, just empty
pivot tables or the same values for more than 2 weeks, which is highly
unlikely as this is sales data we are talking about.

when i hold over one of the linked tables i get a tool tip that shows:

ODBC;DSN=VMFGSQLServer;Description=VMFG Live;UID=readonly;APP=Microsoft
Office 2003;WSID=IMW110;DATABASE=VMFG;TABLE=dbo.PART

now i dont know all the intricasies of this, but i understand most of it. my
biggest concern is the WSID. that is my computer. we are a corporate network
and i need to know does this change per computer or is it a hardcoded value
that "cant" be changed? the reason is that everything seems to work on my
computer, but my coworker is not getting the same results, some of the time.

i dont know what other information i can give to get help with this so
please let me know if there is anything i can post that would help.

 

[golfinray]

In my experience, it is usually a driver problem. Since it works on another
computer, it is not likely the ODBC driver in the server. It is probably the
driver in your machine. Go to Control Panel, administrative tools, ODBC
connections and go through the screens then see if it will connect. Another
thing you need to do is to put the full path to the server, like
\\server\folder\filename

 

[Stefan Hoffmann]

hi Dawn,

now i dont know all the intricasies of this, but i understand most of it. my
biggest concern is the WSID.

This doesn'matter.

the reason is that everything seems to work on my
computer, but my coworker is not getting the same results, some of the time.

Use the SQL Server Profiler to compare the SQL statements issued in
these two cases and compare them. If they are the same, then you should
check whether it may be permission problem and then check your Excel
export code carefully.


mfG
--> stefan <--

 

[Risse]

Hello All

i have an access database which has tables linked from a SQL server
database
through the use of an ODBC connection.

this access database has a bunch of queries that i use to populate pivot
tables in an excel workbook. the workbook is a reporting tool that creates
a
central set of KPI information. this tool has been working great for about
a
year.

however now it seems that certain pivot tables are failing to connect
properly to the queries and retrieve new data. no error messages, just
empty
pivot tables or the same values for more than 2 weeks, which is highly
unlikely as this is sales data we are talking about.

when i hold over one of the linked tables i get a tool tip that shows:

ODBC;DSN=VMFGSQLServer;Description=VMFG Live;UID=readonly;APP=Microsoft
Office 2003;WSID=IMW110;DATABASE=VMFG;TABLE=dbo.PART

now i dont know all the intricasies of this, but i understand most of it.
my
biggest concern is the WSID. that is my computer. we are a corporate
network
and i need to know does this change per computer or is it a hardcoded
value
that "cant" be changed? the reason is that everything seems to work on my
computer, but my coworker is not getting the same results, some of the
time.

i dont know what other information i can give to get help with this so
please let me know if there is anything i can post that would help.