DataBase - Problem with Vista connecting SQL server 2005
Asked By Karthick Jayavel
11-May-08 06:55 AM
Hi All,
Server config:
GP 10 with SQL server 2005 (SP2) had been configured in windows server 2008
standard.
Client config:
GP client installation is made in windows vista ULTIMATE. There were
problems in ODBC connection while connecting to SQL server 2005. It cant able
to communicate with SQL server 2005. Some of the client machine have windows
vista Business, is that their will be same problem with Business?
Please let me know how to overcome this problem.
Thanks!
Regards,
Karthick J
SQL Server
(1)
Vista
(1)
Newsletter
(1)
Jayavelu
(1)
Mariano
(1)
Leslie
(1)
Whaley
(1)
Gomez
(1)
inf replied...
Are you using the SQL Native ODBC Client?
--
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com
KarthickJayavel replied...
Yes. I tried to connect using Native and normal SQL server ODBC connectivity.
But the result is same.
MichaelG replied...
windows firewall blocking it?
KarthickJayavel replied...
No, there is no firewall blocked.
MarianoGome replied...
Are you able to ping your sever? Go to your command line and type ping
[servername].
If you get a "Request time out", you may want to check your DNS server. If
you are able to ping the server (you will get the IP address), then make sure
your SQL Server service is started on your server machine.
On the client side, attempt to disable UAC prior setting up your ODBC
driver. I've seen problems with this too.
Keep us posted!
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
LeslieVai replied...
Are you using 64-bit or 32-bit?
KarthickJayavel replied...
Its 64-bit. And is their any Service panck released for windows server 2008?
Might be outgrowing Access but daunted by SQL Server DataBase I am close to completing the consolidation of various small Access databases and a spent the last 10 hours downloading, installing and trying to get my head around Microsoft SQL Server 2008 Express and how it might help me out. It all started when I came encouraging article on keeping your Access database as your front end application and linking to SQL Server database tables. I am finding it MUCH more complicated than I had hoped. Can anyone be happy to use my quite powerful workstation at the office as some kind of server. You may have guessed by now that I am no IT guru by any stretch so please bare this in mind with any suggestions. Access Discussions SQL Server Migration Assistant (1) SQL Server 2005 (1) SQL Server 2008 (1) SQL Server (1
SQL Server DataBase Hall?schen, ich habe mit einem SQL Server noch nie was am Hut gehabt. Alles was ich bisher gemacht hatte, da war Access immer ausreichend. Nun aber ist eine Anforderung, das ein Backend auf einem SQL-Server laufen soll, wobei dar?ber noch nicht fertig diskutiert ist. Ich habe da noch eine alte Vollversion von VB6, dort ist ein SQL-Server dabei (fracht mich aber nicht welche Version, der Karton mit der VB6 steht noch in
proof DataBase https: / / mcp.microsoft.com / authenticate / validatemcp.aspx transcript: 944364 AccessCode: helloworld Access Discussions SQL Server 2008 R2 (1) SQL Server 2008 (1) SQL Server 2005 (1) Microsoft SQL Server Reporting Services (1) Regards Larry Linson Microsoft Office Access (1) Bing Microsoft SQL Server (1
Cannot link to SQL server DataBase Can any of you guys help? I am new to using SQL Server. I have a database that I wish to upsize from Access to put the back end on a server, and use Access as a front-end. However, I am stuck at the very first stage - I cannot link Access to the SQL server. I am using SQL Server Management Studio on a single computer for development purposes, no network involved yet. In
SQL query slow DataBase Hi In the code below I found that it takes 1.3 to split it up or cancel the query? And can I read this faster? string sql = EquipmentID(Equipment) + StartDate.ToOADate().ToString(FloatFormat, myCulture) + EndDate.ToOADate().ToString(FloatFormat, myCulture); sql + = " group by event_id, name"; _Log("Calc thread #2"); OleDbCommand com = new OleDbCommand(sql, con); _Log("Calc thread #3"); From #2 to #3 it takes 1.3 seconds. Remaing less that 0.1 second. So the query is what slows it down. Access Discussions SQL Server (1) Linson Unlike Albert D. Kallal (1) MySQL (1) Windows Server 2003 (1) Visual Studio (1) SharePoint (1) NHibernate (1) Microsoft SQL Server (1) Hi, Besides that your code is full of SQL injection bugs because of