How to Configure ODBC to Access a Microsoft SQL Server
wie Sie tun, machen, Film, Beispiel
5m 47sLänge
This video tutorial covers how to configure ODBC to access a Microsoft SQL Server database. More guides and tutorials: http://www.itgeared.com/.
Kommentare
-
Is this first computer the querying computer or the sql server?
-
The real problem, one I've had many times and on different machines, is the connectivity of ODBC to the SQL server. It often just plain does not work out of the box.
-
how am I supposed to get the computer domain name stuff ? I'm nt getting it ?? @1:27.. please tell me..
-
Thanks bruh
-
Hi. I am stuck. what credentials did u enter there? Your local machine or the Server used when accessing SQL management Studio
-
I have an MS Access query that uses multiple linked tables. The tables are in SQL Server. When I run the query I can see records as expected but, as we know, what Access displays is not the entire recordset. If I try to export the result of my query or go the the last record (i.e., accessing the entire recordset), Access hangs. I considered using a Pass-Through query but I am using Access native functions in my query that are not compatible with T-SQL. Other than importing the data into MS Access, do you have any suggestion of how to prevent MS Access from hanging? I've seen many people have this issue but have not seen a resolution yet. Thanks!
-
1.how do you find the "computer name" and "sql server name" and "log in account"?
2.how to set up log in method ? win7 integrated and server method?
i do really want to know, because i had a fresh installed win7 and sql express but non of the outcomes are the same like your's, thank you very much. -
Good job mate!
-
I would see any reason why user vs system would make a difference. This is easy to test. Create both types and see if you can reproduce the issue. I suspect that you may need to dig deeper. A packet capture always helps determine what the slow down is. It could be as simple as a problem on the Windows 7 configuration, maybe a DNS config problem where name resolution is taking longer due to a mis-configuration.
-
Are there performance enhancements when connecting via the User DSN versus the System one? Reason I ask is we have the System names since all of our Instances are predefined on all of our workstations currently via the TNSNAMES file. Migrating to Windows 7 seems to have slowed the response time on queries, even the simple ones. Access goes into NOT RESPONDING mode and never comes out of it. It is infuriating.
-
Nice job describing the process and settings. Thank you very much!
-
Great tutorial. Thank you.
-
hello Daniel, glad that the video was useful for you. thanks for the feedback!
-
good work - why i haven't searched on youtube 1 hour earlier :-) - for those who are searching the right format for the Server. just copy it from your Servername from the SQL Server Management Studio login screen.
-
not sure what you mean by "disc rive". If you need help with something in the video, contact me via my website's forum.
-
hello please disc rive better
-
hello coolein, sorry about that confusion. What you need to type there is the fully qualified domain name (FQDN) of the SQL server that you want to connect to. If you are running SQL on the same computer, then you can just type "localhost", or if the name of the computer is called server1.domain.local, then you can type that as well. If you need more help, feel free to stop by my website, and we can use the forums to continue this discussion. Thanks!
-
1:27 At the "itg.db" Exactly what am I supposed to type here? I just want to connect to a local database, but I really ain't sure how to do it