aijmexico
asked on
sql problem/dimensions access
hi again i have access dimensions at work i have never run it before so its new too me th eother it guy did so iam trying to learn as much as i can i have installe dit on a fresh pc but when i try to conect it says it can not find the sql sever??? i have put the right data base in what our accounts are etc in dims but it says error etc carnt find it do i need to point it in the right direction thanks again
ASKER
the server is windows server 2003 useing the small buisness server os
the acces dimenions is installed on there storage wise?? just on the hdd on the server
not shore of a conection but this is wot it says
un able to log into the server
08001:microsoft odbc sql server driver tcp/ip sockets specified sql server not found 01000 microsoft odbc sql server driver tcp/ip sockets conectionopen connect.
the acces dimenions is installed on there storage wise?? just on the hdd on the server
not shore of a conection but this is wot it says
un able to log into the server
08001:microsoft odbc sql server driver tcp/ip sockets specified sql server not found 01000 microsoft odbc sql server driver tcp/ip sockets conectionopen connect.
If you go to that SBS2003 server, and use SQL Server Management Studio, can you connect to the database?
I'm trying to determine whether the problem is on the client or server side.
I'm trying to determine whether the problem is on the client or server side.
ASKER
yes i can go into the data base on the server i deff think its the pc side of things not the server the idea is reading the script what the other guy left me he said for dimentions install the dimenstions and copy over the files i have made ib the folder on the server which is the to accounts folders for the data base then i installed sql on the pc it should be ok once i fille din the key code on the access etc and point the dimensions to the right folders but it just keeps saying sql error.......regards chris
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mmmmmm no i dont think i have set one up i thought the data base would be picked up by the access dimensions once i feed it the correct infomation "dsn"??? not to shore of it
ASKER
all sorted i did not point the sql in the right direction silly me it works ok now thanks all for the help regards chris
Can you access the database from the SQL Server tools on that server?
How does your application store its DB location?
What connection information is your application using?